Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Patch 10111967 : Rel 11i : INV/RCV : Invalid PL/SQL Objects after applying INV / RCV Rollup Patch 23

edited Apr 30, 2013 11:26PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓

(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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center