PC_PRICING PERFORMANCE (UPDULDIS.UPDBIL, UPDULDIS.UPDCST, UPDULDIS.UPDREV) (Doc ID 1665846.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9 and later
Information in this document applies to any platform.

Symptoms

When running PC_PRICING, the performance of the process is very slow for steps: UPDULDIS.UPDBIL, UPDULDIS.UPDCST, UPDULDIS.UPDREV

ACTUAL BEHAVIOR
---------------
For 3,000 rows, it is taking over 3 hours
 
EXPECTED BEHAVIOR
---------------
For 3,000 rows, it shouldn't take this long to process


ENVIRONMENT
---------------
Application & Version: PC 9.0
Bundle/Patch: 44
Environment: Production

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Run PC_PRICING Process


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