Steps to create custom table in Oracle apps R12.2.X

For new table creations we have to follow the below command.

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('XXUNV','XXUNV_DISPUTE_REQ_HDRS');

When you altered the table after the table upgrade command.

Run the below statement.

exec AD_ZD_TABLE.PATCH('XXUNV','XXUNV_DISPUTE_REQ_HDRS');