Invoke Oracle E-Business Suite PL/SQL APIs from Oracle Integration

Oracle E-Business Suite contains numerous interface integration endpoints which can be exposed as REST services through Oracle E-Business Suite Integrated SOA Gateway. To leverage and use these Oracle E-Business Suite REST services to access Oracle E-Business Suite application data, you need to configure the Oracle E-Business Suite Adapter as invoke (target) connections.

PL/SQL REST services are one of the available interfaces for use in outbound integrations from Oracle Integration. In response to a request in an integration, a PL/SQL REST service can be invoked to access or update Oracle E-Business Suite application data to fulfill the integration needs.

Note:

In addition to Oracle seeded PL/SQL APIs, you can use custom PL/SQL APIs or REST services for your integration needs.

For example, select "Sales Order Services" PL/SQL API in the Configure Web Services page of the Oracle E-Business Suite Adapter Endpoint Wizard. The corresponding interface information is automatically populated. This includes the interface internal name (OE_INBOUND_INT) and description.

This image shows the Configure Web Services page of the Oracle E-Business Suite Adapter Endpoint Configuration Wizard. It includes Product Family, Product, Interface Type, API, Internal Name, and Description. In the API field, “Filter by name” and “a list of API names” options are displayed top to bottom allowing you to locate your desired API.

If one or more methods contained in the selected interface are deployed as REST service operations, after you click Continue, the Configure Operations page appears. If none of the methods in the selected interface is deployed as a REST service operation, then an error message appears. See: Undeployed REST Service Error Message.

In the Configure Operations page of the Oracle E-Business Suite Adapter Endpoint Wizard, the selected interface internal name OE_INBOUND_INT is automatically populated. You need to select a desired method name, such as "Sales Order Service" method, that will be used in an integration.

This image shows the Configure Operations page of the Oracle E-Business Suite Adapter Endpoint Configuration Wizard. The following fields are displayed top to bottom: API, Methods, Service Status, and Description

For more information about using PL/SQL REST services in an integration, refer to:

For an integration example of using PL/SQL REST services, see An Example of Using a PL/SQL REST Service as an Invoke (Target) Connection in an Integration.
For troubleshooting information while creating an integration with the Oracle E-Business Suite Adapter as an invoke (target) connection in Oracle Integration, see Troubleshoot the Oracle E-Business Suite Adapter While Using it as an Invoke (Target) in an Integration.