EGL: Budget Checking Process Is Not Updating Ledger_KK Correctly When There Is A Duplicate Insert Error Recorded In The Trace (Doc ID 1559738.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9 and later
Information in this document applies to any platform.

Symptoms

Customer Environment
====================
Financials 9
bundle #18.
Tools

Error
====
None reported


Issue
=====
Budget Checking process is not keeping LEDGER_KK and other Commitment Control(KK) tables in sync.

The delivered budget checking process does not appear to be updating LEDGER_KK in some cases when other KK tables are updated correctly.

We run the attached SQLs to determine the gap between KK tables and the ledger we are interested in.
KK_ACTIVITY_LOG - MINUS - LEDGER_KK



Replication Steps
================
Not able to replicate on demand nor capture issue occurring

Business Impact
===============
Ledger_KK and Activity Log are not in sync and they expect them to be. Impacting reliance on KK numbers

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