Instrument Validation Classification Failed (310) on OPTION_COST did not Meet the Column Requirements (Doc ID 2360867.1)

Last updated on MARCH 13, 2023

Applies to:

Symptoms

On 8.0.5 version, when attempting to run Instrument Table Validation procedure, the following error occurs.

Error:

Table FSI_D_CASA ( 1001)
Table FSI_D_CASA Successfull (1001)
Table FSI_D_CASA ( 360)
Table FSI_D_CASA Successfull (360)
Table FSI_D_CASA ( 310)
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 = 'OPTION_COST' and b.table_name = 'FSI_D_CASA' 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_CASA
HINT3: FSI_D_CASA.OPTION_COST: rev_column_requirements.rev_data_type_cd is 17 rev_tab_columns.rev_data_type_cd is 17
HINT3: FSI_D_CASA.OPTION_COST: rev_column_requirements.data_length is 16 user_tab_columns.data_length is 22 user_tab_columns.char_length is 0
HINT3: FSI_D_CASA.OPTION_COST: rev_column_requirements.data_type is NUMBER user_tab_columns.data_type is NUMBER
Table FSI_D_CASA.OPTION_COST did not meet the column requirements. Check Column data type 
HINT: check_table_class_req procedure returned status N while validating table FSI_D_CASA for classification code 310
Table FSI_D_CASA Failed (310)
...etc

Steps to Replicate:
1. Installed FTP 8.0.5 successfully and model upload was successful.
2. Run Instrument Validation.
3. Received error in FSI_MESSAGE_LOG.

Changes

Cause

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