My Oracle Support Banner

JA22/1752/A510 - HREG0509 - HIR - RR Consolidated Or Control Investment Flag Usage (Doc ID 2744323.1)

Last updated on JANUARY 19, 2021

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.

Goal

Version: RRS 8094
Schedules impacted: RC, RC-B, RC-F, RC-H, HC, HC-B, HC-F
MDRMs: JA22/1752/A510


JA22/1752/A510 - HREG0509 - HIR - RR Conso or Control Investment Flag usage

Issue:
1. JA22 (Equity investments with readily determinable fair values) requires reporting of:
- Report the fair value of all investments in mutual funds and other equity securities (as defined in ASC Topic 321, Investments-Equity Securities) with readily determinable fair values that are not held for trading.
Such securities include, but are not limited to,
- money market mutual funds, mutual funds that invest solely in U.S. Government securities,
- common stock, and
- perpetual preferred stock

Config for above MDRM checks for HREG0509: HIR - RR Conso or Control Investment Flag = 'Y', whereas for above use-cases the Flag will result in 'N' and therefore not getting reported.

--BP used in flag (BPRG1102: BP - RR Conso or Control Investment Flag)
CASE
WHEN FCT_REG_ACCOUNT_SUMMARY.F_INTERNAL_ISSUER_FLAG = 'N'
THEN 'N'
WHEN A_DIM_INT_ISSR_ORG_STRUCTURE.F_CONSOLIDATED_FLAG = 'N'
THEN 'N'
WHEN A_DIM_ISSUER_LV_OWNERSHIP_TYPE.V_OWNERSHIP_TYPE != 'NCINV'
AND COALESCE(FCT_PARTY_SHR_HLD_PERCENT.N_SHAREHOLDING_PERCENT, 0) * A_FSI_REG_PARAM_PCT_DIVISOR.
V_REG_REPORTING_PARAM_VAL <= 20
THEN 'N'
WHEN A_DIM_ISSUER_LV_OWNERSHIP_TYPE.V_OWNERSHIP_TYPE = 'NCINV'
AND COALESCE(FCT_PARTY_SHR_HLD_PERCENT.N_SHAREHOLDING_PERCENT, 0) * A_FSI_REG_PARAM_PCT_DIVISOR.
V_REG_REPORTING_PARAM_VAL <= 3
THEN 'N'
ELSE 'Y'
END

Above flag checking is not required, as below flags are sufficient to identify equity holdings
HREG1101: HIR - RR Holding Type = NOT HFT
HREG2301: HIR - RR Readily Deter Fair Value Flag = Y
HREG2336: HIR - RR Intra Comp Account Flag = N

2. Similarly HREG0509: HIR - RR Conso or Control Investment Flag = 'N' flag may be removed from 1752, A510, A511

3. ASU 2016-01 flag = Y mat be added to JA22, as this MDRM only applies to institution adopting ASU 2016-01.
Unless this is expected to be checked at AR level
 

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
References


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