Oracle E-Business Suite (EBS) is a complete set of business applications for managing and automating processes within your organization. The Order Management (OM) and Financial Module (FM) are important parts of Oracle EBS. The order-to-cash cycle contains the complete processes of a sales order, which includes order management and fulfillment, credit management, invoicing, and payment.

Using Oracle E-Business Suite with App Connect

You can use App Connect to perform actions on the following custom objects:

• Customer sites
• Customers
• Deliveries
• Invoices
• Locations
• Orders
• Party contacts
• Party organizations
• Party sites
• Receipts

 The model properties are displayed on the App Connect UI dynamically.

Building a flow in App Connect with Oracle E-Business Suite

Use IBM App Connect to build flows that integrate with Oracle E-Business Suite and other applications. The connector is displayed as “Oracle E-Business Suite” on the IBM App Connect User Interface (UI).

Provide the following information to connect App Connect to your Oracle E-Business Suite.

Scenario: Create an order in Oracle E-Business Suite (EBS) when a new opportunity is created in Salesforce

Consider the following scenarios where you use App Connect to create a flow to integrate Oracle E-Business Suite (EBS) with Salesforce and notification applications.

Oracle EBS creates a new order whenever a new opportunity is created in Salesforce and a Slack notification is sent to the dedicated channel.

In this example, the action-driven flow is triggered whenever a new opportunity is created in Salesforce.

• By using the Create order operation, Oracle EBS creates the order with the order information from Salesforce such as the opportunity name, order number, and amount.
• A Slack notification is posted on a dedicated channel with the order details.

Consider the sequel scenario where Oracle EBS creates a single invoice when an order status is updated to 'closed'. An email is sent from Gmail with the invoice details.

Ensure that the order is in closed state. For more information, see How to use IBM App Connect with Oracle E-Business Suite.

For this scenario, you run a schedule-based flow to retrieve the specified order from Oracle EBS orders.    

1. The Get order operation retrieves an order based on the specified Order Number from Oracle EBS.
2. The flow includes an If and Else conditional statement node from the Toolbox. 

• • IF the Oracle EBS order status code is ‘CLOSED’, an invoice is created in Oracle EBS, and an email is sent with the order details through the registered Gmail account.
  • ELSE an email is sent to the intended customer with the following content: 

Subject: An invoice has not been created for order {ORDER NUMBER}

Body: An invoice has not been created because an invoice is only generated for CLOSED orders.

IBM® App Connect supports a wide range of data formats, application infrastructures, and integration styles. For more information, see IBM® App Connect connectors.