My Oracle Support Banner

EPC9.1+: PC_WRAPPER Looping At Steps PC_TO_KK.JOURID.UPDATE2 and UPDATE3 Causing Bad Performance (Doc ID 2068307.1)

Last updated on APRIL 19, 2019

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.


Enable Commitment Control and create a budget plan with 3 budget lines. Finalize the budget plan which will run the engine PC_WRAPPER. In the trace we can see that the step "PC_TO_KK.JourID.Update2" is updating the JOURNAL_ID. This is happening for the 3 budget rows we created.

However, the system seems to get into a loop, as the steps "PC_TO_KK.JourID.Update2" and "PC_TO_KK.JourID.Update3" are updating the JOURNAL_ID another 2 times, because we had 3 budget lines, but no data is getting updated.

The system is updating zero rows with a unique journal ID. So the more lines we have, the more times the system will loop causing a performance issue.




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

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