Receiving Savepoint Error when Rebooking a Contract

(Doc ID 2317049.1)

Last updated on OCTOBER 12, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Lease authoring.

When attempting to rebook a contract through front end, the following error is displayed:

ERROR
-----------------------
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01086: savepoint 'create_txn_contract_PVT' never established in this session or is invalid
ORA-06512: at "APPS.OKC_API", line 80
ORA-06512: at "APPS.OKL_CONTRACT_REBOOK_PVT", line 8597
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.OKL_CONTRACT_REBOOK_PVT_W", line 125
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Query a booked contract
2. Click on revise
3. Enter Rebook >> adjust rent >> Date: 01-Feb-2018 >> go and the error happens


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