Delete Items in Bulk

You can add a maximum of 20000 items to a deletion group using the Deletion Groups task in the Product Management work area.

You can also add use a REST service to add items to a deletion group.

You can't delete an item that has open transactions. Sometimes, you can’t delete an item that has a completed or canceled transaction involving the item. Hence, it depends on the product and the type of constraint checks performed.

To delete items in bulk:

  1. Create a deletion group that doesn't contain any items:
    1. On the Product Management landing page, in the Actions panel, click View all actions.
      The Actions drawer is displayed.
    2. Click the Deletion Groups link.
    3. Click Create.
      The Deletion Groups page is displayed.
    4. Enter the Name and optional Description for the deletion group. For example, Item_Delete01.
    5. Click Save and Close.
  2. Run a REST service to populate the deletion group with items in bulk.
    Run the deleteGroups REST service using the Add items to the delete group operation to add items to a deletion group. For more information, see the REST API for Oracle Fusion Cloud SCM guide.
  3. Submit the populated deletion group for processing:
    1. On the Deletion Groups page, search for the deletion group that you created, and click its name to open it.
      The deletion group now contains the list of items to be deleted.
    2. From the Actions menu, click Check Constraints.
    3. Examine the constraint check status for whether there are errors or pending transactions for an item.
    4. After errors or pending transactions are resolved, click Submit Delete from the Actions menu to process the deletion of the items.