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 22.214.171.124 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 : 126.96.36.199 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