Table Classification Error 'Column was not Found for Table in Rev_tab_columns' for 310 After Upgrade to 6.1.1 or Higher

(Doc ID 2028954.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1.1 and later
Oracle Financial Services Profitability Management - Version 6.1.1 and later
Oracle Financial Services Asset Liability Management - Version 6.1.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.3.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), after upgrading to Profitability Management (PFT), Funds Transfer Pricing (FTP), or Asset Liability Management (ALM) 6.1.1 or a higher version, the Table Classification Batch_Table_Class_Req batch fails with the following error in the logs in $FIC_DB_HOME/log/date:

Log Message here 1: Fri 19 May 2017 11:25:04 AM EDT||SEVERE||Stored procedure execution failed

You find errors in FSI_MESSAGE_LOG like the one below for code 310 (instrument profitability):

Table FSI_D_TRUSTS ( 310)
FAILED: Column FSI_D_TRUSTS.BRANCH_CD was not found for table FSI_D_TRUSTS in rev_tab_columns
"HINT1: Last query executed was select 0 from
                user_tab_columns a,rev_tab_columns b,
                   rev_column_requirements c
              where a.column_name = b.column_name
                and a.table_name = b.table_name
                and b.column_name = c.column_name
                and c.column_name = 'BRANCH_CD' and b.table_name = 'FSI_D_TRUSTS' and c.rev_data_type_cd = b.rev_data_type_cd  and ( a.data_length = c.data_length or c.data_length = a.char_length)
                and a.data_type = c.data_type"
HINT2: NO_DATA_FOUND exception encountered while validating table FSI_D_TRUSTS
HINT3: FSI_D_TRUSTS.BRANCH_CD: No record found in rev_tab_columns
HINT3: FSI_D_TRUSTS.BRANCH_CD: No record found in user_tab_columns
HINT3: FSI_D_TRUSTS.BRANCH_CD: No record found in user_tab_columns
Table FSI_D_TRUSTS.BRANCH_CD did not meet the column requirements. Check Column data type
HINT: check_table_class_req procedure returned status N while validating table FSI_D_TRUSTS for classification code 310
Table FSI_D_TRUSTS Failed (310)

The same error may occur for multiple tables and multiple columns.

You could classify the tables successfully in previous versions of 6.1.  You only get this error after installing 6.1.1 or a higher version.

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