My Oracle Support Banner

Y14Q : A3 Schedule : DSCCIN02 - OR Condition (Doc ID 2659987.1)

Last updated on APRIL 24, 2020

Applies to:

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

Goal

 Issue #1: FRY14Q : A3 Schedule: Inner DE DECCIN02 below dataset join is not restricting data to run skey with f_reporting_flag = 'Y'.

( a_origination_date.d_calendar_date BETWEEN
dim_dates.d_fiscal_month_start_date AND dim_dates.d_fiscal_month_end_date )
OR ( a_purchase_dates.d_calendar_date BETWEEN
dim_dates.d_fiscal_month_start_date AND dim_dates.d_fiscal_month_end_date )
AND dim_run.f_reporting_flag = 'Y'

 

Issue #2: In the Rule RLFD_FRCS_NO_OF_ACCOUNTS_02 - Reg FD Reg Customer Summary No of Accounts 02, In DS14M19, there is an inner join to fct_deposits_borrowings. But there is no need for this join for this rule as fct_deposits_borrowings is not used in the rule at all.

 

Issue #3: In FRY-14M Schedule A1;CCHEJA26, CCRSJA26, CCFLJA26 (i.e. National Banks RRSD ID - Line item 141 and Line item 117 in 14M Schedule B1; Line item 123 in 14M
Schedule D1) are missing in Oracle documentation as verified from the OFSAA RRS 80820 HM Linkage.

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


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