Peeyush Tugnawat

Subscribe to Peeyush Tugnawat feed
Oracle Blogs
Updated: 1 month 5 days ago

FOTY0001: type error

Fri, 2009-02-27 08:05

If you are using Cross References (using xref:lookupXRef1M) function in your integration processes (BPEL/ESB) and ever come across the following error

"XPath expression failed to execute.

Error while processing xpath expression, the expression is

Please verify the xpath query."


This exception can occur because of the following reasons:

  • The cross reference table with the given name is not found

  • The specified column names are not found

  • The specified reference value is empty

  • Multiple values are found

Oracle Technology Network (OTN) TechBlog

Tue, 2009-02-24 14:03

If you have not checked out the OTN TechBlog already, I would like to share this great resource blog from Justin Kestelyn. He is the OTN Editor-in-Chief.

Here is the link to his blog


Add to Technorati Favorites

Oracle Technology Network (OTN) TechBlog

Tue, 2009-02-24 14:03

If you have not checked out the OTN TechBlog already, I would like to share this great resource blog from Justin Kestelyn. He is the OTN Editor-in-Chief.

Here is the link to his blog



Add to Technorati Favorites

Best Practices: SOA and Enterprise Applications

Sat, 2009-02-21 14:14

Oracle Fusion Middleware Best Practice Centers for Applications are great reference sources for information on Service Oriented Architecture for Enterprise Applications.

Following are the links to pages for each application:

Best Practice Center: Oracle E-Business Suite and Fusion Middleware

Best Practice Center: Oracle Siebel and Fusion Middleware

Best Practice Center: Oracle PeopleSoft and Fusion Middleware

Best Practice Center: Oracle JD Edwards and Fusion Middleware

I am also a contributor and so far have shared my experiences at Best Practice Center: Oracle E-Business Suite and Fusion Middleware. This blog is also listed there.

There is wealth of information available on these centers and comes from experts in their fields. Highly recommended!


Add to Technorati Favorites

Best Practices: SOA and Enterprise Applications

Sat, 2009-02-21 14:14

Oracle Fusion Middleware Best Practice Centers for Applications are great reference sources for information on Service Oriented Architecture for Enterprise Applications.

Following are the links to pages for each application:

Best Practice Center: Oracle E-Business Suite and Fusion Middleware

Best Practice Center: Oracle Siebel and Fusion Middleware

Best Practice Center: Oracle PeopleSoft and Fusion Middleware

Best Practice Center: Oracle JD Edwards and Fusion Middleware


I am also a contributor and so far have shared my experiences at Best Practice Center: Oracle E-Business Suite and Fusion Middleware. This blog is also listed there.

There is wealth of information available on these centers and comes from experts in their fields. Highly recommended!


Add to Technorati Favorites


Fri, 2009-02-20 16:14

Cloud Computing

Sun, 2009-02-08 08:54

  What is Cloud Computing?

Try searching for "cloud computing" in google and you get 16,200,000 results.


There is lot of interest about Cloud Computing and what it means as it applies to different aspects of computing paradigm. It is more than just Software as a Service (SaaS), which relates to hosted on-demand delivery of applications.

Based on my understanding, Cloud Computing is about applications, platform, infrastructure, and storage resources being available as services.

There are many interesting discussions about what it is and what should be the definition of "Cloud".

Instead of trying to coin yet another definition of "Cloud", I tried to find a somewhat formal but plausible definition. This is the closest one I found. It is from an article published in ACM SIGCOMM Computer Communication Review 

"Clouds are a large pool of easily usable and accessible virtualized resources (such as hardware, development platforms and/or services). These resources can be dynamically re-configured to adjust to a variable load (scale), allowing also for an optimum resource utilization. This pool of resources is typically exploited by a pay-per-use model in which guarantees are offered by the Infrastructure Provider by means of customized SLAs."

"A Break in the Clouds: Towards a Cloud Definition", Luis M. Vaquero, Luis Rodero-Merino , Juan Caceres, Maik Lindner, ACM SIGCOMM Computer Communication Review 50 Volume 39, Number 1, January 2009

  Oracle and Cloud Computing

Visit Oracle Cloud Computing Center to learn about Oracle's offering that allow enterprises to benefit from the developments taking place in the area of Cloud Computing.

Searching BPEL process instances by business keys

