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

Sl. No.

Bug ID

Bug Description

Change Description

1

32405838

DGS DQ - TASK 29 - PERFORMANCE ISSUE

VW_ACCNT_DQ_ASSMNT table is converted into physical tables to improve performance. As part of Task 29, an optional parameter of Data origin is provided which can be used.

2

32434735

DGS VA - ENHANCEMENT - OOB TRUNCATE TABLE FUNCTION

Along with DIM_RUN F_REPORTING_FLAG='Y' included FCT_REG_RUN_LEGAL_ENTITY_MAP table join to pick only Regulatory Runs during Account Mapper and Key Indicator Assessment processing.

3

32150441

DGS DQ - TASK 4 - FCT_DGS_DP_RECORD_ATTR_STATS INSERT - ADD FILTER (SOR / BATCH ID)

For Task4 and Task 28 optional parameter Data Quality Batch ID is provided.

4

31924791

DGS ENHANCEMENT - DGS VA : ISSUE TO PERFORM KI ASSESSMENT WITH DYNAMIC RUNSKEY PICKING

Along with DIM_RUN F_REPORTING_FLAG='Y' included FCT_REG_RUN_LEGAL_ENTITY_MAP table join to pick only Regulatory Runs during Account Mapper and Key Indicator Assessment processing.

5

31961361

DGS VA REPORTS GL BASED DRILL DOWN REPORTS REQUIRE JOINS ON CURRENCY CODE

Currency join between Key Indicator Repline map and FCT GL data is provided.

6

32502214

DGS VA OBIEE - FMR DRILL DOWN - SOR LEVEL REPORTS ARE NOT SHOWING UP

For GL and Account templates, a Product level drill-down is added.

Addressed it for the following templates:

·         GL 1 ACC 1 DRL DW

·         GL 1 ACC 2 DRL DW

·         GL 1 ACC 5 DRL DW

7

32502214

Heavy Data Volume of certain MDRM's are making the load time of Reports longer

For GL and Account templates, a Product level drill-down is added.

The dimension filter is added at the first level drill down and then it is passed to the next level drill-down also as filters.

Account name dimension excluded from the dimension list at the product level.

Addressed it for the following templates:

·         GL 1 ACC 1 DRL DW               

·         GL 1 ACC 2 DRL DW               

·         GL 1 ACC 5 DRL DW

·         ACCOUNT 4 DRL DW

·         ACCOUNT 5 DRL DW

·         ACCOUNT 6 DRL DW

8

32598247

FEW OF THE CELLS OF L SCHEDULE NOT POPULATING IN THE ACCOUNT MAPPER.

Introduced New Party Mapper granularity table.

9

32672198

DGS DQ - FSI_DGS_DQ_BALANCE_COL_MAP - Delete entry of Non-PP Tables "STG_ACCT_WRITE_OFF_DETAILS"

Entry for STG_ACCT_WRITE_OFF_DETAILS is removed from the FSI_DGS_DQ_BALANCE_COL_MAP.

10

32448011

DG VA - 80915 - GATHER STATS FOR KI ASSESSMENT BATCH

Gather stats on the GTT table are removed and the gather stats is done only at the partition level in the final mapper table.

Sl. No.

Bug ID

Bug Description

1

32672213

ACCOUNT MAPPER AND KI ASSESSMENT VALUE MISMATCHES FOR MDRMS RELATED TO DEFD3121.BPFD3122 FOR FFIEC-009 REPORT