Duplicate Rows in LEDGER_STAT After Ledger Load (Doc ID 316608.1)

Last updated on AUGUST 19, 2005

Applies to:

Oracle Financial Services Applications (OFSA) 4.5
Oracle Financial Data Manager - Version: 4.5
ofsa_util.ledger_stat_load
This problem can occur on any platform.

Symptoms

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.

For example:

You load data into LEDGER_STAT using the following load tables:

LS_LOAD_JAN
LS_LOAD_FEB

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

Cause

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