My Oracle Support Banner

Error when Terminate Expired Contracts is Run for a Contract to Move From Booked to Evergreen (Doc ID 2391620.1)

Last updated on DECEMBER 02, 2020

Applies to:

Oracle Lease and Finance Management - Version 12.2.6 and later
Information in this document applies to any platform.


On : 12.2.6 version, Asset Management

Terminate Expired Contracts fails for contract <contract number> – The program errors, however, details are identified only when running in debug mode: 2 Begin(+) 1 In param, p_term_rec.p_quote_id: <Quote_id> 2 End(-) 1 called get_lines , return status: S 4 EXCEPTION :OTHERS, SQLCODE: -6502 , SQLERRM : ORA-06502: PL/SQL: numeric or value error 1 called OKL_AM_CNTRCT_LN_TRMNT_PVT.asset_level_termination , return status: U 4 EXCEPTION :G_EXCEPTION_UNEXPECTED_ERROR 1 called OKL_AM_LEASE_LOAN_TRMNT_PVT.lease_loan_termination , return status: U 4 EXCEPTION :G_EXC_UNEXPECTED_ERROR 1 After OKL_AM_LEASE_LOAN_TRMNT_PUB.lease_loan_termination_new l_return_status: U

The issue can be reproduced at will with the following steps:
Take contract <Contract Number> which has multi asset

Quote <Quote Number>
1. Create a partial without purchase termination quote on the contract selecting 1 asset - Quote Effective Date = 30-Aug-2017 (Contract end date: 31-Aug-2017, Contract Status in BOOKED)
2. Approve the quote
3. Accept the quote (Pre-proceeds termination workflow type)
4. Complete the documentation received step - Workflow action
5. Check that the asset return is created for the asset in SCHEDULED status
6. Update the status of the asset return to RETURNED
7. Submit Workflow background process to ensure that the Termination acceptance pre-proceeds worflow is complete
8. Cancel the quote from the termination quote HTML screen
9. Checke that the quote moved to CANCELLED status

Quote <Quote Number>
1. Created another quote - similar to the above one and on the same asset
2. Complete the same order of steps - through Step 7 above
3. Enable Debug log at user level (To capture debug messages)
4. Run Terminate Expired Contracts - providing the operating unit and contract number
5. Debug log extracted and uploaded to SR (<filename>.xlsx)




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.