Oracle Integration Cloud Service (ICS) is Oracle’s integration Platform as a Service (iPaaS). It provides a web-based interface to integrate Software as a Service (SaaS) and on-premise applications. It includes various technology and application adapters.
Oracle E-Business Suite Adapter from Integration Cloud Service provides native and secure connectivity to Oracle E-Business Suite instance. It lets you create integrations with EBS public integration interfaces. As of ECS 16.2.5, the EBS Adapter supports:
- EBS R12.1.3, R12.2.3, R12.2.4 and R12.2.5.
- PL/SQL-based REST Services for outbound integrations from ICS (also called inbound integrations to EBS).
- Business Events and XML Gateway Messages for inbound integrations to ICS (also called outbound integrations from EBS).
- Custom interfaces registered in Integration Repository.
- Connectivity via an on-premise Agent. If EBS REST Services are directly accessible from ICS, on-premise Agent need not be configured.
Here is a tutorial on using EBS Adapter for integrations in Integration Cloud Service:
- Using Oracle E-Business Suite Adapter in Integration Cloud Service 16.2.5: Business Events (YouTube)
It highlights the steps required to utilize the Business Event information from EBS. It is based on an Order-to-Manual Invoice scenario. When a Sales Order is booked in EBS Order Management, EBS raises a business event with Header Id and Status of the corresponding Sales Order. This information is used to retrieve details of the Sales Order. A manual invoice is created in EBS Accounts Receivable for this Sales Order.
This tutorial uses EBS Adapter as a Trigger (Source) as well as an Invoke (Target) connection. A Business Event is used to trigger the ICS integration whereas, PL/SQL-based REST Service is used to retrieve or fetch Sales Order details from EBS Order Management. It uses a REST Adapter to create manual invoice in EBS Accounts Receivables.
Tutorial Resources
- An Example of Using a Business Event as a Trigger (Source) in Integration. Refer this document for steps to create the integration mentioned in the tutorial.
- Order to Invoice (iar file). This is the iar file of the integration created in the tutorial. You can download it to your local environment and import it to ICS.
- Steps to import Order to Invoice (iar file) to ICS. Refer this document for steps to import and test the integration mentioned in the tutorial.
References
- Using Oracle E-Business Suite Adapter
- Oracle E-Business Suite Adapter Frequently Asked Questions (Note 2110687.1)
- Using Oracle E-Business Suite Adapter in Integration Cloud Service 16.2.5: Business Events (Oracle Learning Library)
Related Articles