Create synonym in edition based objects in Oracle EBS database with Oracle EBS 12.2 version
sqlplus / as sysdba
SQL> show user
USER is "SYS"
SQL> alter session set current_schema=APPS;
Session altered.
SQL> exec AD_ZD_PREP.ENABLE_CUSTOM_USER('TEST');
PL/SQL procedure successfully completed.
SQL> create SYNONYM TEST.XXTEST_DETAILS_V for XXTEST_DETAILS_V;
Synonym created.
SQL> conn TEST/****
Connected.
SQL> select count(*) from XXTEST_DETAILS_V;
COUNT(*)
----------
19440
SQL>
Benefits of Edition Based Redefinition
Edition-based redefinition allows multiple versions of PL/SQL objects, views, and synonyms in a single schema, which makes it possible to perform upgrades of database applications with zero downtime.
Edition-based redefinition is a single technology that provides high availability during upgrades.
It is available from Oracle Database 11gR2
It seamlessly rolls changes forward and backward
It is safe, secure, free, and fully supported by Oracle
What is Edition Based Redefinition(EBR)
High availability is one of the must-have features when you are planning for the Application upgrade. You can achieve high availability using RAC & Dataguard. So the organizations purchase RAC & Datagaurd even though it’s costly to protect systems from downtime as a result of some disaster but they cannot safeguard against an organization’s own change management or applications upgrade processes. So, there is a strong need for zero downtime and Edition Based Redefinition can be helpful to achieve this goal.
So, the main goal of releasing Edition Based Redefinition in the 11gR2 database was to make the application upgrades more streamlined, untroubled, and with almost zero downtime. Edition Based Redefinition came into more effect in Oracle E-Business Suite R12.2 as a new feature to support Online patching when Oracle released R12.2.