EPGM9.0+: BAD PERFORMANCE OPENING RESOURCES PAGE CAUSED BY CHECKING ASSIGNMENT APPROVALS
Last updated on SEPTEMBER 15, 2016
Applies to:PeopleSoft Enterprise FIN Program Management - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.
When opening the Resources page (PC_PRL) for a project with more than 900 resources, the page keeps processing and times out after 10-15 minutes. The issue is caused by the function "CheckPendingApprovalExists" called by the record object "PROJECT_TEAM.TEAM_MEMBER_IND.RowInit".
The application is checking if any Assignment Approval is Pending or not, but it is doing it for every resource. Even if the project does not have any assignments pending for approval it will go through this loop. Can the application be changed, so that it checks whether a project is having any assignments in a Pending state and if not, to avoid this looping? This will improve the page performance for projects with a large number of resources.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms