Review EBS product's new releases & features, troubleshooting tips & tricks, best practices, upcoming webcasts

Oracle EBS PL/SQL APIs as REST Web Services

Suryanarayana Maddula
Principal Technical Support Engineer

With Contributing Author: Vishnu Vemulapalli

Have you tried deploying BOM/Inventory/Product Hub PLSQL API as REST web services?

SOAP (Simple Object Access Protocol) and REST (Representational State Transfer) web services are standalone software components that are accessible from anywhere using HTTP basic or token-based security. In E-Business Suite Integrated SOA Gateway, we have Unified Repository for Interfaces (APIs,  Concurrent Programs, Business Events, etc.) which you can configure and deploy as out-of-the-box interfaces as Web services.

REST or RESTful API design (Representational State Transfer) is designed to take advantage of existing protocols. They are developed based on Oracle E-Business Suite technology infrastructure. REST web services, without the dependency on Oracle SOA Suite, described in WADLs (Web Application Description Language) can be directly deployed to an existing Oracle E-Business Suite WebLogic environment.

Supported Interface Types (As of Oracle E-Business Suite 12.2)

  • Concurrent Programs
  • Java Bean Services
  • Application Module Services
  • Open Interface Tables and Views

PL/SQL APIs and Concurrent Programs are SOAP and REST services whereas Java Bean Services, Application Module Services, and Open Interface Tables are REST services only.

The REST messages are authenticated using HTTP Basic Authentication security (either username/password or security token) at the HTTP transport level.

Please review the below information to leverage the latest Integrated SOA Gateway features to deploy PL/SQL APIs as REST Web services in Oracle E-Business Suite. You can deploy different modules APIs from Inventory to Product Hub to Bills of Material(BOM) as REST web services.

For examples and quick demo, please review the below document which aims to provide an example of how you can leverage the latest Integrated SOA Gateway features to deploy a BOM plsql API (BOM_BO_PUB.Process_BOM) as a REST Webservices.

Logistics Webinar: EBS Logistics – PL/SQL APIs as REST webservices (Doc ID 2581594.1)

Be the first to comment

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