The Main tab provides a summary of the root object. This tab shows the details of tables that will be changed if the root object is approved (and the apply changes background process is run). Use and navigate to the Data Differences tab to view this information.
Description of Page
Table and Description. The identity of the table that will be changed
PK Value. The row's primary key.
Statement Type. May be Insert , Update , or Delete . This defines the type of SQL statement to be used to change this environment.
SQL. The actual SQL statement to be used to apply changes to the data in the current environment.
Suppress. Check this box if the SQL statement should not be executed when the Apply Changes process runs. This only applies to Insert and Update statements. A Delete statement cannot be suppressed as that could lead to orphaned records in the database.
Copyright © 2000, 2015, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.19.2015 16:18:51 [F1_1424305131000]