Execute AD_ZD Script after modify or create table in Oracle R12.2.X

 AD_ZD_TABLE
                                                                                                   

1) For new table creations - after creating the table in custom schema execute below script to generate editoning view and synonym for it in APPS schema.

Begin AD_ZD_TABLE.UPGRADE('XXCUST','XX_CUST_TBL1'); End;

2) For table alteratuons - after running the DDL run below script to regenerate the editioning view for syncing any table changes.

Begin AD_ZD_TABLE.PATCH('XXCUST','XX_CUST_TBL1'); End;

3) Table grants must be done through API to avoid invalids.

Begin AD_ZD.GRANT_PRIVS('SELECT','XX_CUST_TBL1','XX_ROLE0'); End;

4) To view objects in all editions..add _ae to the data dictionary views

select * from user_objects_ae;

5) To update seed data tables in Patch edition, execute prepare command.

example:
 Begin ad_zd_seed.prepare('WF_MESSAGES'); End;

The prepare will create a edition based storage for the run edition data for which the updates will be made. During cutover, the run time data will be synced using forward/reverse cross edition triggers.