Performance At The Called AE Step PC_SUM_RFSH.MAIN.UPDSTAT.S (Doc ID 2215190.1)

Last updated on DECEMBER 16, 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

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

Changes

 

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