My Oracle Support Banner

FRY-12, Sch D. Missing Staging Pp Tables. (Doc ID 2604532.1)

Last updated on NOVEMBER 04, 2019

Applies to:

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

Symptoms

Version :8.0.6
Report : FRY-12,
Sch D.
Issue: Missing staging pp tables.
The OFSAA lineage file (v8.0.6) only shows element going back to the DIM tables
(DIM_REG_EQ_INVST_CLASSFCTN.V_REG_EQTY_INV_CLASS_CODE and DIM_REG_EQ_TXN_GROUP.V_REG_EQTY_TXN_GROUP_CODE), and does not go back to show elements coming from stage PP tables (expected stage PP table(s): Stg_Investments or Stg_Fund_Equity_Investments or Stg_Equity_Exposures).

Changes required for  MDRMs the associated fields sourced from the stage PP tables and also it is missing from the Lineage File.

Impacted MDRMs: BHEIC731, BHEIC732, BHEIJ434, BHEIJ435, BHEIC733, BHEIC734, BHEIC735, BHEIC736, BHEIJ436, BHEIJ437, BHEIC737, BHEIC738, BHEIC739, BHEIJ438, BHEIC740, BHEIC741, BHEIC742, BHEIJ439, BHEIJ440, BHEIC743, BHEIC744

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.