My Oracle Support Banner

WSH Shipping Invalid Objects After Applying Patch (Doc ID 1414534.1)

Last updated on NOVEMBER 22, 2024

Applies to:

Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


'WSH' related packages got invalid after applying patches 11823085 and 13043283 to production instance. These patches are prereq patches for patch '13561078'. Below are the packages (body) which got invalid:
WSH_DELIVERY_DETAILS_ACTIONS
WSH_INTERFACE
WSH_CONTAINER_ACTIONS
WSH_DLVB_COMMON_ACTIONS
WSH_CONTAINER_GRP
WSH_DELIVERY_DETAILS_GRP
WSH_DELIVERIES_GRP
WSH_PROCESS_INTERFACED_PKG
WSH_TRIP_STOPS_GRP
WSH_TRIPS_GRP

users are gitting below error:
"SQLCODE: -6508 SQLERRM: ORA-06508: PL/SQL: could not find program unit being cal
led
Exception occurred in WSH_PICK_LIST.Release_Batch_Sub
Error occurred in Release_Batch_Sub
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST".

These patches were successfully applied to test instacne before applying to production.

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
Cause
Solution
References


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