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

(Doc ID 2360867.1)

Last updated on FEBRUARY 16, 2018

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.5 and later
Oracle Financial Services Profitability Management - 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, Installation

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

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