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 FEBRUARY 03, 2019

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 123 – The program errors, however, details are identified only when running in debug mode: 2 Begin(+) 1 In param, p_term_rec.p_quote_id: 171926109147378618558504817860610384110 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 123 which has multi asset
Quote # 25090
1. Created 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)
Note: Different asset number was chosen to the asset in the problematic quote - But with similar asset profile (Cost, RV etc..,)
2. Approved the quote
3. Accepted the quote (Pre-proceeds termination workflow type)
4. Completed the documentation received step - Workflow action
5. Checked that the asset return is created for the asset in SCHEDULED status
6. Update the status of the asset return to RETURNED
7. Submitted 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. Checked that the quote moved to CANCELLED status

Quote # 25091
1. Created another quote - similar to the above one and on the same asset
2. Completed the same order of steps - through Step 7 above
3. Enabled 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 (export_SR_new_quote_debug_log.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.