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

Last updated on APRIL 20, 2016

Applies to:

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

Symptoms

On : 9.1 version, Commitment Control, Fund Distribution

ACTUAL BEHAVIOR
---------------
When running fund distribution process with commitment control turned on, some of the data for FDS transactions in KK tables is getting deleted when different journals with same journal id and different journal dates are posted to proj_resource.


EXPECTED BEHAVIOR
-----------------------
When running fund distribution process with commitment control turned on, data should correctly be reflected in KK tables in all scenarios.

STEPS
-----------------------
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