Termination Quotes Stuck and Termination Transactions show Error FRM-40654: Record Has Been Updated. Requery Block To See Change and ORA-06502: PL/SQL: numeric or value error (Doc ID 2985528.1)

Last updated on DECEMBER 21, 2023

Applies to:

Symptoms

Find that termination quotes are stuck in Accepted status and termination transactions show Error 1 below and FND Debug log shows Error 2:

ERROR 1
-----------------------
FRM-40654: Record has been updated. Requery block to see change
ORA-06502: PL/SQL: numeric or value error: NULL index table key value in Package OKL_ACCOUNT_DIST_PVT Procedure CREATE_ACCOUNTING_DIST
Step : Accounting Entries
Receivable adjustments cannot be processed because the adjustments are larger than the receivables open balance. Please unapply cash receipts applied after quote creation as needed.
Error: Adjustment record amount and accounted amount causes no need to execute
arp_process_adjustment.insert_adjustment exception: User-Defined Exception

ERROR 2
-----------------
okl.am.plsql.okl_am_lease_loan_trmnt_pvt.adjust_open_inv_recvbles called unapply_open_inv_rec , return status: E
okl.am.plsql.okl_am_lease_loan_trmnt_pvt.adjust_open_inv_recvbles EXCEPTION :G_EXCEPTION_ERROR
okl.am.plsql.okl_am_lease_trmnt_pvt.process_tq_adjustments Called okl_am_lease_loan_trmnt_pvt.adjust_open_inv_recvbles l_return_status = E
okl.am.plsql.okl_am_lease_trmnt_pvt.process_tq_adjustments EXCEPTION :G_EXCEPTION_ERROR
okl.am.plsql.okl_am_lease_trmnt_pvt.lease_termination_new "EXCEPTION :OTHERS, SQLCODE: -1086 , SQLERRM : ORA-01086: savepoint 'PROCESS_TQ_ADJUSTMENTS' never established in this session or is invalid
ORA-06510: PL/SQL: unhandled user-defined exception"
okl.am.plsql.okl_am_lease_loan_trmnt_pvt.lease_loan_termination_new EXCEPTION :OTHERS, SQLCODE: -1086 , SQLERRM : ORA-01086: savepoint 'lease_termination_new_PVT' never established in this session or is invalid
okl.am.plsql.okl_am_lease_loan_trmnt_pub.lease_loan_termination_new called OKL_AM_LEASE_LOAN_TRMNT_PVT.lease_loan_termination , return status: U
okl.am.plsql.okl_am_btch_exp_lease_loan_pvtprocess_termination "EXCEPTION :OTHERS, SQLCODE: -1086 , SQLERRM : ORA-01086: savepoint 'TRX_LEASE_LOAN_TERMINATION' never established in this session or is invalid
ORA-06510: PL/SQL: unhandled user-defined exception"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using lease super user responsibility, complete contracts Billing in Evergreen with Unpaid Rent Evergreen Invoices.
2. Create a Termination Quote Without Purchase, shows BNP - Rent Evergreen Invoices.
3. Accept the Termination Quote.
4. Pay the Unpaid Rent Evergreen Invoices with a Cash Receipt (or) Credit those Invoices using Lease Center Credit-Memo.
5. Submit the Terminate Expired Contracts Program for the Contract-Number.
6. Notice Error:Receivable adjustments cannot be processed because the adjustments are larger than the receivables open balance. Please unapply cash receipts applied after quote creation as needed.
7. In AR, Unapply earlier Cash-Receipt Applications to Rent Evergreen Invoices (or) Unapply Credit-Memo Applications to Rent Evergreen Invoices that we did in Step-4.
8. Recycle Termination Transaction, and Rerun Terminate Expired Contracts Program.
9. Error: FRM-40654: Record has been updated. Requery block to see change is observed.

Changes

Cause

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