'ORA-00001: Unique Constraint (LEDGER_STAT)' Error Running Allocation When Currency Set to 'Same As Driver'
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)
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:  - oexec(),
oexn() SQL Function:  - 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.
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