My Oracle Support Banner

Interface Trip Stop Errors With You Are Changing A PO Number That Has Already Been Sent On A Shipment For This Sales Order (Doc ID 2124716.1)

Last updated on AUGUST 11, 2022

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


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.