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 3rd 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):
- Display all Oracle E-Business Suite integration interface definitions through Oracle Integration Repository
- Support custom integration interfaces from Oracle Integration Repository
- Provide service enablement capability (REST services) for seeded and custom integration interfaces within Oracle E-Business Suite
- Use the Integration Repository user interface to perform design-time activities such as generate and deploy Oracle E-Business Suite Web services
- Support synchronous interaction pattern for REST-based Web services
- Support multiple authentication types for inbound service requests in securing Web service content
- Enforce function security and role-based access control security to allow only authorized users to execute administrative functions
- Provide centralized, user-friendly user interface for logging configuration
- Audit and monitor Oracle E-Business Suite service operations from native SOA Monitor
Below is the SOA ISG Architecture:
Credits
- This tutorial is independently created and is not official Oracle Corporation documentation.
- The content of this tutorial has been enriched by leveraging the insights and documentation available from Oracle Corporation. We extend our thanks to Oracle for their dedication to knowledge sharing. For official Oracle resources and additional information, please refer to www.oracle.com.
