My Oracle Support Banner

Error Bug fix XXXXX Is Not Being Applied As Product "CLE" Is Not Recognized during patching (Doc ID 2859379.1)

Last updated on APRIL 07, 2022

Applies to:

EMEA Add-on Localizations - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Problem Description
------------------
Though relevant CLE patches for Italy were applied find that the underneath object change is not happening.
Which means that the patches/bug numbers are residing in ad_bugs table but the required objects are not reflecting or getting compiled without error.
From the patch log and lgi file find below message.

Steps for replication
----------------------
1. Facing below message when trying to apply any CLE related patch.

Error message ( from patch log,lgi file)
--------------
Bug fix XXXXXX is not being applied as product "cle" is not recognized.
Bug fix YYYYYY is not being applied as product "cle" is not recognized.
Bug fix AAAAAA is not being applied as product "cle" is not recognized.

Note: From the above error message XXXXXX,YYYYYY,AAAAAA denote the respective patches which were applied for CLE product.

Error message ( object compilation log)
-------------
alter package CLE_F078_FA_CHMATE_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY CLE_F078_FA_CHMATE_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
155/6 PL/SQL: SQL Statement ignored
155/6 PLS-00394: wrong number of values in the INTO list of a FETCH statement

395/5 PL/SQL: SQL Statement ignored
395/5 PLS-00394: wrong number of values in the INTO list of a FETCH statement

412/8 PL/SQL: SQL Statement ignored
412/8 PLS-00394: wrong number of values in the INTO list of a FETCH statement

Note: This issue is not specific compilation of object CLE_F078_FA_CHMATE_PKG alone.
        There can be multiple invalid objects. Hence the focus should be on the actual error message from the lgi file instead of the respective invalid objects.

 

Changes

 

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
References


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