Invalid Shipping Execution (WSH) Objects After Applying Patch 21665268:R12.WMS.C

(Doc ID 2331516.1)

Last updated on NOVEMBER 27, 2017

Applies to:

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

Symptoms

On : 12.2.3 version,

Following  package bodies became invalid after applying the patch 21665268:R12.WMS.C.
WSH_DELIVERIES_GRP
WSH_DELIVERY_DETAILS_GRP
WSH_TRIPS_GRP
WSH_TRIP_STOPS_GRP
WSH_UTIL_CORE

Compilation failure message for following packages:

WSH_DELIVERIES_GRP

Errors for PACKAGE BODY WSH_DELIVERIES_GRP

PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored

WSH_DELIVERY_DETAILS_GRP

Errors for PACKAGE BODY WSH_DELIVERY_DETAILS_GRP

PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored

WSH_TRIPS_GRP

Errors for PACKAGE BODY WSH_TRIPS_GRP

PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored

WSH_TRIP_STOPS_GRP

Errors for PACKAGE BODY WSH_TRIP_STOPS_GRP

PL/SQL: ORA-00942: table or view does not exist
PL/SQL: SQL Statement ignored

WSH_UTIL_CORE

Errors for PACKAGE BODY WSH_UTIL_CORE

PLS-00201: identifier 'YMS_EQUIPMENT_V.EQUIPMENT_NUMBER' must be declared
ERROR 201

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 21665268
2. Find that mentioned package bodies are invalid

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