PC_FND_DIST Not Using Accounting Date When Budget Checking The Fund Distribution Rows (Doc ID 2186245.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
PC_FND_DIST not using Accounting Date when budget checking the fund distribution rows

For Ex: If a July transaction is created in September in AP, PO or GL; The Accounting Date on the Transaction is July but the Creation date in in September. After Funds Distribution, the FDF and FDR rows will have Accounting date in July but the Budget tables (KK_ACTIVITY_LOG) get hit in September.

It used the date the process is ran. As a result the KK entries will hit incorrect periods in KK_ACTIVITY_LOG

EXPECTED BEHAVIOR
-----------------------
It should be using the accounting date when booking the budget so the KK_ACTIVITY_LOG will be booked to the correct accounting periods

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add voucher transactions in January - it booked the budget in January
2. Run PC_AP_TO_PC in JAN. it will create ACT with January acctg dt.
3. Prepare fund distribution
4. Run PC_FND_DIST in March, FDF/FDR will be booked in March even the acctg date for these rows are in January. (january is still open)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Because of PC replying on KK_TRANS_DT to calculate the Fiscal Year and Accounting period and GL deriving Fiscal Year and Accounting Period based on the Accounting Date. KK and GL is not sync. The moment we will cross 30th June (Our clients financial year is from 1st July 2015 to 30 Jun 2016) and run the Fund Distribution, it will hit KK in next year. Our client would never be able to reconcile fiscal year.
Because of this defect, we have to do massive data clean up to redistribute the KK entries to the right month based on the accounting period of the FDF/FDR rows from Project Resource.

Changes

 

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