R12.1.3 : After applying patch 18221212 package body AHL_WARRANTY_ENTL_PVT has become invalid.
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: