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,
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