PC_FND_DIST Created Duplicate Target Rows When Multiple Processes Run At Almost The Same Time
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.
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.
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