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 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)


On : version, Calculation Engine

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


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).


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