Classification Error: Column Did Not Meet Detail Requirement

(Doc ID 150800.1)

Last updated on OCTOBER 23, 2009

Applies to:

Oracle Financial Services Applications (OFSA) 4.5
Oracle Financial Data Manager - Version: 4.5 to 4.5.39
This problem can occur on any platform.
Checked for relevance on 23-Oct-2009.

Symptoms

You cannot classify a table for use in Oracle Financial Services Applications (OFSA) 4.5.  When you run the table classification requirements procedure (ofsa_app_utils.check_table_class_req), you receive the following errors:

Column did not meet detail requirement. Column: <column name>
Column detail requirements not met. Column: <column name>

Steps to replicate:

1. Log into SQL*Plus as the OFSA database owner
2. Execute the table classification requirements procedure on an instrument table

Example:

SQL> set serveroutput on
SQL> execute ofsa_app_utils.check_table_class_req ('MORTGAGES', 310);

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