PC_FND_DIST Sets FND_DIST_STATUS To P And Does Not Unlock It If Row Was Not Processed

(Doc ID 2348734.1)

Last updated on JANUARY 15, 2018

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 engine sets FND_DIST_STATUS flag to P and does not unlock it if the row was not processed. 

Steps
1. Create a project.
2. Create an activity.
3. Add an ACT transaction with the accounting date and transaction date of 01/10/2017.
4. Add Funds Distribution for that project with the effective date of 11/10/2017.
5. Run PC_FND_DIST process.
6. No fund row was created and the FND_DIST_STATUS of the ACT row was updated to P.

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