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