T2T_STG_ANNUITY_CONTRACTS_CAS Failed With ORA-00942: table or view does not exist Errors Due to Missing ALMBI Tables (Doc ID 2225441.1)

Last updated on JUNE 12, 2017

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 8.0.3 to 8.0.3 [Release 8]
Oracle Financial Services Asset Liability Management - Version 8.0.3 to 8.0.3 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)
Table to Table (T2T)

Symptoms

On ALMBI 8.0.3, several of the seeded T2T extracts are failing with ORA-00942: table or view does not exist errors.

ERROR

The T2T_STG_ANNUITY_CONTRACTS_CAS T2T failed with below error:
ORA-00942: table or view does not exist
FCT_COMMON_ACCOUNT_SUMMARY

The issue can be reproduced at will with the following steps.
1. Upgrade to ALM 8.0.3 App Pack via Patch 24695027 OFS Asset Liability Management Application Pack (OFSALM) Release 8.0.3
2. Run seeded T2T extracts
3. Find failed batches with errors

Changes

 Upgrade to ALM 8.0.3 App Pack via <Patch 24695027> OFS Asset Liability Management Application Pack (OFSALM) Release 8.0.3.

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