PC_FND_DIST Created Duplicate Target Rows When Multiple Processes Run At Almost The Same Time

(Doc ID 2310789.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

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

Symptoms

On :  9.2 with PUM Image 22

ACTUAL BEHAVIOR  
---------------
PC_FND_DIST created duplicate target rows when multiple processes run at almost the same time

When funds distribution is processed at the same time with the same run control parameters, the process performs the distribution twice (once for each process instance).

EXPECTED BEHAVIOR
-----------------------
No duplicate rows should be created

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a funds distribution by project.
2. Load expense transactions using transaction loader (excel to CI), run PC_INTFEDIT to load the transactions to proj _resource.
3. Have multiple users run funds distribution process for the same project at the same time.
4. The Funds Distribution process does not table lock.  It processes by PI so if you run the process at the same time it creates results twice.


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