WIXLIB

ERP Integration Best Practices toDrive Digital Transformation

Oracle Commerce Cloud is a fully featured, extensible SaaS commerce solution,hosted in the Oracle Cloud, supporting B2C and B2B models in a single platform.Commerce Cloud grants greater agility and cost savings, with the extensibility andcontrol required in the ultra-competitive digital commerce market.SIMPLIFY your technology footprint.INNOVATE to stay ahead of consumer demands and competitors in a low-risk way.DELIVER to every customer, every time to increase loyalty and revenue.Commerce Cloud has frequent releases.Please ensure you have the latest documentation.This outlines features included in Commerce Cloud as of version 17.3,released July 2017.ERP Integration Best Practices to Drive Digital Transformation2

CONTENTSERP Integration Best Practices to DriveDigital Transformation Simplify integration time and costBenefits of integrating commerce and ERPCommon integration points to any ERP systemLeveraging Integration Cloud Services (ICS)Leveraging Oracle Commerce Cloud RESTWeb Services Framework Bulk import/export Sample use casesERP Integration Best Practices to Drive Digital Transformation3

Simplify integration time and costBusinesses run into a number of challenges when exploring ERP integration options such asneeding to connect to multiple systems, the mixing on-premise and cloud applications, and theconstant evolution of a business’s needs and requirements.One of the top questions we get around Oracle Commerce Cloud is “Can you integrate with “X”ERP system?” This isn’t surprising as an integrated offering allows companies to more efficientlymanage the customer buying processes – both on and offline. The short answer is OracleCommerce Cloud is truly agnostic when it comes to ERP integrations.Oracle Commerce Cloud customers have integrated with Oracle ERP systems such as JD Edwardsand EBS as well as third-party systems.Built with an API-first architecture, Commerce Cloud features an open, REST Web Servicesframework. This dramatically cuts down on integration time and cost when integrating toOracle and/or third-party systems.Benefits of an integrated solution“Oracle’s REST model natively supports thedynamic permutations of profile (accounts),catalogs (products), and price lists, alongwith native plug-ins to CPQ (configure, price,quote tools) via API, allowing me thefreedom to design modern customerexperiences without having to worry aboutcore modeling issues.”Rohit Garewal, Object Edge Significantly reduce the amount of time it takesto enter order data while also reducing errorsrelated to manual data entry Accurately and immediately reflect price andproduct changes Improve the accuracy of inventory management Provide customers with faster, more accuratecommunication with automatic shippingnotifications, ability to track shipment, anddelivery updates. Support more online orders without addedresources Decrease time between order placement andshipment Reduce call volume to customer service representativesERP Integration Best Practices to Drive Digital Transformation4

Common integration points for ANY ERP systemTypically, ERP systems manage a business’s core data (customers, products, pricing, contracts,inventory, invoices, etc.). Some ERP systems also enable configuration of complex products,services, and bundles.Common integration points between ERP and commerce could include:Product Data: Product and pricing data is continually being updated. A common use case example isinventory availability. This includes what’s in stock online, in-store, and often quantity available.Showing inaccurate information could result in selling products not in stock or missing out on salesopportunities.Configuration: If your catalog contains products and services that offer a variety of configurable options,or your self-service user will benefit from decision assistance, Oracle Commerce Cloud accommodates avariety of configuration options. For optimal user experience, we recommend Oracle’s fit-for-purposesales configuration and quoting tool, Oracle CPQ Cloud. A seamless integration eases set-up andmaintenance for this use case. As an example, configured products are passed to the cart; the user mayERP Integration Best Practices to Drive Digital Transformation5

reconfigure as needed; and upon checkout, the integration validates the cart price against the CPQpricing engine. When paired with CPQ Cloud, Commerce Cloud ensures customers select the optimalproducts and services they need quickly and easily.Customer Data: Your customer data is in a constant state of change. What products have they bought?Where do they want it shipped?Another common use case we see is customers wanting a consolidated view of their purchase andaccount data. Many businesses offer their customers a centralized location where they can login andsee their order history, order status, contracts in place, and more. Often, this data needs to beintegrated from multiple back-end systems.Order Data: After a purchase is made online – what happens next? A seamless integration betweencommerce and ERP makes sure the correct order data gets passed between systems to reduce errorsand speed up order processing.ERP Integration Best Practices to Drive Digital Transformation6

