Fusion Blog

EBS Blog


Contact Us

  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
In real life, a bus makes people travel. A bus helps people reach from one place to another. In similar way, ESB facilitates messages/data to move from one system to another.
Note:- This article is my understanding of how Oracle ESB could add value to your business, hence this is not a statement of direction of product.
A real life bus does not discriminate between the race, cast or the age of the person, all the passengers and their luggage is classified as physical entity that can be carried from one place to another.
Similarly, an ESB does not discriminate between different type of systems that wish to send or receive messages, regardless of whether their interfaces are file based(csv etc), xml based or database tables, or message driven. It means a bus can receive data in any/most formats/technologies.

Having said so, a real life bus doesn't transform its passengers, but in case of ESB, it can transform the message format from one format to another. Accordingly, you can say that ESB provides some additional services in comparison to a real life bus.

The real life bus operates on a route, similarly ESB has its own boundaries, which is the enterprise. All internal systems within enterprise and external systems(trading partners) can connect to ESB server(subject to firewall & security etc), in order to send and receive messages.

So, now we know that ESB, is a bus, that provides services and it operates at enterprise level. Lets do some common Q&A.

I find BPEL and ESB to be confusing and overlapping in functionalities, as to where they fit in?
Lets look at the current model in Oracle EBS, whereby documents are sent and received via XML Gateway.
Following happens currently in Apps World
  1. Your trading partner posts a payables invoice - to XML Gateway Server [using one of the supported protocols]
  2. XML Gateway transforms the message using XML Message Map[this tool is proprietary technology]
  3. Invoice is then loaded using api and approved with help of Oracle Workflow
In my opinion, steps 1 &2 above fit into ESB layer, whereas step 3 will fit into BPEL.

Still some Confusion?
Nothing stops you to achieve all the steps 1,2 &3 in BPEL itself. For example, you can have a bpel process in which the first step publishes a WSDL[service] to which payables invoices can be posted. However, BPEL is heavyweight and ESB is lightweight. Think of it with current mindset, would you use Oracle Workflows to merely send a message from one system to another?. Hence we need to recognise how ESB and BPEL can compliment one another.

Isn't it a tedious process to define message mappings between two message formats? Can't we simply write program to transform formats?
Its not tedious when done with Oracle ESB. If you design all your systems to use a common naming convention, then most of the mappings can be generated automatically. What impressed about Oracle ESB was that automated mapping in Oracle ESB works at nested level too.

So lets see how Oracle ESB may integrate with fusion applications:-
1. System A and system b will not exchange data directly. This will happen via ESB. For example A-->ESB-->B
2. Transformation of messages will happen within ESB
3. As of today's date, there is no publish-subscription model in ESB(may be I am mistaken). But one can hope that Oracle will integrate its current Business Event/Subscriptions within ESB layer.
4. The current widespread practice of writing message transformation routines in PL/SQL will become a thing of past. Why program it when the tool does this for you. Hence all XML message maps(thoseXGM files of xml gateway) will be replaced by routing rules/mappings of Oracle ESB.

What will not happen in ESB?
1. Just as we think ESB will replace XML Gateway, it appears obvious that BPEL will replace Oracle Workflow. Hence approval processes will be designed in BPEL.
2. Although ESB will still be used to integrate point-to-point services,but service orchestrations will happen in BPEL. Which means, if you have a process that involves various different services to be integrated within a business process, then BPEL will be used to design and implement such process.

BPEL and ESB overlap is still confusing, can we have some example where both ESB and BPEL fit together?
Lets take a scenario, whereby a new employee joins
1. You have Oracle HRMS, whereby a person joins your Organization
2. A business event is raised and a message of employee information is transmitted to the ESB Server.
3. ESB transmits the message to different systems within enterprise, like computer network security, mail server, gate-security(for security pass), restaurant discount system etc. Just making the other systems aware of a message can be done within ESB, as all we are doing is transmitting the message securely over enterprise bus.
4. This ESB process, could also integrate with a BPEL process which will coordinate the following
     A. This person gets registered on the purchasing system for say approval limits. If required, their GL Security codes could also be set.
     B. Consumes the service of pension department
     C. Manages/approves security card access to certain buildings/areas within organization.
     D. Registers the individual with company's benefits like accidental insurance policies and health insurance. Approval process can be in place to define and approve the levels for insurance cover.

As you can see, a persons termination could also involve various different systems within the enterprise.

A question on this scenario. Big deal, all this can be co-ordinated by Oracle Workflow notification process.
Well, not really. At the best it can send notifications, receive responses, update oracle tables, raise events, and may be even update different systems via java stored procedures.But there won't be much visibility as integration with other systems is limited.
This is where BPEL fits in, as it can interact with all the different systems using web-services, which are open standard. Once a web-service is consumed, it then becomes headache of the third party system to either use JDBC or PL/SQL or COBOL or whatever to amend their system.

Well, this works only if all the other systems are service enabled?
True to an extent, but remember ESB provides different adaptors. Just having an ESB/BPEL may not be enough to service enable your Enterprise.
But in ideal world, enterprises should be moving to service enable all their systems for easy integration with the bus.

Anil Passi


0 #1 Harshad 2007-11-16 16:53
Having read your article, does it mean it can replace Workflow ? I assume not, but have heard many times from people that Workflow will be replaced by BPEL. Also under Oracle Application Suite, what will drive to use BPEL web services over other PL-SQL web services.

Your help will be appreciated.

H arshad
0 #2 sumo 2008-03-10 06:29
hi Anil,
It's a good material .
I ahve one dobut there are many Oracle BI are for reorting structurelike
BI Publisher , Data Integrator , Reports Services ,
Business Intelligence , Business Activity Monitoring and Hyperion Essbase
Out of these which will bw used for Oracle Fusion.
Thank you.

out of them
0 #3 Amarendra Joshi 2010-03-11 04:51
Hi Anil,

Very nice article. The best part is you co related the actual day today life and the techology nicely.
Keep it up.

Am ar
0 #4 Jayant R Dhavale 2010-04-28 00:10
Hi Anil,

Iam new to ESB.i want to create a simple ESB process.

can you help me by giving a simple example like reading from file
and inserting into database.

than ks
0 #5 Vedprakash Kamishetty 2012-10-12 04:04
Hi Anil,

Very good Article and very good knowledge to share.

But Following are my comments on the Replacement of BPEL for WorkFlow

Workf lows basically used inside an application to have the internal system interaction designed. A BPEL Engine iis a super set and lies outside the application boundaries and inside the Enterprise Application Suite. BPEL Engine is more capable of doing the things than Workflow.

Work flow suites and performs better if it is within the application boundaries
BPEL Suites outside the application boundary and within Enterprise Application Architecture and its Capabilities will definetly act as Accelerator in orchestration of the process.

Big Debates can go around in supporting BPEL but it is perception and Architecture point of view

Thanks & Regards,

Add comment

Security code

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  2  3  4  5  6  7  8

Enquire For Training

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner