ORA-01722 Error When Billing Or Creating A Payoff
(Doc ID 2323283.1)
Last updated on JUNE 10, 2022
Applies to:
Oracle Loans - Version 12.2.6 and later Information in this document applies to any platform.
Symptoms
On : 12.2.6 version, Loan Servicing
When attempting to payoff a loan the following error occurs.
ERROR --------------- 1. ORA-01722: invalid number in Package LNS_BILLING_BATCH_PUB Procedure CREATE_SINGLE_OFFCYCLE_BILL 2. An error occurred creating the payoff documents for this loan. Please contact your system administrator
STEPS ---------------- The issue can be reproduced at will with the following steps: 1. Enter details for a loan payoff and submit.
BUSINESS IMPACT ------------------------- The issue has the following business impact: Due to this issue, users cannot payoff a loan.
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!