Category: Oracle Integrated SOA Gateway

Oracle E-Business Suite (Release 12.2) provides REST based web services. Below is a quick summary of the setup tasks you need to do.

For detailed information see the following My Oracle Support document:
Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID1311068.1)

Of course, Oracle recommends you are running on the latest AD and TXK releases. Check the note above for any additional patches you may need to install first.

Part 1: Configure EBS for REST Services

Step 1: Source the run file system

unix> source /EBSapps.env run


Step 2: Setup REST

unix> perl $FND_TOP/patch/115/bin/ISGRestSetup.pl

When prompted, enter the APPS username and password
When prompted, enter the WebLogic username and password

Step 3: Copy REST configuration to the patch file system

unix> adop phase=fs_clone

Part 2: Validate setup using backend script

Step 1: Source the run file system

unix> source /EBSapps.env run

Step 2: Run this command and check for errors

unix> ant -f $JAVA_TOP/oracle/apps/fnd/isg/ant/isgDesigner.xml
-Dfile=$JAVA_TOP/oracle/apps/fnd/isg/ant/isg_service.xml -Dverbose=OFF

Check for any errors in the reports created. Reports are located at:

$JAVA_TOP/oracle/apps/fnd/isg/ant

Step 3: Access EBS applications

Use your browser to go to the following URL:

http(s)://:/webservices/rest/provider/isActive/

When prompted, enter the username and password for an EBS administration user. You should then see the following in your browser:

<?xml version = '1.0' encoding = 'UTF-8'?>
<isActive_Output>
<OutputParameters>
<Output>ACTIVE </Output>
...
</OutputParameters>
</isActive_Output>

Building on top of Oracle Fusion Middleware and service-oriented architecture (SOA) technology, Oracle E-Business Suite Integrated SOA Gateway (ISG) is a complete set of service infrastructure to provide, consume, and administer Oracle E-Business Suite web services.

With service enablement feature, integration interfaces published in the Oracle Integration Repository can be transformed into SOAP and REST based web services.

Use Case – Our client currently has an Oracle E-Business Suite application instance which is R12.1.3+ level along with an in house credit card payment processing system. Ideally client needs to implement Oracle Payments and Oracle iReceivables modules to process credit card payments, instead we applied Oracle SOA ISG add on patches to existing Oracle E-Business Suite instance and wrote custom pl/sql programs and deployed these as web services in SOA ISG repository as REST web services. These web services are consumed by 3^rd party applications for querying invoices, creation of receipts, and application of receipts to specific invoices, reversal of applied receipts and host of other functionalities.

In current Oracle EBS system, invoices generated for customers belonging to various internal applications within the client network, accepts only payments by checks since payment by credit cards has not been configured. Existing E-Business Suite processes millions of dollars’ worth financial data for client and any changes to this system have to be thoroughly vetted and then implemented. Existing E-Business Suite instance has to integrate with the custom credit card payment process system using in built features of Oracle Integrated SOA Gateway (ISG) and record payments, inquire outstanding balances, process reversals etc. in real time etc.

Here are some major features that can be achieved from  this project (from Oracle ISG):

1. Display all Oracle E-Business Suite integration interface definitions through Oracle Integration Repository
2. Support custom integration interfaces from Oracle Integration Repository
3. Provide service enablement capability (REST services) for seeded and custom integration interfaces within Oracle E-Business Suite
4. Use the Integration Repository user interface to perform design-time activities such as generate and deploy Oracle E-Business Suite Web services
5. Support synchronous interaction pattern for REST-based Web services
6. Support multiple authentication types for inbound service requests in securing Web service content
7. Enforce function security and role-based access control security to allow only authorized users to execute administrative functions
8. Provide centralized, user-friendly user interface for logging configuration
9. Audit and monitor Oracle E-Business Suite service operations from native SOA Monitor

Below is the SOA ISG Architecture: