My Oracle Support Banner

Balances Loaded by Cash Flow Loader Are Larger than Expected in RES_DTL_xxxxxx (Doc ID 2479329.1)

Last updated on MARCH 31, 2021

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.0 to 8.0.6 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


In Oracle Financial Services Asset Liability Management (ALM) 8.0.x, when running the Cash Flow Loader program to load data from STG_ACCOUNT_CASH_FLOWS into the RES_DTL table, the balances loaded are larger by a certain factor.  For example, the balances loaded are 3x larger than the existing balances in STG_ACCOUNT_CASH_FLOWS.

For example:

Input Bucket 1 Balances in STG_ACCOUNT_CASH_FLOWS:

FE 210: 1250
FE 430: 46.5

Output Bucket 1 balances in RES_DTL_xxxxxx:

FE 210: 3750  (1250 * 3)
FE 430: 139.5  (46.5 * 3)

You do not understand why the balances in RES_DTL_xxxxxx do not match the exact balances from STG_ACCOUNT_CASH_FLOWS.


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

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