EGO_ITEM_PUB Invalid After Patch 16508747, See Error 'identifier 'L_NULL_CHAR' must be declared' (Doc ID 2064286.1)

Last updated on OCTOBER 08, 2015

Applies to:

Oracle Product Hub - Version 11.5.10.2 and later
Information in this document applies to any platform.
Happens on 11.5.10.2 - EGO.C (Non-PIM Instances)

Symptoms

On :  11.5.10.2 version, Catalog items
EGO_ITEM_PUB Invalid after applying <Patch 16508747> - After application of this patch, EGO_ITEM_PUB.process_item API will not stamp the unused segments in MTL_SYSTEM_ITEMS_B with chr(0) for UPDATE transaction
 
ERROR
-----------------------
Warning: Package Body altered with compilation errors.

APPS@gpsogd149>show error
Errors for PACKAGE BODY APPS.EGO_ITEM_PUB:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1635/10  PL/SQL: Statement ignored
1635/67  PLS-00201: identifier 'L_NULL_CHAR' must be declared
1639/10  PL/SQL: Statement ignored
1639/67  PLS-00201: identifier 'L_NULL_CHAR' must be declared
1643/10  PL/SQL: Statement ignored
1643/67  PLS-00201: identifier 'L_NULL_CHAR' must be declared
1647/10  PL/SQL: Statement ignored
1647/67  PLS-00201: identifier 'L_NULL_CHAR' must be declared
1651/10  PL/SQL: Statement ignored
1651/67  PLS-00201: identifier 'L_NULL_CHAR' must be declared
1655/10  PL/SQL: Statement ignored

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to compile EGO_ITEM_PUB after applying <Patch 16508747>

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms