Poor Performance of PC Funds Distribution Process PC_FND_DIST in the PC_TO_KK application engine

(Doc ID 2334550.1)

Last updated on NOVEMBER 30, 2017

Applies to:

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

Symptoms

The Funds Distribution process, PC_FND_DIST, creates excessive KK_SOURCE_HDR rows causing excessive looping. In version 9.1, PC_FND_DIST populates one row in KK_SOURCE_HDR per project/activity and resource_id of FDS/FDR is stored in KK_SOURCE_LN. Now, in 9.2, it creates one row per PROJECT_ID/ACTIVITY/RESOURCE_ID_FROM which is causing excessive loop while performing PC_JOURNAL budget check. When comparing the code, Oracle added RESOURCE_ID_FROM in PC_TO_KK.BudCheck.Call2_F. We have 45,000 Project journals lines from PC_GL_TO_PC that goes through fund distribution and creates about 80,000 rows of FDS/FDR. We found in 9.1 we have about 1400 rows inserted in KK_SOURCE_HDR for the same data vs 13200 rows in 9.2, which causes additional processing time due to the additional looping. We are wondering why the code was changed to incude resource_id_from in generating KK_SOURCE_HDR. Without adding resourc_id_from criteria, we can easily tie PC Journal transaction to PROJ_RESOURCE by joining FDS/FDR resource_id in KK_SOURCE_lN/JOURNAL_ID. This resource_id_from change in 9.2 is negatively impacting our ability to process during the nightly batch as process takes about 3.5 hrs in 9.2 vs 90mins in 9.1

The performance and volume of data created should be similar to version 9.1.

The issue can be reproduced at will with the following steps:
Assumption is that there is a funds distribution rule defined for each project which has at least two target rows and commitment control is turned on.

1. Create GL Journal with 45,000 project and activity lines.
2. Run PC_GL_TO_PC process
3. Run PC_FND_DIST

Due to this issue, the process will not complete within the available production window.

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