adapters apps-101-orderimportconcurrentprogram

Oracle SOA Suite 11g - Sample

SAMPLE NAME : adapters-apps-101-OrderImportConcurrentProgram

COMPONENT : Oracle Applications Adapter for Open Interface

Tables and Concurrent Program.

OVERVIEW

Oracle Applications provides a set of Open Interface Tables to insert and update data in

Oracle Applications. 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.

A concurrent program is an instance of an execution file, along with parameter

definitions and incompatibilities. Concurrent programs are scheduled in Oracle

Applications to move data from interface tables to base tables. These programs perform

the application-level checks and run validation before inserting data into base tables.

The Oracle Adapter for Oracle Applications exposes both Open Interface Tables and

Concurrent Programs as Web Services that can inturn be invoked from a BPEL process.

This example showcases insert of Sales Order data into Oracle Applications using BPEL

Process Manager and Oracle Adapter for Oracle Applications. The Adapter exposes the

following operations as Web Services:

• Order data is inserted into Oracle's Order Management Open Interface tables.

• The Order Import concurrent program is then invoked to further validate and

import the orders

PROVIDED FILES

• README.txt

• adapters-apps-101-OrderImportConcurrentProgram.zip-Files needed for the

sample.

o Artifacts\

� Input\


• order_data.xml- Payload file to be read by the File

Adapter

• cp_data.xml- CP parameters file to be read by the File

Adapter

� sql\

• XX_BPEL_FND_REQUEST_WRAPPER.sql- Creates

wrapper package for the Concurrent Program

o Docs

� adapters-apps-101-OrderImportConcurrentProgram.pdf--

Instructions

o OrderImportConcurrentProgram-App.zip – JDeveloper Application

and project

o README.txt

STEP BY STEP INSTRUCTIONS

RUNNING THE PREBUILT SAMPLE

• Set up the wrapper package on target DB (The database on which you intend to

run this sample) by executing XX_BPEL_FND_REQUEST_WRAPPER.sql as

APPS/APPS.

• Edit the input file order_data.xml.Replace the order_id_01 with a non-default

value

• Make sure that the input files exist in the path mentioned in the composite.xml

• Build the sample using JDeveloper.

• Deploy the BPEL process adapters-apps-101-

OrderImportConcurrentProgram to the weblogic server

• Invoke the BPEL Process.

• Verify that the sample is executed successfully.

VERIFYING EXECUTION

INSTALLING & CONFIGURING

• Configure the data source in the weblogic server.

RUNNING THE SAMPLE

• Launch JDeveloper and start weblogic server.

• Open the application OrderImportConcurrentProgram-App.jws

• Drill down further to the .bpel file and double-click to open it.


• Navigate to composite.xml in the project adapters-apps-101-

OrderImportConcurrentProgram.

• Edit composite.xml to specify the physical directory for the File Adapter –

synchronous read operation getOrderDetails and getCPDetails.

<property name="inputDir" type="xs:string" many="false"

override="may">/usr/tmp</property>

Deploy the BPEL Process

• Right click the project ‘adapters-apps-101-OrderImportConcurrentProgram’

under projects in the Application Navigator.

• Select Deploy -> adapters-apps-101-OrderImportConcurrentProgram-

>’serverConnection’

• Select the sample and click on Test to test the process.


• Enter a random string ‘test’ as input and click Testwebservice.

• Click on the BPEL process name in the left pane to see the instances.

• Click on the latest Instance ID under Instances tab to see the process flow trace.


VERIFYING EXECUTION

• Navigate to Oracle Applications forms to check the status of the Concurrent

Program execution.

• The creation of purchase order could also be checked using Oracle Forms

Application.

• Log on to Oracle Self service Application on the target database as

Operations/welcome


• Choose responsibility Order Management Super User, Vision Operations

(USA) from the left panel.

• Choose Sales Order. Oracle forms application would open up.


• Press F11 to search for Order. In Customer PO field enter order_id_01 (order id

present in xml file) and press CTRL+F11 keys

• Details of newly created order with Order id = 'order_id_01' could be seen. Press

on Line items tab.

• Check the quantity and item type of the order is same as that present in xml file

• The following query also can be used from the backend to check if the order is

created

Select orig_sys_document_ref from oe_order_headers_all where

orig_sys_document_ref = ‘order_id_01';

BUILDING THE SAMPLE

PROCESS FLOW

