Table Name Not in Uppercase - Missing Column Error Running Table Classification Script

(Doc ID 140334.1)

Last updated on OCTOBER 09, 2009

Applies to:

Oracle Financial Data Manager
This 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