My Oracle Support Banner

12.2 Unable To Autocreate Deliveries From Shipping Transactions From, Invalid Object: WMS_YMS_INTEGRATION_PVT (Doc ID 2369412.1)

Last updated on MARCH 05, 2018

Applies to:

Oracle Warehouse Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Shipping Transactions form

After applying patch 22105620:R12.WMS.C, the following error started to occur in the Shipping Transaction Form.
Customer has an invalid Yard Management Object of WMS_YMS_INTEGRATION_PVT.
Customer has no plans of using Yard Management.
Apps check shows that Yard Management is NOT installed.

==========
Researching shows that there is some dependencies but since it occurred after applying the WMS patch and it is a WMS/YMS invalid object causing the issue as noted in this bug:
Bug 21898901: WMS_YMS_INTEGRATION_PVT INVALID OBJECT IN AZ2MU22
which is for the same issue as this customer is reporting

When attempting to autocreate a delivery, the following error occurs.

ERROR
-----------------------
Error: Failed to autocreate deliveries in organization NOVATECH IO
Unexpected Error: Error in Routine
WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DELIVERY_DETAIL, Oracle Error - 6508
ORA-06508:PL/SQL: could not find program unit being called
--------
Error: Deliveries could not be automatically created. The lines may already be assigned to a delivery

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management Super User Responsibility
2. Shipping
3. Transactions
4. Query order
5. Select autocreate delivery from Actions LOV

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!


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