E-Business Tax: Missing AX Synonyms Created as APPS Results in AR Diagnostics Not to Run Successfully for Upgraded Data (Doc ID 1620263.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle E-Business Suite Diagnostics - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After upgrade from 11i to 12.1.3 there's only one synonym - for AX.AX_EVENTS that has been created during R12 upgrade (most likely delivered by xlaaxseq.sql, included in some XLA patch or CU during the upgrade)

On 11i there were 50+ synonyms for AX tables in APPS schema.

<Note 1493638.1> R12 : AX.AX_EVENTS and AX.AX_DOCUMENT_STATUSES Do Not Have Synonyms in the APPS Schema (Doc ID 1493638.1) states:
...."That's normal behaviour, that after upgrading to Release 12, there is no synonyms for AX tables in APPS schema...."

On the other hand, xlaaxuar.sql from <Patch 15939552> is checking for following synonyms:

The new logic, in R12/AX, does not require the synonyms in APPS schema, while there might be issues with some scripts/datafixes from other modules when manipulating the AX tables
Therefore, some synonyms are created eventually by some patches.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms