While working on one of the clients assignment, we developed this simple proof-of-concept to illustrates how easy it is to integrate Oracle Applications with BPEL
The process flow
This BPEL service accepts user values from ADF web application and passes them to HR_EMPLOYEE_API.CREATE_EMPLOYEE API using BPEL Oracle Applications adaptor [and not by calling DB package surpassing Function Security]. The values returned by the API are displayed to the user.
BPEL process
The BPEL process utilizes iRep repository to browse all the available Oracle Apps services. In Release 12, the Oracle Integration Repository is shipped as part of the E-Business Suite. R11 instances can be patched to achieve the same.
Refer http://irep.oracle.com/ for details
Browsing iRep repository
Once BPEL process is ready, the next step was to integrate this with a web application which will invoke this BPEL process. To achieve the same, we created a simple data entry ADF page utilizing ADF Data Control component.
On successful creation of an employee record in EBS, user is shows the next page [This page essentially contains the values of OUT parameters from CREATE_EMPLOYEE API]
Note: This is a synchronous integration of a web application with EBS API using BPEL as a broker. The application can be configured to show or hide various values, accept default parameters or call any other EBS API
