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 OCTOBER 15, 2020

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)

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

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
Symptoms
Changes
Cause
Solution
References


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