Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Common Oracle AIA Pre-Built Integration Guides
• Documentation Accessibility
• Additional Resources

Part I Understanding the Delivered Process Integrations

1 Oracle Order Management Integration Pack for OTM, Oracle EBS, and Siebel CRM

• 1.1 Overview
  • 1.1.1 Key Benefits
  • 1.1.2 Security
• 1.2 Participating Applications
  • 1.2.1 Siebel CRM and Order Management
  • 1.2.2 Oracle Transportation Management
  • 1.2.3 Oracle E-Business Suite
• 1.3 Business Process Flows
  • 1.3.1 Synchronizing Customer Integration
  • 1.3.2 Synchronizing Location Integration
  • 1.3.3 Synchronizing Product Integration
  • 1.3.4 Querying Order Itinerary and Rate Integration
  • 1.3.5 Synchronizing Order and Order Status Integration
• 1.4 Assumptions and Constraints

2 Process Integration for Customers

• 2.1 Overview
• 2.2 Business Process Flows
  • 2.2.1 Synchronizing Account Information
• 2.3 Assumptions and Constraints
• 2.4 Siebel CRM Interfaces
• 2.5 Oracle E-Business Suite Interfaces
• 2.6 Oracle Transportation Management Interfaces
• 2.7 Core Application Integration Architecture Components
• 2.8 Integration Services
  • 2.8.1 SyncCustomerPartyListLogisticsProvABCSImpl
  • 2.8.2 JMS Topic
  • 2.8.3 SyncCustomerPartyJMSProducerV1
  • 2.8.4 SyncCustomerPartyEbizJMSConsumerV1
  • 2.8.5 SyncCustomerPartyLogisticsJMSConsumer

3 Process Integration for Location

• 3.1 Overview
• 3.2 Business Process Flows
  • 3.2.1 Synchronizing Location Information
  • 3.2.2 Overall Integration Flow
• 3.3 Assumptions and Constraints
• 3.4 Siebel CRM Interfaces
• 3.5 Oracle Transportation Management Interfaces
• 3.6 Core Application Integration Architecture Components
• 3.7 Integration Services
  • 3.7.1 AIA Transportation Stop Queue
  • 3.7.2 SyncTransportationStopSiebelJMSConsumer
  • 3.7.3 SyncTransportationStopListSiebelReqABCSImpl
  • 3.7.4 TransportationStopEBS
  • 3.7.5 TransportationStopResponseEBS
  • 3.7.6 SyncTransportationStopListLogisticsProvABCSImpl
  • 3.7.7 SyncTransportationStopAddressSiebelAggregatorAdapterConsumer
  • 3.7.8 SyncTransportationStopContactSiebelAggregatorAdapterConsumer
  • 3.7.9 SyncTransportationStopAggregatorRoutingService

4 Process Integration for Product

• 4.1 Overview
• 4.2 Business Process Flows
  • 4.2.1 Synchronizing Product Information
    • 4.2.1.1 Product Synchronization
• 4.3 Assumptions and Constraints
• 4.4 Siebel CRM Interfaces
• 4.5 Oracle Transportation Management Interfaces
• 4.6 Core Application Integration Architecture Components
• 4.7 Integration Services
  • 4.7.1 Siebel Product Queue
  • 4.7.2 SyncItemSiebelConsumer
  • 4.7.3 SyncItemListSiebelReqABCSImpl
  • 4.7.4 ItemEBS
  • 4.7.5 SyncItemListLogisticsProvABCSImpl

5 Process Integration for Query Transportation Order Itinerary

• 5.1 Overview
• 5.2 Business Process Flows
  • 5.2.1 Query Transportation Order Itinerary Process
  • 5.2.2 Query Transportation Sales Order Itinerary List
• 5.3 Assumptions and Constraints
• 5.4 Siebel CRM Interfaces
• 5.5 Oracle Transportation Management Interfaces
• 5.6 Core Application Integration Architecture Components
• 5.7 Integration Services
  • 5.7.1 QueryTransportationSalesOrderItineraryListSiebelReqABCSImpl
  • 5.7.2 TransportationSalesOrderEBS
  • 5.7.3 QueryTransportationSalesOrderItineraryListLogisticsProvABCSImpl

6 Process Integration for Order

• 6.1 Overview
• 6.2 Business Process Flows
  • 6.2.1 Synchronizing Order Information
