Instrument Tables Are Missing Many Columns After Data Model Upload (Doc ID 1184321.1)

Last updated on MAY 21, 2012

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 5.2 and later
Oracle Financial Services Asset Liability Management - Version 5.2 and later
Oracle Financial Services Profitability Management - Version 5.2 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Checked for relevance on 21-May-2012.

Symptoms

After installing one or more of the Oracle Financial Services Applications (ex. Funds Transfer Pricing, Profitability Management, etc.) and uploading a merged data model, the number of columns on the instrument and transaction tables does not match the number of columns listed in the Data Dictionary.

For example, FSI_D_LOAN_CONTRACTS contains 110 columns in the database.
In the Data Dictionary documentation, FSI_D_LOAN_CONTRACTS contains 193 columns.

The instrument table appears to be missing many columns.  All of the standard FSI_D_LOAN_CONTRACT columns exist but the table is missing other groups of columns like the standard Cash Flow columns, Portfolio columns, and Leaf columns.

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