My Oracle Support Banner

DG VA - Incorrect Threshold Setting - FCT_KI_DEF_THRSLD (Doc ID 2803083.1)

Last updated on SEPTEMBER 04, 2021

Applies to:

Oracle Financial Services Data Governance for North America Regulatory Reporting - Version 8.0.8 and later
Information in this document applies to any platform.

Symptoms

DG 80915 - DG Variance Analysis - Threshold Setting

Threshold Setting in FCT_KI_DEF_THRSLD Table

Case 1
When the Value of Threshold percent (N_upper_limit,N_LOWER_LIMIT) is moe than 99999% then its not breaching

Case 2
When Variance Percent is between 5.000000001% to 5.99999% ( Anything between 10 or 11)
The Check should be for anything greater then +5% or -5% , but these conditions may fail if Threshold is between.

N_upper_limit and N_LOWER_LIMIT in fct_ki_def_thrsld is Number(20) and can not modify value in decimals.

Cause

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
Symptoms
Cause
Solution
References


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