Getting ORA-20009: ERROR: Duplicate Rows While Running Wrapper_ledger_stat_load
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