Shipment Actual Interface Program Fails for Partial Pick Confirm Quantity (Doc ID 2108533.1)

Last updated on MARCH 20, 2017

Applies to:

Oracle Shipping Execution - Version 12.2.5 and later
Information in this document applies to any platform.
Checked for relevance on 02-Mar-2016

Symptoms

On an OTM enabled EBS environment, the following error occurs when attempting to ship confirm the partially pick confirmed quantity:

ERROR
-----------------------
Warning: Contents of Trip have Warning Exception(s).
------------------------------------
Warning: The following transaction must be processed for delivery by the Shipping Transportation Outbound Interface: UPDATE.
If this exception is set to error, ship confirmation cannot be completed before receiving an updated trip from Transportation Management.
If this exception is set to warning or information, the following will occur:
- Delivery is assigned to a trip: ship confirmation will be performed normally as if no update is expected from Transportation Management.

- Delivery is not assigned to a trip: ship confirmation of this delivery will ignore it for planning.
------------------------------------
Warning: Delivery has Warning Exception(s).
------------------------------------
Warning: One or more Ship Sets on delivery are incomplete.

As a result of the above error, the Shipment Actual Interface fails with the following error message found in the log file.

CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSACTION: [002961] Query
no data found at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at
java.lang.reflect.Constructor.newInstance(Constructor.java:526) at
glog.util.exception.GLException.factory(GLException.java:481) at
glog.util.exception.GLException.factory(GLException.java:457) at
glog.integration.tools.GLIntegrationException.factory(GLIntegrationException.java:48) at
glog.integration.tools.GLIntegrationException.factory(GLIntegrationException.java:44) at
glog.integration.gidfinder.MultiArgsGidFinderWrapper.findGid(MultiArgsGidFinderWrapper.java:95) at
glog.integration.gidfinder.MultiArgsGidFinderWrapper.findGid(MultiArgsGidFinderWrapper.java:50) at
glog.integration.application.shipment.SEquipmentHelper.ConvertSavedQueryToSEquipment(SEquipmentHelper.java:71) at
glog.integration.application.shipment.ShipmentWrapper.map(ShipmentWrapper.java:290) at

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Log into the Order Management Super User responsibility.
2) Create a new sales order and book it.
3) Create a delivery and send to OTM by running the Shipping Transportation Outbound Interface.
4) Perform tender acceptance and create a trip in Shipping.
5) Navigate to Shipping->Release Sales Orders->Release Sales Orders and pick release the order.
6) Log into Inventory and navigate to Move Orders->Transact Move Orders.
7) Perform move order for partial quantity.
8) Navigate to Shipping->Transactions and ship confirm the trip.
9) Run the Shipment Actual Interface program which results in an error.

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