My Oracle Support Banner

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

Last updated on MARCH 05, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.8 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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.