E-Business Tax: Missing AX Synonyms Created as APPS Results in AR Diagnostics Not to Run Successfully for Upgraded Data
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.
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.
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