Scribd
Upload
7 views59 pages

BPEL Inbound Project Setup Guide

This document provides step-by-step instructions for creating a BPEL inbound project in Oracle BPEL Process Manager to read files from an incoming directory and insert the data into a database table. The key steps include: 1) Creating a new BPEL process project and defining connections to the application server, database, and integration server; 2) Configuring a file adapter to monitor an incoming directory and define the input file format; 3) Configuring a database adapter to insert the incoming file data into a database table; 4) Adding a transform activity to map data between the file and database; and 5) Adding logic to check for errors and send notification emails.

Uploaded by

Kishore Garlapati
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
7 views59 pages

BPEL Inbound Project Setup Guide

This document provides step-by-step instructions for creating a BPEL inbound project in Oracle BPEL Process Manager to read files from an incoming directory and insert the data into a database table. The key steps include: 1) Creating a new BPEL process project and defining connections to the application server, database, and integration server; 2) Configuring a file adapter to monitor an incoming directory and define the input file format; 3) Configuring a database adapter to insert the incoming file data into a database table; 4) Adding a transform activity to map data between the file and database; and 5) Adding logic to check for errors and send notification emails.

Uploaded by

Kishore Garlapati
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

BPEL Inbound Project (Step– by– Step Screen shots):-

Connections to the Application Server, Database and Integration Server

Connections tab to get the


connections window

Application Server

Database Connection

Integration Server
Create New Project to build the BPEL Process
Select the BPEL Process Project
Specify the Name and select the Template as Asynchronous BPEL Process

Name of BPEL Project

Select BPEL Process from LOV


Remove the Client Partner link and Callback Client Activity (As this is an
Asynchronous Process)

Remove these two Activities


Create a New Partner link (Right Click the mouse to get the Partner Link Activity)
And Select the Adapter type

Adapter type
Mention the Operation type
Enter the directory information for the Incoming file to read the file operation

Incoming File Path

Archive File Path


Mention the Input file format name
Mention the Polling Frequency and File Age
Define the Schema file (To generate the xsd file)

System
generates
xsd file for
the given
File format
Select the Input File Format
Mention the File Name from Local System
Enter the Element Name (Mandatory Field)

Mandatory Field
Specify the field name and field Properties
System will generate the xsd file

System generates xsd


file at the mentioned
location
Finish the File Adapter service
Apply the Adapter Services
Make a link between File Adapter and Receive Partner Link
Create a New partner link with Adapter Partner Link
Select the Database Adapter
Select the Connection
Select the Operation type
Click on the Import Table to fetch the desired table from database
Mention the schema and data base Table name
Enable the Primary Key column in the selected table (Mandatory Field)
Finish the Database Adapter service
Drag and drop Invoke Activity and place after receive Activty
Drag and drop the transform Activity and place between receive and invoke activity
Make a Join between the Invoke and Database Adapter File
System generates variable and assign it to that activity
Double Click on the transform Activity and assign the Input and Output Variables
Map the source columns to target columns (Legacy file to Database table Columns)
Assign Loop conditions
Make a join from Sub-Element to Loop condition
Create a new Partner link and select the Adapter
Select the Database Adapter
Connect to the database
Select the Operation type
Write the SQL query to fetch the number of records from Interface table
Finish and apply the database Adapter service
Drag Invoke service and link with the record count Database File Adapter partner link
Drag Switch Activity after record count Invoke activity
Give the condition in the Expression Builder
Drag Mail Activity in the switch Activity
Create a new database Partner link
Select the Database Adapter
Connect to the Database
Mention the Schema and Procedure Name
Finish the Database Adapter Service
Drag and drop the Invoke activity
Give the Condition in Expression Builder
Join Invoke Activity with the Database Adapter Activity to know the status
Drop a switch activity after Invoke Status report
Check the condition in the Switch Activity
Assign the Mail activity (If Program completes in Error)
Assign the Mail activity (If Program completes Normal)
Make the GL_Interface Project
Deploy into the Application Server

You might also like