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 MARCH 02, 2023
Applies to:PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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.
- Stage the INTFC_PROJ_RES with high volume of data.
- Run PC_INTFEDIT process
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