Type 1 or 2 Ledger Load Fails with Error 'ORA-00918: Column Ambiguously Defined' (Doc ID 2162635.1)

Last updated on OCTOBER 05, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 and later
Oracle Financial Services Profitability Management - Version 8.0.2 and later
Oracle Financial Services Asset Liability Management - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) 8.0.2, the Type 1 or Type 2 Ledger Stat Load program, fn_ledgerDataLoader, fails with an error.  The following error exists in FSI_MESSAGE_LOG for the Ledger Loader batch:

WRAPPER_LEDGER_STAT_LOAD- Error: -918: ORA-00918: column ambiguously defined

The merge SQL generated for the Ledger Load contains the column "one" in 2 places.  For example:

25-JUN-2016 12:05:19 - AGGREGATE_METHOD = 115
25-JUN-2016 12:05:19 - Merge into lsl t using ( select
v.ACCUM_TYPE,v.CONSOLIDAT,v.ISOCRNCYCD,v.FINANC_ID,v.ORG_ID,
v.GL_ACCT_ID,v.CMN_COA_ID,v.PRDCT_ID,v.BALTYPECD,v.ds,
v.year_s, one,
m5,l.m1 Y1,l.m2 Y2,l.m3 Y3,l.m4 Y4,one,
l.m6 Y6,l.m7 Y7,l.m8 Y8,l.m9 Y9,l.m10 Y10,
l.m11 Y11,l.m12 Y12
FROM LS_LDTBL_v v,lsl l.........

As a result of this error, no data is moved from the staging table to the LEDGER_STAT table.

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