My Oracle Support Banner

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.

Symptoms

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

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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