Contract Expiration Ends In ORA-01722: Invalid Number Error
Last updated on AUGUST 03, 2017
Applies to:Oracle Lease and Finance Management - Version 12.2.4 and later
Information in this document applies to any platform.
On : 12.2.4 version, Asset Management
When attempting to expire contracts, termination transactions error out with the following with when there are no open receivables:
Auto termination request for contract 200-3112572-100
Step: Validate contract
ORA-01722: Invalid number in Package OKL_AM_LEASE_TRMNT_PVT Procedure check_open_receivable
Contract validation failed.
The issue can be reproduced at will with the following steps:
1. Create a DF Lease contract with end date in the past
2. Book the contract
3. Bill until the end date
4. Accrue the contract
5. Pay all open invoices
6. Run terminate expired contract and it does not expire and errors out
2. Termination Transactions error out with the above.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms