LNS: Loans Portfolio Report Failed To Generate The Report Output (Doc ID 1583032.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Loans - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

11.5.10.2:

In LNS: Loans Portfolio Report when submitted for an organization that has only one or Multiple Paid-Off loans, the seeded "Loan Portfolio Report" template computation logic is failing to derive the "Percent of Portfolio by Amount." This is failing to generate the report output.

There is a scenario in the production instance where there is only one loan that is in 'PAIDOFF' status.
The loan got paid off on 15-Jul-2012.
The Loan Total Principal Balance is 0.00 Dollars for Org 00270.

The report has a code logic to display the "Percent of Portfolio by Amount" for each Loan Status based on the computation logic "Total Principal Balance/Total Amount".
While the Total Principal Balance is 0 for PAIDOFF Loans, the Total Amount is also 0 for this org.

Irrespective of Loan Status, if the Total Principal Balance is 0 and the Total Amount is 0 then report is failing to derive the "Percent of Portfolio by Amount".

This is causing the report to error out with 'No Data Found' due to failure in computation logic in this scenario.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms