Performance At The Called AE Step PC_SUM_RFSH.MAIN.UPDSTAT.S
(Doc ID 2215190.1)
Last updated on APRIL 11, 2023
Applies to:
PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
PC_PRICING process is taking long time to process even if the number of less to be process. This is in turn causing delay in submitting invoice to the customer. Seek your update on this at the earliest.
REPLICATION STEPS
=================
1. Navigate to Main Menu, Project Costing, Utilities.
2. Run PC_PRICING process.
As per the trace file:
PeopleSoft Application Engine Timings
(All timings in seconds)
2016-08-19 10.33.53
AE Program: CA_LIMITS
Total SQL Statement Count Time Count Time Count TimeTime
TempTbls.LMT1.S 1 0.000 1 324.654 0 0.000 324.654
TempTbls.LMT4-RP.S 1 0.000 1 311.144 0 0.000 311.144
AE Program: PC_SUM_RFSH
MAIN.UpdStat.S 3 0.000 3 784.061 0 0.000 784.061
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |