My Oracle Support Banner

RC-C Potential Duplication Of Business Processors Usage (Doc ID 2696789.1)

Last updated on AUGUST 06, 2020

Applies to:

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

Symptoms

RC-C Potential duplication of business processors usage  

For RCFDK165, there is a replication of logic in BPFD1663 and BPFD1664. All the filters are the same except for multiplication with n_percent_encumbered in BPFD1663 as below. This is leading to excess balance.

BPFD1663 SUM((COALESCE(DERG1000.BPRG1011,0) + COALESCE(DERG1000.BPRG1012,0) + COALESCE(DERG1000.BPRG1013,0) + COALESCE(DERG1000.BPRG1014,0)) * (COALESCE(FCT_COMMON_ACCOUNT_SUMMARY.N_PERCENT_ENCUMBERED,0) / A_FSI_REG_PARAM_PCT_DIVISOR.V_REG_REPORTING_PARAM_VAL))

BPFD1664 SUM(COALESCE(DERG1000.BPRG1011,0) + COALESCE(DERG1000.BPRG1012,0) + COALESCE(DERG1000.BPRG1013,0) + COALESCE(DERG1000.BPRG1014,0))

BPFD1663 is being used for below MDRMs in RC-C with mentioned filters
RCFDA247 Underlying Securitized Flag =Y
RCFDA570 Underlying Securitized Flag = Y & Encumbrance Reason = SECTZN
RCFDA571 Underlying Securitized Flag = Y & Encumbrance Reason = SECTZN
RCFDA572 Underlying Securitized Flag = Y & Encumbrance Reason = SECTZN
RCFDA573 Underlying Securitized Flag = Y & Encumbrance Reason = SECTZN
RCFDA574 Underlying Securitized Flag = Y & Encumbrance Reason = SECTZN
RCFDA575 Underlying Securitized Flag = Y & Encumbrance Reason = SECTZN
RCFDB538 Underlying Securitized Flag = Y & Encumbrance Reason = SECTZN
RCFDG378 Encumbrance Reason = Pledge, Encumbrance Status = FUL#~#PAR, Underlying Securitized Flag= N
RCFDK098WORK Underlying Securitized Flag= N
RCFDK165 Underlying Securitized Flag= N
RCONB538 Underlying Securitized Flag = Y & Encumbrance Reason = SECTZN

MDRMs RCFDG378, RCFDK098WORK, RCFDK165 has configuration in HML with Underlying Securitization Flag= N. However, for RCFDG378 there is Encumbrance Reason = Pledge.

Shouldn’t the HML for these 3 MDRMs (RCFDG378, RCFDK098WORK, RCFDK165) have Underlying Securitization Flag= Y as well?

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


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