My Oracle Support Banner

CLE Objects Failing On GSCC Report With The Error: Query/DML Statements Must Access Tables Via The APPS Table Synonym (Doc ID 2787032.1)

Last updated on JUNE 24, 2021

Applies to:

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

Symptoms

CLE (EMEA Add-on localizations) objects are failing on GSCC report (Online Patching Database Compliance Checker).

ERROR
-----------------------
DOC> **********************************************************************
DOC> SECTION-26 [minimal]
DOC> **********************************************************************
DOC> "Query/DML statements must access tables via the APPS table synonym."
DOC>
DOC> - P2: These objects may operate incorrectly after the referenced table
DOC> has been patched.
DOC> - Fix: Change the object to reference tables via the APPS table synonym.

APPS CLEF297_BANK_STMT_LOAD_PKG PACKAGE BODY CLE CLE_F297_CONTROLS
APPS CLEF297_BANK_STMT_LOAD_PKG PACKAGE BODY CLE CLE_F297_ENDS
APPS CLEF297_BANK_STMT_LOAD_PKG PACKAGE BODY CLE CLE_F297_EXTS
APPS CLEF297_BANK_STMT_LOAD_PKG PACKAGE BODY CLE CLE_F297_HEADERS
APPS CLEF297_BANK_STMT_LOAD_PKG PACKAGE BODY CLE CLE_F297_LINES
APPS CLE_F246_CASH_DESK_IMPORT_PKG PACKAGE BODY CLE CLE_CD_CASH_DOCUMENTS_INT
APPS CLE_F246_CASH_DESK_IMPORT_PKG PACKAGE BODY CLE CLE_CD_CASH_DOC_AP_INVS_INT
APPS CLE_F246_CASH_DESK_IMPORT_PKG PACKAGE BODY CLE CLE_CD_CASH_DOC_AR_INVS_INT
APPS CLE_F246_CASH_DESK_IMPORT_PKG PACKAGE BODY CLE CLE_CD_CASH_DOC_TAXES_INT
APPS CLE_F246_CASH_DESK_IMPORT_PKG PACKAGE BODY CLE CLE_CD_CASH_REPORTS_INT

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Online Patching Database Compliance Checker

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.