Getting ORA-20009: ERROR: Duplicate Rows While Running Wrapper_ledger_stat_load

(Doc ID 2057902.1)

Last updated on DECEMBER 26, 2017

Applies to:

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


While running Type 3 Ledger Stat Load Using STG_GL_DATA (wrapper_ledger_stat_load) the following error occurs.

ERROR: duplicate rows. INSERT_ONLY='Y' requires that there be no matching rows in LEDGER_STAT.
Delete all rows from LEDGER_STAT where IDENTITY_CODE = 10008 and rerun.

1. Loaded data for 31st August 2015 during that time system uploaded the data in ledger_stat with IDENTITY_CODE 10008 .
2. In the next run update the FIC_MIS_DATE for STG_GL_DATE to a different date for the same data.
3. Ran the Ledger Stat Load again and received the above error.


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