Integrating an Oracle Business Event Workflow using WebSphere Adapter for Oracle E-Business Suite

The Oracle® Business Event Workflow system is used to communicate business events between systems. When a significant business event occurs in an internet or intranet application on a system, it triggers event subscriptions that specify the processing to execute for that event. This article describes how you can use WebSphere® Adapter for Oracle E-Business Suite business applications to retrieve events from the Oracle Business Event Workflow System.

Bharathi Manian (bharathi.manian@in.ibm.com), Software Engineer, IBM

Photo of Bharathi Manian Bharathi Manian is a Software Developer working with the WebSphere Cast Iron and WebSphere Adapters teams at the IBM Software Lab in Bangalore, India. Her expertise includes Java, J2EE, and Web technologies. She received her Bachelor's degree in Computer Engineering from the Birla Institute of Technology and Science, Pilani, India.



20 November 2013

Also available in Chinese Russian

Introduction

IBM® WebSphere Adapter for Oracle E-Business Suite (hereafter called Oracle E-Business Suite) helps you integrate Oracle E-Business Suite applications with your enterprise assets using common E-Business Suite interfaces - without coding. It helps you extend service-oriented architecture (SOA) applications beyond organizational walls to customers, partners, and suppliers. Oracle E-Business Suite reduces maintenance and development costs while optimizing and renewing the value of your enterprise assets.

Using the Oracle Business Event System and event notification, changes to the Oracle E-Business Suite can be automatically notified to other applications. By combining event processing by Oracle E-Business Suite and another adapter, updates can be automatically propagated to other enterprise applications such as Siebel®, PeopleSoft®, and SAP®.


About Oracle E-Business Suite

Oracle E-Business Suite is one of the most popular, fully integrated, and comprehensive suite of business applications for the enterprise, which consists of a collection of ERP, CRM, SCM, and so on, either developed by or acquired by Oracle.

Just a single transaction or business event can trigger enterprise-wide activities, such as coordinating partners in your supply chain, packing and shipping a product to a customer, or automating payment transactions based on product consumption. Consequently, best-of-breed applications that manage customer relationships, partner relationships, and the extended supply chain have become critical to business transactions. However, crucial customer and product data within enterprise information systems is often inaccessible by other applications and data systems.

The Oracle Business Event Workflow system is used to communicate business events between systems. When a significant business event occurs in an internet or intranet application on a system, it triggers event subscriptions that specify the processing to execute for that event.


Integrating the Oracle Workflow Business Event System using Oracle E-Business Suite

This article introduces the adapter's capability to leverage the Oracle Business Event System in Oracle E-Business Suite. This capability enables event-based integration for composite applications.

Figure 1 shows the flow of information between Oracle E-Business Suite and IBM Process Server.

Figure 1. Flow of information
Flow of information

This article uses an order management sample scenario. When a new order is created in Oracle E-Business Suite, an event is generated. The adapter picks up the order details and passes them to other applications.

The steps to configure inbound connectivity from E-Business Suite using the adapter are as follows:

  • Create the event store (table) required by adapter on the EIS (database).
  • Set up the applications and workflows in Oracle E-Business Suite to raise events when an event of significant importance occurs.
  • Create subscriptions in the Business Event System for the desired event.
  • Configure the subscription to execute a custom PL/SQL program when the subscribed event is received in the Business Event System.
  • The custom PL/SQL program is responsible to populate the adapter event store with information necessary to retrieve the event of interest.

Creating the event table and stored functions

You can use SQL scripts to create the required event table and functions in Oracle E-Business Suite. Also, a sequence and stored function are to be created. The stored function will insert an event into the event table used by the adapter when a new order is created in the Order Management module of Oracle E-Business Suite.


Configuring the Oracle Business Event System

This article uses the Oracle E-Business Suite Business Event System, which is a mechanism that processes data based on events, subscriptions, and actions that you have defined. Before you can use the Business Event System, you must complete some setup tasks within Oracle.

To configure the subscriptions in the Oracle Business Event System:

  1. Access your Oracle E-Business Suite application instance as the user "SYSADMIN".
  2. Select the Workflow Administrator Web Applications responsibility role.
  3. Select the Administrator Workflow > Business Events menu.
  4. Select the Subscriptions submenu.
  5. Click the Create Subscription button.
  6. Fill in the subscription details as shown in Figure 2.
Figure 2. Event subscription
Event subscription

Configuring the module using Oracle E-Business Suite for deployment

