My Oracle Support Banner

FFIEC -041 Report Showing 0 , Where It Should show Null (Doc ID 2600601.1)

Last updated on OCTOBER 31, 2019

Applies to:

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

Symptoms

List of impacted MDRMs:

Schedule RI
RIADC889 , RIADC890 ,RIADF228

Schedule RC-B
RIADB838 through RIADB861

Schedule RC-C Memo
RCONC391 , RCONF231, RCONF232

Schedule RC-D
RCON3531, RCONG386, RCON3541, RCON3546, RCONF624

Schedule RC-L
RCONG418 through RCONG462

Schedule RC-R Part II
RCONH171

In run FFIEC-041  Call Report, there were several instances where AgileReporter was populating a value of 0 when what was filed in FIS was N/A and should be blank in AgileReporter.

The logic for the expressions associated with the following MDRMs needs to be corrected.

For example, the expression in AgileReporter currently says: IF(TotalAssetSize>=10,000,000,000, RCONG418WORK,0)
The expression should say: IF(TotalAssetSize>=10,000,000,000, RCONG418WORK,NULL)

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


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