This appendix covers the following topics:
Using Oracle Workflow, you can automatically trigger actions based on the following business events. Examples of actions you can trigger include issuing notifications and launching a workflow.
The following table lists business events, as well as a description and the event parameters of each event.
| Event Name | Event Description | Event Parameter Names and Descriptions |
|---|---|---|
| oracle.apps.ego.item.postAML.Change | Item AML is changed (such as a manufacturer part number is added, updated, or deleted) Applicable: SSWA, FORMS |
DML_TYPE: CREATE, UPDATE, DELETE INVENTORY_ITEM_ID: Item ID ORGANIZATION_ID: Organization ID MANUFACTURER_ID: Manufacturer ID MFG_PART_NUM: Manufacturer Part Number |
| oracle.apps.ego.item.postItemCreate | Item Creation Applicable: SSWA, FORMS, API |
INVENTORY_ITEM_ID: Item ID ITEM_NUMBER: Item ID ORGANIZATION_ID: Organization ID ORGANIZATION_CODE: Organization Code ITEM_DESCRIPTION: Item Description |
| oracle.apps.ego.item.postItemUpdate | Item Update Applicable: SSWA, FORMS, API |
INVENTORY_ITEM_ID: Item ID ITEM_NUMBER: Item ID ORGANIZATION_ID: Organization ID ORGANIZATION_CODE: Organization Code ITEM_DESCRIPTION: Item Description |
| oracle.apps.ego.item.postGTINAttributeChange | GTIN Attribute group row is created or updated. Applicable: SSWA |
DML_TYPE: CREATE, UPDATE, DELETE ATTR_GROUP_NAME: Attribute Group Name EXTENSION_ID: Extension Id that uniquely identifies the record in the UDA extension table INVENTORY_ITEM_ID: Item ID ORGANIZATION_ID: Organization ID REVISION_ID: Revision ID |
| oracle.apps.ego.item.postItemApproved | On Item Approval Applicable: SSWA |
INVENTORY_ITEM_ID: Item ID ORGANIZATION_ID: Organization ID |
| oracle.apps.ego.item.postItemBulkload | Bulk Item processing (creation, update) Applicable: XL import, IOI |
REQUEST_ID: Concurrent Request ID that processed the bulk item import |
| oracle.apps.ego.item.postXrefChange | Item cross-reference creation, update, or deletion Applicable : SSWA, FORMS |
DML_TYPE: CREATE, UPDATE, DELETE INVENTORY_ITEM_ID: Item ID ORGANIZATION_ID: Organization ID CROSS_REFERENCE_TYPE: Cross-reference Type CROSS_REFERENCE: Cross-reference |
| oracle.apps.ego.item.postRevisionChange | Item revision is created or updated Applicable: SSWA, FORMS, IOI, XL import, API |
DML_TYPE: CREATE, UPDATE, DELETE INVENTORY_ITEM_ID: Item ID ORGANIZATION_ID: Organization ID REVISION_ID: Revision ID REQUEST_ID: Concurrent Request ID |
| oracle.apps.ego.item.postItemRoleChange | An item role grant is changed (added, modified, or removed) Applicable: SSWA |
DML_TYPE: CREATE, UPDATE, DELETE INVENTORY_ITEM_ID: Item ID ORGANIZATION_ID: Organization ID ROLE_ID: Role ID PARTY_TYPE: Party Type (Person, Group or Company) PARTY_ID: Party ID START_DATE: Start Date |
| oracle.apps.ego.batch.postbatchprocess | Post Batch Import of Item and Item Related Entities This event is raised when a batch is processed. |
REQUEST_ID: Concurrent Request ID that processes the batch. |
| oracle.apps.ego.item.preAttributeChange | Item Attribute group row is created, updated, or deleted. This event is raised before the change is committed. Applicable: SSWA, Concurrent Program, WebADI, API |
DML_TYPE: CREATE, UPDATE, DELETE ATTR_GRP_NAME: Attribute Group Name EXTENSION_ID: Extension ID that uniquely identifies the record in the UDA extension table INVENTORY_ITEM_ID: Item ID ORGANIZATION_ID: Organization ID REVISION_ID: Revision ID |
| oracle.apps.ego.item.postAttributeChange | Item Attribute group row is created, updated, or deleted. This event is raised after the change is committed. Applicable: SSWA |
DML_TYPE: Indicates the type of operation. Values can be CREATE, UPDATE, or DELETE. ATTR_GRP_NAME: Attribute Group Name EXTENSION_ID: Extension ID that uniquely identifies the record in the UDA extension table INVENTORY_ITEM_ID: Item ID ORGANIZATION_ID: Organization ID REVISION_ID: Revision ID PK1_VALUE: Supplier ID PK2_VALUE: SupplierSite ID DATA_LEVEL_ID: Data Level ID |
| oracle.apps.ego.item.associations.create | Item Association Creation This event is raised after an item's association with a supplier, suppliersite, or suppliersite organization is created. |
INVENTORY_ITEM_ID: Item ID ORGANIZATION_ID: Organization ID ASSOCIATION_ID: Association Id ASSOCIATION_TYPE_CODE: Indicates the type of association (supplier, suppliersite, or suppliersite organization). |
| oracle.apps.ego.item.associations.delete | Item Association Deletion This event is raised after an item's association with a supplier, suppliersite, or suppliersite organization is deleted. |
INVENTORY_ITEM_ID: Item ID ORGANIZATION_ID: Org ID SUPPLIER_ID: Supplier ID SUPPLIER_SITE_ID: Supplier Site ID |
| oracle.apps.ego.item.associations.update | Item Association Update This event is raised after an item's association with a supplier, suppliersite, or suppliersite organization is updated. |
INVENTORY_ITEM_ID: Item ID ORGANIZATION_ID: Organization ID ASSOCIATION_ID: Association Id ASSOCIATION_TYPE_CODE: Indicates the type of association (supplier, suppliersite, or suppliersite organization). |
| Event Name | Event Description | Event Parameter Names and Descriptions |
|---|---|---|
| oracle.apps.ego.item.postCatalogCategoryChange | Catalog category is changed such as when categories are created, updated or deleted Applicable: SSWA, FORMS |
DML_TYPE: Indicates the type of operation. Values can be CREATE, UPDATE, or DELETE. CATEGORY_NAME: Category Name CATEGORY_ID: Category ID |
| oracle.apps.ego.item.postCatalogAssignmentChange | Post Item Catalog Assignment Change Event This event is raised when an item's assignment to a category (within a catalog) is created, updated or deleted. Applicable: SSWA, FORMS, IOI |
DML_TYPE: Indicates the type of operation. Values can be CREATE, UPDATE, or DELETE. INVENTORY_ITEM_ID: Item ID ORGANIZATION_ID: Organization ID CATALOG_ID: Catalog ID CATEGORY_ID: Category ID REQUEST_ID: Concurrent Request ID |
| oracle.apps.ego.item.postValidCategoryChange | Post Valid Category Change Event This event is raised when a category is added to or removed from a catalog. This event is also raised when the attributes of catalog are changed. Applicable: SSWA, FORMS |
DML_TYPE: Indicates the type of operation. Values can be CREATE, UPDATE, or DELETE. CATEGORY_SET_ID: Category Set ID CATEGORY_ID: Category ID PARENT_CATEGORY_ID: Parent Category ID |
| Event Name | Event Description | Event Parameter Names and Descriptions |
|---|---|---|
| oracle.apps.ego.gtin.uccnetEvent | UCCnet GDSN Event | - |
| oracle.apps.ego.item.postCustItemXrefChange | Post Customer Item Cross Reference Change | - |
| oracle.apps.ego.item.postRelatedItemChange | Post Related Item Change | - |
| oracle.apps.ego.orchestration.postProcessMessage | Send Post Process Confirmation Message Event | - |
| Event Parameter Name | Description |
|---|---|
| Event_Type | This parameter identifies the type of transaction that raised the event. The values are Single or Bulk. |
| Last_Updated_By | Identifier of the user. |
| Last_Update_Date | Identifies the date the transaction occurred. |
| Created_By | Identifier of the user.
Note: In bulk events that include both creation and update transactions, this parameter is does not apply and is not available. |
| Creation_Date | Identifies the date the creation transaction occurred.
Note: In bulk events that include both creation and update transactions, this parameter is does not apply and is not available. |
| Request_Identifier | When Event_Type = Bulk, this identifies the concurrent request that processed the bulk data set. |
Related Topics
To view sample subscription functions, see Sample Subscription Functions, Business Event Data for Oracle Bills of Material, Oracle Bills of Material User's Guide.
Using Item Business Events, Oracle Product Information Management User's Guide