Previous	Next		Contents	Index	Navigation	Glossary	Library

What entities you can delete depends on what Oracle application you are currently using and what applications you have installed.

• if you are using Oracle Bills of Material, you can delete only bills, routings, components, and operations

• if you are using Oracle Engineering, you can delete any engineering entity except ECOs

• if you are using Oracle Inventory and you do not have Bills of Material installed, you can only delete manufacturing items

• if you are using Inventory and you do have Bills of Material installed, you can delete only items, bills, and routings

Note: Files or objects that are attached to bills or routings are not deleted. Instead, the link between the bill or routing and the attached file is severed. The files themselves remain intact in their original location.

Several deletion constraints are installed with Bills of Material. However, you can define custom deletion constraints. If what you are attempting to delete does not pass deletion constraints, it is not deleted. For example, you can define a constraint that prevents you from deleting a bill of material for an assembly that has an item status of active.

When you delete an entire bill, you delete all the components for the assembly along with their reference designators and substitute items. When you delete a routing, all operations are deleted. For both bills and routings, any links to attachments are severed.

Oracle Work in Process reflects any changes to the bills or routings using the delete functionality only if you re-explode the bill or routing in Work in Process.

   To define a deletion group:

1. Navigate to the Deletion Groups window.

If you are updating an existing deletion group, the date it was last submitted (if applicable) is displayed.

2. Enter a group name to identify the group of entities to delete.

3. Select what type of entity to delete.

4. Indicate whether to archive the deleted entities in the archive tables.

Attention: You can archive bill and routing information, but not item information. The option to archive is not available if you are deleting only items.

5. Enter the item, bill, or routing to delete, or from which to delete components or operations.

The Details alternative region displays the organization the entity belongs to, its type, and the alternate (if applicable). The Effectivity alternative region displays the effective date range. See: Effective Date Fields.

The Results alternative region displays the delete status and the date of deletion (if applicable).

6. To delete an alternate bill or routing, enter the alternate.

7. If you are deleting components, choose the Components button; if you are deleting operations, enter the Operations button.

8. When finished, choose either the Delete Group button or the Check Group button.

   To specify components to delete:

1. Navigate to the Components window. Do this by choosing the Components button from the Deletion Groups window.

2. Enter a component item to delete.

The Results alternative region displays the status as Error, Check OK, or Deleted. A status of Pending indicates the delete program has not run yet. The Effectivity alternative region displays the effective date range of the component. See: Effective Date Fields.

If the status is listed as Error, choose the Error button to review why the deletion failed.

   To specify operations to delete:

1. Navigate to the Operations window. Do this by choosing the Operations button from the Deletion Groups window.

2. Enter the operation sequence to delete.

The Results alternative region displays the status as Error, Check OK, or Deleted. A status of Pending indicates the delete program has not run yet. The Effectivity alternative region displays the effective date range of the operation. See: Effective Date Fields.

If the status is listed as Error, choose the Error button to review why the deletion failed.

   To check entities for deletion:

Attention: If you perform a check on the item, bill, and routing, the check program will return an Error status for the item. This simply indicates that the item's bill or routing still exists. In this case, disregard the Error status for the item.

• Choose the Check Group button to verify whether any deletion constraints are violated.

The delete concurrent program updates the entity's status to Error, or Check OK. A status of Pending indicates the delete program has not run yet.

   To submit entities for deletion:

• Choose the Delete Group button to submit the delete concurrent program.

The delete concurrent program first performs a check for all the entities listed for deletion. Once the check succeeds, the entities are deleted.

The delete concurrent program updates the entity's status to Error, Check OK, or Deleted. A status of Pending indicates the delete program has not run yet.

   To review errors:

1. Choose the Errors button to see why the entity could not be deleted. Do this from either the Components, Operations, or Delete Groups windows.

2. Choose the View Constraint button or the drill down indicator to see the violated deletion constraint.

See Also

Deletion Constraints

Creating Custom Deletion Constraints

Deleting Components and Operations

Delete Items Report