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 | This event is obsolete. | - |
| 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.item.syncItemCatalogCategory | A seeded event used when publishing Item Catalog Categories to other Oracle Product Hub systems. The seeded subscription invokes the Item Catalog Category Web Service for publishing through the Service Invocation Framework of SOA Gateway and should not be modified. | Refer to Implementing Service Invocation Framework, Oracle E-Business Suite Integrated SOA Gateway Implementation Guide for details about using the SIF framework. Event Data: Input Payload for the webservice. WFBES_SOAP_USERNAME: SOAP user name to invoke webservice. WFBES_SOAP_PASSWORD_MOD: Module Name to retrieve the password stored using the FND vault. WFBES_SOAP_PASSWORD_KEY: Module Key to retrieve the password stored using the FND vault. |
| oracle.apps.ego.extfwk.syncValueSet | A seeded event used when publishing Value Sets to other Oracle Product Hub systems. The seeded subscription invokes the Value Set Web Service for publishing through the Service Invocation Framework of SOA Gateway and should not be modified. | Refer to Implementing Service Invocation Framework, Oracle E-Business Suite Integrated SOA Gateway Implementation Guide for details about using the SIF framework. Event Data: Input Payload for the webservice. WFBES_SOAP_USERNAME: SOAP user name to invoke webservice. WFBES_SOAP_PASSWORD_MOD: Module Name to retrieve the password stored using the FND vault. WFBES_SOAP_PASSWORD_KEY: Module Key to retrieve the password stored using the FND vault. |
| oracle.apps.ego.extfwk.syncAttributeGroup | A seeded event used when publishing Attribute Groups to other Oracle Product Hub systems. The seeded subscription invokes the Attribute Group Web Service for publishing through the Service Invocation Framework of SOA Gateway and should not be modified. | Refer to Implementing Service Invocation Framework, Oracle E-Business Suite Integrated SOA Gateway Implementation Guide for details about using the SIF framework. Event Data: Input Payload for the webservice. WFBES_SOAP_USERNAME: SOAP user name to invoke webservice. WFBES_SOAP_PASSWORD_MOD: Module Name to retrieve the password stored using the FND vault. WFBES_SOAP_PASSWORD_KEY: Module Key to retrieve the password stored using the FND vault. |
| oracle.apps.ego.item.publishItemCatalogCategory | A seeded event used when publishing Item Catalog Categories to external systems such as Siebel, Oracle Billing and Revenue Management (BRM), and Oracle Design Studio via Batch Mode. It is raised from the Publish Item Catalog Categories Batch page and indicates the submittal of an ICC batch for publishing. | BATCH_ID: Unique ID for the ICC batch to publish. PUBLISH_PARENT_HIERARCHY: Indicates whether or not to publish the parent ICC hierarchy along with an ICC. Values include:
PUBLISH_CHILD_HIERARCHY: Indicates whether or not to publish the child ICC hierachy along with an ICC. Values include:
|
| oracle.apps.ego.extfwk.publishValueSet | A seeded event used when publishing Value Sets to external systems such as Siebel and BRM via Batch Mode. It is raised from the Publish Value Sets Batch page and indicates the submittal of a Value Set batch for publishing. | BATCH_ID: Unique ID for the batch of ValueSets to publish. |
| oracle.apps.ego.item.publishItem | A seeded event used when publishing Items to external systems such as Siebel and BRM via Batch Mode. It is raised from the Publish Items Batch page and indicates the submittal of an Items batch for publishing. | BATCH_ID: Unique ID for the batch of Items to publish. STRUCTURE_FLAG: Indicates whether or not to publish an item's structure along with the item. Values include:
Note: oracle.apps.bom.structure.publishStructure is no longer raised when publishing structures. |
| 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 Hub User's Guide