AD_ZD_TABLE commands for custom tables

Syntax For AD_ZD_TABLE.PATCH & AD_ZD_TABLE.UPGRADE

EXEC AD_ZD_TABLE.PATCH('SCHEMA_NAME','TABLE_NAME');

EXEC AD_ZD_TABLE.UPGRADE('SCHEMA_NAME','TABLE_NAME');

Scripts required for 12.2.X custom table development

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.

exec AD_ZD_TABLE.UPGRADE('XXCUST','XX_CUST_TBL1');

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

exec AD_ZD_TABLE.PATCH('XXCUST','XX_CUST_TBL1')

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

exec AD_ZD.GRANT_PRIVS('SELECT','XX_CUST_TBL1','XX_ROLE0')

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:

 exec ad_zd_seed.prepare('WF_MESSAGES');

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.