My Oracle Support Banner

Rule RLUS_FRAS_REG_HIGH_RISK_IND_02 performance issue (Doc ID 2766686.1)

Last updated on APRIL 12, 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.


Rule- Reg US Reg Acc Summ High Risk Ind - 02 PD Percent (RLUS_FRAS_REG_HIGH_RISK_IND_02)

This rule is showing the performance issues due to the scan associated with LLFP. The problem is since the join with LLFP ensures a full table scan on
this table and requires global stats to be collected on LLFP table prior to every run. This slows down the entire batch cycle.




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.