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

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
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

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

Comments

  1. Perfect, beautifully explained.

    ReplyDelete
  2. Thanks Narayana for great presentation on the flow.

    ReplyDelete
  3. Thank you for sharing this informative information with us. Its very helpful.
    Saas Cloud Based ERP

    ReplyDelete
  4. Thank you for sharing this informative information with us. Its very helpful. Cloud ERP for Import Export

    ReplyDelete
  5. This is really informative blog, I have to thank for your efforts. Waiting for more post like this.
    Cloud Computing
    Benefits of Computing


    ReplyDelete
  6. Thank you for sharing this informative information with us. Its very helpful. Saas Based ERP for Import Export

    ReplyDelete
  7. Product listing data entry which are our core specialists, our turnaround time is very quick, and we can well deal with volumes of work without any hassles. All information provided by you is dealt with strictest confidence and hence we ensure complete privacy of data at our end.

    ReplyDelete
  8. Thanks for this great post.
    I have issue : " I have de-activated the Item Update OIC integration which subscribes to the 'Item Update' Business event of oracle fusion cloud and selected the 'Delete event subscription' check box.Then after re-activating the OIC integration,Item updates chnages/events messages are not receiving in OIC" . Do we need to do any configuration from Fusion end to re-establish coneection and to receive event messages in OIC? Can you please help me.

    ReplyDelete
  9. Really nice post. To know about What is OKR , read here.

    ReplyDelete

Post a Comment