Ship Confirm Process Completes In Error: ORA-01086: savepoint 'START_SHIP_CONFIRM_DELIVERY' never established in this session or is invalid" (Doc ID 2086294.1)

Last updated on JUNE 09, 2017

Applies to:

Oracle Shipping Execution - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms


Delivery or trip being ship confirmed results in the following error from both Ship Transaction Form or triggered through wrapper program (calling Delivery Action API to ship confirm the delivery)


ERROR
-----------------------
Error in Routine WSH_NEW_DELIVERY_ACTIONS.CONFIRM_DELIVERY, Oracle Error - -1086 ORA-01086: savepoint 'START_SHIP_CONFIRM_DELIVERY' never established in this session or is invalid




STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Navigation:
Order Management Super User -> Shipping -> Transaction
Go to Delivery Tab, select the delivery and click on 'Ship Confirm'



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