My Oracle Support Banner

EPC: Project Costing > Third Party Integration > Load Transactions (PC_INTFEDIT) Process Performance Issue At PC_INTFEDIT.UPDATE4.UPDATE1.S (Doc ID 2215124.1)

Last updated on OCTOBER 29, 2020

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 problem with PC_INTFEDIT process. The process is taking progressively taking longer time to complete as the data volume goes up.

Sample processing times: 
For 1300 rows - process took 18 minutes
For 12000 rows - Process took 50 minutes
For 125000 rows - Process is taking about 7 hours.

PC_INTFEDIT.Update4.Update1.S is taking about 2112 seconds to process 11,000 rows because of iterations.
 
Replication Steps:

  1. Stage the INTFC_PROJ_RES with high volume of data.
  2. Run PC_INTFEDIT process

Changes

 

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
Changes
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.