Sales Order Fails To Book After Upgrade - Workflow Activity Ship Has Failed (Doc ID 1269922.1)

Last updated on MAY 04, 2017

Applies to:

Oracle Shipping Execution - Version 12.1.3 to 12.1.3 [Release 12.1]
Information 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.

 

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)


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

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