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 21, 2022
Applies to:
EMEA Add-on Localizations - Version 12.1.1 and laterInformation 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 |