The Latest Oracle E-Business Suite Technology News direct from
Oracle E-Business Suite Development & Product Management

Open Interfaces Now Available from EBS Adapter in Oracle Integration Cloud

Rekha Ayothi
Product Management

Open Interfaces are available as REST based web services as part of Oracle E-Business Suite Integrated SOA Gateway’s August 2018 update. I am pleased to announce the availability of Open Interfaces from Oracle E-Business Suite Adapter in Oracle Integration Cloud.

Open Interfaces include Open Interface Tables and Interface Views. Depending on direction of Open Interface Table, you will be able to perform CRUD operations on it. That is, you will be able to insert (Create), Read, Update or remove (Delete) data stored in an Open Interface table from Oracle Integration Cloud using EBS Adapter. Also, you will be able to submit the associated concurrent program for validation and further processing. And, you can Read data from Open Interface Views.

This capability is available for Oracle E-Business Suite Release 12.1.3 and E-Business Suite 12.2.3 and onwards.


Related Articles

Join the discussion

Comments ( 2 )
  • Yadnesh Chavan Friday, May 31, 2019
    Hello Rekha,

    Thank you for the post. it is really helpful. I have one doubt.
    We have some custom tables which we want to expose it via Rest service for select and other dml operations. Do you have any information on this topic. If yes, please guide.

  • Rekha Ayothi Friday, May 31, 2019
    Hi Yadnesh,

    Thank you for kind words. I am afraid, as of today, Integrated SOA Gateway (ISG) does not support custom tables. However, ISG supports custom PL/SQL APIs.

    Hence, you can write custom PL/SQL API to manage data in custom tables. And then, register it in Oracle Integration Repository, to use custom PL/SQL API as REST Service.


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.