Oracle Financial Services Data Management Application Pack v8.0.9.0.0 Maintenance Level Release #1 (8.0.9.1.0)

Sl. No.

Bug ID

Bug Description

Change Description

1

31895784

DGS - VARIANCE ANALYSIS: MDRMS NOT ASSESSED IN KI ASSESSMENT PROCESSING

Measures for the missing cells are included to participate in the KI Assessments.

2

31864175

MISMATCH IN FSI_CONTROL_ASSESS_SUMMARY

Data Quality Exceptions like Warning, Error, and Information and Default are considered for Control Assessment.

3

31855046

MISMATCH OF DGS CONTROLS UI V/S DATABASE TABLES

MIS Date filter is considered to show the Data Quality exception counts in the Control UI.

4

31848446

NUMBER OF DQ CHECKS COUNT – NOT POPULATED IN OBIEE "CONTROLS BY REGULATORY REPORTS"

Control Data Quality T2T is modified to resolve this issue.

5

31802029

DGS DQ CTL BATCH - TASK 26 - FN_CREATE_ASSESSMENT

Column Length of V_DQ_CHECK_ID is changed to varchar2(4000) in the FSI_CTL_EFFECTIVENESS table.

6

31778862

DGS_DQ_CTL_BATCH - FN_CREATE_CONTROL - TASK 24 FAILURE

Column Data Size is increased in the following tables:

·         FSI_CONTROL

·         FSI_CTL_EFFECTIVENESS

·         FSI_CONTROL_DQ_MAP

7

31776200

DGS DQ CTL BATCH - DQATTRIBUTESTATS.SH - TARGET TABLES ARE NOT GETTING POPULATED

In Control Data Quality Batch the following are resolved:

·         The existing Task 14, Data Quality AttributeStats, and task 4, Mat view refresh for vw_result_Detl_Master are replaced with a Task 4.

·         Task 4 currently populates fct_dgs_dp_record_attr_stats and fct_dgs_dp_record_stats tables.

·         While Populating the fct_dgs_dp_record_attr_stats and fct_dgs_dp_record_stats tables Parallel Hint and also truncate Options and Partition are enabled.

8

31756656

DGS DQ CTL BATCH - FN_LOAD_FSI_ERROR_DATA_P (TASK 9)

Changes are done to materialized view VW_RESULT_SUMM_MASTER to get the max iteration number for an MIS Date.

9

31739777

DGS: A-10 REPORTING DATE AND MONTH PROMPT

A-10 reporting month column is filtered based on the MIS Date.

10

31739525

DGS_DQ_CTL_BATCH TASK1 FAILURE DUE TO SOURCE AND TARGET COLUMN DATA TYPE MISMATCH

Changes are done to materialized view VW_DQ_CHECK_MASTER to address the Data Type Mismatch in the DQ_CHECK_MASTER table.

11

31672479

DGS - A10 STUDENT LOAN REPORT SHOWING UP ONLY 2 MONTH END DATA IN A QTR

A-10 data is fetched based on Entity Code instead of Entity Skey.

12

31644738

DGS A-10 SCHEDULE ISSUES

LRI Flag is removed to fetch prior month’s data.

13

31541562

JOINS WITH DIMENSIONS IN T2TS MISSING FILTER TO CHECK ONLY LATEST RECORDS

Record Start Date and End Date filter from the dimensions are used in the T2Ts.

14

31705773

AUTOMATING DGS DIRECT POSTING BATCH EXECUTION- SELECTING RUN KEY

All the available RunSkeys for the MIS Date and Legal Entity combination are auto-populated for the user to select in the Adjustment Batch window.

Sl. No.

Bug ID

Bug Description

1

31960077

DQ EXCEPTION REPORT TO BE SUPPORTED FOR DATA ORIGIN (SOR)

2

31960099

DQ EXCEPTION SUMMARY PAGE NEEDS TO BE SHOWN THE MDRM AND DQ WISE CELL AND EXCEPTION AMOUNT