Identify Deleted Entities Using Deletion Business Events

Items in Product Information Management contains core entities and child entities.

The core entities include master organization item, item revision, item organization assignment, item supplier association, and non-translatable or translatable single row extensible flexfields at all levels. The child entities include item category assignments, all types of relationships, trading partner items, non-translatable or translatable multi-row extensible flexfields at all levels. When a core entity is deleted, the child entities are also deleted. However, you can delete the child entities independently.

Note: Structure and related entities aren’t applicable.

The core entity is always deleted through delete group along with constraint checks. The child entities can be deleted through import or individually. Constraint checks that are a part of the delete group aren’t performed for child entities.

Business events are raised every time an item or its related entity is deleted. The types of delete events are:

• Bulk Delete Event: When a core entity is deleted through delete group or child entity is deleted through import, then the Bulk Delete Event is generated.
• Entity Delete Event: When a child entity is deleted individually, then the Entity Deleted Event is raised.

You can use the Deleted Item Entities REST resource to fetch the details of the deleted items from the Bulk Delete Events. The details include the primary identifier of the object and other secondary identifiers of the deleted entity. If the parent object is deleted, the child objects is also deleted, and thus the primary and alternate identifiers of the child objects must be stored.

Integration with external systems can be done by listening to the delete business event with the payload or by using a combination of business events and fetching the details using the Deleted Item Entities REST resource.

When you delete an item or its related entity in Product Information Management work area, the business events are seen in Oracle Integration Cloud. You can subscribe to these events through Oracle Integration Cloud and orchestrate real-time integrations with other systems.

You can create user-defined Business Intelligence reports based on the deleted entity tables to get the complete item details and send them to downstream products for integrations on a scheduled basis. The reports can be used to maintain external systems in sync, near real time when an item or its related entities are deleted. For information about the delete entity tables, see the EGP_DELETE_ENTITIES section in the Oracle Fusion Cloud SCM: Tables and Views for SCM guide.

Here’s the image that illustrates the delete business events framework.

Here’s the supported entities for the delete business events:

• Item Deletion
• Item Revision Deletion
• Item Organization Assignment Deletion
• Item Supplier Association Deletion
• Item Category Assignment Deletion
• Item Relationship Deletion
• Item Trading Partner Relationship Deletion
• Item Multi-row Attribute Deletion at Item, Item Revision, Item Supplier Levels

Note: Business events aren't supported for deletion of item attachments.

Here's the list of entities and the corresponding delete events.

Entity	Event
Item	Item Bulk Delete Event [postItemBulkDelete]
Item Revision	Item Bulk Delete Event [postItemBulkDelete]
Item Organization	Item Bulk Delete Event [postItemBulkDelete]
Item Supplier Association	Item Bulk Delete Event [postItemBulkDelete]
Item Category Assignment	Item Category Assignment Delete Event [postItemCategoryAssignmentDelete]
Related Item Relationship	Related Item Relationship Delete Event [postRelatedItemXRefDelete]
Trading Partner Item Relationship	Trading Partner Item Relationship Delete Event[postTradingPartnerItemXRefDelete]
GTIN Item Cross Reference Relationship	GTIN Item Cross Reference Relationship Delete Event [postGtinItemXRefDelete]
Item Cross Reference Relationship	Item Cross Reference Relationship Delete Event[postItemXRefDelete]
Source System Item Relationship	Source System Item Relationship Delete Event[postSourceSystemItemXRefDelete]
Item Level Multi-row Attribute	Item Level Multi Row EFF Delete Event [postItemMultiRowEFFDelete]
Item Revision Level Multi-row Attribute	Item Revision Level Multi Row EFF Delete Event [postItemRevisionMultiRowEFFDelete]
Item Supplier Level Multi-row Attribute	Item Supplier Level Multi Row EFF Delete Event [postItemSupplierMultiRowEFFDelete]
Single Row Attribute at all Levels	Item Bulk Delete Event [postItemBulkDelete]
Entities Deleted Via Import	Item Bulk Delete Event [postItemBulkDelete]