Sales Order Fails To Book After Upgrade - Workflow Activity Ship Has Failed
(Doc ID 1269922.1)
Last updated on AUGUST 21, 2023
Applies to:
Oracle Shipping Execution - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to progress orders in the upgraded 12.1.3 instance, the following error occurs for all orders (upgraded, imported, copy, or new orders entered via the form):
ERROR
-----------------------
Note: Errors are from different activities.
APP-ONT-251013: There are no eligible activities to be completed. The flow may be completed. Please see the workflow monitor or status window for more information.
User-Defined Exception in packeage OE_Shipping_intergration_PVT Procedure Update_Shipping_From_OE Workflow activity ship has failed. Please fix error
OM Debug log file shows the following error:
Exiting WSH_UTIL_CORE.DEFAULT_HANDLER (01/03/2014 03:13:19 PM, .04 seconds)
Unexpected error has occured. Oracle error message is ORA-06508: PL/SQL: could not find program unit being called ------------------------------failure in shipping integration
Exiting WSH_INTERFACE.PROCESS_RECORDS - EXCEPTION:OTHERS (01/03/2014 03:13:19 PM, 2.58 seconds)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Navigate: Orders Workbench, Order Organizer > query the Sales order > go to the line in question >
3. Select Actions > Progress Order > and the error occurs
4. Retry Activities in Error also ends with error and the order does not progress
Changes
Upgraded from 11.5.10 to 12.1.3. This process works fine in the 11.5.10 environment but fails in the 12.1.3 environment
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 |