PeopleSoft Enterprise Program Management: BAD PERFORMANCE OPENING RESOURCES PAGE CAUSED BY RESOURCE ASSIGNMENTS

(Doc ID 1599882.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Program Management - Version 9 to 9 [Release 9]
PeopleSoft Enterprise FIN Resource Management - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

When there are 600 resources in the table PS_PROJECT_TEAM for which assignments have been created, it is causing bad performance when opening the Project Resources page. It keeps processing and after 20 minutes the system times out.

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