Exception reports

An Exception Report is generated when a loan account contains inaccurate or missing information due to an unexpected event or manual changes to the loan account. These reports must be scheduled to be delivered to the system administrator or the personnel responsible for monitoring the system, and if there are any records with the code as Error,  you should log a support ticket with us.

Exception Reports are of two types, namely:

• Daily Loan Diagnostics Exception Report and

• ACH Filegen Failures Exception Report

Daily loan diagnostics exception report

This report gets updated everyday as a part of LoanDiagnosticJob and should be scheduled to be delivered early in the morning. The Daily Loan Diagnostics Exception Report contains a table that describes the error message and the details of the related lending account ID which might have invalid data. 

ACH filegen failures exception report

This report gets updated everyday as part of SOD and should be scheduled to be delivered at midnight. The ACH Filegen Failures Exception Report contains a table that describes if there are any exception sin the ACH file generation. Exceptions such as missing routing number, lending account number, loan amount or bank account. 

You will learn how to run a Daily Loan Diagnostics Exception Report and ACH FIlegen Failures Exception Report here. 

Step-by-step instructions

To navigate to Reports, do the following:

1. Click the App Launcher .

2. Scroll down and click Reports. To run the Daily Loan Diagnostics Exception Report, do the following:

3. Click Reports.

4. In the Navigation pane, click FOLDERS > All Folders.

5. Click Exception Reports.

   Exception Reports

   

   Note:

   You can also search for the Exception Reports by typing the same in the search box under All Folders.

6. Click Daily Loan Diagnostics.

7. Click Edit.

8. Click Run.

   Note:

   Here, you can see the details such as the error message, the date on which the error message was created, the level, the related loan account, and the error code. Now, this has to be sent to the concerned people for resolving the issue.

   • You can summarize information by various parameters of loans, data migration errors. You can view your loans, your team's loans and all the other loans available.

   • You can view the Report in various time frames as well.  Let us say, next due date, last due date, next amortization date to name a few. 

   • You can also view the Report in Custom range or Fiscal year, Fiscal quarter, Calendar year, Calendar quarter, Calendar Month, Calendar Week and Day; say, Yesterday, Tomorrow, Today, Last 7 days, Last 30 days to name a few.

   In the Daily loan diagnostics report, you can click the related Data Migration Batch ID to view the Data Migration Error Details.

   Note:

   You have now run the Daily Loan Diagnostics Exception Report.

Scheduling Future Run

You can also schedule your future runs by clicking Run Reports> Schedule Future runs.

Following are the steps to schedule your future runs:

1. Select the required field under Email Report to.

2. Select the required Frequency.

3. Enter the Preferred Start Time.

4. Select the required field under Save changes.

5. Click Save Report Schedule.

  Following are the steps to run ACH Filegen Failures Exception Report:

1. Click Reports.

2. In the left navigation pane, click FOLDERS > All Folders.

3. Select Exception Reports.

   Note:

   You can also search for the Exception Reports by typing the same in the search box under All Folders.

4. Click ACH Filegen Failures.

5. Click Edit.

6. Click Run.

   Note:

   In this report, you will see the details such as the error message, the date on which the error message was created, the level and the error code. Now, this has to be sent to the concerned people for resolving the issue.

   The ACH Filegen Failures Exception Report can be viewed in various forms:

   • You can summarize information by full name, date of creation, data migration ID, error code, error message, last modified date, lending account ID and processing error. You can view data migration errors and your team's data migration errors as well.

   • You can view the Report in various time frames.  Let us say, created date and last modified date.

   • You can also view the Report in Custom range or Fiscal year, Fiscal quarter, Fiscal week, Calendar year, Calendar quarter, Calendar Month, Calendar Week and Day; say, Yesterday, Tomorrow, This day, Last 7 days, Last 30 days to name a few.

In the ACH Filegen Failures Report, you can click the related Data Migration Batch ID to view the Data Migration Error Details.