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

MOSC Banner

R12.1.3 : After applying patch 18221212 package body AHL_WARRANTY_ENTL_PVT has become invalid.

edited Feb 21, 2014 11:28AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered

Hello,


We recently applied patch 18221212: (NEW) 12.1 CONSOLIDATED PATCH FOR BUG FIXES BETWEEN DATES 15-JAN-14 TO 05-FEB-14.  After doing this, it appears to have made package body AHL_WARRANTY_ENTL_PVT invalid.

SQL> alter package ahl_warranty_entl_pvt compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY AHL_WARRANTY_ENTL_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
244/5    PL/SQL: SQL Statement ignored
247/12   PL/SQL: ORA-00904: "MRH"."WARRANTY_TEMPLATE_ID": invalid
        identifier

253/5    PL/SQL: SQL Statement ignored
257/12   PL/SQL: ORA-00904: "ROUTE"."WARRANTY_TEMPLATE_ID": invalid
        identifier

SQL>

The AHL_WARRANTY_ENTL_PVT package and body are at the following levels:

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