My Oracle Support Banner

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 later
Information in this document applies to any platform.


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):


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.


Workflow Line Status Activity Shows Ship - Line, Manual Ship Force ORA-20001


Line Status Messages in Order Output shows the following:
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)

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


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


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

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