OFSAAI Model Upload Fails With ORA-00942: table or view does not exist Errors
(Doc ID 1492196.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.x
Oracle Financial Services Analytical Applications (OFSAA)
On OFSAAI 7.3, when attempting to upload the data model (ALMBI_Datamodel.xml) with sliced mode, the following error results:
Start Firing with index script ....file name :XIE1COMMON_CHART_OF_ACCOUNTS_D_DIM_COMMON_COA.sql
Error while executing Update :Failed Executing Query. Reason: ORA-00942: table or view does not exist
The index script is creating an index on DIM_COMMMON_COA table, which does not exist. The table should also be created during the model upload.
The issue can be reproduced at will with the following steps:
1. New model upload with ALM_Datamodel.xml ==> successful
2. Sliced model upload with FTP_Datamodel.xml ==> successful
3. Sliced model upload with PFT_Datamodel.xml ==> successful
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document