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

Sl. No.

Bug ID

Bug Description

Change Description

1

32085437

PRODUCT AND ACCOUNT LEVEL DGS REPORT ARE RUNNING OVER 15 MIN FOR SOME OF THE MDRM

Relevant joins are modified to Inner Join and filters are added for Partition pruning to improve the performance.

2

32121260

PERFORMANCE ISSUES DGS- KI MAPPER BATCH

Removed merge statement to the Final mapper table and part of separate Task (Task6) Inserts are happening to the final Mapper tables.

3

32233220

DGS KI BATCH PERFORMANCE ISSUE

Resolved handling of multiple Legal Entities that are executed for an MIS date to display in the Variance Analysis dashboard.

Introduced a new column n_run_skey in the table FSI_DG_KI_GRP_RESULT to hold the runkey for each execution and to identify the assessment key for each runkey.

4

31883257

DGS MDRM/SCHEDULE ISSUE: DGS 808 (AND 809).

Removed the incorrect mapping of cells from the schedules of respective reports.

5

32105203

DGS VA: 80911 RCONP754WORK APPEARS TWICE WITH DIFFERENT DESCRIPTIONS.

Removed the incorrect mapping of the cell from the schedules of respective reports.

6

32198819

DGS VA - MDRM WITH CURRENT AND PREVIOUS PERIOD AS $0 ARE HIGHLIGHTED S RED SIGNIFYING THE THRESHOLD HAS BREACHED

Breached Flag derivation is corrected by including the legal entity for the previous value.

7

32206691

TASK28 - DGS DQ CTL BATCH - FSI_DGS_DQ_ERR_VAL_MAP - RECORDS REJECTED DUE TO DQ INCORRECT FORMATS

Added a new column in FSI_DGS_DQ_BALANCE_COL_MAP.V_SRC_PK_COLS to remove the dependency on DQ_RESULT_DETL_MASTER.

8

32204024

DGS DATA ORIGIN ANALYSIS REPORT PRODUCTION PERFORMANCE ISSUE

A new aggregated table is added to improve the report performance.

9

32180485

DGS DQ - CONTROL BATCH - GATHER STATS

Gather Stats is added on all the relevant tables in Data Quality Control Batch.