• 6.3 Assumptions and Constraints
• 6.4 Siebel CRM Interfaces
• 6.5 Oracle Transportation Management Interfaces
• 6.6 Core Application Integration Architecture Components
• 6.7 Integration Services
  • 6.7.1 AIA Transportation Sales Order Queue
  • 6.7.2 TransportationSalesOrderListSiebelConsumer
  • 6.7.3 SyncTransportationSalesOrderListSiebelReqABCSImpl
  • 6.7.4 TransportationSalesOrderEBS
  • 6.7.5 TransportationSalesOrderResponseEBS
  • 6.7.6 SyncTransportationSalesOrderListLogisticsProvABCSImpl

7 Process Integration for Order Status

• 7.1 Overview
• 7.2 Business Process Flows
  • 7.2.1 Integration Flow
• 7.3 Assumptions and Constraints
• 7.4 Siebel CRM Interfaces
• 7.5 Oracle Transportation Management Interfaces
• 7.6 Core Application Integration Architecture Components
• 7.7 Integration Services
  • 7.7.1 UpdateTransportationSalesOrderListLogisticsReqABCSImpl
  • 7.7.2 TransportationSalesOrderEBS
  • 7.7.3 TransportationSalesOrderResponseEBS
  • 7.7.4 UpdateTransportationSalesOrderListSiebelProvABCSImpl
  • 7.7.5 UpdatePlannedShipmentLogisticsAQConsumer

Part II Configuring the Delivered Process Integrations

8 Setting Up Participating Applications

• 8.1 Setting Up Oracle E-Business Suite
  • 8.1.1 Obtaining Oracle E-Business Suite Operating Unit IDs
• 8.2 Setting Up Siebel CRM
  • 8.2.1 Mapping Siebel CRM Organizations
• 8.3 Setting Up Oracle Transportation Management
  • 8.3.1 Obtaining Oracle Transportation Management Domains
  • 8.3.2 Creating Status Type for Location in Oracle Transportation Management
  • 8.3.3 Creating Contacts in Oracle Transportation Management
  • 8.3.4 Setting Up External Systems for Queues
• 8.4 Creating Oracle E-Business Suite System Profiles
  • 8.4.1 Creating System Profile Values for the Customer Integration
• 8.5 Setting Up Cross-References for Siebel IDs, Oracle E-Business Suite Entities, and Oracle Transportation Management Domains
  • 8.5.1 Identifying Siebel Row IDs
  • 8.5.2 Identifying Oracle E-Business Suite Entities
  • 8.5.3 Populating Cross-References
• 8.6 Setting Up Cross-References for Accessorial and Special Services Products
  • 8.6.1 Identifying Siebel Row IDs
  • 8.6.2 Identifying Cross-Reference Row Number
  • 8.6.3 Create the Accessorials/Special Services in Oracle Transportation Management
  • 8.6.4 Populating Cross-References

9 Data Requirements and Prerequisites

• 9.1 Customer Integration
• 9.2 Location Integration
• 9.3 Order Integration
• 9.4 Order Status Integration
• 9.5 Product Integration
• 9.6 Query Transportation Order Itinerary Integration

10 Working with Cross-References

11 Working with Domain Value Maps

12 Setting Configuration Properties

• 12.1 SyncCustomerPartyListLogisticsProvABCSImpl
• 12.2 SyncTransportationStopListLogisticsProvABCSImpl
• 12.3 SyncTransportationStopContactSiebelAggregatorAdapterConsumer
• 12.4 SyncTransportationStopAddressSiebelAggregatorAdapter
• 12.5 SyncTransportationStopListSiebelReqABCSImpl
• 12.6 SyncTransportationSalesOrderListLogisticsProvABCSImpl
• 12.7 SyncTransportationSalesOrderListSiebelReqABCSImpl
• 12.8 UpdateTransportationSalesOrderListSiebelProvABCSImpl
• 12.9 UpdateTransportationSalesOrderListLogisticsReqABCSImpl
• 12.10 SyncItemListSiebelReqABCSImpl
• 12.11 SyncItemListLogisticsProvABCSImpl
• 12.12 QueryTransportationSalesOrderItineraryListSiebelReqABCSImpl
• 12.13 QueryTransportationSalesOrderItineraryListLogisticsProvABCSImpl
• 12.14 Handling Errors
• 12.15 Enterprise Business Object Implementation Maps