Integration of Oracle EBS with Siebel CRM, Mediator in Oracle BPEL, Integration of Two DBs

In this post i will show how to use Mediator in BPEL Process and Transformation of attributes. This post is part of my previous posts series. You should also go through previous posts to fully understand the scenario. Here is the link of previous post                              Inserting data using DB Adapter  lets start on Mediator and Transformation in BPEL Process. 1)...

Read More

Inserting data using DB Adapter in BPEL SOA Suite

In this Post i am going to show how to insert data using DB Adapter in SOA Suite. This is a integration of Oracle Apps with Siebel CRM. First i will show you how to configure DB Adapter to insert data in it. I have two tables master and detail. I will show you only master table insertion wizard, however this can be done in combine as well. You can also create relationship between table in DB Adapter but i am not going into much detail. Please...

Read More

Store Procedure invocation using BPEL Process in SOA Suite

In this post i will show you how to call and get Data using DB Adapter that we have developed previous post. You can check it out here Store Procedure with Out Parameter. In this Post we will develop a BPEL Process to Invoke this stored Procedure. 1) Drag and Drop a BPEL Process in component section. Following snaps shows how to do it. In input parameter select input parameter from XSD that is generated by your DB Adapter.  2) For...

Read More

Calling Stored Procedure in BPEL Process, Stored Procedure with Out Parameters

In this post i will show how to call a stored procedure with out parameters using DB Adapter. I have a package which consist of a procedure, this procedure has two output parameters one output parameter returns master data while the other return detail data. Actually i have created a table type structure which that is used to return bulk of data. Following are steps to call store procedure in SOA Suite. 1) Drag and Drop a Database Adapter...

Read More