You can create custom deletion statements to specify from which database table to delete data that meets the deletion constraint criteria. Create custom deletion constraints to enforce your unique business rules. Custom deletion constraints identify the rows in a table that meet certain conditions for deletion.

Oracle provides seeded deletion statements and constraints, which you can view using the Deletion Statements and Deletion Constraints windows. You cannot modify seeded deletion statements and constraints, though.

   To create a custom deletion constraint:

1. Navigate to the Deletion Constraints window.

2. Enter a name for the deletion constraint.

3. Indicate whether the constraint is enabled. An enabled deletion constraint means that it is in effect when the delete concurrent program runs.

4. Select the kind of delete entity the constraint applies to: item, bill, routing, component, or operation.

5. Select the name of the product that applies to this deletion constraint.

   The Product Name field enables you to group deletion constraints by product.

6. Enter the SQL Select Statement that the delete concurrent program is to execute. You cannot update SQL statements for predefined deletion constraints.

7. Indicate whether to delete if there are rows found or no rows found by the SQL Select Statement.

8. Enter a failure message from Oracle Application Object Library's message dictionary to display if the delete fails.

   To create a custom delete statement:

1. Navigate to the Deletion Statements window.

2. Enter a name for the deletion statement.

3. Indicate whether the statement is enabled. An enabled deletion statement means that it is in effect when the delete concurrent program runs.

4. Select the kind of delete entity the statement applies to: item, bill, routing, component, or operation.

5. Select the name of the product that applies to this deletion statement.

   The Product Name field enables you to group deletion statements by product.

6. Enter the SQL Delete Statement that the delete concurrent program is to execute. You cannot update SQL statements for predefined deletion statements.