• Receive activity – A dummy input from the BPEL Console triggers this.


• An invoke activity that points to a File Adapter – Performs synchronous Read

operation to read the “Purchase Order” from the input file.

• An invoke activity that points to an Oracle Applications Adapter – Inserts data

into Open Interface tables.

• An assign activity -- This sets the output of the File Adapter’s Sync Read service

to the input of the Oracle Applications Adapter’s Open Interface service.

• An invoke activity that points to the associated Oracle Applications Adapter –

Invokes the Concurrent Program service.

• An invoke activity that points to a File Adapter – Performs synchronous Read

operation to read the payload for the Concurrent Program from the input file.

• An assign activity to set the payload of the Concurrent Program service.

• Set Apps Adapter Context - Set Apps Adapter context for the invocation of the

Concurrent Program Service

DESIGN THE BPEL PROCESS

Launch JDeveloper.

Create a service Connection

• Select view->Database Navigator.

• Right click on IDE Connections and select New Connection to create a new

database connection.

• Enter the following values in the Create Database Connection window.


• Click OK.

Create a New Application

• Click New Application in the Application Navigator.

• Enter OrderImportConcurrentProgram-App as the Application Name.

• Select SOA Application in the Application Template.

• Click Next


• Enter adapters-apps-101-OrderImportConcurrentProgram as the Project

Name

• Select SOA from the Project Technologies.

• Click Next


• Select Composite With BPEL from the Composite Template.

• Click Finish

• Enter OrderImportConcurrentProgram as the name of the BPEL Process.

• Click OK


• Select Asynchronous BPEL Process as the Template.

Create Oracle Apps Adapter Partner Link for Open Interfaces

• Click BPEL services in the Component palate

• Click Oracle Applications, drag-and-drop it onto the right ‘Partner Links’ swim

lane.


• Click Next if the welcome page appears

• Enter InsertOrder as the Service Name.

• Click Next.

• Use icon to select a database connection already created.

• Click Next.


• This opens the window IREP File not present.

• Click No to select interface using the live connection

• Click Next in the Operation page of the wizard. This opens Oracle

Applications Module Browser


• Navigate to Order Management Suite (OM_PF)->Order Management (ONT)->

Sales Order (ONT_SALES_ORDER) -> OpenInterfaces ->Order Management

Sales Orders Open Interface -> Tables

• Select OE_HEADERS_IFACE_ALL


• Click OK.

.

• Click Get Object to open ‘Oracle Applications Module Browser’

• Navigate to Order Management Suite (OM_PF)->Order Management (ONT)->

Sales Order (ONT_SALES_ORDER) -> OpenInterfaces ->Order Management

Sales Orders Open Interface -> Tables


• Select OE_LINES_IFACE_ALL

• Click OK.

• Click Next.

• Select Insert operation in the Operation Type page.

• Click Next.

• Select OE_HEADER_IFACE_ALL as the root database table.


• Select the primary key fields as shown in the figure. You can also select multiple

fields

• Define the relationship between the header and the detail table. Select the parent

and child tables.


• Select the mapping type (1:M, 1:1, or 1:1 with Foreign Key on Child Table).

• Associate the foreign key fields to the primary key fields.

• Enter a name for the relationship you are creating. It is optional to specify a name.

By default, a name is generated for the relationship.

• Click OK.

• Click Next.


• Click Next in the Attribute Filtering page

• Select the defaults and click Next in the Advanced Options page.

• Click Finish in the Finish page.


Invoke the Partner link

• Select BPEL Activities and Components in the component palette.

• Drag and drop Invoke activity to point to the above partner link.


• Drag the arrow of Invoke activity and link to the InsertOrder Partnerlink

• Change the Name of the Invoke activity to Invoke.


• Click on to create the Input Variable.

• Leave the default name for the variable and click OK.

• Click Apply and OK.


Create a File Adapter Partner Link.

• Click BPEL Services from the component palette.

• Click File Adapter and drag-and-drop it onto the right Partner Links swim lane.

• Click Next in the welcome page of the wizard.

• Enter getOrderDetails as the service name.

• Click Next.

• Select defaults in the Adapter Interface page


• Click Next.

• Select the radio button Synchronous Read File in the Operation page and click

Next.

• Uncheck Delete Files after successful retrieval.

• Select Logical Name.

• Enter the Directory for Incoming Files (logical Name) as inputDir

• Click Next


• Enter the file Name as order_data.xml and click Next

