My Oracle Support Banner

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

Last updated on MAY 16, 2019

Applies to:

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


On :  9.2 with PUM Image 22

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).

No duplicate rows should be created

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.


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

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