My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

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 = xxxxx and rerun.

Steps:
1. Loaded data for Month A in ledger_stat where data already exists for Month A with IDENTITY_CODE xxxxx.
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.