Beginning Balance (FE 60) & Runoff Balance in RES_DTL_xxxxx Less than Instrument Table Balance (Doc ID 1960641.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.1 and later
Oracle Risk Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Risk Manager (RM) or Oracle Financial Services Asset Liability Management (ALM), when running an ALM or RM Process, the balance from the instrument table does not match the beginning balance (FE 60) and total runoff balance (FE 210) in the Result Detail table, RES_DTL_xxxxx.  The balance from the RES_DTL_xxxxx table is less than the instrument table balance.

For example:

In MORTGAGES for USD: 2,035,594,794.12
In RES_DTL_xxxxx for USD for FE 60: 2,031,342,472.62

There is a gap of approximately 4 million.  You expect the balances to match.

This prevents you from reconciling the RM / ALM results with the instrument table data.

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