Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Query/DML statements must access tables via the APPS table synonym

edited Aug 20, 2021 10:18AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered

Dear Experts,

I am in upgrade phase of EBS R12.1.3 to R12.2.7. After applying adop enablement patch , in ADZDDBCC report, I am facing challenges under seccion-26 as follows:

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.

DOC>#

OWNER            OBJECT_NAME                    OBJECT_TYPE        REFERENCED_OWNER REFERENCED_NAME

---------------- ------------------------------ ------------------ ---------------- ------------------------------

APPS             AP_DRILL                       VIEW               AP               AP_ACCOUNTING_EVENTS_ALL

APPS             AP_DRILL                       VIEW               AP               AP_AE_HEADERS_ALL

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center