Fri, 2009-02-06 03:37

Out of the Box Search Capabilities

BPEL Console provides several out of the box features for searching the process instances using multiple search criteria. Following are the main search criteria that can be used within BPEL console



All the above are very powerful features for process administration. Enterprise Integrations and Support

Enterprise integrations deal with business data and transactions. These integrations often have interactions between multiple layers. In case of a failed transaction at any layer, the support function personals can spend a great deal of time and energy on finding the issue and troubleshooting it. I wrote about this in one of my previous post "Service Oriented approach for ERP integration".

Now imagine a use case where thousands of messages are being processed every minute. Searching by some of the default criteria’s can result in multiple search results.

Lets take an example. Custom Search Requirement Example

Lets assume that there is a BPEL process that processes orders in Oracle E-Business Suite. The order details are coming from an external application that is used by end users which in turn publishes to a JMS queue. The BPEL process picks up from the JMS queue and creates an Order in the EBS with the Order Number that comes from the message.

In the above example, if the end application does not receive an order confirmation, you can imagine there can be many reasons for that. One of them could be that the bpel process instance failed for some reason.

When it comes to tracking that order, the end application support will most likely call the support and mention that for this particular order (along with some sort of business key like the order number) there was no confirmation received.

In a production environment, there may be thousands of process instances. For our bpel support person to browse through the instances just by time can also take some time. But for him to be able to search the process instance by using a business key can prove to be extremely useful.

So the question from business user and administrator becomes Can I search by Order Number?

The answer is YES. Is there a simple way to do it?

Any one who has worked with application integration can relate to it and would agree with it. Now the question is Is there a simple way to do it?”

The answer is YES. Let’s Do It

Let's build one simple bpel process from scratch and find out how can we achieve this highly desirable functionality Step 1

Right Click on your application and select “New Project” option

Select BPEL Process Project


  Step 2Name the process “SearchableUsingCustomKeyProcess

ScreenShot128 Step 3

For simplicity we will proceed with the default option

ScreenShot129 Step 4

So now we have a skeleton asynchronous BPEL process


  Step 5

Click on SearchableUsingCustomKeyProcess.xsd




Change the name of the input to orderNumber



Step 6

Drag and drop a Java Embedding activity from the Process Activities drop down on right hand side

Name it “JavaEmbeddingToSetProcessTitle”



Step 7

Double click Java Embedding you just added

Add the following code




Step 7

Deploy the process on server

Step 8

Initiate the process from BPEL console with “1001” as input to the orderNumber field

Notice the instance title is different than the process name. This is because of the setTitle statement in our Java Embedding.



Click on Audit Flow and then on the Java activity to make sure that the instance ran without any errors



Step 10

Let’s see if we can search by our custom field (order number) that we want to search for out of many bpel process intances in the console

Click on Instances

Now put the following into the Title field under Locate Instances and click “Go”

“OrderEntryBPELProcess - OrderNumber:1001”


Notice how we are able to search for our particular order number (1001).


You can search for other order numbers easily by just replacing the end of the string with the order number. For example searching for the following string within the title field will search for order number “2001”

“OrderEntryBPELProcess - OrderNumber:2001”


Requirements related to searching for a process instance in BPEL console by using a custom field could be addressed by the approach demonstrated in this post.

This example demonstrates that it can be done and it can be done easily.

Java Embedding in BPEL Process

Fri, 2009-01-30 14:34

If you have a Java embedding in your BPEL process and have ever wondered where (if not domain.log) the output is written to if you do something like

System.out.println statement from your code within the java embedding

The  output gets written to the file under <soa_suite / oas_install_home>/opmn/logs/default*.log

Siebel Record Locking with Web Services

Tue, 2009-01-27 16:03


Error: "The selected record has been modified by another user since it was retrieved"

Reason: The reason we were getting this error in our case was because of the custom scripts. Execution of custom scripts on the Business Components was slowing down the WriteRecord process. This was resulting in the record locking issue.

One way to know if custom scripts are causing this error is to disable all custom scripts (if any) and then try to run the web service to check if you still run into the same error. If yes, following references might help.


Related References:

Troubleshooting Workflow Process Execution Problems

Defining an Error Exception to Handle an Update Conflict


Tue, 2009-01-27 16:01

I was getting this error when trying to deploy or compile a bpel project

