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

Last updated on APRIL 11, 2024

Applies to:

Symptoms

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.

Changes

 Upgrade to 12.2.

Cause

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