PC_SUM_RFSH/PC_BUD_SUM Performance Issue

(Doc ID 2282887.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

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

Symptoms

On : 9.2 version, Performance

ACTUAL BEHAVIOR
---------------
Performance issue with PC_SUM_RFSH process. Upgrading from 9.1 to 9.2 PUM 19 and needed to run the processes as part of upgrade step.

Most of the time is consumed in PC_BUD_SUM process.
AE Program: PC_BUD_SUM

ACT_REV.Insert1.S 736001 134.260 736001 8256.760 0 0.000 8391.020
ACT_REV.Select1.D 1 0.000 736001 548.940 1472002 127.990 676.930
FULL.Insert1.S 1 0.000 1 4576.500 0 0.000 4576.500
INS_TA1.Insert1.S 736001 140.760 736001 8381.930 0 0.000 8522.690


------------------------------------------------------------------------------------------

Total run time : 23326.280

Total time in application SQL : 23300.260 Percent time in application SQL : 99.9%

Total time in PeopleCode : 3.530 Percent time in PeopleCode : 0.0%

Total time in cache : 0.120 Number of calls to cache : 44

------------------------------------------------------------------------------------------

EXPECTED BEHAVIOR
-----------------------
PC_SUM_RFSH should complete in reasonable time.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run PC_SUM_RFSH process as part of upgrade steps

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