My Oracle Support Banner

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

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'


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!


In this Document
Symptoms
Changes
Cause
Solution
References


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