EXPLORE ORACLE FUSION MIDDLEWARE

In this post I will explain you how to generate a unique Id in XSLT. To Generate a unique id in XSLT use oraext:generate-guid() function. See below screen shot to generate unique id in XSLT : Result of XSLT : The function oraext:generate-guid() has generated a unique Id as 2d333136303937343532313436323038. Similarly for each run this function will generate different unique Ids.

There are scenarios when we want to complete commit or complete rollback. This is known as transaction handling. To demonstrate this scenario I am taking following use case. Use Case : Read a file and insert data into Header and Line tables. Data must be inserted into both the tables or it should be complete roll back in case of any exception. Lets start the use case : 1. Drag a file adapter in the Exposed Services. Configure it to read a file from Local directory. For more details to configure a FTP adapter, please go through my previous block : http://exploreofm.blogspot.in/2015/09/soa-12c-how-to-read-file-using-file.html 2. Configure two database adapters to insert data into header and line tables. 3. Create a BPEL process and wire it to the FTP adapter and database adapter. After wiring it your composite should look like as below : 4. Add invoke activity and other assign activity to complete BPEL process. Deploy the service to em co...

In this post I will explain you how to install Oracle SOA Suite 12c. Download latest version of SOA 12c from oracle OTN. Download java 7 and install it to your machine If you don't have java 7 installed, your can download it from below path http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html The further installation is shown in Windows OS. You need to create a JAVA_HOME environment variable. Follow the below path to set JAVA_HOME : Click on Advanced System Settings, go to Advance tab and click on  Environment Variables. Click on New under User Variables. Click ok and Save it. Now java 1.7 has been setup in your machine. We are ready to install JDeveloper 12c. Unzip fmw_12.1.3.0.0_soaqs_Disk1_1of1.zip file which you have downloaded from OTN. Now open a command prompt as a administrator Navigate to the installation folder and run command " %JAVA_HOME%\bin\java -jar fmw_12.1...

In this post I will explain how to read, delete, and archive a file from any location. This post will also explain reading content of file in 12c and configuration of NXSD (Native Format Builder). This post can be applicable for SOA 11g also. File Adapter Configuration : Drag File Adapter to Exposed Services section : Enter file adapter JNDI Name File Adapter have multiple operations read, write, sync and chunked read operations. Here we are using read operation. Enter file source and archive location. If you don't want to archive any file, uncheck the Archive check box. Specify File name pattern to read files based on any pattern. Set Polling frequency. Polling frequency is the interval in which adapter will read the file from the particular location. Now we need to define an NXSD schema, to convert the file data to XML f...

In this blog I will walk  you  through from the new features of OSB 12c as well as the difference between OSB 11g and 12c. Following are the differences between OSB 11g and 12c : In the new version Oracle Service Bus (OSB) is renamed as Service Bus. Eclipse tool is needed to develop an interface in OSB 11g where as JDeveloper tool is needed to develop an interface in OSB 12c.  Oracle has integrated OSB 12c with JDeveloper. Now there is no need of Eclipse to develop an interface in 12c. Graphical representation of OSB components are similar to SOA BPEL components. Pipeline is separated from proxy service and it is separate component in 12c. To perform operations on database, ftp and files, it is no longer required to configure adapters in JDeveloper and copy it to Eclipse, because OSB 12c service is developed using JDeveloper only.

Introduction: Java Callout activity is used to call custom java methods from proxy services in OSB.  For this it is needed to create a POJO ( Plain Old Java Object ) class and create different methods.  The java methods which you want to call from proxy services must be static. Following data types are supported as method parameters: String Primitive types, and their corresponding class types  BigDecimal  BigInteger  XmlObject  Single array type of above data types javax.activation.DataSource   Following return types are supported from a java method: String Primitive types, and their corresponding class types  XmlObject Note: void is not supported as a return type. How to use Java Callout in OSB: Follow the below steps to use a Java Callout in proxy services in OSB: [ Note: The steps shown below are performed in Eclipse IDE] Step-1: Create a POJO class and a method as shown below : ...