[Error ORABPEL-10902]: compilation failed
[Description]: in "bpel.xml", XML parsing failed because "undefined part element.
In WSDL at

Please make sure the spelling of the element QName is correct and the WSDL import is complete.
[Potential fix]: n/a.


The problem was that the within my wsdl file the schema definition included an import statement and the schemaLocation attribute was not pointing to correct path

<xsd:schema xmlns:xsd="">
    <xsd:import namespace="something" schemaLocation="http://something:someport/MyXSD.xsd"/>

Once this was changed to correct url, the error went away.

Siebel Web Service Invocation Error

Mon, 2008-07-07 10:05

Issue: Error code: SBL-EAI-04313 while invoking a Sibel Web Service from BPEL.

Error Details:

“There is no active Web Service with operation named ''.(SBL-EAI-04313”

   <siebelf:siebdetail xmlns:siebelf="" xmlns:SOAP-ENV="">
      <siebelf:logfilename xmlns:siebelf="" xmlns:SOAP-ENV="">EAIObjMgr_enu_0024_25165939.log</siebelf:logfilename>
      <siebelf:errorstack xmlns:siebelf="" xmlns:SOAP-ENV="">
         <siebelf:error xmlns:siebelf="" xmlns:SOAP-ENV="">
            <siebelf:errorcode xmlns:siebelf="" xmlns:SOAP-ENV="">SBL-EAI-04313</siebelf:errorcode>
            <siebelf:errorsymbol xmlns:siebelf="" xmlns:SOAP-ENV="">IDS_EAI_WS_OP_NOT_FOUND</siebelf:errorsymbol>
            <siebelf:errormsg xmlns:siebelf="" xmlns:SOAP-ENV="">There is no active Web Service with operation named ''.(SBL-EAI-04313)</siebelf:errormsg>


I was able to resolve this issue by doing the the following:

1. Login to Siebel

2. Browse to Administration - Web Services

3. Within Siebel WS Administration, make sure that the status of WS is ‘Active’


4. Make sure that the Binding is set to SOAP_DOC_LITERAL


5. and finally Clear the Cache by clicking the “Clear Cache” button


Service enable integration business services using Oracle Application adapter

Fri, 2008-03-28 07:22


To make the business service within E-Business Suite participate in your service oriented integration architecture as a web services. The integration approach used depends upon the requirements and the integration mechanism that is best suited to satisfy the requirements. To use one of the integration function in a SOA based solution (integration or composite process) is relatively simple with the help of Oracle Applications adapter by exposing them as web services. This enhances re-usability, extensibility, and faster design to deploy time frame.

Using EBS adapter has tremendous advantages. It exposes existing EBS Integration Interfaces as Web Services. The adapter inherently uses and leverages open standards, including J2CA, XML, WSIF, WSIL, and WSDL. Most importantly it dramatically reduces the time to design and develop a SOA based integration that interfaces with web service based integration interface for EBS.
Bookmark and Share

E-Business Suite Integration: Using Irep to discover available business services

Thu, 2008-03-27 10:40

Bookmark and Share

To plan your soa based integrations, the architects and business users need to know what services are available within ebs that can be leveraged to be a part of your information integration, business process integration or coming up with composite application spanning across enterprise silos.

The first step when planning and designing your integrations should be to use Oracle Irep. This will give you the details of the business services available within EBS and also the details of service end-points. IRep lets users easily discover the appropriate business service interface for integration with any system, application, or business partner.

It is a pre-built central catalog of information about the numerous public integration interfaces delivered with Oracle applications, known as business interfaces.

The key advantages of using Irep are

  • Helps in better integration planning by providing information to make informed decisions

  • Acts as single source of truth for the available business servicesEnhanced re-use of existing components

  • Assurance that you are using supported public interfaces

    Using Irep

    Go to

    If you are working on EBS R12: From the Navigator menu, select the Integration Repository responsibility, then click the Integration Repository link that appears.

    Browse IRep : You can browse Irep using the categories of product or by the integration standards you wish to leverage.


    Search IRep: IRep also lets you search using various search parameters. You can search by interface name, internal name, product family, interface type (concurrent program, web service, XML gateway map etc), product, and business entities.


    In Release 12, the Oracle Integration Repository will ship as part of the E-Business Suite. As your instance is patched, the repository will automatically be updated with content appropriate for the precise revisions of interfaces in your environment. But until Release 12 is available, you can explore an on-line version of the Integration Repository for the 11i10 version of E-Business applications.
    Bookmark and Share

  • E-Business Suite Integration Components

    Wed, 2008-03-26 05:14

    Bookmark and Share

    It is important to understand different integration components available within EBS to make informed decision about using one or more for your SOA integration project. Selecting one or more of them depends upon the requirements and the interaction pattern determined to be best fit for the service oriented architecture based integration.
    Following are the integration mechanisms available within e-Business suite.

    Oracle XML Gateway: E-Business Suite utilizes the Oracle Workflow Business Event System to support event-based XML message creation and consumption. It can consume events raised by the Oracle E-Business Suite and can subscribes to inbound events for processing. It can be leveraged for Business-to-Business (B2B) and Application-to-Application (A2A) integration scenarios. Majority of messages delivered with the Oracle E-Business Suite are mapped using the Open Application Group (OAG) standard.

    Business Events: The Oracle Workflow Business Event System is an application service that leverages the Oracle Advanced Queuing (AQ) infrastructure to communicate business events between systems. There are more than 1000 built in events with in EBS that can be leveraged for event-based integration of business processes.

    Concurrent Programs: A concurrent program is an instance of an execution file. Concurrent programs use a concurrent program executable to locate the correct execution file. Several concurrent programs may use the same execution file to perform their specific tasks, each having different parameter defaults.

    Interface Tables: Interface tables are intermediate tables into which the data is inserted first. Once the data gets inserted into the interface tables, the data is validated, and then transferred to the base tables. Base tables are real application tables that reside in the application database. The data that resides in the interface tables is transferred to the base tables using concurrent programs. Interface views provide a way to retrieve data from Oracle Applications. By using views, you can get synchronous data access to Oracle Applications.

    PL/SQL APIs: These are stored procedures that enable you to insert and update data in Oracle Applications.
    Oracle e-Commerce (EDI) Gateway: Oracle e-Commerce Gateway provides a common, standards-based approach for Electronic Data Interchange (EDI) integration between Oracle Applications and third party applications. It is the EDI integration enabler for Oracle Applications.

    Bookmark and Share

    Service Oriented approach for ERP Integration

    Wed, 2008-03-19 13:44

    Bookmark and Share

    Business Requirements: Seamless Information

    Today businesses are changing faster than ever. Business models are evolving and being transformed every day. There are greater expectations in terms of innovation, business performance, results, and effective use of resources. All this is putting greater pressure on the organizations to find new ways to streamline their processes and share information effectively and seamlessly. In other words businesses today need to be more flexible and responsive than ever before to their customers, suppliers, partners, vendors, and most importantly changing business models.
    As ERP systems are at the center of enterprise business model, they need to provide a way for the business processes to participate and collaborate with external applications, partners, and information. Enterprise applications are moving from being monolithic and self-contained to the being more and more flexible and collaborative.

    Whats Wrong with Traditional EAI?

    Traditional integration focused on solving some of the above-mentioned requirements by enabling data flow between silos and external applications. It helped to a certain extent but over the time the complexity and of the integrations started posing serious concerns. The issues were proprietary technology used for integrating applications was a gridlock and it was not easy to easily orchestrate business processes between the disparate applications using the traditional eai.
    What is Service Oriented Architecture?
    SOA as it relates to software paradigm is an agile architecture approach that is based on service-oriented principles of composition, abstraction, loose coupling, discoverability, and amalgamation. SOA inherently empowers scalability, evolution of services, interoperability, re-usability, and modularity.

    Do we need SOA based Integrations?

    Using SOA principles while designing application integrations results in SOA based application integration. Simplicity is desired for the traditional and complex world of integrations. Better and common sense approaches such as Service interactions and amalgamation supported by Open Standards should be enabled. SOA is needed for the following main reasons:

  • To provide seamless agility to business
  • To improve business process visibility
  • To simplify the current rigid and complex state of IT
  • To enhance efficiency and provide cost-effectiveness
  • To enable re-usability factor
  • To provide better quality of service

    But you are still doing integration?

    Yes. Besides the obvious advantages enumerated by everyone, the key advantage of this approach is that you are contributing to the future of the SOA of your enterprise. The integrations with service-oriented approach are loosely coupled with the infrastructure components and more flexible and refactorable. Logical end-points for integration services provide far more decoupling and is implementation agnostic. The components and integration services can be used for creating a composite application or business process later. The benefits of adopting SOA grow with time. Once you have these reusable components from across applications, application modules, and other enterprise software components, creating a new application is relatively easy and that�s when the full potential of SOA is realized.

    Design your SOA Integrations

    Most of the design depends on the requirements. But before applying the very same approach you took for your earlier integration project, you need to keep in mind is that the goal here is to come up with integration components that are designed for interoperability, re-usability, and modularity. The key to designing your SOA integrations is remembering that they are SOA based. Using and adopting SOA principles is the key. Always try to apply SOA principles composition, abstraction, loose coupling, discoverability, and amalgamation to your services and integrations.

    Architecture Perspective: Guidelines for SOA based Integrations

    Based on my experience, considering the following guidelines can help you realize the SOA vision for integrations with EBS. Most of the following guidelines are generic and can and have been applied to other ERP integrations as well.
    Use standards: Using standards based technologies for your service-oriented integrations will help eliminate lock-down with products and companies. This is one of the biggest challenges with traditional EAI. This will enhance easy evolution, enhancement, and composition of business processes that may use services related to integrations.

    Classify Integration Requirements:
    Categorize requirements into data integration and business process integration. Identify message exchange patterns and use ESB functions (transportation, mediation, and routing) to model data integration processes. Use BPEL for modeling your processes that involve anything more than what can be satisfied with ESB functions. Many times it is hard to classify and try to fit a particular integration process in one of the two buckets. In such cases it will be a good idea to use layered approach and use ESB functions for data integration and use BPEL for future extensions to the business integration process.

    Introduce Extensibility:
    To deliver on the high hopes for soa based integration architecture solution, it is very important to do some forward thinking for the desired flexibility and agility in your integration architecture. To deliver on that, think hard early on ways to introduce extensibility and forward compatibility into the architecture and all the components including individual integrations and messages.

    Service Enable Enterprise Application Functions:
    Enterprise applications have many business functions and technology components that are application specific and depend on proprietary technologies. These components or functions should be service enabled before they can participate in the service oriented integration architecture. Using resource adapters is a way of connecting and interacting with the application specific components. It is important that the resource adapter is implemented using industry standards such as J2CA, WSIF, and WSDL and can provide a web service interface to the application specific functions.

    Inject Resiliency:
    Build resiliency into the individual integration processes. This may be easy to miss as even with the best architecture in place. Always think about all the �what if� scenarios and try to inject process level resiliency into the individual integration processes.

    Exception Handling:
    Despite all the forward thinking there are things that might and will go wrong. Define reusable, extensible, and agile approach to handle exceptions at process level and other unknown exceptions. Using a common exception handler service with extensible interface can provide the flexibility, re-usability, and extensibility.

    Simplify Support Functions:
    Any one who has worked with application integration can relate to the great deal of time and energy waste involved when troubleshooting integration issues. With asynchronous messaging and multiple services, the idea should be to ease the pains of traditional EAI support functions. This can be done by thinking ahead about how can support functions be empowered with better ways to provide information visibility and take actions. Notifications and human work-flow are some of the ways to empower your support team.

    Human interaction and intervention:
    Business processes inevitably will involve human interaction in some or other form. If your integration process involves such role based people interaction, plan ahead and use standards based mechanisms to have human work-flows.

    Separate Business Rules:
    The integration process probably is not a good place to embed and hard codes the business rules. Identify the rules and provide loosely coupling between your process and rules. This would provide the flexibility to change business rules dynamically without modifying or redeploying your integration services or processes.

    Business Process Visibility:
    Plan for providing visibility into your so integration or business process. This is very important because today enterprises have heterogeneous systems and applications and with integrations spanning multiple systems, it becomes very hard to have visibility in run time. Users (IT and Business) should be able to monitor and have visibility into your business processes and integrations.

    Service Composition:
    Provide the capability to provide business functionality that is composed of disparate and/or independent services. The composite solution may cater to an integration solution or a new future business process. Service composite architecture is the relevant standard that addresses service composition. It provides the specifications to describe the model for building applications and systems using a Service-Oriented Architecture (SOA).

    SOA Governance:
    In simple terms, plan for the capability to manage and apply policies for the services within the service portfolio of your integration services. This is critical for SOA and needs to be planned well to ensure better management and control of services.


    Service oriented approach to enterprise integrations offers tremendous advantages over traditional EAI. Enterprise integrations can be converted into reusable and implementation agnostic useful services by applying very basic principles of flexibility, agility, and extensibility in all the components of service oriented integration architecture.

    Bookmark and Share

  • Oracle SOA Suite 11 g - Technology Preview

    Tue, 2008-01-22 06:59

    Get started with the new technology preview release of SOA Suite 11g!

    Refer to this link for details:

    Oracle SOA Suite 11 g - Technology Preview

    Exception Handling in BPEL

    Sun, 2007-06-03 14:47

    I did not realize that its been a while since I posted anything on my blog. Well we all get busy once in a while and that was the case with me as I got really busy with my current project. The good thing is I have few things to share that came out of my experience working with BPEL.

    For exception handling, I learned that the function called ora:getFaultAsString was missing from the bpel designer (10.1.3) and it was not returning the detailed information about the fault. There are two patches that can help on this issue 5672007 & 5841736.


    The Falcon Has Returned

    Wed, 2007-05-09 17:14

    The Falcon Has Returned
    This is a very interesting story about the endangered Falcon (Peregrine) that returned to Oracle for nesting.

    Read more here:
    Falcon Story at UC Santa Cruz

    And the best part is the live webcam of Saddie and her four newborn chicks at Oracle HQ
    Check it out here!

    Business Agility @ SOA

    Sun, 2007-05-06 17:41

    Bookmark and Share

    Business Agility @ Service Oriented ArchitectureWe live in a constantly changing world. Technology and businesses are changing, emerging, and improving at a faster pace than ever
    before. Business want the power to deliver products and services better and more
    efficiently, to be able to excel, capture new opportunities, and
    sustain competition. Technology innovation and improvements are striving to deliver on these requirements. From a business perspective, dynamics of such fast-changing world in terms of
    technology can be daunting in terms of time to market cost, maintenance, training, and support. Replacing or re-writing entire systems
    every time for new and improved functionalities is definitely a major concern.

    Is IT just an unavoidable cost?Arguments about IT being a cost are not rare in business
    world. There is no doubt in my mind that innovations in IT systems have
    propelled business abilities and enriched business processes in past years.
    Definitely, there is high business value gained from IT systems. At the same
    time organizations also have to deal with the "cost" components that
    come with IT systems such as maintenance, support, enhancements, training etc.

    The argument from my perspective, should not be about the
    classification of cost components, but how all the components and their
    interactions can be simplified to provide more value to the business.

    I think simplicity can help!Simplicity is highly desired in increasingly complex world
    on IT. Direct incentives of infusing simplicity in IT architecture are
    tremendous and do not require elaboration.

    Direct derivative of simplicity in IT architecture approach
    is Business Agility.

    Simply put, "Simple is Powerful"

    SOA translates to business agility. SOA is simple but very powerful architecture approach
    for complicated systems and problems of IT world.

    As I mentioned in my earlier post based on my experience,
    SOA as it relates to software paradigm is an agile architecture approach that
    is based on service-oriented principles of composition, abstraction, loose
    coupling, discoverability, and amalgamation. SOA inherently empowers
    scalability, evolution of services, interoperability, reusability, and

    Following diagram identifies high level concepts infused into SOA that help enhance business agility for an enterprise.

    Inherent InteroperabilitySOA empowers Inherent Interoperability between systems, business processes, and people (organizations).

    Re-usability Reusability factor in case of SOA is multi-fold because of standard based interfaces. Reusability is not new in software; what�s new is reusability across diverse systems, platform, and technologies. SOA components can be reused not only by the inherent system or technology but also by any system or process.

    Modularity and CompositionSOA encourages Modularity that enhances the concept of Composition. Composite applications can be build based on changing business requirements and rolled out faster with less cost.

    SOA Delivers
    SOA enables faster development turn-around time,
    faster realization of new inter and intra enterprise business processes, and
    cost effective maintenance and upgrades.

    All this translates to enhanced Business Agility. And
    I would like to call it.....

    Business Agility @ SOA

    Bookmark and Share