Duplicate Rows in LEDGER_STAT After Ledger Load
Last updated on AUGUST 19, 2005
Applies to:Oracle Financial Services Applications (OFSA) 4.5
Oracle Financial Data Manager - Version: 4.5
This problem can occur on any platform.
After running the LEDGER_STAT Load procedure (ofsa_util.ledger_stat_load) to load two months of data into the LEDGER_STAT table from two separate load tables, there are duplicate rows in LEDGER_STAT. The duplicate rows have the same value for all of the columns included in the LEDGER_STAT unique index. Each of the duplicate rows has a different month populated.
You load data into LEDGER_STAT using the following load tables:
When you query LEDGER_STAT for the loaded records, you see duplicate records with the same IDENTITY_CODE, CONSOLIDATION_CD, ORG_UNIT_ID, GL_ACCOUNT_ID, ISO_CURRENCY_CD, etc. One duplicate record has MONTH_01 populated while the other has MONTH_02 populated. Both have an ISO_CURRENCY_CD value of "USD".
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