PC_WRAPPER insert KK_STATUS_LN with Not Validated and BUDGET_STATUS as Default instead of OPEN in KK_CF_VALUE table (Doc ID 2193456.1)

Last updated on OCTOBER 14, 2016

Applies to:

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

Symptoms

ACTUAL BEHAVIOR  
---------------
PC_WRAPPER insert KK_STATUS_LN with Not Validated and BUDGET_STATUS as Default instead of OPEN in KK_CF_VALUE table


We have an issue where when finalizing the Budget Details of a Project, it adds the project to the KK_CF_VALUE table on the commitment control side but does not attempt to validate the entry. It seems that validation only happens if the ledger group has not been validated and only then will it go through and attempt validation on all entries within that Ledger Group for the values within KK_CF_VALUE. Maybe there's a standalone process that needs to run after PC_WRAPPER but we were not able to find that standalone process...only process found was the one attached to the link within Budget Definitions when a Ledger Group is not validated.

We also see that the entries in KK_CF_VALUE are given a status of "Default" when being inserted in by PC_WRAPPER. We are not sure what "Default" means since we were not able to find documentation that even show this as a translate value so we would like more details on this as well.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add Project budget for an award or for a project
2. Finalize the project to KK.
3. Check the KK Budget definition > Control Chartfield tab, it will show the new project inserted with KK_STATUS_LN as Not validated and BUDGET_STATUS as Default.

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