EPC - PC_FND_DIST - Concurrency Issue Due to Step PC_FND_DIST.NETADJ.Step09E
(Doc ID 2587161.1)
Last updated on JULY 22, 2020
Applies to:PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
The fix for Bug 29647289 (PC_FND_DIST GENERATING ROUNDING ISSUES IN PROJ_RESOURCE WHEN DISTRIBUTING COSTS) that was delivered in FSCM 9.2 PUM Image 33 added new steps to PC_FND_DIST. Once of these new steps deletes data from a temp table but does not qualify the step with the process instance.
New step PC_FND_DIST.NETADAJ.Step09E contains this code:
DELETE FROM %Table(PC_F_BAL_TA4)
Since the deletion is not restricted by PROCESS_INSTANCE, concurrent execution of PC_FND_DIST by multiple users may cause a process instance to fail. The code should be modified to allow concurrent execution with the following change:
DELETE FROM %Table(PC_F_BAL_TA4) WHERE PROCESS_INSTANCE = %ProcessInstance
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