Ledger Stat Load Type I is Failing with ORA-20009: ERROR Duplicate Rows

(Doc ID 2331456.1)

Last updated on NOVEMBER 22, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.1.1 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

On : 6.1.1.1 version, Calculation Engine

When attempting to run Ledger Load for one month data, the following error occurs.

Error


Steps to Replicate
1. Do steps mentioned in How to Do All Steps of a Type I OFSAA Ledger Stat Load? <Document 1226243.1>.
2. Run the Ledger Stat load using parameters "'LS_LDTBL','FISCAL_ONE_MONTH','REPLACE','Y','08','08'"
3. Ensure that no data in Ledger Stat with the same Identity Code.
4. Ensure that there is no duplication in the LS_LDTBL (the Loading table).

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