Batch_Table_Class_Req Fails with '<Column> Did Not Meet the Column Requirements' (Doc ID 1579603.1)

Last updated on MARCH 13, 2023

Applies to:

Symptoms

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

Table FSI_D_LOAN_CONTRACTS ( 360)

"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 = 'LRD_BALANCE' and b.table_name = 'FSI_D_LOAN_CONTRACTS'
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_LOAN_CONTRACTS
HINT3: FSI_D_LOAN_CONTRACTS.LRD_BALANCE: rev_column_requirements.rev_data_type_cd is 1 rev_tab_columns.rev_data_type_cd is 99
HINT3: FSI_D_LOAN_CONTRACTS.LRD_BALANCE: rev_column_requirements.data_length is 22 user_tab_columns.data_length is 22  user_tab_columns.char_length is 0
HINT3: FSI_D_LOAN_CONTRACTS.LRD_BALANCE: rev_column_requirements.data_type is NUMBER user_tab_columns.data_type is NUMBER
Table FSI_D_LOAN_CONTRACTS.LRD_BALANCE did not meet the column requirements. Check Column data type
HINT: check_table_class_req procedure returned status N while validating table FSI_D_LOAN_CONTRACTS for classification code 360
Table FSI_D_LOAN_CONTRACTS Failed (360)

The error prevents 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 Pricing (FTP), or Asset Liability Management.

Cause

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