I sat down last week with our Senior Director of Technology, Gurvinder Bargota and Tech Lead, Manoj Tyagi to demo of the Oracle Commerce Cloud (OCC) integration with Oracle E-Business Suite (EBS). While the OCC to EBS integration has been available through other means, the set of accelerators built by TAISTech is enabled on OCC SSE and ORDS on EBS. So, what does that mean for those who are running their commerce business on OCC? This accelerator allows for a direct integration between OCC and EBS that can be enabled out-of-the-box, and at no additional expense. Within hours, order functionality such as Order Submit and Order Status are bi-directionally synced between OCC and EBS. Your Catalog, also synced. Additional integration points include Accounts/Organizations, Users Profiles, Price List, Inventory, and Invoice History.
The integration is built on SSE which is technology included with OCC OOTB. Existing integrations are available, but they are typically built on third-party tools such as MuleSoft or using Oracle Integration Cloud Service (ICS). ICS lets you connect securely to applications and services both in the cloud and on-premises. The flexibility of ICS is impressive, yet many are looking to gain value from their existing Oracle technology (like OCC and EBS) without making an additional investment in ICS or an API-management tool.
Once integrated, the seamless flow of data between the two systems is a boon for the business user while it largely reduces the reliance on IT staff to support and maintenance (which can be easily outsourced). The integration is built on REST APIs with significant flexibility around the customization of attributes and business logic and also includes the enablement of ORDS to expose functionality as a service for greater reuse and adoption.
The demo is quite simple. I create an order in the OCC storefront as a new user from an existing account. It also identifies if I am submitting the order for an existing billto/shipto address or from a new billto/shipto address. I checkout and am given an order confirmation number. I then log into my instance of EBS and there is my order—the products, my profile (now attached to the existing account), and my order status. I am able to take action on the information in either system and it is easily synced. And, best of all, it just works.
EBS integration Flows:
- Customer/Accounts :
The first integration works for sending customer/accounts information to EBS from OCC. The Admin logs in to OCC for creating an account and as soon as the account is created, the OCC webhook fires all the account information to SSE which maps it to EBS APIs and creates an account in EBS.
To check an account is created successfully, login to EBS and click on create/maintain customers link as shown below.
After clicking the link you will land on the find customers page in EBS.
Enter the organization name, that was created in OCC and click find, as shown in below screenshot.
You’ll see the account has been synched to EBS and it displays in the results area.
Click on the name of the account to see the details of the account and it would look something like below.
- Orders Integration:
Orders can be integrated from OCC to EBS in a similar way. Once the user from an account submits an order, the order is readily pushed to the EBS system using the OCC order webhook and via SSE pushed to the EBS order API.
Once EBS creates that order, an EBS order id is passed back to OCC which can be shown in the order history as an external order id field.
To see this, the user can go to the order history and see what orders have been synched to EBS. Below is the screenshot of the user’s order history.
Her Order Id is the external order id from EBS.
Now we can pick this order id and go find it in EBS to see the order details.
Login to EBS and click sales order tab and open find orders.
Enter one of the order id that was shown in the order history in the find orders tab in EBS like shown below.
The order details will look something like below.
Now, whenever the status of orders get updated in EBS, a scheduler pushes the order statuses to OCC via an API and shows users whether the Order moved to processing, shipped or canceled.
On October 31st, Surya Koppera, VP of eCommerce at Things Remembered, will present a webinar about their commerce journey to OCC. We hope you will be able to join us and ask questions directly about the ease of use.
Keep an eye out for additional integration demos like OCC to Eloqua, OCC to Responsys, OCC to Apple Pay and more. To request your personalized demo, please visit https://mastek.taistech.com/demo or check us out at OpenWorld at Booth #112 in the CX Showcase.