Performance Problem with Project Prompts (or View SP_PROJ_OPRVW) when Project Security is implemented (Doc ID 1474494.1)

Last updated on AUGUST 04, 2015

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
***Checked for relevance on 06-Jan-2014***

Symptoms

In FSCM 9.1 MP6 Release, Performance

Actual Behavior:
-------------------------
System is not retrieving the Projects associated to an user within a reasonable time when Tree based Security is implemented ( Example: Prompt for Project on Add Transaction Page)

Expected Behavior:
-------------------------
System should retrieve the Projects associated to an user within a reasonable time when Tree based Security is implemented ( Example: Prompt for Project on Add Transaction Page)


Replication Steps:
------------------------

1. Implement Project Security based on operator id tree based security.2.
2. Associate a large number of projects (~600) to a particular user.
3. Try doing look up for Project on Add Transaction Page or any other page where the view SP_PROJ_OPRVW is used.
4. Observe the page 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