Interface Trip Stop Errors with Ship_confirm_new Unexpected Error : User-defined Exception and Ora-01086: Savepoint 'process_order' Never Established in This Session or Is Invalid

(Doc ID 2124716.1)

Last updated on JULY 19, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Interface Trip Stop

When attempting to run interface trip stop, the following error occurs.

ERROR
-----------------------

ENTERING PROCEDURE CLEAR_GLOBAL_STRUCTURE
leaving handle_nonbulk_mode U
ship_confirm_new UNEXPECTED ERROR : User-Defined Exception
Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt
ENTERING DELETE_ATTRIBUTE_CHANGES -1
LEAVING OE_MSG_PUB.COUNT_AND_GET 3
rollback to om_ship_confirm :
After OE_Shipping_Integration_PUB.Ship_Confirm_New TIME: ==> 03/31/2016 02:46:34 PM
l_return_status ==> U
NO. OF OE MESSAGES :3

Calling program unit OE_MSG_PUB.GET
Warning: You are changing a PO number that has already been sent on a shipment for this sales order.
Error msg: Warning: You are changing a PO number that has already been sent on a shipment for this sales order.

Calling program unit OE_MSG_PUB.GET
You are not allowed to create Line Price Adjustment because: Line is Invoice Interfaced.

Calling program unit OE_MSG_PUB.GET
ORA-01086: savepoint 'PROCESS_ORDER' never established in this session or is invalid
ORA-06512: at "APPS.OE_ORDER_PVT", line 10527
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06510: PL/SQL: unhandled user-defined exception in Package OE_Delayed
Error msg: ORA-01086: savepoint 'PROCESS_ORDER' never established in this session or is invalid

 

 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management Super User Responsibility
2. Shipping
3. Interfaces


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