Table Name Not in Uppercase - Missing Column Error Running Table Classification Script
Last updated on OCTOBER 09, 2009
Applies to:
Oracle Financial Data ManagerThis problem can occur on any platform.
Checked for relevance on 09-Oct-2009
Oracle Financial Services Applications (OFSA)
Symptoms
When attempting to classify an Oracle Financial Services Applications (OFSA) instrument table using ofsa_app_utils.check_table_class_req script, the following error occurs.Error
FAILED: Table Property 1030 - Validate Correction Key
Invalid Object Name
Steps:
Run the following scripts to classify the mortgages table and received the error below:
SQL> set serveroutput on
SQL> execute ofsa_app_utils.check_table_class_req('mortgages',360);
Validating table to classification. Table: mortgages Classification Code: 360
Column was not found. Column: ACCRUAL_BASIS_CD
Missing column. Column: ACCRUAL_BASIS_CD
Table does not meet the column requirements.
Table did not meet column requirements. Table: mortgages
Object: mortgages
SQL> execute ofsa_app_utils.check_table_class_req('mortgages',330);
Validating table to classification. Table: mortgages Classification Code: 330
Object: mortgages
FAILED: Table Property 1030 - Validate Correction Key
Invalid Object Name
Table did not meet stored procedure requirements.Table: mortgages
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