My Oracle Support Banner

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

Last updated on APRIL 05, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.5 and later
Oracle Financial Services Asset Liability Management - Version 8.0.5 to 8.0.5 [Release 8]
Oracle Financial Services Funds Transfer Pricing - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


On : 8.0.5 version, Installation

When attempting to run Instrument Table Validation procedure, the following error occurs.

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)

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.




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

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