Use Data from External Systems to Automate Data Embellishment in Oracle Fusion Cloud Product Lifecycle Management

After an item is added to Oracle Fusion Cloud Product Lifecycle Management (PLM), there's a critical need for the item data to be embellished further by getting more data elements from external systems.

For example, if an item "Chemical" is added to Oracle Cloud PLM then the data element might be a "HAZMAT" classification.

Description Integration Type Integration Options Notes

This use-case scenario usually demands:

  • Item data update is performed in Oracle Product Hub.
  • External systems furnish extra data elements for the item based on the attributes available in Oracle Cloud PLM.
  • For the item data to be transaction-ready, it must be updated with the data furnished by the external system.
  • Process integration
  • Outbound
Item web services, along with Oracle Integration Cloud (OIC), can be used to build this orchestrated flow of information to achieve an end-to-end business process. Here's an example solution:
  1. OIC detects an item update in Oracle Product Hub by listening to the business events and then extracts the item attributes of interest, for example, chemical composition.
  2. OIC provides the external system with the extracted data and collects the data element the external system furnishes, for example, HAZMAT.
  3. OIC uses Item or Change web services to update (or redline) the item in Oracle Product Hub and Oracle Product Development with the data element's (HAZMAT) data.