Skip Headers
Oracle® Application Integration Architecture Order Management Integration Pack for Oracle Transportation Management, Oracle E-Business Suite and Siebel CRM Implementation Guide
Release 3.1.1

Part Number E20504-05
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

4 Process Integration for Product

This chapter provides an overview of the process integration for product and includes the following sections:

4.1 Overview

In Transportation Order Management process integration pack (PIP), Siebel has four different types of products:

Whenever a product is created or updated in Siebel, a synchronization flow is initiated to route these to AIA layer. However, AIA routes only the product type of commodity to OTM.

For every commodity type product from Siebel, these objects are created, updated, or both in OTM:

One-to-one mapping should exist among the item, commodity, and packaged item in OTM.

The process integration for product supports these integration flows:

4.2 Business Process Flows

Figure 4-1 shows the product process integration:

Figure 4-1 Product Process Integration Flow

Description of Figure 4-1 follows
Description of "Figure 4-1 Product Process Integration Flow"

Whenever a product is created, updated, or both in Siebel, Siebel sends a message in their schema in a queue. AIA receives the message and converts it to the EBM format, and then converts the EBO into appropriate Oracle Transportation Management (OTM) format and finally sends it to OTM.

One-to-one mapping should exist among the item, commodity, and packaged item in OTM.

4.2.1 Synchronizing Product Information

When a product of type commodity is created or updated in Siebel, the updated record must be synchronized to OTM.

Figure 4-2 shows the synchronization of a product details from Siebel to OTM:

Figure 4-2 Synchronizing Product Information from Siebel to OTM Sequence Diagram

Description of Figure 4-2 follows
Description of "Figure 4-2 Synchronizing Product Information from Siebel to OTM Sequence Diagram" Product Synchronization

The synchronization flow is described here:

  1. Whenever a product is created or updated, Siebel publishes a product application business message (ABM).

  2. The Siebel requester ABCS receives this message, transforms the ABM to enterprise business message (EBM), updates the Siebel, and invokes the ItemEBS service.

  3. The ItemEBS service routs this message to Oracle Transportation Management (OTM) Provider ABCS.

  4. OTM Provider ABCS receives this enterprise business message (EBM), checks if the product type is commodity. If so, it transforms to OTM commodity ABM and invokes the OTM web service. It then waits for the transmission report from OTM.

  5. After the transmission report is received, the OTM provider ABCS checks the status. If status is OK, it updates the OTM column in the ITEM_ITEMID cross-reference with the commodity GID.

4.3 Assumptions and Constraints

These are the solution assumptions and constraints:

4.4 Siebel CRM Interfaces

Use the Siebel product schema for this integration.

4.5 Oracle Transportation Management Interfaces

OTM provides an interface through a web service to connect to its application. This connectivity is established as a partner link in the provider service. The logistics web service immediately returns an acknowledgment with a transmission number. After processing is complete, it then sends a transmission report back indicating success or failure.

4.6 Core Application Integration Architecture Components

The integration flow uses these components:

The core enterprise business object (EBO) and enterprise business message (EBM) XSD files can be located by EBO within the $AIA_HOME/AIAMetaData/AIAComponents/EnterpriseObjectLibrary/Core/EBO/ parent folder.

The core enterprise business services (EBS) web services definition language (WSDL) files can be located by EBO within the $AIA_HOME/AIAMetaData/AIAComponents/EnterpriseBusinessServiceLibrary/Core/EBO/ parent folder.

For detailed documentation of individual EBOs and EBMs, click AIA Reference Doc link on EBO and EBM detail pages in the Oracle Enterprise Repository.

For more information about using the Oracle Enterprise Repository and configuring it to provide the AIA Reference Doc link, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Configuring and Using Oracle Enterprise Repository as the Oracle AIA SOA Repository."

EBOs can be extended, for instance, to add new data elements. These extensions are protected, and remain intact after a patch or an upgrade.

For more information, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Extensibility for AIA Artifacts".

4.7 Integration Services

These are the services delivered with this integration:

4.7.1 Siebel Product Queue

Siebel Product Queue is used to queue Siebel product messages. This queue can reside on any Oracle database. For this integration, the AIA database is used as the place for this queue.

4.7.2 SyncItemSiebelConsumer

This service is invoked the moment Oracle Transportation Management (OTM) enqueues a message into AIA_SiebelItemJMSQueueV1 queue. This service routes and invokes the SyncItemListSiebelReqABCSImpl process.

4.7.3 SyncItemListSiebelReqABCSImpl

The SyncItemListSiebelReqABCSImpl is a BPEL process. This process receives the Siebel Product application business message (ABM) as input from Siebel system, transforms it to the SyncItemListEBM message, and invokes the ItemEBS service. In this transformation, in addition to mapping, the enterprise business message (EBM) Header and the cross-reference tables are populated.

4.7.4 ItemEBS

ItemEBS is the Enterprise Business Service to route all item related operations.

4.7.5 SyncItemListLogisticsProvABCSImpl

SyncItemListLogisticsProvABCSImpl is a BPEL Process. This process receives the SyncItemListEBM as input from the ItemEBS, transforms the input into the LogisticsWebServiceABM and invokes the LogisticsWebService. When logistics sends the transmission report and the status in the transmission report is success, it updates the cross-reference tables with OTM IDs.