My Oracle Support Banner

FRY11_2314 : Greatest Function Around Unrealized Loss Gain Not Reporting Contra GL Plugs - (RRS 80912) (Doc ID 2730239.1)

Last updated on NOVEMBER 24, 2020

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

USFED 80912 Y11/2314 Report, For the MDRMs FR-2314 MDRM: SUBCA210 (BS-M.4.e) and FR-Y11 MDRM: BHCSA210 (BS-M.6.e), Client is not able to report the contra (-ve) GL reconciliation records. The business processor BPFD4018 has the following expression SUM(greatest(coalesce(fct_reg_account_summary.n_exp_unrealized_loss_gain_rcy, 0), 0)). Because of greatest function around the measure fct_reg_account_summary.n_exp_unrealized_loss_gain_rcy, it is not picking negative gl plugs though it satisfies all the reporting conditions. 

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.