My Oracle Support Banner

Invalid Objects During Application Of EBS Patch 32455759:R12.CLE.C (Doc ID 2969571.1)

Last updated on DECEMBER 11, 2023

Applies to:

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

Symptoms

Encountered the problem described in
CLE: Application of Patch 32455759:R12.CLE.C Introduces New CLE Invalid Objects (Doc ID 2852349.1)

These objects are invalid:
OWNER OBJECT_TYPE OBJECT_NAME CREATED LAST_DDL_TIME
APPS PACKAGE BODY CLE_F331_STRATEGY_PKG 23-08-17 14:00 23-08-18 10:10
APPS PACKAGE BODY CLE_F331_DUNNING_PKG 23-08-17 14:00 23-08-18 10:10
APPS PACKAGE BODY CLE_F389_MODEL30_PKG 23-08-17 14:00 23-08-18 10:10

SQL> alter package CLE_F331_STRATEGY_PKG compile body;
Warning: Package Body altered with compilation errors.
 
SQL> show error
Errors for PACKAGE BODY CLE_F331_STRATEGY_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
240/7 PL/SQL: SQL Statement ignored
240/20 PL/SQL: ORA-00942: table or view does not exist

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.