My Oracle Support Banner

FFIEC009 - DTs Failing Due To Precision Error For FSI_RRS_ACCT_MITI_PLCD_COLL.N_COVERED_PERCENT (Doc ID 2747447.1)

Last updated on JANUARY 31, 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.

Symptoms

Version: RRS USFED 8.0.9.6.0
Report: FFIEC009

Issue: Following logic is used to derive the 'N_COVERED_PERCENT' in 'FSI_RRS_ACCT_MITI_PLCD_COLL' which is failing with error "ORA-01438: value larger than specified precision allowed for this column"

CASE WHEN COALESCE(FSI_RRS_ACCT_MITI_PLCD_COLL.N_EXPOSURE_AMOUNT_RCY, 0) = 0 THEN 0 ELSE LEAST((COALESCE(FSI_RRS_ACCT_MITI_PLCD_COLL.N_MITI_PLCD_COLL_AMOUNT_RCY, 0) * LEAST(COALESCE(FSI_RRS_ACCT_MITI_PLCD_COLL.N_MITI_PLCD_COLL_WEIGHT, 1), 1) / COALESCE(FSI_RRS_ACCT_MITI_PLCD_COLL.N_EXPOSURE_AMOUNT_RCY, 0)), 1) END AS N_COVERED_PERCENT

Changes

 NA

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
Changes
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.