'ORA-00001: Unique Constraint (LEDGER_STAT)' Error Running Allocation When Currency Set to 'Same As Driver' (Doc ID 2089267.1)

Last updated on MARCH 04, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 5.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT), when you run a Dynamic Driver Ledger Stat to Ledger Stat Allocation that has Currency set to "Same As Driver" in the Debit or Credit screen, the Allocation fails with the following ORA-00001 error:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
    oexn() SQL Function: [189] - SQL function not found! Oracle
    Error: ORA- 00001: unique constraint (<atomic>.LEDGER_STAT)
    violated Driver Function: drv_oci::Execute()

If you check the "merge into" statement in the ofspa log from $FIC_DB_HOME/log/FusionApps, a section of the code looks for a blank ISO_CURRENCY_CD value:

AND    TARGET.YEAR_S = 2015
AND    TARGET.IDENTITY_CODE = 13883.000000
AND    TARGET.ISO_CURRENCY_CD = ''
AND    TARGET.CONSOLIDATION_CD = 100
 

If you make a copy of the Allocation and execute the copy, it runs successfully.  However, you expect to be able to run the original Allocation.

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