My Oracle Support Banner

I.U.7 - Cash In Process Of Collection - Coalesce Condition To Consider EOP Balance If Standard Amount Reporting Currency is NULL (Doc ID 2957928.1)

Last updated on JULY 03, 2023

Applies to:

Oracle Financial Services Liquidity Risk Measurement and Management - Version 8.0.7 and later
Information in this document applies to any platform.


 For I.U.7: Cash Items in the Process of Collection, please incorporate the below coalesce condition to pick the amount from N_EOP_BAL_RCY if N_STD_ACCT_HEAD_AMT_RCY is blank.

Coalesce condition to be added in the T2T LRM_FR2052A_6G_COMP_IU_7:


The cash items in the process of collection is coming from PP table. And It should not any impact for any clients who choose to load it from stg_standard_acct_head as the same column N_AMOUNT is mapped to N_EOP_BAL_RCY and N_STD_ACCT_HEAD_AMT_RCY.


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.