Patch 10111967 : Rel 11i : INV/RCV : Invalid PL/SQL Objects after applying INV / RCV Rollup Patch 23
(Thread created by Oracle Support on behalf of Customer)
Hi there
We are on Release 11.5.10.2 and applying Patch 10111967 ("Oracle Inventory and
Receiving (PO): Release 11.5.10, Rollup Patch 23")
This has caused several objects to error, for example :
Package Body INV_OBJECT_GENEALOGY fails to compile with : ORA-00942: table or view does not exist
Package Body INV_UI_ITEM_SUB_LOC_LOVS fails to compile with : ORA-00904: "A"."LOCATOR_SEGMENTS": invalid identifier
Package Body PO_INVOICES_SV2 fails to compile with many errors like :
PLS-00201: identifier 'P_TAX_INFO_TBL' must be declared
PLS-00201: identifier 'X_RECOV_TAX_TBL' must be declared
PLS-00201: identifier 'X_NONRECOV_TAX_TBL' must be declared