Expose Oracle E-Business Suite APIs

Review the prerequisites, and then expose Oracle E-Business Suite services as REST APIs to facilitate the connectivity with Oracle Integration Cloud.

Before You Begin Exposing Oracle E-Business Suite APIs

Before you begin exposing the Oracle E-Business Suite APIs, ensure that you install Oracle E-Business Suite 12.2.6 or later and that you install and configure the Oracle E-Business Suite Integrated SOA Gateway for REST services.

See My Oracle Support Document 1311068.1, sections B and C.

Expose Oracle E-Business Suite Services as REST APIs

Expose the required Oracle E-Business Suite services as REST APIs with Oracle Integration Repository in the Oracle E-Business Suite Integrated SOA Gateway.

  1. Sign in to Oracle E-Business Suite as the ASADMIN user.
  2. Start Oracle Integration Repository in Oracle E-Business Suite Integrated SOA Gateway, and then click Search.
  3. In the Internal Name field, enter oracle.apps.fnd.rep.ws.service.EbsMetadataProvider, and then click Go. Click Metadata Provider.
  4. Click the REST Web Service tab. In the Service Alias field, enter provider, and then select the GET method option for all the rows in the table. Click Deploy.
  5. Click the Grants tab. Select all the rows in the table, and then click Create Grant. In the Grantee Name field, enter hrms, or a user with similar entitlements, and then click Create Grant.
  6. Click Search. In the Internal Name field, enter IRC_PARTY_API, and then click Go. Click Party.
  7. Click the REST Web Service tab. In the Service Alias field, enter IRL_PARTY_API, and then select the method options for all the rows in the table. Click Deploy.
  8. Click the Grants tab. Select all the rows in the table, and then click Create Grant. In the Grantee Name field, enter hrms, or a user with similar entitlements, and then click Create Grant.
Now, the Oracle E-Business Suite services are exposed as REST APIs, and Oracle Integration Cloud can connect to Oracle E-Business Suite and invoke these services.