Instrument Table Validation Failed Due to Column Data Type (Doc ID 1335531.1)

Last updated on JULY 05, 2011

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2.8 and later   [Release: 7 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms


When attempting to run Instrument Table Validation batch, the following error occurs.

Error:
FSI_MESSAGE_LOG shows the following:

Table FSI_D_CREDIT_LINES.EFF_INTEREST_RATE_C does not meet the column requirements. Check Column data type
Table FSI_D_CREDIT_CARDS.EFF_INTEREST_RATE_C does not meet the column requirements. Check Column data type
Table FSI_D_MORTGAGES.EFF_INTEREST_RATE_C does not meet the column requirements. Check Column data type
...etc.


Steps:
1. Applied OFSAA 5.5 Service Pack and execute steps in the Readme.
2. Performed data model merge per the Readme of 5.5.
3. Upload data model successfully.
4. Run INSTRUMENT_TABLE_VALIDATION and received the error.

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