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

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

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.

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