5 Using e-Commerce Gateway

Creating a New BPEL Project

The first configuration task is to create a new BPEL project. Use the following steps to create a new BPEL project:

1. Open JDeveloper BPEL Designer.

2. From the File menu, select New. The New Gallery dialog box is displayed.

3. Select All Items from the Filter By box. This displays a list of available categories.

4. Expand the General node, and then select Projects.

5. Select BPEL Process Project from the Items group, as shown in Figure 5-1.

   Figure 5-1 Creating a New BPEL Process Project

   
   Description of "Figure 5-1 Creating a New BPEL Process Project"
   
   

6. Click OK. The BPEL Process Project dialog box is displayed.

7. In the BPEL Process Name field, enter a descriptive name. For example, InsertShipNotice.

8. From the Template box, select Asynchronous BPEL Process. Keep the default selection for Use Default under Project Content, as shown in Figure 5-2.

   Figure 5-2 Specifying a Name for the New BPEL Process Project

   
   Description of "Figure 5-2 Specifying a Name for the New BPEL Process Project"
   
   

9. Click OK. A new BPEL process, with the required source files including bpel.xml, InsertShipNotice.bpel, and InsertShipNotice.wsdl is created, as shown in Figure 5-3.

   Figure 5-3 New BPEL Process Project

   
   Description of "Figure 5-3 New BPEL Process Project"
   
   

Adding a Partner Link

The next task is to add a partner link to the BPEL process. A partner link defines the link name, type, and the role of the BPEL process that interacts with the partner service.

Use the following steps to add a partner link:

1. Drag and drop PartnerLink, from the Component Palette, into the border area of the process diagram. The Create Partner Link dialog box is displayed.

2. Click the Define Adapter Service icon in WSDL Settings. The Adapter Configuration Wizard is displayed.

3. Click Next. The Adapter Type dialog box is displayed.

4. Select Oracle Applications, as shown in Figure 5-4. Click Next.

   Figure 5-4 Selecting OracleAS Adapter for Oracle Applications

   
   Description of "Figure 5-4 Selecting OracleAS Adapter for Oracle Applications"
   
   

5. The Service Name dialog box is displayed, as shown in Figure 5-5. Enter the following information:

   1. In the Service Name field, enter a service name.

   2. In the Description field, enter a description for the service. This is an optional field. Click Next.

   Figure 5-5 Specifying the Service Name

   
   Description of "Figure 5-5 Specifying the Service Name"
   
   

6. The Service Connection dialog box is displayed. Enter the Java Naming and Directory Interface (JNDI) name in the Database Server JNDI Name field. The JNDI name acts as a placeholder for the connection used when your service is deployed to the BPEL server. This enables you to use different databases for development and later production.

   
   

   See Also: Oracle Application Server Adapter Concepts for understanding JNDI concepts

   
   

   Figure 5-6 shows how to create a new database connection.

   Figure 5-6 Creating a New Database Connection

   
   Description of "Figure 5-6 Creating a New Database Connection"
   
   

7. Click New to define a database connection. The Create Database Connection Wizard is displayed.

   
   

   Note: You need to connect to the database where Oracle Applications is running.

   
   

8. Enter the following information in the Type dialog box:

   1. In the Connection Name field, specify a unique name for the database connection.

   2. From the Connection Type box, select the type of connection for your database connection.

      Figure 5-7 shows the Type dialog box.

      Figure 5-7 Specifying the Connection Name and Type of Connection

      
      Description of "Figure 5-7 Specifying the Connection Name and Type of Connection"
      
      

9. Click Next. The Authentication dialog box is displayed.

10. Enter information in the following fields:

    1. In the UserName field, specify a unique name for the database connection.

    2. In the Password field, specify a password for the database connection.

11. Click Next. The Connection dialog box is displayed.

12. Enter information in the following fields:

    1. From the Driver list, select Thin.

    2. In the Host Name field, specify the host name for the database connection.

    3. In the JDBC Port field, specify the port number for the database connection.

    4. In the SID field, specify a unique SID value for the database connection.

    Figure 5-8 shows the Connection dialog box.

    Figure 5-8 Specifying the New Database Connection Information

    
    Description of "Figure 5-8 Specifying the New Database Connection Information"
    
    

13. Click Next. The Test dialog is displayed.

14. Click Test Connection to determine whether the specified information establishes a connection with the database.

15. Click Next. The Service Connection dialog box is displayed, providing a summary of the database connection.

16. Click Finish to complete the process of creating a new database connection.

Once you have completed creating a new connection for the service, you can select an e-Commerce Gateway interface by browsing through the modules available in Oracle Applications.

1. Click Next in the Service Connection dialog box. The Operation dialog box is displayed.

   
   

   Note: If you are connecting to a pre-11.5.10 Oracle Applications instance, then you would be required to select the interface to Oracle Applications data. Select EDI Gateway to proceed. Select Inbound into Oracle Applications or Outbound from Oracle Applications depending on whether data is inbound into Oracle Applications or outbound from Oracle Applications. Next, click Get CP to choose the EDI concurrent program from the Oracle Applications Module Browser.

   
   

