My Oracle Support Banner

RC-E Line M.1.a RCON6835 - Incorrectly Removing Non-transaction Amounts (Doc ID 2639901.1)

Last updated on FEBRUARY 17, 2020

Applies to:

Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.8 and later
Information in this document applies to any platform.

Goal

RC-E Line M.1.a RCON6835 - Incorrectly removing non-transaction amounts

RC-E Line M.1.a RCON6835 (Total Individual Retirement Accounts (IRAs) and Keogh Plan accounts) requires both Transactional and Non-Transactional amounts (Col A and Col C).
However, for IRAMMDA, IRANOW, CERTIRAKEOGHTD, BPFD1591 is used with expression removing Non-transactional Balance.

WHEN FCT_DEPOSITS_BORROWINGS.N_NONTRANSACTIONAL_BALANCE IS NOT NULL THEN GREATEST((GREATEST(((COALESCE(FCT_REG_ACCOUNT_SUMMARY.N_EOP_BAL_RCY, 0) - COALESCE(FCT_REG_ACCOUNT_SUMMARY.N_ACCRUED_INTEREST_RCY, 0)) - (CASE WHEN DIM_BROKER_DEPOSIT_TYPE.V_BROKER_DEPOSIT_TYPE_CODE IN ('RECDEP', 'NBRRECDEP') THEN COALESCE(A_FRAS_NETTING_ASSETS.BPRG1601, 0) ELSE 0 END) - (CASE WHEN FCT_DEPOSITS_BORROWINGS.F_LIEN_MARKED_IND = 'Y' AND A_DIM_BS_CATEGORY_OFFSET_ACCT.V_BALANCE_SHEET_CATEGORY_CD = 'ASSET' THEN GREATEST((COALESCE(A_FRAS_OFFSET_ASSET.N_EOP_BAL_RCY, 0) - COALESCE(A_FRAS_OFFSET_ASSET.N_ACCRUED_INTEREST_RCY, 0)), 0) ELSE 0 END)), 0)) - (COALESCE(FCT_DEPOSITS_BORROWINGS.N_NONTRANSACTIONAL_BALANCE, 0)),0)
 

Solution

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
Goal
Solution


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