My Oracle Support Banner

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.

Goal

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.
 

Solution

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
Goal
Solution


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