My Oracle Support Banner

14Q-B1/B2 - Clarification On Usage Of V_INSTR_CD_SRC_ID (Doc ID 2812134.1)

Last updated on OCTOBER 11, 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 80940, SVF Jan2020
Report/Schedule: 14Q B1/B2

Issue:
As per SVF, STG_INSTRUMENT_CONTRACT_MASTER.V_INSTR_CD_SRC_ID is required for 14Q-B, but not shown in Lineage/Configuration

Questions:
1) Is this field required to be sourced? or reporting would consider other fields (for CQSCP082/CQSHP082)
2) If sourced, should V_INSTR_CD_SRC_ID contain the values as listed in the definition: CUSIP, ISIN, CINS, COMMONCODE, INTERNALGENERATED, SEDOL, or will there be any dimension table? if yes, which dimension table?
3) What code/value should be used if there is not a public identifier for the instrument ID (i.e. internal identifiers)?
4) How CQSCP082/CQSHP082 would report Identifier Type (CUSIP/ISIN/Other)
 

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.