Hi All,

Using PPM 24.1, I developed a PL/SQL procedure for Massive Update for Projects. PL/SQL is needed since the requirement is to update some fields also in a closed projects.

The procedure is working quite fine, updating fields in Oracle database (as required to support massive data extraction) and in the gui.

I have issues with 2 special fields only.

1. Project Name

updating fields PROJECT_NAME and PRJ_PROJECT_NAME of KCRT_FG_PFM_PROJECT table, the project name is updated on the OOTB "Project Name" field in the Detail page of the project, but it is not updated on top at the page

2. Project Manager

updating fields PRJ_PROJECT_MANAGER_USER_ID and PRJ_PROJECT_MANAGER_USERNAME of the same KCRT_FG_PFM_PROJECT table, project managers are updated on the OOTB "Project Manager" field in the Detail page of the project, but it is not updated on top at the page and in the Configure Participant page. Further, if you save without changes from the Configure Participant page, the old value will override in the database the new value 

Please see screenshot below 

Since I modified only the KCRT_FG_PFM_PROJECT table, I ask any guideline and/or if I miss additional actions, in order to have a full refresh for this #2 special fields

My comment: the table kcrt_fg_pfm_project has not a last_update_date field, this can generate cache issue ?

Ciao, Silvio