REMAIN_TERM_C Column Missing From FSI_D_LOAN_COMMITMENTS Table

(Doc ID 1669246.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.13 and later
Oracle Financial Services Balance Sheet Planning - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

The REMAIN_TERM_C column appears to be missing from the FSI_D_LOAN_COMMITMENTS table.

ACTUAL BEHAVIOR
REMAIN_TERM_C is missing from FSI_D_LOAN_COMMITMENTS table.

EXPECTED BEHAVIOR
Expect this column to be on the FSI_D_LOAN_COMMITMENTS table as REMAIN_TERM_MULT_C and REMAIN_NO_PMTS_C columns in the same table. Also, this column is on every other FSI_D table.

There is also a cash flow edit rule that references the column:

Error Code: 9170
Error Condition: If REMAIN_NO_PMTS_C + (REMAIN_TERM_C (in days) / REPRICE_FREQ (in days)) > 2000

Check of the Erwin Data Model shows that the FSI_D_LOAN_COMMITMENTS table is missing the relationship to the PORTFOLIO super entity which contains the REMAIN_TERM_C column.

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