

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi,
I need to change the Planned Start Period and Planned Finish Period of projects in DB.
Because, I need a mass update.
PPM 8.04.
Any help is appreciated.
Regards
TM
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
the information you're looking for is in the KCRT_FG_PFM_PROJECT.
You should also update LAST_UPDATE_DATE in this table as well as in KCRT_REQUESTS.
Let us know if it works.
Cheers
Alex
--remember to kudos people who helped solve your problem


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi, TurboMan,
do you need to change the field in the Project Request form, or the start / end date of the Project workplan?
for the first one, you can use the PPM built-in functionality called Mass Update 😉
cheers
alex
--remember to kudos people who helped solve your problem


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Thanks,
I need to change in the Project Request Form.
Becasue, I cannot save.
So, I need to try to resolve this problem by updating DB fields first and see on the Project Request Form.
Regards
TM


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
the information you're looking for is in the KCRT_FG_PFM_PROJECT.
You should also update LAST_UPDATE_DATE in this table as well as in KCRT_REQUESTS.
Let us know if it works.
Cheers
Alex
--remember to kudos people who helped solve your problem


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Alex,
You are a legend, thanks very much.
Just a quick update,
After I updated, I have to run cache manager to flush all caches as follows
./kRunCacheManager.sh A
or rebounce the PPM .
Regards
TM


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
If you also update the KCRT_REQUESTS.ENTITY_LAST_UPDATE_DATE, then you don't need to refresh the cache or bounce the server.
Remember to provide kudos to people who helped solve your problem.
Cheers
Alex
--remember to kudos people who helped solve your problem