My Oracle Support Banner

14M D1: CCRSM071 'Multiple Banking Relationships' Stage Tables In Lineage (Doc ID 2607002.1)

Last updated on NOVEMBER 11, 2019

Applies to:

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

Symptoms

Report FR Y-14M Schedule D1- The OFSAA lineage file for MDRM: M071 (Multiple Banking Relationships) requires identifying non-credit card banking relationships with the bank Lineage has issue as only cards is shown but PP tables applicable for products reported on this MDRM not shown RLFD_FRCS_NO_OF_ACCOUNTS_01 and RLFD_FRCS_NO_OF_ACCOUNTS_02 that have datasets The Bussiness Processor used by the rules mentioned below and corresponding dataset DS14M19 has the joins pointing to the Fact columns used for logic are not shown in lineage. Hence those and the following Staging tables also required:
(1) Staging tables required in lineage for loan/lease products (BP14M002,
BP14M003, BP14M004, BP14M005, BP14M009)
(2) Staging tables required in lineage for deposit products (BP14M001)
(3) Staging tables required in lineage for Investment Trust Products
(BP14M006)

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
References


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