{"id":1582,"date":"2011-04-17T12:36:06","date_gmt":"2011-04-17T12:36:06","guid":{"rendered":"http:\/\/sendyoursmiles.com\/articles\/bpel-file-adapter-tutorial"},"modified":"2014-12-09T06:24:20","modified_gmt":"2014-12-09T06:24:20","slug":"bpel-file-adapter-tutorial","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial","title":{"rendered":"BPEL File Adapter Tutorial"},"content":{"rendered":"<p><span style=\"text-decoration: underline;\">Overview:<\/span> In this tutorial I will explain how to read a CSV file using ReadFileAdapter and then to write a CSV file using WriteFileAdapter. We don&#8217;t have two separate FileAdapters but based on the read and write operation we mention them as ReadFileAdapter or WriteFileAdapter.<\/p>\n<p>ReadFileAdapter will Receive the input data from file and translate the data based on the translation logic defined and post the XML messages.<\/p>\n<p>WriteFileAdapter will receive the XML messages and translate it into actual data and write to a file.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda1.jpg\" \/><\/p>\n<p>FileAdapter supports the following file formats.<\/p>\n<p>1.XML<\/p>\n<p>2.Delimited (Delimiter can be anything)<\/p>\n<p>3.Fixed position<\/p>\n<p>4.Binary Data<\/p>\n<p>You don&#8217;t need to use both ReadFileAdapter and WriteFileAdapter in a single process, for example you can read the data from file using ReadFileAdapter and write data to a database using DBAdapter. In other way you can get the data from a database and write it to a file using WriteFileAdapter. This is purely based on the business requirement and up to us how we are going to use them.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\">System Requirements:<\/span><\/p>\n<p>1. jDeveloper 10.1.3<\/p>\n<p>2.SOA Suite 10.1.3<\/p>\n<p>Connections Required:<\/p>\n<p>1.Start the SOA Suite<\/p>\n<p>2.Create Application Server Connection<\/p>\n<p>3.Create Integration Server Connection<\/p>\n<p><span style=\"text-decoration: underline;\">Start the SOA Suite:<\/span><\/p>\n<p>If you don&#8217;t have SOA Suite already installed on your machine click here to download and install it.<\/p>\n<p>If you have SOA Suite installed on your machine navigate Start &gt;&gt; All Programs &gt;&gt; Oracle &#8211; &gt;&gt;Start SOA Suite<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda2.jpg\" \/><\/p>\n<p>Once your Application Server starts successfully you will see the screen below<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda3.jpg\" \/><\/p>\n<p>Create Application Server Connection<\/p>\n<p>Navigate to Connection Navigator by clicking view &gt;&gt; Connections Navigator or by pressing Ctrl + Shift + o<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda4.jpg\" \/><\/p>\n<p>Right click on &#8220;Application Server&#8221; and click New Application Server Connection<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda5.jpg\" \/><\/p>\n<p>Wizard opens with welcome screen <img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda6.jpg\" \/><\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda7.jpg\" \/><\/p>\n<p>Connection Name: AppServerConnection1 (you can change it to anything)<\/p>\n<p>Connection Type: Oracle Application Server 10g 10.1.3<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda8.jpg\" \/><\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda9.jpg\" \/><\/p>\n<p>Username: oc4jadmin<\/p>\n<p>Password: welcome1(this is the default password, if you have changed it use your own password)<\/p>\n<p>Click next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda10.jpg\" \/><\/p>\n<p>Leave everything as it is and click next<\/p>\n<p>And then press Test Connection<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda11.jpg\" \/><\/p>\n<p>If you receive the Status as Success! You are good to proceed. If you get any errors make sure your application server is running and try again.<\/p>\n<p>Click Finish to close the wizard and return to Connection Navigator.<\/p>\n<p>Create Integration Server Connection<\/p>\n<p>Go to Connection Navigator by pressing Ctrl+Shift+o<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda12.jpg\" \/><\/p>\n<p>Right click on &#8220;Integration Server&#8221;<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda13.jpg\" \/><\/p>\n<p>By Clicking the &#8220;New Integration Server Connection&#8221; wizard opens up with welcome screen.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda14.jpg\" \/><\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda15.jpg\" \/><\/p>\n<p>You can leave the Name as it is or change it if needed<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda16.jpg\" \/><\/p>\n<p>Application Server: Select the Application Server you created in first step. If you have only one application server it will be automatically selected.<\/p>\n<p>Hostname: localhost<\/p>\n<p>Port Number: 8888<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda17.jpg\" \/><\/p>\n<p>Click &#8216;Test Connection&#8217;<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda18.jpg\" \/><\/p>\n<p>If you receive the following message you connection is successful.<\/p>\n<p>Application Server: OK<\/p>\n<p>BPEL Process Manager Server: OK<\/p>\n<p>ESB Server: OK<\/p>\n<p>Click finish to close the wizard<\/p>\n<p>Create New Application<\/p>\n<p>Open Application Navigator by clicking Ctrl+Shift+A or go to view &gt;&gt; Application Navigator<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda19.jpg\" \/><\/p>\n<p>If you have any Application exists\u00a0 you can create your BPEL process under that if not creation new application by right clicking the Applications and selecting New<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda20.jpg\" \/><\/p>\n<p>Change the application name as you need and leave all the remaining things as default and click OK<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda21.jpg\" \/><\/p>\n<p>Click Cancel to cancel the project. We will create new project manually by selecting the BPEL Process project in next step.<\/p>\n<p>Create New BPEL Process<\/p>\n<p>Right Click on the Application that we created and click New Project<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda22.jpg\" \/><\/p>\n<p>Wizard opens as shown<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda23.jpg\" \/><\/p>\n<p>Select BPEL Process Project and click OK<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda24.jpg\" \/><\/p>\n<p>Change the Name(optional) and<\/p>\n<p>Template: Empty BPEL Process<\/p>\n<p>Click Finish.<\/p>\n<p>If you expand the BPEL Process you can see the files below which are created by default.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda25.jpg\" \/><\/p>\n<p>Middle panel of jdeveloper opens BPELProcess.bpel file automatically if not open it by double clicking on the file shown in the above figure.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda26.jpg\" \/><\/p>\n<p>In the .bpel file you can see 3 regions<\/p>\n<p>1.Services(Left Side)<\/p>\n<p>2.Main Activity Region<\/p>\n<p>3.Services(Right Side)<\/p>\n<p>On the Right Side of your screen you can see the component palette.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda27.jpg\" \/><\/p>\n<p>From the dropdown select &#8216;Services&#8217; if it is not selected.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda28.jpg\" \/><\/p>\n<p>From services select &#8220;File Adapter&#8221;<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda29.jpg\" \/><\/p>\n<p>Drag it to Services region on left and leave it.<\/p>\n<p>Automatically &#8216;Adapter Configuration Wizard&#8217; will pop up showing the welcome screen<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda30.jpg\" \/><\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda31.jpg\" \/><\/p>\n<p>Enter Service Name as &#8216;ReadFileAdapter&#8217; since we are going to use this adapter for reading the file.<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda32.jpg\" \/><\/p>\n<p>Select &#8216;ReadFile&#8217; and click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda33.jpg\" \/><\/p>\n<p>Select the &#8216;Physical Path&#8217; option and select the path where you CSV file is placed.<\/p>\n<p>I have placed by .CSV file in the &#8216;C:readfile&#8217; directory<\/p>\n<p>Deselect the option &#8216;Delte files after successful retrieval&#8217;<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda34.jpg\" \/><\/p>\n<p>Enter the patten name in &#8216;Include Files with Name Pattern&#8217;<\/p>\n<p>I have entered erpschools*.txt which means that all the files starting with &#8216;erpschools&#8217; word prefix will be picked for processing.<\/p>\n<p>Ex:<\/p>\n<p>erpschools.txt will be picked<\/p>\n<p>erpschools1.txt will be picked<\/p>\n<p>erpschools2.txt will be picked<\/p>\n<p>1erpschools.com will not be picked.<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda35.jpg\" \/><\/p>\n<p>Leave the default values and<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda36.jpg\" \/><\/p>\n<p>Click on &#8216;Define Schema for Native Format&#8217; button<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda37.jpg\" \/><\/p>\n<p>Navtive Format Builder Wizard will pop up with welcome screen.<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda38.jpg\" \/><\/p>\n<p>Select &#8216;Delimited&#8217; option and<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda39.jpg\" \/><\/p>\n<p>Select your delimited file.<\/p>\n<p>My Delimited file looks like this<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda40.jpg\" \/><\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda41.jpg\" \/><\/p>\n<p>Since our file contains only one record select first option and<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda42.jpg\" \/><\/p>\n<p>Namespace: leave default value<\/p>\n<p>Enter a name for element that will represent record: readrecord<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda43.jpg\" \/><\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda44.jpg\" \/><\/p>\n<p>Change the column names and types as needed and<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda45.jpg\" \/><\/p>\n<p>.xsd(XML Schema Definition) file will created by default<\/p>\n<p>Click next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda46.jpg\" \/><\/p>\n<p>Click Finish to go back to Adapter Wizard<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda47.jpg\" \/><\/p>\n<p>Schema Location and Schema Element will be populated with the values that we created just now.<\/p>\n<p>Click next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda48.jpg\" \/><\/p>\n<p>Click Finish<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda49.jpg\" \/><\/p>\n<p>Create Partner Link window will show up as above<\/p>\n<p>Click OK<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda50.jpg\" \/><\/p>\n<p>Now you should be able to see the ReadFileAdapter in the services region as shown above<\/p>\n<p>Now in the component Palette select &#8216;Process Activities&#8217;<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda51.jpg\" \/><\/p>\n<p>Select &#8216;Receive&#8217; component and drag it to main region<\/p>\n<p>When you move the component to main region it will change the color to yellow then you can drop it.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda52.jpg\" \/><\/p>\n<p>Double click on Receive_1 component to edit<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda53.jpg\" \/><\/p>\n<p>Click on &#8216;Flash light&#8217; right to to the &#8216;Partner Link Field&#8217;<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda54.jpg\" \/><\/p>\n<p>Select &#8216;ReadFileAdapter&#8217; and click OK<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda55.jpg\" \/><\/p>\n<p>Now Partner Link and operation fields will be populated as shown<\/p>\n<p>Click on &#8216;Auto Create&#8217; button right to Variable to create new variable. If you don&#8217;t understand which icon to click place your cursor on the icons and you can see the hint text<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda56.jpg\" \/><\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda57.jpg\" \/><\/p>\n<p>Click OK<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda58.jpg\" \/><\/p>\n<p>Check &#8216;Create Instance&#8217; box and click apply<\/p>\n<p>Click OK<\/p>\n<p>Now the figure looks like this<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda59.jpg\" \/><\/p>\n<p>There is a link created from ReadFileAdapter to Receive_1 component<\/p>\n<p>Create WriteFileAdapter<\/p>\n<p>Go to component palette and select services from drop down<\/p>\n<p>Select the drag FileAdapter to Services region on the right side<\/p>\n<p>FileAdapter Wizard will open with welcome screen as shown below<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda60.jpg\" \/><\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda61.jpg\" \/><\/p>\n<p>ServiceName: WriteFileAdapter<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda62.jpg\" \/><\/p>\n<p>Select &#8216;Write File&#8217; option<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda63.jpg\" \/><\/p>\n<p>Enter Directory path and file naming convention as shown above.<\/p>\n<p>%SEQ% will increase the numbers from 1 onwards which means if you have 10 files to write then your file names will be erp_1.txt, erp_2.txt, erp_3.txt \u2026..erp_10.txt<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda64.jpg\" \/><\/p>\n<p>Click Browse to select the schema file that we already created before<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda65.jpg\" \/><\/p>\n<p>Select readrecord<\/p>\n<p>Click OK<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda66.jpg\" \/><\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda67.jpg\" \/><\/p>\n<p>Click Finish to close the wizard<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda68.jpg\" \/><\/p>\n<p>Click Apply and OK<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda69.jpg\" \/><\/p>\n<p>WriteFileAdapter will showup in the right Services region as show above<\/p>\n<p>Now go to Component palette and select &#8216;Process Activites&#8217;<\/p>\n<p>Select &#8216;Invoke&#8217; Component from component palette and drop it below the &#8216;Receive_1&#8217; component<\/p>\n<p>Double click on &#8216;Invoke_1&#8217; component to edit it<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda70.jpg\" \/><\/p>\n<p>Click Flash light to select the partner link<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda71.jpg\" \/><\/p>\n<p>Click ok<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda72.jpg\" \/><\/p>\n<p>Click Automatically create input variable icon to create new variable<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda73.jpg\" \/><\/p>\n<p>Click ok<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda74.jpg\" \/><\/p>\n<p>Click Apply and OK<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda75.jpg\" \/><\/p>\n<p>Now drag and drop the &#8216;Transform&#8217; component below the &#8216;Receive_1&#8217; component and above &#8216;Invoke_1&#8217; component<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda76.jpg\" \/><\/p>\n<p>Double click on &#8216;Transform_1&#8217; component to edit the settings<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda77.jpg\" \/><\/p>\n<p>Select as follows<\/p>\n<p>Source variable: Receive_1_Read_InputVariable<\/p>\n<p>Target variable: Invoke_1_Write_InputVariable<\/p>\n<p>Click Apply and OK<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda78.jpg\" \/><\/p>\n<p>Transformation_1.xsl file will open as show above<\/p>\n<p>select\u00a0 &#8216;tns:readrecord&#8217; in source and drag it to &#8216;tns:readrecord&#8217; on target to map the fields.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda79.jpg\" \/><\/p>\n<p>Auto Map Preferences will pop up as shown above<\/p>\n<p>Click OK to auto map<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda80.jpg\" \/><\/p>\n<p>All fields will be mapped automatically as shown above<\/p>\n<p>Now select BPELProcess.bpel file on top and click validate icon to validate the process<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda81.jpg\" \/><\/p>\n<p>Once it is validated with out errors we are ready to deploy the process<\/p>\n<p>Deploy BPEL Process<\/p>\n<p>Right click on BPEL Process and select Deploy option as shown below<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda82.jpg\" \/><\/p>\n<p>If you have this process already on server it will pop up with version number if not it will start deploying the process<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda83.jpg\" \/><\/p>\n<p>If your deployment is successful you will see the message<\/p>\n<p>BUILD SUCCESSFUL.<\/p>\n<p>Initiate BPEL Process<\/p>\n<p>Open your browser and type the following URL<\/p>\n<p><a href=\"http:\/\/localhost:8888\/BPELConsole\">http:\/\/localhost:8888\/BPELConsole<\/a><br \/>\nIf your hostname is different change it in the URL<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda84.jpg\" \/><\/p>\n<p>Username: oc4jadmin<\/p>\n<p>Password: welcome1(default)<\/p>\n<p>Login<\/p>\n<p>You can see the list of deployed BPEL Process on the left panel as shown below<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda85.jpg\" \/><\/p>\n<p>Click on the process we deployed right now<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda86.jpg\" \/><\/p>\n<p>You will be taken to Initiate screen where you have option to post XML Message<\/p>\n<p>Now your process has initiated<\/p>\n<p>Go to your writefile directory to see your file<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda87.jpg\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview: In this tutorial I will explain how to read a CSV file using ReadFileAdapter and then to write a CSV file using WriteFileAdapter. We don&#8217;t have two separate FileAdapters but based on the read and write operation we mention them as ReadFileAdapter or WriteFileAdapter. ReadFileAdapter will Receive the input data from file and translate [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[73],"class_list":["post-1582","post","type-post","status-publish","format-standard","hentry","category-fusion-middleware","tag-bpel-file-adapter-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>oracle bpel file adapter tutorial<\/title>\n<meta name=\"description\" content=\"oracle bpel file adapter tutorial example\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prudhvi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"BPEL File Adapter Tutorial\",\"datePublished\":\"2011-04-17T12:36:06+00:00\",\"dateModified\":\"2014-12-09T06:24:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial\"},\"wordCount\":1558,\"commentCount\":11,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda1.jpg\",\"keywords\":[\"BPEL File Adapter Tutorial\"],\"articleSection\":[\"Fusion Middleware\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial\",\"url\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial\",\"name\":\"oracle bpel file adapter tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#primaryimage\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda1.jpg\",\"datePublished\":\"2011-04-17T12:36:06+00:00\",\"dateModified\":\"2014-12-09T06:24:20+00:00\",\"description\":\"oracle bpel file adapter tutorial example\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#primaryimage\",\"url\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda1.jpg\",\"contentUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BPEL File Adapter Tutorial\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/erpschools.com\/erps\/#website\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"name\":\"erpSchools\",\"description\":\"Oracle Apps\",\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/erpschools.com\/erps\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\",\"name\":\"erpSchools\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"width\":250,\"height\":60,\"caption\":\"erpSchools\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/facebook.com\/erpschools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\",\"name\":\"Prudhvi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"caption\":\"Prudhvi\"},\"sameAs\":[\"http:\/\/www.erpschools.com\"],\"url\":\"https:\/\/erpschools.com\/erps\/author\/prudhvi\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"oracle bpel file adapter tutorial","description":"oracle bpel file adapter tutorial example","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"BPEL File Adapter Tutorial","datePublished":"2011-04-17T12:36:06+00:00","dateModified":"2014-12-09T06:24:20+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial"},"wordCount":1558,"commentCount":11,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"image":{"@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda1.jpg","keywords":["BPEL File Adapter Tutorial"],"articleSection":["Fusion Middleware"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial","url":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial","name":"oracle bpel file adapter tutorial","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"primaryImageOfPage":{"@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#primaryimage"},"image":{"@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda1.jpg","datePublished":"2011-04-17T12:36:06+00:00","dateModified":"2014-12-09T06:24:20+00:00","description":"oracle bpel file adapter tutorial example","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#primaryimage","url":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda1.jpg","contentUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1232_BPELFileAda1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-file-adapter-tutorial#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"BPEL File Adapter Tutorial"}]},{"@type":"WebSite","@id":"https:\/\/erpschools.com\/erps\/#website","url":"https:\/\/erpschools.com\/erps\/","name":"erpSchools","description":"Oracle Apps","publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/erpschools.com\/erps\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/erpschools.com\/erps\/#organization","name":"erpSchools","url":"https:\/\/erpschools.com\/erps\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","width":250,"height":60,"caption":"erpSchools"},"image":{"@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/erpschools"]},{"@type":"Person","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512","name":"Prudhvi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","caption":"Prudhvi"},"sameAs":["http:\/\/www.erpschools.com"],"url":"https:\/\/erpschools.com\/erps\/author\/prudhvi"}]}},"_links":{"self":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/1582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/comments?post=1582"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/1582\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=1582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=1582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=1582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}