Getting ORA-20009: ERROR: Duplicate Rows While Running Wrapper_ledger_stat_load (Doc ID 2057902.1)

Last updated on SEPTEMBER 18, 2015

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)

Symptoms

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

Error:
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.

Steps:
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.


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