PC_FND_DIST Does Not Net ODL Correctly When Inactivating Sequence

(Doc ID 2320321.1)

Last updated on NOVEMBER 13, 2017

Applies to:

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

Symptoms

On : 9.2 version, Functionality

ACTUAL BEHAVIOR
---------------
PC_FND_DIST does not create target rows correctly when Inactivating Sequence against which earlier distribution has taken place. Also notice the incorrect distributed amount in the funds distribution page. Negative ACT source amounts are involved that are equal/greater than the earlier processed amounts.

EXPECTED BEHAVIOR
-----------------------
PC_FND_DIST should create target rows appropriately and also display distributions correctly on the funds distribution page

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Project/3 Activities CONST, FEDERAL, STATE
2. Create a Contract and associate FEDERAL and STATE activity with rate set attached
3. Add Funds distribution rule with 2 sequences. SOURCE ACT, PAY, TLC


Target Sequence 1: 10,000


% - analysis_type, activity
85.44 - FND - FEDERAL
14.56 - FND - STATE


Target Sequence 2: 1,313.37


% - analysis_type, activity
90 - FND - FEDERAL
10 - FND - STATE


3. Add and ACT transaction for 100,000 in CONST activity
4. Run funds distribution process


ODL of 88686.63 created and
2 FND for federal activity with amounts 8544, 1182.03
2 FND for state activity with amounts 1456, 131.34

5. Run PC_PRICING, to generate target BIL rows from FND rows of federal and state
6. Run CA_BI_INTFC and PSA_ACCTGGL process


7. Create -100,000 ACT transaction in CONST activity
8. Inactivate Target Sequence 1
9. Run Funds distribution with reprocessing option on as per the message that comes when you inactive the Target Seq 1.

10. Run Funds distribution with unprocessed rows option

ODL is removed.
The target FND rows for federal and state are incorrect
2 FND for federal activity with amounts 79817.97, -90,000
2 FND for state activity with amounts 8868.66, -10,000

11. Funds Distribution shows a -10,000 for the Distributed Amount on Sequence 2 which is incorrect and does not match the Distributed Amount at the Line Level. This is incorrect

12. Expectation is to see in PROJ_RESOURCE instead of the rows created in #10
ODL for Activity CONST01 for 10,000 and
2 FND for federal activity with amounts 79817.97, -81,000
2 FND for state activity with amounts 8868.66, -9,000

13. Also the Sequence #2 distribution should be 0 and the line amount distributions should be 0 in Funds Distribution instead of what is displayed in #11.


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