6678700 12.1.1 wshuplp3.sql failed - Linux x86-64
While applying Patch 6678700 to upgrade from 11.5.9 to 12.1.1 the wshuplp3.sql failed with the following errors:
INV_CONVERT is invalid because of INV_CACHE is invalid.
INV_CACHE is invalid because of
PLS-00201: identifier 'MTL_CLIENT_PARAMETERS' must be declared
______________________________
select text from dba_source where name='INV_CONVERT' and line=2
text
-----------------------------------------------------------------------------
/* $Header: INVUMCNS.pls 120.2 2008/01/21 07:59:18 anagupta noship $ */
/* $Header: INVUMCNB.pls 120.2.12010000.2 2008/07/29 13:47:55 ptkumar ship $ */
alter package INV_CONVERT compile;
ORA-04043: object INV_CONVERT does not exist
select line,text from dba_errors where name='INV_CONVERT'
line text
----- --------------------------------------------
1187 PLS-00905: object APPS.INV_CACHE is invalid
1187 PL/SQL: Statement ignored
1195 PLS-00905: object APPS.INV_CACHE is invalid