My Oracle Support Banner

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 MARCH 12, 2019

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.3 to 8.0.3 [Release 8]
Oracle Financial Services Asset Liability Management Analytics - 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

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.