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

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.

Symptoms

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:

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


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

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms