Fusion Blog

EBS Blog


Contact Us

Prasad Bhogle
  • 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: 4 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Inactive

Getting Comfortable with Oracle SOA Suite

Before starting this white paper let me tell you that I am also like you (readers) who are from the world of Oracle, PLSQL, Oracle E-Business Suite work areas who is trying to get comfortable with the upcoming technologies related to Service Oriented Architecture. I am not an expert in SOA arena. I am going to try to put things in simple terms. Some of you will differ with my opinion of starting developments related to ESB/BPEL without fully understanding the concept but I think this can also be one way of getting to the debth of the subject by actually developing it.

For Oracle Apps folks I would suggest, just start thinking about Oracle Workflow. All things which you can do using workflow can be done using BPEL and interfaces using (FTP/Shell Script/PLSQL) can be built using ESB.
I will be using Oracle SOA Suite and Oracle JDeveloper software for demos/screen shots.

Defining Acronym Jargons in SOA world

When we enter the world of Service Oriented Architecture we come across various acronyms viz. XML, SOA, ESB, BPEL, WSDL, XSLT, SOAP, XSD, DTD etc. Let’s define each of them.

XML is the eXtensible Markup Language accepted by the industry as ideal vehicle for sharing structured data among applications and organizations. XML is becoming universally understood, many applications provide inputs and outputs in XML. XML makes data self describing. XML eliminates fixed formats.

XSD (XML Schema Definition), a Recommendation of the World Wide Web Consortium (W3C), specifies how to formally describe the elements in an Extensible Markup Language (XML) document.

DTD is Document Type Definition which is again one of the industry accepted way of defining XML structure.

WSDL (Web Service Definition Language) is an XML format for describing network services as a set of endpoints operating on messages containing either document-oriented or procedure-oriented information. The operations and messages are described abstractly, and then bound to a concrete network protocol and message format to define an endpoint. Related concrete endpoints are combined into abstract endpoints (services).

SOAP (Simple Object Access Protocol) a message-based protocol based on XML for accessing services on the Web.

SOA A service-oriented architecture is essentially a collection of services. These services communicate with each other. The communication can involve either simple data passing or it could involve two or more services coordinating some activity. Some means of connecting services to each other is needed.

ESB is an open standards-based distributed synchronous or asynchronous messaging middleware that provides secure interoperability between enterprise applications via XML, Web services interfaces and standardized rules-based routing of documents.

BPEL (Business Process Execution Language) for Web services is an XML-based language designed to enable task-sharing for a distributed computing or grid computing environment - even across multiple organizations - using a combination of Web services.

Installing Oracle SOA Suite

Download SOA Suite installable soa_windows_x86_101310_disk1.zip from oracle.com. Unzip the file in C:\OracleSOAInstall and run setup.exe. During installation you will get two options viz. Basic Install and Advanced Installation. Generally SOA Suite needs a database for installation. If Basic installation is selected then it automatically installs Oracle Database Lite on the machine while Advanced Installation needs Oracle Database 10G ( or higher). For advanced installation, oracle database needs to have following schemas ORAESB, ORABPEL and ORAWSM.

Basic installation installs following components

· Oracle Containers for J2EE

· Oracle SOA Suite including Oracle BPEL Process Manager, Oracle Enterprise Service Bus (ESB), Oracle Web Services Manager (OWSM), and Oracle Business Rules.

· Oracle Enterprise Manager 10g Application Server Control

· Oracle Process Manager and Notification Server

· OC4J Java Single Sign-On

Advanced installation includes all the above components along with Oracle HTTP Server with SSL Support.

I would suggest not going for advanced installation if you are installing Windows XP Professional desktop/laptop because I always found issues Oracle Web Services Manager and Oracle BPEL manager during advanced installation. Using Basic installation as well at the Oracle BPEL Process Manager fails to configure at the end of installation but without exiting installation screen you can restart SOA Suite using windows start menu and retry BPEL process manager configuration.

During installation please make a note of Application Server Instance Name (e.g. SOA_AS) and administrator username oc4jadmin and password. This will be needed all the time for login on to Application Server Console, BPEL Console, ESB Console and WSM Console.

After Basic installation, application server is accessible at URL http://localhost:8888 or http://<machine>:<port> where you will find all the links to BPEL Process Manager, Web Services Manager Console and ESB Console.

Application Service Control

  • Click on Application Server Control, enter username (oc4jadmin) and password and make sure all services are running. If any of the service status is down then you can start the service by clicking start button.
  • Click on HomeàApplications to which displays list of all applications.
  • Click on Web Services Link to display all deployed web services


Configuring the Container

Once you install Oracle SOA Suite, you need to create a connection pool, data source, and database adapter, Oracle Applications Adaptor

  1. Point your browser to the Enterprise Manager for your installation of Oracle SOA Suite using URL http://<machine>:<port> e.g. http://localhost:8888
  2. From the right-hand side Manage Your SOA Suite portlet, click the Application Server Control link. The Application Server Control Console displays the administrator logon dialog box.
  3. Enter oc4jadmin as username and its password

Connection Pool and Data Source

  1. Create a connection pool and JDBC data source for the OC4J instance. Data source is used to get a connection to a database server. You must define one connection pool and its connection factory.
    1. Select the home OC4J link, which takes you to OC4J home page
    2. Click on Administration Link



    1. In Services > JDBC Resources, click the Go To Task icon to navigate to JDBC Resources page



    1. In the Connection Pools section, click the Create button to navigate to connection pool navigation page


    1. Accept defaults, and click Continue.
    2. Enter the connection pool name, Database SID, User Name password etc.



    1. Test the connection. If connection is successful then click finish
    2. Under Data Sources, click Create (Similar to Step c) and navigate to Create Data Sources screen. Accept default and click continue
    1. Enter values for Data Source Name and JNDI Location (Please note this JNDI name should be used same as JDNI Name while using DB adaptor in Oracle JDeveloper)
    2. Click Finish to complete Creation of data source
    3. Create a similar Data Source using APPS username for connecting to Oracle E-Business Suite Database. This data source will be used for creating Database Adaptor and Apps Adaptor


Adaptors in SOA Suite

In SOA world, systems talk to each other through various adaptors. In the context of an SOA an adapter is an intermediary service that bridges incompatible data formats between services and its clients. An adapter often also acts as a façade or technology gateway. Oracle SOA suite is shipped with various such adaptors given in following screenshot


In this article we will take a look at how to setup DbAdaptor, AppsAdaptor, File Adaptor and FTP Adaptor

Database Adaptor

  1. In Application Server Console, click on OC4J: home-->Applications
  2. Click on Default Application to arrive at screen displayed above
  3. Click DbAdaptor link and then click connection factories link
  4. Click Create Button to create connection factory. Click Continue
  5. Specify Connection Factory JNDI Name and most important xADataSourceName same as Data Source JNDI Name created few steps before i.e. eis/DB/APPS_SOADB



Oracle Applications Adaptor
  1. In Application Server Console, click on OC4J: home-->Applications
  2. Click on Default Application to arrive at screen displayed above
  3. Click AppsAdaptor link and then click connection factories link
  4. Click Create Button to create connection factory. Click Continue


  1. Specify Connection Factory JNDI Name and most important xADataSourceName same as Data Source JNDI Name created few steps before i.e eis/DB/APPS_SOADB


File Adaptor

File adaptors is already setup with default installation and can be used as it is while developing ESB or BPEL applications. For File Adaptor the JNDI location is eis/FileAdapter which can be used for writing files at any location on machine hosting Oracle SOA Suite

FTP Adaptor

FTP Adaptors can be created for each destination machine by setting up configuration properties needed for FTP process.


This much knowledge of configuring Oracle SOA Suite is sufficient to start developing applications based on ESB and BPEL. In the next article we will take an overview of Oracle JDeveloper and various services, Process Activities involved in developing ESB and BPEL projects.

Prasad Bhogle


0 #1 rashmitushars 2008-08-31 17:41
hi ,
Nice blog and good effort to summerize all thing in one article.
I too workingon SOA , got following doubts.
I am using partner in my BPEL project.which I have to modify very time I install it to new Environment.
Is ther any way to Dyanamically doing it.
I heard of runtime path in partner link.Can we use that to specify host name and
port number of runnable env. by defining any JNDI or dvm type thing.
Let me know if yu know any answer...
0 #2 Sudheer Kannu 2009-03-11 03:29
Prasad, I am not really sure this is the right place to ask this question. But hopefully you might have something in your armour to help me out.

I would like to manipulate the Endpoint property of an ESB Service (SOAP Service/Routing Service/Adapter Service)??

My requirement is to configure an inbound File/FTP adapter to read from a Directory which can be known only at runtime. I guess one way possible is, you configure a File/FTP Adapter with a logical name for directory and set the physical directory path using the endpoint property. But in that case, I should know the Physical directory @ deployment time.

So is there any way to get the enpoint property configured during runtime???

Any help would be appreciated.

- Sudheer
0 #3 I 2009-07-14 04:33
I am not able to see the images.Nor I a am able to download the document
0 #4 Anil Passi- 2009-07-14 16:22
It appears that http://docs.google.com is blocked at your place.

Please can you check if that site is accessible by you
0 #5 OFemi 2009-08-06 11:28
When I click on PDF version of this document, I get error message:
TCPDF error: Unsupported image type: com/file?id=dng zc3b_101dkhwwqg 6_b
0 #6 Mousa Asmaran 2009-12-22 14:17

I have big problem. when deployed jsps on oc4j set one jsp in one war
i need include jsps to don't write code java on every jsp

0 #7 sailesh 2009-12-28 06:53
good one
0 #8 JAHNAVI 2010-02-20 13:58
Hi when i was trying to test connection pool i am getting the following error

Unable to establish connection. Error message: Exception occurred testing connection. Exception: java.sql.SQLExc eption: Io exception: The Network Adapter could not establish the connection.
0 #9 siram.vinod kumar 2010-09-07 06:58
please give me detais on increasing heap size of jvm,........... .....
0 #10 cheap jordans 2010-12-16 20:13
Shafts of sunlight filtered through the curtains !
0 #11 NHL Jerseys 2011-06-13 02:49
good,I like this post.
0 #12 brij 2011-07-14 09:39
Can you also provide us the installation of AIA?
if you have done successfully.

0 #13 Jayne20Paul 2011-09-19 22:02
I had got a desire to begin my commerce, nevertheless I didn't have enough of money to do that. Thank God my colleague told to utilize the business loans. Thus I took the college loan and realized my desire.
0 #14 how to make 100 2014-04-21 19:36
Hi I am so delighted I found your weblog, I really found
you by error, while I was researching on Google for something else,
Nonetheless I am here now and would just like to say cheers
for a incredible post and a all round thrilling blog (I also love the theme/design), I don’t have time to read through
it all at the minute but I have bookmarked it and also added in your RSS feeds, so
when I have time I will be back to read a lot more, Please do keep up the excellent jo.

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

Related Items

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner