My Oracle Support Banner

SICM - Data Element Clarifications/Alternate Sourcing (Doc ID 2807428.1)

Last updated on SEPTEMBER 22, 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

SICM - Data Element Clarifications/Alternate sourcing

Version: RRS 8094, SVF Jan2020

Issue:
1) STG_INSTRUMENT_CONTRACT_MASTER.F_ARS_SECURITY_FLAG - SVF Usage: 14Q-B
>>SICM also has V_IR_STRUCTURED_INSTR_CODE = ARS to identify auction rate securities

2) STG_INSTRUMENT_CONTRACT_MASTER.F_CONVERTIBLE_IND - SVF Usage: 14Q-C
>>V_INSTRUMENT_TYPE_CD has multiple values to identify convertible securities

3) STG_INSTRUMENT_CONTRACT_MASTER.F_CUMULATIVE_FLAG - SVF Usage: 14Q-C
>>V_INSTRUMENT_TYPE_CD has multiple values to identify cumulative securities

4) STG_INSTRUMENT_CONTRACT_MASTER.F_EQ_MONEY_MKT_IND - SVF Usage: 14Q-B
>>V_INSTRUMENT_TYPE_CD has value to identify Equity Money Market fund

5) STG_INSTRUMENT_CONTRACT_MASTER.N_DEBT_SENIORITY - SVF Usage: HC-M
>>SICM also has F_SUBORDINATED_INDICATOR for senior/subordinate identification

6) STG_INSTRUMENT_CONTRACT_MASTER.N_FACE_VALUE - SVF Usage: 14Q-C
>>For capital instrument reporting in 14Q-C, STG_CAP_INSTR_POSITIONS.N_NOTIONAL_AMT and STG_CAP_INSTR_DETL.N_NOTIONAL_AMT are available and are appropriate for aforementioned reporting.

7) STG_INSTRUMENT_CONTRACT_MASTER.V_INSTR_CD_SRC_ID - SVF Usage: 14Q-B
>>Usage not clear, not seen in HML Config/Lineage

8) STG_INSTRUMENT_CONTRACT_MASTER.V_ISSUER_NAME - SVF Usage: 14Q-C
>>Same information can be obtained from STG_PARTY_MASTER.V_PARTY_NAME/V_PARTY_FULL_NAME

9) STG_INSTRUMENT_CONTRACT_MASTER.V_ISSUER_TYPE - SVF Usage: RC-T
Same information can be obtained from STG_PARTY_MASTER.V_PARTY_TYPE

a) Since for each of the above elements, alternative is available which are already being sourced by customer.
Please confirm if these need to be sourced by customer
b) If above elements need not be sourced, then please provide the ETA for documentation removal (DE Sheet/SVF)
 

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.