Leveraging Oracle Integration Cloud ServicesSome organizations choose to perform a point-to-point connection between ERP and Commerce,meaning no operational platform exists in the middle of your systems. While this often works as ashort-term solution, organizations experiencing growth may experience limitations. For example, apoint-to-point integration may require reconfiguration as needs evolve, such as adding new channels.Oracle offers Integration Cloud Services (ICS) to help solve these challenges and increase flexibility. ICSwill help you simplify integration problems, deliver integrations faster, and ultimately deliver a bettercustomer experience.ICS brings enterprise grade-integration to the cloud without the difficulties associated with typicalintegration tools no matter where you are in the build, operate, and maintain continuum.ICS is designed to work with all types of applications allowing you to have a hybrid of cloud and onpremise applications supporting your connected customer journey.ICS comes packaged with many adapters that help you connect Oracleand 3rd party applications, both Cloud-based and On Premiseapplications to ICS. ICS adapters include Oracle Commerce Cloud,CPQ Cloud and many ERP adapters including JD Edwards, EBS, OracleERP Cloud, SAP, and more. ICS also offers integration flow bestpractices around the movement and transformation of data betweenyour applications. In addition to adapters, Oracle provides pre-builtintegrations between Oracle CX applications such as Oracle CommerceCloud, Oracle CPQ Cloud, Oracle Marketing Cloud, and Oracle ServiceCloud that allow integration implementations to get off the groundquickly.ICS ERP AdaptersOracle JDEOracle ERPCloudSAPOracle EBSOracleNetsuiteOraclePeoplesoftFull list of ICS adaptersThe Commerce Cloud adapter supports all major entities. Details are available at docs.oracle.com. TheselfHelpDoc can be used for troubleshooting the common error during integration flow creation withOracle Commerce Cloud adapter.ERP Integration Best Practices to Drive Digital Transformation7

Taking advantage of Oracle Commerce Cloud’sREST Web Services FrameworkAs previously mentioned, Oracle Commerce Cloud’s open, REST Web Services framework andwebhooks dramatically cuts down on integration time and cost when integrating to OracleCommerce Cloud and third-party systems.A sampling of Oracle Commerce Cloud webhook to ERP integration includes:Webhook NameOrder SubmitShopper RegistrationShopper Account UpdateAccount CreateAccount UpdateRequest QuoteUpdate QuoteReturn Request UpdateIdle CartPublish CompleteShipping CalculatorExternal Price ValidationExternal Tax CalculationOrder ApprovalsAvailable on ICSYesYesYesYesYesYesYesYesYesYesYesYesYesYesICS Trigger name for Request QuoteUpdate QuoteReturnIdle CartPublish EventCalculate ShippingExternal PricingExternal Tax CalculationOrder ApprovalsA sampling of Oracle Commerce Cloud REST endpoints applicable to an ERP integration ionOrderssyncQuote,updateQuoteStatus,getOrders, cts,createProductERP Integration Best Practices to Drive Digital Transformation8

Which Rest web services of Commerce to invoke depends on the use case. Mostly for data sync fromERP systems to Oracle Commerce Cloud, create or update services are invoked. Full documentation onOracle Commerce Cloud REST Endpoints.Entity Sync with Bulk recordsIn an environment where Oracle Commerce Cloud interacts with anexternal system, you may want to exchange data. Oracle Commerce Cloudincludes REST web services APIs that allows you to select data items andexport or import them in bulk. This framework allows you to performlarge data transfers between different environments or systems of itemssuch as accounts, profiles and promotions. It is recommended that initialdata sync be done using bulk import/export capability of OracleCommerce Cloud.Entities which are supported for bulk import/export in Oracle CommerceCloud toryProfilesProducts (with SKUs and Prices)PromotionsMore details are available here Bulk Export Import documentation.ERP Integration Best Practices to Drive Digital Transformation9

20 Example ERP Integration Use Cases1Account created/updated outside and synced in Oracle Commerce Cloud 2Account created/updated in Oracle Commerce Cloud and synced outside 3Oracle Commerce Cloud provides below webhooks for syncing account data one by oneo Account Createo Account UpdateOracle Commerce Cloud provides bulk export capability of account for exportingaccount data in bulko Plugin name: Accountso More details are available here.Catalog created/updated outside and synced in Oracle Commerce Cloud 4Oracle Commerce Cloud provides below Rest services for syncing account data one byoneo /ccadmin/v1/organizations (createOrganization)o /ccadmin/v1/organizations/{id} (updateOrganization)Oracle Commerce Cloud provides bulk import capability of account for importingaccount data in bulko Plugin name: Accountso More details are available here.Oracle Commerce Cloud provides below Rest services for syncing catalog data one byoneo /ccadmin/v1/catalogs (createCatalog)o /ccadmin/v1/catalogs/{id} (updateCatalog)Oracle Commerce Cloud provides bulk import capability of catalog for importing catalogdata in bulko Plugin name: Catalogso More details are available here.Catalog created/updated in Oracle Commerce Cloud and synced outside Oracle Commerce Cloud provides bulk export capability of catalog for exporting catalogdata in bulkERP Integration Best Practices to Drive Digital Transformation10