Real Time Item Synchronization using Oracle Integration

Usecase

As we move critical systems to the cloud, maintaining a true Item Master at the core becomes astronomically challenging without standardized controls. Whether just starting or well into the cloud, a simplified Item Master will drive business transformation no matter what the make-up of your world. Irrespective of Consolidation or Centralized Style of implementation of Oracle Product Hub Cloud the Real Time Synchronization of Item/Attributes/Item Categories/BOM and related information with Enterprise ERP's and Commerce ERP's is pretty much a necessity. Look at the World of Possibilities which is true in many of the Real Customer Scenarios.

In this use case we will explore the use of Oracle Integration to subscribe to Oracle Product Hub Cloud Events and push the relevant event information to downstream systems such as E-Business suite for a typical Hybrid Deployment scenario. 

a.       User creates an Item in Oracle Product Hub Cloud

b.       Oracle Integration subscribes to the Item event, transforms and pushes the relevant Item information to E-Business Suite

Configure

ERP Cloud

There are certain pre-requisites that need to be performed in Oracle Product Hub Cloud, they are detailed below.

• Add the required roles for integration Navigating to ERP Cloud Security Console
• Integration Specialist
• Oracle ERP Cloud-specific data access to the integration user

Refer the pre-requisites @ OIC Documentation

• Create a csf key to subscribe to events in ERP Cloud. OIC ERP cloud adapter supports lot of ERP Cloud Events which is described here

E-Business Suite

Similarly, we need to setup a bunch of pre-requisites to expose E-Business Suite Rest API that we intend to invoke from OIC

• Set Up and Enable the Oracle E-Business Suite Adapter for Integrations
• Deploy the PLM REST API in E-Business Suite Integration Repository

Navigate to Integrated SOA Gateway -> Integration Repository and search for EGO_ITEM_PUB

Select Catalog Item Maintenance

Switch to Rest Webservices and provide an alias “plmsvc”

Select Process Item (convenience wrapper version) and deploy

Switch to Grants tab and Select Process Item and Create Grant for EBS Integration User we intend to use when Creating Connection in OIC

Implementing the Product Hub Cloud Real Time Item Sync Usecase

Creating Connections

Create the following connections in OIC leveraging the Out of the Box ERP Cloud and EBS Adapters

• ERP Cloud Connection  (Use the Integration User for which Roles are assigned)
• E-Business Suite Connection (Use the EBS Integration User for which REST API grants are assigned)

Creating the Item Sync Integration Flow

1. Create an App Driven Integration Flow 
2. Drag and Drop ERP Connection as Trigger Provide an Endpoint Name
3. Select “Receive Business Events Raised within ERP Cloud” as the option and search for the “Item Create Event” and provide an XPath Expression as below and Click Next. Here we are trying to filter Item Events with a Specific Item Number. Infact, we can provide any attribute as filter conditions.

<xpathExpr xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns1="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/" xmlns:ns2="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/types/">$eventPayload/ns2:result/ns0:Value/ns1:ItemNumber="Lan Cable XX"</xpathExpr>

How to derive the XPath filter expression?

Business events in Fusion-based SaaS are processed like this

• If a business object is created, updated or deleted, an event is triggered inside SaaS if there is a subscription. This event payload contains only some core elements of the business object.

• An enrichment service is called to get the complete data of this business object

• This enriched payload is sent to the external system which has been registered to receive the event (in our case OIC)

The payload in most cases is identical to the findXXX web service response payload.

Let's look at our example - the "Item Creation" event. The corresponding event payload is based on the findItemResponse structure of the findItem operation in web service ItemServiceV2. We can find a documentation of the SCM web service structures in the SCM Cloud API Documentation

Refer Doc ID 2009590.1 for Sample PIM payloads

The response structure looks like this:

So for "ns2:result/ns0:Value/ns1:ItemNumber", the namespaces need to be derived from above response payload as.
ns2: "http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/types/"
ns0: "http://xmlns.oracle.com/adf/svc/types/"
ns1: "http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/"

The root path for the XPath expression starts with the variable $eventPayload - this references the variable which stores the result after calling the enrichment service.

• Next we will add the Invoke Activity Using the EBS connection to insert Item.

• In the Web Services page select the Product Family/Product/Interface Type/API 

  Note: The API/Operation should have been published and the grants to be added from EBS ISG repository.

In the Operations page Select “Process Item” Operation

Integration so far...

A Map activity (Map to EBS_PLM) is created automatically.  Perform the mapping as per below.

·     onEvent -> findItemResponse -> result->ItemNumber TO  PROCESS_ITEM_Input -> inputParameters -> P_SEGMENT1
·       onEvent -> findItemResponse -> result->ItemDescription TO  PROCESS_ITEM_Input -> inputParameters -> P_DESCRIPTION
·       “CREATE” à  TO  PROCESS_ITEM_Input -> inputParameters -> P_TRANSACTION_TYPE
·       “V1” àItemNumber TO  PROCESS_ITEM_Input -> inputParameters -> P_ORGANIZATION_CODE

Provide a Tracking Identifier

Activate the Integration

Login into ERP Cloud with User credentials having "Product Data Steward Role"

Select Tasks tab and Select Create Item

In the Create Item Screen Select "Create New"

1.      In the Create Item page enter the Item name same as the value provided in the XPath filter expression for Item Number

Confirm that the Item is created by searching with Item Number

We should see an Integration Instance created in OIC 

Select View Activity Stream to verify if the Item is successfully created in EBS. Check the Item Creation Event payload

1.    We can view the payload response  after successful creation of item in EBS

     Conclusion

Now you should have fair understanding of how you can use Oracle Integration effectively to Synchronize Data in Real Time using Out of the Box Adapter capabilities integrating with Oracle ERP Cloud and E-Business Suite