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 APRIL 26, 2018

Applies to:

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

Symptoms

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:

okl.am.plsql.okl_am_cntrct_ln_trmnt_pvt.get_lines 2 Begin(+)
okl.am.plsql.okl_am_cntrct_ln_trmnt_pvt.get_lines 1 In param, p_term_rec.p_quote_id: 171926109147378618558504817860610384110
okl.am.plsql.okl_am_cntrct_ln_trmnt_pvt.get_lines 2 End(-)
okl.am.plsql.okl_am_cntrct_ln_trmnt_pvt.asset_level_termination_new 1 called get_lines , return status: S
okl.am.plsql.okl_am_cntrct_ln_trmnt_pvt.asset_level_termination_new 4 EXCEPTION :OTHERS, SQLCODE: -6502 , SQLERRM : ORA-06502: PL/SQL: numeric or value error
okl.am.plsql.okl_am_lease_loan_trmnt_pvt.lease_loan_termination_new 1 called OKL_AM_CNTRCT_LN_TRMNT_PVT.asset_level_termination , return status: U
okl.am.plsql.okl_am_lease_loan_trmnt_pvt.lease_loan_termination_new 4 EXCEPTION :G_EXCEPTION_UNEXPECTED_ERROR
okl.am.plsql.okl_am_lease_loan_trmnt_pub.lease_loan_termination_new 1 called OKL_AM_LEASE_LOAN_TRMNT_PVT.lease_loan_termination , return status: U
okl.am.plsql.okl_am_lease_loan_trmnt_pub.lease_loan_termination_new 4 EXCEPTION :G_EXC_UNEXPECTED_ERROR
okl.am.plsql.okl_am_btch_exp_lease_loan_pvtprocess_termination 1 After OKL_AM_LEASE_LOAN_TRMNT_PUB.lease_loan_termination_new l_return_status: U


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



Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.