To process the data sent from Oracle E-Business Suite to IBM Process Server or WebSphere Enterprise Bus, you must create business objects. First, you initialize the wizard by configuring the values of the properties that enable the adapter to set up a communication channel to a specific database. Then, run a query to discover the business objects. Finally, specify the values of the connection properties for the export file.

  1. Switch to the Business Integration perspective in IBM Integration Designer.
  2. Start the WebSphere Adapter for Oracle E-Business Suite External Service wizard by choosing File > New > External Service. In the available types, choose Oracle E-Business Suite.
  3. Select IBM WebSphere Adapter for Oracle E-Business Suite (7.5.0.3) and click Next.
  4. In the "Locate the Required Files and Libraries" window, add the Oracle JDBC driver and click Next.
  5. Select the processing direction as Inbound.
  6. In the Specify the Discovery Properties page, select the version of the database and fill in the connection information necessary to connect to the Oracle E-Business Suite system, as shown in Figure 3.
    Figure 3. Configuring the Oracle E-Business Suite system
    Configuring the Oracle E-Business Suite system
  7. In the Find Objects in the Enterprise System page:
    1. Open the Edit Query dialog box, enter the Schema filter APPS, select the Prompt for additional configuration settings when adding business object, and click OK.
    2. Click Run Query. The query results are listed in the Discovered objects.
  8. Under Synonyms - Nick Names, the tables are filtered out under and the following tables need to be selected: PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, and PO_DISTRIBUTIONS_ALL. The configuration of each table is described below:
    • Table PO_HEADERS_ALL: Shown in Figure 4, in the Specify the Configuration Properties for 'PO_HEADERS_ALL' page, you see the configuration table PO_HEADERS_ALL attribute information, including the primary key PO_HEADER_ID. Click OK.
      Figure 4. Configuration properties for PO_HEADERS_ALL
      Configuration properties for PO_HEADERS_ALL
    • Table PO_LINES_ALL: Shown in Figure 5, in the Specify the Configuration Properties for 'PO_LINES_ALL' page, you see the configuration table PO_LINES_ALL attribute information, including the primary key PO_LINE_ID, the parent table PO_HEADERS_ALL, foreign keys PO_HEADER_ID, and other information. Click OK.
      Figure 5. Configuration properties for PO_LINES_ALL
      Configuration properties for PO_LINES_ALL
      Figure 6. Additional configuration properties for PO_LINES_ALL
      Additional configuration properties for PO_LINES_ALL
    • Table PO_LINE_LOCATIONS_ALL: As shown in Step 2, in the Specify the Configuration Properties for 'PO_LINE _LOCATIONS _ALL' page, you see the configuration table PO_LINE_LOCATIONS_ALL attribute information, including primary key LINE_LOCATION_ID, the parent table PO_LINES_ALL, foreign keys PO_LINE_ID, and other information. Click OK.
    • Table PO_DISTRIBUTIONS_ALL: As shown in Step 2, in the Specify the Configuration Properties for 'PO_DISTRIBUTIONS_ALL' page, you see the configuration table PO_DISTRIBUTIONS_ALL attribute information, including primary key PO_DISTRIBUTION_ID, the parent table PO_LINES_ALL, foreign keys PO_LINE_ID, and other information. Click OK.

    After the above operations, the PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, and PO_DISTRIBUTIONS_ALL are added to the Selected objects. The results are shown in Figure 7.

    Figure 7. Selected objects
    Selected objects
  9. In the Configure Composite Properties page, clear the Generate a business graph for each business object option. For the other options, keep the default configuration. Click Next.
  10. In the Specify the Service Generation and Deployment Properties, keep the default configuration and complete the module as shown in Figure 8.
    Figure 8. Service generation and deployment properties
    Service generation and deployment properties
  11. Create a Java™ component to serialize the business object received from the Oracle Business Event System and implement the method createAppsPo_Headers_AllBG as shown in the Figure 9.
    Figure 9. Java component snippet
    Java component snippet

Testing the configured module

You can deploy the module to WebSphere Process Server and use the E-Business Suite console to create a purchase order and approve it. The Oracle Workflow Business Event System will generate the "oracle.apps.po.event.xmlpo" event, as you have already subscribed to this event. A corresponding entry is created in the event table used by the adapter. The adapter picks up the corresponding event from the Oracle Business Event System and passes it to the Java component, which serializes the business object.


Conclusion

This article described how to retrieve events that are generated in the Oracle Business Event System using WebSphere Adapter for Oracle E-Business Suite. The article also provided instructions to set up the subscription in Oracle E-Business Suite and to configure the adapter to receive the events.

Resources

Learn

Discuss

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into WebSphere on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=WebSphere
ArticleID=953832
ArticleTitle=Integrating an Oracle Business Event Workflow using WebSphere Adapter for Oracle E-Business Suite
publish-date=11202013