EPC: Performance With Project Security View PS_SP_PROJPT_CLSLG (Non English) (Doc ID 2145479.1)

Last updated on JUNE 01, 2016

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Performance issue with the delivered Project security view PS_SP_PROJPT_CLSLG.

Issue was reported for French language. This is also the same for other languages, so I will do in UK English for easier troubleshooting.
Project Definition.
1. Login in non-English
2. Navigate to Project General
3. Use a PC BU that has > 300 projects, and notice on TOAD the SQL will take long time
 

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