PC_FND_DIST Is Deleting Entries In Commitment Control Tables For Prior FDS Rows In Certain Cases. (Doc ID 2126401.1)

Last updated on APRIL 12, 2016

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

The replication steps is actually exactly what was documented in PC_FND_DIST Deleting Entries In Commitment Control Tables For Prior FDS Rows In Certain Use Cases.

The issue can be reproduced at will with the following steps:
1. Enable Commitment control for Projects and Grants.
2. Create a Proposal, submit and generate award.
3. Enter project budgets and finalize.
4. Create Fund Distribution Rules to take GLE transactions and create target fund distribution rows. The budget check is checked for the target fund rows.
5. Create a Journal in General ledger with journal date say 7/11/2013. Analysis Type on one of the line is 'GLE'. Journal ID is 000000174 is created. Post the Journal
6. Run PC_GL_TO_PC. The transactions made it to Project Costing.
7. Run PC_FND_DIST to create target fund distribution rows.
8. Target fund distribution rows 'FDR' and 'FDS' are created as per fund distribution set up in PS_PROJ_RESOURCE.
9. The journal ID is different on the FDR and FDS in PS_PROJ_RESOURCE. KK_TRAN_ID is commitment control tables KK_SOURCE_HDR, KK_SOURCE_LN and KK_ACTIVITY_LOG are different for FDR and FDS transactions.
10. Create another journal in GL with journal date say 10/11/2013. Analysis Type on one of the line is 'GLE'. Journal ID is 000000174 is created. Post the Journal
11. Run PC_GL_TO_PC. The transactions made it to Project Costing.
12. Run PC_FND_DIST to create target fund distribution rows.
13. Target fund distribution rows 'FDR' and 'FDS' are created as per fund distribution set up in PS_PROJ_RESOURCE.
14. The journal ID is different on the FDR and FDS in PS_PROJ_RESOURCE again. The problem is that data is wiped out for FDS transaction in KK tables for the earlier set of transaction data 7/11/2013.

 

 

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