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 184.108.40.206 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 : 220.127.116.11 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