Interface Trip Stop Errors With ORA-01086: Savepoint 'OM_SHIP_CONFIRM' Never Established In This Session Or Is Invalid
(Doc ID 2915186.1)
Last updated on APRIL 18, 2024
Applies to:
Oracle Shipping Execution - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
Interface trip stop fails with the following error:
Other data points:
Order Lines = Shipped status
Shipped and shipped quantity is updated on the order line.
Delivery = Closed
Trip Stop = Closed with Pending Interface Flag = P
Delivery Details = Shipped status with OM interface flag = P and Inventory Interface flag = N
ERROR
-----------------------
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 1
rollback to om_ship_confirm :
API Process_Stop_To_OM failed with an unexpected error
The unexpected error is ORA-01086: savepoint 'OM_SHIP_CONFIRM' never established in this session or is invalid
ORA-06510: PL/SQL: unhandled user-defined exception
UNEXPECTED ERROR IN Process_Stop_To_OM
Unexpected error has occured. Oracle error message is ORA-01086: savepoint 'OM_SHIP_CONFIRM' never established in this session or is invalid
ORA-06512: at "APPS.OE_SHIP_CONFIRMATION_PUB", line 5263
ORA-06510: PL/SQL: unhandled user-defined exception
Exiting WSH_SHIP_CONFIRM_ACTIONS.PROCESS_STOP_TO_OM - EXCEPTION:OTHERS (12/09/2022 05:22:43 PM, 34.17 seconds)
Rollback to savepoint its_process_order_non_bulk
Errmsg: ==> ORA-01086: savepoint 'ITS_PROCESS_ORDER_NON_BULK' never established in this session or is invalid
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 1
rollback to om_ship_confirm :
API Process_Stop_To_OM failed with an unexpected error
The unexpected error is ORA-01086: savepoint 'OM_SHIP_CONFIRM' never established in this session or is invalid
ORA-06510: PL/SQL: unhandled user-defined exception
UNEXPECTED ERROR IN Process_Stop_To_OM
Unexpected error has occured. Oracle error message is ORA-01086: savepoint 'OM_SHIP_CONFIRM' never established in this session or is invalid
ORA-06512: at "APPS.OE_SHIP_CONFIRMATION_PUB", line 5263
ORA-06510: PL/SQL: unhandled user-defined exception
Exiting WSH_SHIP_CONFIRM_ACTIONS.PROCESS_STOP_TO_OM - EXCEPTION:OTHERS (12/09/2022 05:22:43 PM, 34.17 seconds)
Rollback to savepoint its_process_order_non_bulk
Errmsg: ==> ORA-01086: savepoint 'ITS_PROCESS_ORDER_NON_BULK' never established in this session or is invalid
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. OM Super User
2. Shipping
3. Interfaces
4. Run Interface Trip Stop
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 |
Cause |
Solution |
References |