EPC9.1+: PC_WRAPPER Looping At Steps PC_TO_KK.JOURID.UPDATE2 and UPDATE3 Causing Bad Performance
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms