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.

Symptoms

 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:

coalesce(fsi_lrm_instrument.n_std_acct_head_amt_rcy,
fsi_lrm_instrument.n_eop_bal_rcy)

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.

Cause

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
Symptoms
Cause
Solution
References


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