Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• What's New in this Guide
• Common Oracle AIA Pre-Built Integration Guides
• Documentation Accessibility
• Additional Resources

Part I Understanding the Delivered Process Integrations

1 Oracle Driver Management for OTM and Oracle E-Business Suite

• 1.1 Overview
  • 1.1.1 Key Benefits
  • 1.1.2 Security
• 1.2 Participating Applications
  • 1.2.1 Oracle Transportation Management
  • 1.2.2 Oracle E-Business Suite
    • 1.2.2.1 Oracle HRMS
    • 1.2.2.2 Oracle Human Resources
    • 1.2.2.3 Oracle Learning Management
    • 1.2.2.4 Oracle Incentive Compensation
• 1.3 Business Process Flows
  • 1.3.1 Assumptions and Constraints

2 Process Integration for Driver Profile

• 2.1 Overview
• 2.2 Business Process Flows
• 2.3 Driver Profile Integration Details
  • 2.3.1 Initial Load of Driver Information
  • 2.3.2 Updating Driver Profile Information
• 2.4 Assumptions and Constraints
• 2.5 Oracle E-Business Suite Interfaces
  • 2.5.1 SyncWorkerListEbizInitialLoad
  • 2.5.2 SyncWorkerListEbizGroupEventAdapter
  • 2.5.3 SyncWorkerListEbizEventAggregator
  • 2.5.4 SyncWorkerListBPELAggregator
  • 2.5.5 SyncWorkerListEbizJMSProducer
  • 2.5.6 SyncWorkerListEbizJMSConsumer
• 2.6 Oracle Transportation Management Interfaces
• 2.7 Core Application Integration Architecture Components
• 2.8 Integration Services
  • 2.8.1 SyncWorkerListEbizReqABCSImpl
  • 2.8.2 WorkerEBS
  • 2.8.3 SyncWorkerListLogisticsProvABCSImpl

3 Process Integration for Locations

• 3.1 Business Process Flows
• 3.2 Locations Integration Details
  • 3.2.1 Initial Load of Location Information
  • 3.2.2 Updating Location Information
• 3.3 Assumptions and Constraints
• 3.4 Oracle E-Business Suite Interfaces
  • 3.4.1 SyncLocationListInitialLoadDBAdapter
  • 3.4.2 CreateLocationListEbizAdapter
  • 3.4.3 UpdateLocationListEbizAdapter
  • 3.4.4 SyncLocationListEbizGetABM
  • 3.4.5 SyncLocationListEbizJMSProducer
  • 3.4.6 SyncLocationListEbizJMSConsumer
• 3.5 Oracle Transportation Management Interfaces
• 3.6 Core Application Integration Architecture Components
• 3.7 Integration Services
  • 3.7.1 SyncLocationListEBizReqABCSImpl
  • 3.7.2 LocationEBS
  • 3.7.3 SyncLocationListLogisticsProvABCSImpl

4 Process Integration for Training and Absence Calendar

• 4.1 Overview
• 4.2 Business Process Flows
• 4.3 Training and Absence Calendar Integration Details
  • 4.3.1 Initial Load of Training Calendar
  • 4.3.2 Updating the Training Calendar
  • 4.3.3 Initial Load of Absence Calendar
  • 4.3.4 Updating the Absence Calendar
  • 4.3.5 Assumptions and Constraints
  • 4.3.6 Oracle E-Business Suite Interfaces
  • 4.3.7 SyncTrainingCalendarListInitialLoadDBAdapter
  • 4.3.8 SyncAbsenceCalendarListInitialLoadDBAdapter
  • 4.3.9 CreateDelegateBookingEbizAdapter
  • 4.3.10 CreateAbsenceAttendanceEBizAdapter
  • 4.3.11 UpdateDelegateBookingEbizAdapter
  • 4.3.12 UpdateClassScheduleEbizAdapter
  • 4.3.13 UpdateLocationListEbizAdapter
  • 4.3.14 UpdateTrainingCenterandLocationEBizAdapter
  • 4.3.15 UpdateAbsenceAttendanceEBizAdapter
  • 4.3.16 DeleteDelegateBookingEBizAdapter
  • 4.3.17 DeleteAbsenceAttendanceEBizAdapter
  • 4.3.18 SyncTrainingCalendarListProcess
  • 4.3.19 SyncAbsenceCalendarListProcess
  • 4.3.20 SyncTrainingCalendarListEbizJMSProducer
  • 4.3.21 SyncTrainingCalendarListEbizJMSConsumer
  • 4.3.22 SyncAbsenceCalendarListEbizJMSProducer
  • 4.3.23 SyncAbsenceCalendarListEbizJMSConsumer
