FRY 14Q-A10: BPRSLN20-BP SLN Weighted Avg Life Of Loans (Divide By Zero Error )
(Doc ID 2679130.1)
Last updated on JUNE 15, 2020
Applies to:Oracle Financial Services Data Governance for US Regulatory Reporting - Version 8.0.8 and later
Information in this document applies to any platform.
Version: RRS 80862
Report: FRY 14Q-A10:
BPRSLN20-BP SLN Weighted Avg Life of Loans
Logic change required for BP BPRSLN20
To calculate Weighted Avg Life of Loans for A.10 required as per Q1 Fed change, In , DE - DERSLN03 is modified.
This DE now has BP - "BPRSLN20-BP SLN Weighted Avg Life of Loans" with below expression:
ROUND(SUM(FCT_COMMON_ACCOUNT_SUMMARY.N_WEIGHTED_ACCT_LIFE_IN_MONTHS * FCT_REG_ACCOUNT_SUMMARY.N_EOP_PRIN_BAL_RCY) / SUM(FCT_REG_ACCOUNT_SUMMARY.N_EOP_PRIN_BAL_RCY))
This expression is throwing "Divide by Zero Error" for few of the segments which do not have data or sum of EOP balance is zero.
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