My Oracle Support Banner

Getting 'invalid identifier' Error for Some Columns Existing in ALMBI Repository but Not in ALM Data Model (Doc ID 2429720.1)

Last updated on AUGUST 07, 2018

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 8.0.6 and later
Oracle Financial Services Asset Liability Management - Version 8.0.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Asset Liability Management Analytics (ALMBI) 8.0.6, when reviewing the Repository (RPD), you find that there are several columns that get an "invalid identifier" error:

Under 'ALM Model':

Dim Credit Rating > DIM_CREDIT_RATING > N_CREDIT_RATING_CD: invalid identifier

Fact Common Account Summary > FCT_COMMON_ACCOUNT_SUMMARY > V_STOCK_TYPE: invalid identifier

Dim Country > DIM_COUNTRY > V_LAST_MODIFIED_BY: invalid identifier

Dim Customer > DIM_CUSTOMER > V_D_CUST_NO_OF_PRODUCTS_LEVEL2: invalid identifier

Fact Ledger Stat > FCT_LEDGER_STAT > N_PRODUCT_SKEY: invalid identifier

Under 'FTP ALiases':

Fact Common Account Summary > FCT_COMMON_ACCOUNT_SUMMARY > V_STOCK_TYPE: invalid identifier

Dim Account > DIM_ACCOUNT > V_CONTRACT_CODE: invalid identifier

Fact Ledger Stat > FCT_LEDGER_STAT > N_PRODUCT_SKEY: invalid identifier

The columns getting the 'invalid identifier' error do not exist in the ALM 8.0.6 Data Model.

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
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.