Over the main process listed below, does Stat take care of ad_zd_table.upgrade process to generate Editioning View (EV) ?
The below is the process of table creation in R12.2.x:
- Creating a table
- Connect to the run time edition of the development environment
- Create table in the custom schema.
- Upgrade the table for online patching using the below command
exec ad_zd_table.upgrade(<table>,<EV Synonym>) <-- This will generate an Editioning View (EV) for the table and then create an APPS synonym that points to the Editioning View.
At this point the table is now ready for use from the APPS schema. The generated EV is named and looks exactly like the table.