My Oracle Support Banner

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

Last updated on FEBRUARY 28, 2019

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)


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.IDENTITY_CODE = 13883.000000

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.