EGL9.1+: GLS8010 is Going To Error - ORA-00001: Unique Constraint (EMDBO.PS_KKLED_RECON_TMP) Violated (Doc ID 2158421.1)

Last updated on OCTOBER 03, 2016

Applies to:

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

Symptoms

On : 9.1 version, Functionality

When attempting to run report GLS8010 Budget Actual Reconciliation the following error occurs.

ERROR
-----------------------
SQL Error number ORA-000001: unique constraint (occurred. Process request failed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Enable Alternate Account.
  2. Make sure Account is mapped to many Alternate Accounts (One Account to One or Many AltAccts). For example Account 500000 is linked to multiple Alternate Accounts (607000 is the default and another one is 609000).
  3. Create a budget journal and post it.
  4. Create a journal in General Ledger, enter account 500000 and Alternate Account 607000.
  5. Edit and post journal.
  6. Navigate to Commitment Control > Budget Reports > Budgets/Actuals Reconciliation and run report GLS8010. Report is running to Success.
  7. Create another journal in General Ledger, enter account 500000 and this time use another Alternate Account, for example 609000.
  8. Edit and post journal.
  9. Navigate to Commitment Control > Budget Reports > Budgets/Actuals Reconciliation and run report GLS8010. Report is running in Error.
  10. Message Log is showing: SQL Error number ORA-00001: unique constraint ( occurred. Process request failed.
  11. Trace file is showing: SQL Status = 1, SQL Error = ORA-00001: unique constraint (EMDBO.PS_KKLED_RECON_TMP) violated


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot reconcile budget to actual.

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