My Oracle Support Banner

Ledger Stat Load Type I is Failing with ORA-20009: ERROR Duplicate Rows (Doc ID 2331456.1)

Last updated on DECEMBER 03, 2019

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




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

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