My Oracle Support Banner

Rules Missing FCAS Filter. (Doc ID 2809890.1)

Last updated on OCTOBER 03, 2021

Applies to:

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


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.


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

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