My Oracle Support Banner

EPC 9.2 : Performance Issue With Calculate Percent Complete (PC_PERCENT) Process At Steps PC_PERCENT.41000000.SELECT, and PC_PERCENT.AMOUNT.SELECT2 (Doc ID 2918851.1)

Last updated on JANUARY 07, 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

Performance issue with PC_PERCENT Process.

Sample Timings Summary:

                                                  C o m p i l e                 E x e c u t e               F e t c h                        Total
SQL Statement                            Count      Time             Count        Time         Count          Time           Time
-------------------------------------------------------------------------------------------------------------------------------------------------
PC_PERCENT.41000000.SELECT    163828    24.770           163828     7117.510   163828        0.000         7142.280
PC_PERCENT.AMOUNT.SELECT2     455639   34.260           455639    2069.410   455639         0.000         2103.670

 

---
Total run time: 20120.730

Total time in application SQL: 15685.310      Percent time in application SQL : 78.0%

Total time in PeopleCode: 182.090               Percent time in PeopleCode : 0.9%

Total time in cache: 1.810                           Number of calls to cache : 164053

---


Replication Steps:

  1. Run the process Project Costing > Utilities > Calculate Percent Complete with 17 Business units in the run control and it took 5 hours. When the process is run with 33 business units it took 9 hours.

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.