Overview of Integrating Order Management with eBusiness Suite

If you use an application that's part of Oracle E-Business Suite, Enterprise Resource Planning (Oracle EBS ERP), and plan to migrate to Order Management in phases, then you can integrate Order Management with E-Business Suite and continue to use E-Business Suite.

You deploy a connector that sits between Order Management and the Integrated SOA Gateway in E-Business Suite. Use it to send sales orders and communicate status updates between Order Management and E-Business Suite. This connector uses a SOA (Service Oriented Architecture) and BPEL (Business Process Execution Language) composite that you can use to deploy to a SOA server.

  • Set up Order Management to send sales orders to eBusiness Suite so eBusiness Suite can fulfill the sales order, including shipment and invoice.

  • Set up eBusiness Suite to send status updates to Order Management. If customer details don't already exist in eBusiness Suite, then this integration synchronizes them when eBusiness Suite receives the sales order.

These integration flows use a connector that you deploy on the SOA server. They also use services from Order Management and the Integrated SOA Gateway in eBusiness Suite. The gateway is part of Oracle eBusiness Suite, release 12.1 and higher. It includes:

  • Integration Repository. Use public APIs (application program interface) in eBusiness Suite that create and deploy the integration as a web service. Use this integration to send sales orders from Order Management to eBusiness Suite, and to use the Process Order API in eBusiness Suite as a SOA (Service Oriented Architecture) web service.

    In general, this document describes APIs that use PL (Procedural Language) or SQL (Structured Query Language).

  • Service Invocation Framework (SIF). Use the business events that eBusiness Suite uses, and use event details to call a web service. This integration uses the Service Invocation Framework in Integrated SOA Gateway to send status update from eBusiness Suite to Order Management. Order Management uses a web service to process the status update response that the Service Invocation Framework calls.

Oracle provides this connector and example integration only for testing purposes. Oracle doesn't support this connector or example integration in a production environment.

For more, see:

Features This Integration Supports

Feature

Description

Synchronize sales orders.

Synchronize entities when you create a sales order in eBusiness Suite.

  • Customers

  • Addresses

  • Contacts

Create new sales orders.

Create sales orders that include different types of items.

  • Items

  • Ship sets

  • Pick-to-order configured item

  • Assemble-to-order configured item

  • Kits

  • Return Material Authorization (RMA)

Revise sales orders.

  • Revise order, such as modify values in the order header.

  • Cancel order.

  • Revise order lines.

    • Cancel order line.

    • Revise an order line, including revising quantity, product configuration, and pricing.

    • Revise addresses, contacts, and so on.

    • Add a new order line to an existing sales order.

    • Revise addresses, contacts, and so on.

Synchronize status updates.

Synchronize order status updates and sales order splits. Here's what you can synchronize.

  • Order Line status, including Awaiting Shipping, Shipped, Fulfilled, Awaiting Return, and Returned

  • Scheduled Ship Date

  • Scheduled Arrival Date

  • Warehouse

  • Shipping Method

  • Line Split

Features This Integration Doesn't Support

  • Entities that a sales order or order line references, such as.

    • Sales credit

    • Attachment

    • Shipping charge

    • Tax

    • Lot serial number

  • Status updates for shipping details and invoice details

  • Warranty or extended warranty

  • Sales order flows for assets

Requirements for Using This Integration

Requirement

Description

Release

You must use this release or higher.

  • eBusiness Suite release 12.1.3 and OM Patch 23249299:R12.ONT.B

Statuses

Order Management sends these statuses.

  • Schedule Ship Date

  • Shipped

  • Fulfilled

  • Returned

  • Canceled

Returns

This integration assumes.

  • Order Management allows a return order to reference the original order so it can identify the sales order you're returning.

  • Order Management sends only the configured item that eBusiness Suite uses for returns. It doesn't send the order lines that the configured item references.

Synchronization

You must synchronize item data before you use this integration.

Bill of Materials

The BOM (bill of materials) structure for each kit, pick-to-order, and assemble-to-order must be identical in Product Information Management and in eBusiness Suite.

Customer details

If you modify customer details in Order Management, then this integration doesn't synchronize these details directly from the customer master in Order Management to the customer master in eBusiness Suite.

This integration synchronizes these details only if it uses the customer or address during ordering, and it only synchronizes the addresses and contacts that the sales order references.

Deployment Options

Use this integration with Order Management, the on-premise version of eBusiness Suite, and with connectors deployed on SOA Cloud Service (PAAS).