iStore package IBE_DRT_PKG Invalid After Patch R12.IBE.B.delta.5 (29658729) (Doc ID 2589184.1)

Last updated on JULY 11, 2022

Applies to:

Symptoms

The package IBE_DRT_PKG is Invalid after Patch R12.IBE.B.delta.5 (29658729)

After applying Patch 29658729 the following IBE_DRT_PKG package is invalid and gives compilation errors -
SQL> alter package IBE_DRT_PKG compile;


ERROR
-----------------------
Warning: Package altered with compilation errors.

SQL> show error
Errors for PACKAGE IBE_DRT_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
18/2 PL/SQL: Declaration ignored
20/31 PLS-00201: identifier 'PER_DRT_PKG.RESULT_TBL_TYPE' must be declared



Appscheck (OMCHECK.sql)report for iStore (IBE) shows the following details for the invalid package -

Errors for PACKAGE IBE_DRT_PKG

PLS-00201: identifier 'PER_DRT_PKG.RESULT_TBL_TYPE' must be declared
PL/SQL: Declaration ignored

IBE_DRT_PKG IBEDRTPB.pls 120.0.12010000.1
BODY INVALID

Errors for PACKAGE BODY IBE_DRT_PKG

PLS-00905: object APPS.IBE_DRT_PKG is invalid
PLS-00304: cannot compile body of 'IBE_DRT_PKG' without its specification
PL/SQL: Compilation unit analysis terminated

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.