Problem With Synonyms Created For MSC_DEMANTRA_ODS_F And MSC_DEMANTRA_F (Doc ID 2154701.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Planning Command Center - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

On : 12.2.4 version, Documentation

The customer has altered the MSC_DEMANTRA_ODS_F and MSC_DEMANTRA_F tables to add additional custom columns in the MSC Schema.

The customer uses Synonyms to access tables in other schemas. The Synonyms are not updating with the newly added columns and the Editioning View associated with the Synonym is also not updating.

Edition-Based Redefinition
Oracle E-Business Suite Release 12.2 installation now includes two editions (versions) of the application code and seed data. The file system contains two complete copies of the Oracle E-Business Suite and application-tier technology files. In the database, we use the Edition-based Redefinition feature to create a new database edition for each online patching cycle.


 

Solution

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