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
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:
- Access your Oracle E-Business Suite application instance as the user "SYSADMIN".
- Select the Workflow Administrator Web Applications responsibility role.
- Select the Administrator Workflow > Business Events menu.
- Select the Subscriptions submenu.
- Click the Create Subscription button.
- Fill in the subscription details as shown in Figure 2.
Figure 2. 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.
- Switch to the Business Integration perspective in IBM Integration Designer.
- 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.
- Select IBM WebSphere Adapter for Oracle E-Business Suite (220.127.116.11) and click Next.
- In the "Locate the Required Files and Libraries" window, add the Oracle JDBC driver and click Next.
- Select the processing direction as Inbound.
- 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
- In the Find Objects in the Enterprise System page:
- Open the Edit Query dialog box, enter the
APPS, select the Prompt for additional configuration settings when adding business object, and click OK.
- Click Run Query. The query results are listed in the Discovered objects.
- Open the Edit Query dialog box, enter the Schema filter
- 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
- 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
- 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
Figure 6. 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
- 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.
- 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.
- 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
- Create a Java™ component to serialize the business object
received from the Oracle Business Event System and implement the
createAppsPo_Headers_AllBGas shown in the Figure 9.
Figure 9. 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.
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.
- IBM Business Process Manager Information Center
- WebSphere Adapter for Oracle E-Business Suite Information Center
- WebSphere Adapters product page
- WebSphere Process Server and WebSphere Integration Developer resource page