Rules Missing FCAS Filter. (Doc ID 2809890.1)

Last updated on OCTOBER 03, 2021

Applies to:

Goal

Cycle for Expanded batch in IFT4,

1) rule: Reg FD Reg Acc Summ Reg Business Segment 01 - Line Loans(RLFD_FRAS_REG_BUS_SEG_01) failed multiple times with error:

ORA-12801: error signaled in parallel query server P008, instance danuxl7350db05.XXXXX:u73500201 (1) ORA-01652: unable to extend temp segment by 128 in tablespace TEMP.

2) Reg FD Reg Acc Summ Reg Business Segment 05 - Line Loans Shift(RLFD_FRAS_REG_BUS_SEG_05) and Reg FD Credit Line Drawn Amt Weg Avg Int Rate for Ult Parent(RLFD_FCL_WA_INT_RATE_ULT_PARNT)long running due to FCAS filter missing.

Below filter condition is missing on this rule

 _AND fct_common_account_summary.n_mis_date_skey = to_number(TO_CHAR(TO_DATE('20210331', 'yyyymmdd'), 'YYYYMMDD')_

Without this filter we noticed cardinality as 1 on FCAS table.

3) RLFD_FRAS_REG_BUS_SEG_06>>Reg FD Reg Acc Summ Reg Business Segment 06 - Stand alone Loans Shift runninf very long and failing. Same issue exists on this Rule as well, FCAS date filter is missing.

4) Reg FD Reg Acc Summ Reg Business Segment 07 - Domestic Cards Shift - Long running without completion. Analyzed and found same issue. FCAS date filter is missing.

In addition to that when running the Select from Merge Manually found that the order in which inner join with FCAS is placed way after the left outer joins is causing issue, it needs to be reconsidered and moved up.
 

Solution

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