• In the Messages page, click to select the schema.

• Select oeHeadersIfaceAllCollection from the Type Chooser.

• Click OK.

• Click Next in the Messages page.


• Click Finish in the Finish page of the wizard.

• Click Apply and then OK to complete the creation of File Adapter – Synchronous

Read Operation Partner Link.

Invoke the File Adapter Partner Link.

• Select BPEL Activities and Components in the component palette.

• Click the Invoke activity and drag- and-drop it below the receiveInput.


• Drag the arrow mark of Invoke activity and link it to the getOrderDetails Partner

link.

• Name the invoke activity as Invoke

• Click on for Input and Output to create Input and Output variables

respectively.


• Click Apply and then OK to complete the invoke activity.


Create Oracle Applications Partner Link for Concurrent Program

• Click BPEL services in the Component palette

• Drag-and-drop Oracle Applications onto the right ‘Partner Links’ swim lane.


• Enter Service Name as ImportOrderCP in the Service Name page.

• Select the connection using the browse and click Next

• Click No for IREP File not present window to use live connection.

• Click Next in the Operation Page.


• In the OAM browser, navigate to Order Management Suite (OM_PF)->Order

Management (ONT)-> Sales Order (ONT_SALES_ORDER) -> OpenInterfaces -

>Order Management Sales Orders Open Interface -> ConcurrentPrograms

• Select the concurrent Program OEOIMP.

• Click OK.

• Click Next in the Application Interface Page.



• Click Apply and then click Ok to complete the creation of Partner Link.

• Drag-and-drop Invoke activity above the callbackclient

• Now link the Invoke activity to the ImportOrderCP partner Link.

• Name the Invoke activity as Invoke.


• Click on for Input and Output to create Input and Output variables

respectively.

• Click Apply and then OK.


Create a File Adapter Partner Link.

• Drag-and-drop File Adapter onto the right Partner Links swim lane.


• Enter getCPDetails as the service name

• Click Next.


• Select defaults in the Adapter Interface page and click Next.

• Select the radio button Synchronous Read File in the Operation page and click

Next.

• Uncheck Delete Files after successful retrieval.

• Select Logical Name.

• Enter the Directory for Incoming Files (logical Name) as inputDir.

• Click Next


• Enter the file Name as ‘cp_data.xml’.

• In the Messages page, click to select the schema.

• Select InputParameters from the Type Chooser.

• Click OK.


• Click Next in the Messages page.



• Click Apply and then click Ok to complete the creation of Partner Link.

• Drag-and-drop Invoke activity below the first invoke activity and link it to the

above partner link.


• Create the input and output variables.


• Click Apply and then Click OK

Configure Assign Activities.

• Click the Assign activity from the BPEL Activities and Components list.

• Drag and drop the Assign activity in between second and third invoke activities

set the output of the File Adapter – Synchronous Read operation to the input of

the Oracle Applications Adapter – Open Interface operation

• Right click the Assign and choose Edit

• Click the General tab and Name the Assign activity as SetOrderDetails.

• Click the Copy Operation tab and select Copy Operation.


• Set the output of File Adapter to the input of InsertOrder partnerlink.

• Click OK.


• Click Apply and OK in the Assign Activity.

• Drag-and-drop another Assign activity above the Invoke activity for

ImportOrderCP.

• Click the General tab and Name the Assign activity as SetCPDetails.

• Click the Copy Operation tab and select Copy Operation.


Set Apps Adapter Context

• Right-click the Invoke activity of ImportOrderCP and select Edit.

• Click Properties tab to set the Header properties.

• Select jca.apps.Username and click to assign a value to it.


• Select the radio button Expression.

• Enter ‘operations’ in the text box

• Click OK.

• Similarly enter 'Order Management Super User, Vision Operations (USA)' for

jca.apps.Responsibility.

• Click OK


• Enter value as 204 for jca.apps.ORG_ID.

• Click OK.


• Click Apply

• Click OK.

• The end-to-end BPEL process is shown in the figure.


• Design tab of Composite.xml looks as shown in the figure.


• Click the Source tab of Composite.xml

• Enter a value of the physical directory for the property inputDir for the

references getOrderDetails and getCPDetails e.g. /usr/tmp

adapters apps-101-orderimportconcurrentprogram

Software

base tables

oracle adapter

oracle applications

intermediate tables

set of open interface

g sample sample

real application tables

overview oracle applications