My Oracle Support Banner

Error in section-26 Query/DML statements must access tables via the APPS table synonym in GSCC report (Doc ID 2794327.1)

Last updated on JUNE 12, 2023

Applies to:

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

Symptoms

GSCC report is failing for the below objects:

Error message
-----------------

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 CLECLE_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

Expected Behavior
---------------------
Expectation is such that when Online Patching Database Compliance Checker is run it should complete successfully.

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

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