My Oracle Support Banner

There are thousands of apps synonyms that are pointing to base tables instead of Edition based # views (Doc ID 2642610.1)

Last updated on JANUARY 11, 2023

Applies to:

Oracle Applications DBA - Version 12.2.9 and later
Information in this document applies to any platform.


We installed the base R12.2 and then subsequently upgraded to R12.2.7 and then R12.2.8 and finally R12.2.9 and then upgrade of rdbms to 19c.  All this time we had not done any setups or entering of data.  So all of these instances were blank with no data.  All steps were always successful with no issues.  We are now finally doing setups and data entry in the R12.2.9 and we have noticed some issues and based on these issues we ran a query

select s.synonym_name,s.table_name,o.object_name,o.object_type from dba_synonyms s, dba_objects o where s.owner='APPS'
and s.table_name=o.object_name and o.object_type in ('TABLE')

The result was 2125 apps synonyms that are pointing to base tables instead of edition based # views.  Among these are base tables such as OE_ORDER_LINES_ALL, MTL_SYSTEM_ITEMS_B etc.  We found at least one note ORA-06508: OE_Header_Util.Post_Write_Process (Doc ID 2442190.1) which obviously addressed the OE_ORDER_LINES_ALL issue but that is just one out of 2125.  We need to know what went wrong and if anything else regarding Editioning is wrong.  By the way through out the patching we had no issues with dual file systems etc.  All has been successful.


 Upgrade to 12.2.


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

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