EPGM9.0+: BAD PERFORMANCE OPENING RESOURCES PAGE CAUSED BY CHECKING ASSIGNMENT APPROVALS (Doc ID 1671283.1)

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.

Symptoms

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms