Invalid Objects After Application Of Patch 31702926 - How to Resolve These (TROLIN_SERIAL_TBL_TYPE' must be declared) (Doc ID 2773382.1)

Last updated on MAY 03, 2021

Applies to:

Symptoms

Patch 31702926:R12.INV.C has been applied and has created new invalid objects such as:

WMS_REPLENISHMENT_PVT PACKAGE BODY
WMS_WAVE_PLANNING_PVT PACKAGE BODY
WSH_DELIVERY_DETAILS_GRP PACKAGE BODY
WSH_INBOUND_SHIP_ADVICE_PKG PACKAGE BODY
WSH_NEW_DELIVERY_ACTIONS PACKAGE BODY
WSH_SHIP_CONFIRM_ACTIONS2 PACKAGE BODY
WSH_TRANSACTIONS_UTIL PACKAGE BODY
INV_SHIPPING_TRANSACTION_PUB PACKAGE BODY
WSH_SHIP_CONFIRM_ACTIONS2 PACKAGE

Error messages like the following can be seen:

WSH_SHIP_CONFIRM_ACTIONS2      WSHDDSPS.pls              120.2.12020000.2    
           SPEC INVALID
Errors for PACKAGE WSH_SHIP_CONFIRM_ACTIONS2
PLS-00302: component 'TROLIN_SERIAL_TBL_TYPE' must be declared
PL/SQL: Declaration ignored

Changes

Cause

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