EMEA Add-on Localization: Object "CLE_F020_FLAT_FILE_PKG" Is Getting Invalid While Trying To Apply EBS System Schema Migration Patches 31817501 and 34569659 (Doc ID 3009278.1)

Last updated on MARCH 08, 2024

Applies to:

Symptoms

While trying to apply patches for EBS System Schema Migration (31817501 and 34569659), object "CLE_F020_FLAT_FILE_PKG" is getting invalid

ERROR
-----------------------

Errors for PACKAGE BODY APPS.CLE_F020_FLAT_FILE_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
315/1 PL/SQL: SQL Statement ignored
351/5 PL/SQL: ORA-00942: table or view does not exist
786/7 PL/SQL: Statement ignored
786/10 PLS-00364: loop index variable 'R_EUAR' use is invalid
799/12 PL/SQL: Statement ignored
801/49 PLS-00364: loop index variable 'R_EUAR' use is invalid
SQL>

The issue can be reproduced at will with the following steps:
1. Apply EBS System Schema Migration patches: 31817501 and 34569659.
2. Notice the error for EMEA Addon localization object "CLE_F020_FLAT_FILE_PKG".

Cause

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