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 laterInformation 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 |