My Oracle Support Banner

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)

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

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
Symptoms
Cause
Solution


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