DIM ACCOUNT Function FN_POPDIMACCOUNT Failed with ORA-00904 on FIC_MIS_DATE (Doc ID 1987027.1)

Last updated on MARCH 05, 2015

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.4.2.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When trying to populate DIM_ACCOUNT using function FN_POPDIMACCOUNT, it failed with the following error.

Error:
FSI_MESSAGE_LOG:

While dropping Table TEMP_DIM_ACCOUNT SQLErrm ORA-00942: table does not exists.
Tables Used = select V_ACCOUNT_NUMBER ACCOUNT_NUMBER , trunc(FIC_MIS_DATE) FIC_MIS_DATE , 1 LEG_TYPE FROM STG_CUSTOM where FIC_MIS_DATE = to_date('20150131','YYYYMMDD')
In others block ORA-00904: "FIC_MIS_DATE": invalid identifier

Changes

 STG_CUSTOM is customized.

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