2. Click Get Object to open the Oracle Applications Module Browser. Figure 5-9 shows the Oracle Applications Module Browser.

   Figure 5-9 Specifying the EDI Concurrent Program

   
   Description of "Figure 5-9 Specifying the EDI Concurrent Program"
   
   

   Oracle Applications Module Browser includes the various product families that are available in Oracle Applications. For example, Applications Technology or Order Management Suite are product families in Oracle Applications. The product families contain the individual products. For example, Applications Technology contains the e-Commerce Gateway product. The product contains the business entities associated with the product. For example, the e-Commerce Gateway product contains the Advanced Shipment Notification business entity.

   Business entities contain the various application modules that are exposed for integration. These modules are grouped accoding to the interface they provide. EDI programs can be found under the EDI category.

3. Select an inbound or outbound EDI program. Click OK. You can select only one EDI program for each adapter service.

   
   

   Note: You can also search for an EDI program by entering the name of the program in the Object Name field. Select the EDI check box and click Search.

   
   

4. The EDI program is added to Operation Objects. Click Next in the Operation dialog box.

5. Click Finish. When you click Finish, the wizard generates the WSDL file corresponding to the selected interface. This WSDL file is now available for the partner link. Figure 5-10 shows the Create Partner Link dialog box after the WSDL file has been generated.

   
   

   Note: When you click Finish, two SQL files may be added to the project if a wrapper does not exist for the function. A wrapper is generated the very first time you create the e-Commerce Gateway based service. Subsequent services reuse the wrapper that is created.

   
   

   Figure 5-10 Completing the Partner Link Configuration

   
   Description of "Figure 5-10 Completing the Partner Link Configuration"
   
   

6. Click OK. The partner link is created with the required WSDL settings.

Configuring the Invoke Activity

After adding and configuring the partner link, the next task is to configure the BPEL process itself. You can start by configuring the Invoke process activity to invoke the EDI concurrent program.

The following steps discuss configuring the Invoke activity:

1. Drag and drop Invoke into the process map window. shows the Invoke activity after it has been added to the process map.

   Figure 5-11 Adding the Invoke Activity

   
   Description of "Figure 5-11 Adding the Invoke Activity"
   
   

2. Double-click Invoke in the process map to open the Invoke dialog box. The General tab is selected by default. Figure 5-12 shows the Invoke dialog box.

   Figure 5-12 Configuring the Invoke Activity

   
   Description of "Figure 5-12 Configuring the Invoke Activity"
   
   

3. In the Partner Link box, select the partner link to invoke. This is the partner link that you configured in the previous section. The Operation is automatically selected, depending on the EDI concurrent program that you chose when configuring the partner link.

4. Click the Create icon next to the Input Variable field. Enter a descriptive name for the variable in the Create Variable dialog box that appears. You can also accept the default name. Click OK. Figure 5-13 shows the Create Variable dialog box.

   Figure 5-13 Creating the Input Variable

   
   Description of "Figure 5-13 Creating the Input Variable"
   
   

5. Click the Create icon next to the Output Variable field. Enter a descriptive name for the variable in the Create Variable dialog box that appears. You can also accept the default name. Click OK.

6. In the Invoke dialog box, click Apply, andthen click OK.

   
   

   Note: You can define a Input Header Variable under the Adapters tab of the Invoke dialog box. This variable can be used to provide context information for Oracle Applications.

   
   

Configuring the Transform Activity

The Transform activity can be used to configure the parameters for the input and output variable. The Transform activity can also be used if variable values need to be transformed before updating them in Oracle Applications.

The following steps discuss configuring the Transform activity:

1. Drag and drop Transform into the process map window. The Transform activity should be placed in between Receive and Invoke. Figure 5-14 shows the process map window after the Transform activity has been added.

   Figure 5-14 Adding the Transform Activity

   
   Description of "Figure 5-14 Adding the Transform Activity"
   
   

2. Double-click Transform in the process map to open the Transform dialog box. The Transformation tab is selected by default. Figure 5-15 shows the Transform dialog box.

   Figure 5-15 Configuring the Transform Activity

   
   Description of "Figure 5-15 Configuring the Transform Activity"
   
   

3. Select the Source Variable and Target Variable from the respective boxes. Elements are mapped from the Source Variable to the Target Variable.

4. Select the Source Part of the variable from which to map elements. For example, the source part may be a payload schema consisting of a purchase order request.

5. Select the Target Part of the variable to which to map elements. For example, the target part may be a payload schema consisting of a purchase order acknowledgment.

6. Mapper File specifies the file in which you create the mappings using the XSLT Mapper Transformation tool. Click the Create icon next to the Mapper File field to create a new transformation mapping file.

7. The transformation mapping file is displayed. The Design view is displayed by default. Figure 5-16 shows the Design view for the transformation mapping file.

   Figure 5-16 Editing the Transformation Mapping File

   
   Description of "Figure 5-16 Editing the Transformation Mapping File"
   
   

8. You can define the parameter values in the Design view. Drag a string function to the Design area. Connect the function to the appropriate parameter for which you want to define a value.

   
   

   Note: You can use an input parmaeter value from the source variable, transform it using a string function, and use it as the input parameter value for the target variable.

   
   

9. Double-click the icon for the function. The Edit Function dialog box is displayed. Figure 5-17 shows the Edit Function dialog box.

   Figure 5-17 Supplying the Function Parameters

   
   Description of "Figure 5-17 Supplying the Function Parameters"
   
   

10. Repeat steps 8 and 9 for all the parameters that you need to supply.

    
    

    Note: You can use both the Transform and Assign activities to configure the variables. If the number of mappings to be configured is less, say three or four, then you can use the Assign activity. The Transform activity is more suitable for situations where the number of mappings is large or where variable transformation is required.