Batch_Table_Class_Req Fails with '<Column> Was Not Found for Table <Table> in Rev_tab_columns' (Doc ID 1579605.1)

Last updated on FEBRUARY 10, 2017

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 (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), when you run the Table Classification program Batch_Table_Class_Req, the batch ends with a status of 'Failed'.  Messages like the following exist in FSI_MESSAGE_LOG:

Table FSI_D_LOAN_CONTRACTS ( 370)
FAILED: Column FSI_D_LOAN_CONTRACTS.HISTORIC_OAS was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.CHARGE_CREDIT_OCOST_REM_TERM was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.CHARGE_CREDIT_OCOST was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.CUR_OAS was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.ALL_IN_TP_RATE was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.LIQUIDITY_PREM_CHARGE_CREDIT was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.CUR_STATIC_SPREAD_ALT was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.HISTORIC_STATIC_SPREAD was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.CUR_STATIC_SPREAD was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.HISTORIC_OAS_ALT was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.HISTORIC_STATIC_SPREAD_ALT was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.ORG_MARKET_VALUE was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.BASIS_RISK_CHARGE_CREDIT was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.PRICING_INC_CHARGE_CREDIT was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.CUR_OAS_ALT was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
FAILED: Column FSI_D_LOAN_CONTRACTS.OTHER_ADJ_CHARGE_CREDIT was not found for table FSI_D_LOAN_CONTRACTS in rev_tab_columns
.
.
.

HINT: check_table_class_req procedure returned status N while validating table FSI_D_LOAN_CONTRACTS for classification code 370
Table FSI_D_LOAN_CONTRACTS Failed (370)

The errors prevent you from classifying the table for that classification code.  This may result in the table not appearing in an application like Profitability Management (PFT), Funds Transfer Priciing (FTP), or Asset Liability Management.

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