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

MOSC Banner

OZF_QP_QUAL_PVT PACKAGE BODY invalid after patch

edited Feb 28, 2014 12:00PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered

Hi

We are getting huge invalids in R12 Production instance and we need permanent fix , as we have to compile invalids very frequently.

APPS OZF_QP_QUAL_PVT PACKAGE BODY


Details of the error and package version



alter package OZF_QP_QUAL_PVT compile;

Warning: Package altered with compilation errors.

SQL> show errors
No errors.
SQL> alter package OZF_QP_QUAL_PVT compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY OZF_QP_QUAL_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1911/4   PL/SQL: SQL Statement ignored
1912/20  PL/SQL: ORA-00904: "SUPPLIER_ITEM_UOM": invalid identifier

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