Verified Answers


If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Verified Answer
  • Replies replies
    4
  • Subscribers subscribers
    12
  • Views views
    169
  • Users 0 members are here
Related
Options

how to completely refresh Project Name and Project Manager special fields by PL/SQL procedure

silviocri

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

  • Verified Answer

    +1  

    Hi Silvio,

    The table you're looking for is pm_projects, and the column is project_name.

    select project_id, pfm_request_id as project_number, project_name from pm_projects;

  • 0 in reply to   

    Hi Etienne,

    thank you, with your guideline I fixed the special field 1. Project Name.

    The special field 2. Project Manager is always not fixed. I noticed pm_projects.project:manager field is always NULL. So please clarify what is the expected table/field for project manager in previous screenshot; if the pm_projects.project_manager should be forced, I should insert a list of user_id or username or fullname (separators are the OOTB characters '#@#') ? 

    Ciao, Silvio

  • 0   in reply to 

    Hi Silvio,

    Did you check in table ITG_TRUSTEE by any chance? 

    My advice would be to change project manager in the UI with debug mode enabled, and see which tables get updated/inserted into. That should point you in the right direction.

  • 0 in reply to   

    Hi Etienne,

    your clarification was very useful as usual, and now I have the target PPM report.

    For PPMmers experienced with pl/sql code, see also the OOTB PM_UTILS.get_project_managers function cointating the cursor "manager_cur" to be replicated in order to implement the target PPM report as per Etienne clarification.

    Ciao, Silvio

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.