REMAIN_TERM_C Column Missing From FSI_D_LOAN_COMMITMENTS Table
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)
The REMAIN_TERM_C column appears to be missing from the FSI_D_LOAN_COMMITMENTS table.
REMAIN_TERM_C is missing from FSI_D_LOAN_COMMITMENTS table.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms