My Oracle Support Banner

EPC: PC_FND_DIST Created Duplicate Target Rows When Multiple Processes Run At Almost The Same Time (Doc ID 2310789.1)

Last updated on MAY 01, 2021

Applies to:

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

Symptoms

PC_FND_DIST creates duplicate target rows when multiple processes run at almost the same time.

Steps to replicate the issue:
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.


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.