My Oracle Support Banner

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

Last updated on MARCH 01, 2021

Applies to:

Oracle iStore - Version 12.1.3 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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