Last updated on MARCH 05, 2015
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
When trying to populate DIM_ACCOUNT using function FN_POPDIMACCOUNT, it failed with the following error.
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
STG_CUSTOM is customized.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms