My Oracle Support Banner

Contract Expiration Ends In ORA-01722: Invalid Number Error (Doc ID 2293631.1)

Last updated on FEBRUARY 22, 2019

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 <CONTRACT_NUMBER>
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.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.