My Oracle Support Banner

Issue After Applying Patch 9747231, PLS-00302: component 'G_BINARY_LIMIT' must be declared (Doc ID 1299347.1)

Last updated on SEPTEMBER 05, 2019

Applies to:

Oracle Order Management - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms



Customer applied <>.


Now sees the following errors:
"PLS-00302: component 'G_BINARY_LIMIT' must be declared"
"PL/SQL: Item ignored"
"PLS-00320: the declaration of the type of this expression is incomplete or
malformed"
"PL/SQL: Statement ignored"

Customer is unable to recompile the packages, they remain invalid.

Appscheck shows

Run for
INV - Inventory
ONT - Order Management
WSH - Shipping Execution

 
OE_BLKT_RELEASE_UTIL OEXUBRLB.pls120.3.12000000.7
BODY INVALID

Errors for PACKAGE BODY OE_BLKT_RELEASE_UTIL

PLS-00302: component 'G_BINARY_LIMIT' must be declared
PL/SQL: Item ignored
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
PL/SQL: Statement ignored
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
PL/SQL: Statement ignored
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
PL/SQL: Statement ignored
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
PL/SQL: Statement ignored
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
PL/SQL: Statement ignored
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
PL/SQL: Statement ignored

Changes

Applied <>.

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
Changes
Cause
Solution


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