• 4.4 Oracle Transportation Management Interfaces
• 4.5 Core Application Integration Architecture Components
• 4.6 Integration Services
  • 4.6.1 SyncTrainingCalendarListEbizReqABCSImpl
  • 4.6.2 SyncAbsenceCalendarListEbizReqABCSImpl
  • 4.6.3 ResourceCalendarEntryEBS
  • 4.6.4 SyncResourceCalendarEntryListLogisticsProvABCSImpl

5 Process Integration for Work Invoice

• 5.1 Overview
• 5.2 Updating Work Invoices
• 5.3 Work Invoice Integration Details
  • 5.3.1 Work Invoice Transaction Flow
  • 5.3.2 Assumptions and Constraints
• 5.4 Oracle E-Business Suite Interfaces
  • 5.4.1 CalculateDriverIncentiveCompensationListEBIZAdapter
• 5.5 Oracle Transportation Management Interfaces
  • 5.5.1 CalculateDriverIncentiveCompensationListLogisticsAQConsumer
• 5.6 Core Application Integration Architecture Components
• 5.7 Integration Services
  • 5.7.1 CalculateDriverIncentiveCompensationListLogisticsReqABCSImpl
  • 5.7.2 CalculateDriverIncentiveCompensationListEBIZProvABCSImpl
  • 5.7.3 PayableInvoiceEBS
  • 5.7.4 PayableInvoiceResponseEBS

Part II Configuring the Delivered Process Integrations

6 Setting up Participating Applications

• 6.1 Setting Up Oracle E-Business Suite
  • 6.1.1 Obtaining Oracle E-Business Suite Operating Unit IDs
  • 6.1.2 Obtaining Oracle Transportation Management Domains
• 6.2 Setting Up Oracle Transportation Management
  • 6.2.1 Creating a Calendar Event Type in Oracle Transportation Management
  • 6.2.2 Creating a Driver Status Type in Oracle Transportation Management
  • 6.2.3 Creating a Remark Qualifier GID in Oracle Transportation Management
  • 6.2.4 Creating an Involved Party Qualifier ID in Oracle Transportation Management
  • 6.2.5 Creating a Special Service GID in Oracle Transportation Management
  • 6.2.6 Creating Contacts in Oracle Transportation Management
  • 6.2.7 Setting Up External Systems for Queues
• 6.3 Setting Up Cross-References for Oracle E-Business Suite Entities
  • 6.3.1 Identifying Oracle E-Business Suite Entities
  • 6.3.2 Populating Cross-References
  • 6.3.3 Populating Cross-References
  • 6.3.4 Enabling Oracle E-Business Suite Business Events
  • 6.3.5 Validating Cross-References

7 Data Requirements and Prerequisites

• 7.1 Driver Profile Integration
  • 7.1.1 Location Integration
  • 7.1.2 Training and Absence Calendar Integration
  • 7.1.3 Work Invoice Integration

8 Working with Cross-References

• 8.1 Cross-references for OTM Profiles
  • 8.1.1 Driver Profile Process Flow
  • 8.1.2 Location Process Flow
  • 8.1.3 Training and Absence Calendar Process Flow
  • 8.1.4 Work Invoice Process Flow

9 Working with Domain Value Maps

• 9.1 Domain Value Maps
  • 9.1.1 Driver Profiles Process Flow
  • 9.1.2 Location Process Flow
  • 9.1.3 Training and Absence Calendar Process Flow
  • 9.1.4 Work Invoice Process Flow

10 Setting Configuration Properties

• 10.1 SyncWorkerListEbizReqABCSImpl
• 10.2 SyncWorkerListLogisticsProvABCSImpl
• 10.3 SyncWorkerListBPELAggregator
• 10.4 SyncWorkerListEbizInitialLoad
• 10.5 SyncLocationListEbizReqABCSImpl
• 10.6 SyncLocationListLogisticsProvABCSImpl
• 10.7 SyncLocationListEbizReqABCSImpl
• 10.8 SyncLocationListLogisticsProvABCSImpl
• 10.9 SyncTrainingCalendarListEbizReqABCSImpl
• 10.10 SyncAbsenceCalendarListEbizReqABCSImpl
• 10.11 SyncResourceCalendarEntryListLogisticsProvABCSImpl
• 10.12 CalculateDriverIncentiveCompensationListLogisticsReqABCSImpl
• 10.13 CalculateDriverIncentiveCompensationListEbizProvABCSImpl
• 10.14 Handling Errors
• 10.15 Enterprise Business Object Implementation Maps