OFSAAI Model Upload Fails With ORA-00942: table or view does not exist Errors (Doc ID 1492196.1)

Last updated on JANUARY 23, 2015

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)

Symptoms

On OFSAAI 7.3, when attempting to upload the data model (ALMBI_Datamodel.xml) with sliced mode, the following error results:

ERROR

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

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