Loan Maturity Update Event Fails with Error No Record Selected from T_LoanMaturityquery

Loan Maturity Update Event Fails with Error No Record Selected from T_LoanMaturityquery

No record selected from T_LoanMaturityquery


Root Cause:

The Loan Maturity Update Event is designed to work on and affect loans where Interest Method is one of these :

  • Arrears - code 0
  • Advance - code 1
  • Interest Only - code 2

 

If you do not have any active loans in the Service database with any of these Interest Methods, the Loan Maturity Update Event will fail.


Workaround:

If you do not service loans with the listed Interest Methods, then there is no need to schedule and run the Loan Maturity Update Event.

You should review the The Loan Maturity FFIEC Update Event description in the Help Topics (F1) and consider whether this event will be more suitable for you.

 

ArticleNumber:

000039043