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 Process Integration Pack for Oracle Financial Management

• 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 Financials - General Ledger
  • 1.2.3 Oracle E-Business Suite Financials - Payables
  • 1.2.4 Oracle E-Business Suite Financials - Receivables
• 1.3 Business Process Flow
• 1.4 Assumptions and Constraints

2 Process Integration for Currency Exchange Rates

• 2.1 Overview
• 2.2 Business Process Flows
  • 2.2.1 Initial Load of Currency Exchange Rates
  • 2.2.2 Incremental Updates of Currency Exchange Rates
• 2.3 Assumptions and Constraints
• 2.4 Oracle E-Business Suite Interfaces
• 2.5 Oracle Transportation Management Interfaces
• 2.6 Core Application Integration Architecture Components
• 2.7 Integration Services
  • 2.7.1 SyncCurrencyExchangeListEbizAdapter
  • 2.7.2 CurrencyExchangeEbizListJMSProducer
  • 2.7.3 CurrencyExchangeListEbizJMSConsumer
  • 2.7.4 SyncCurrencyExchangeListEbizReqABCSImpl
  • 2.7.5 CurrencyExchangeEBS
  • 2.7.6 SyncCurrencyExchangeListLogisticsProvABCSImpl
  • 2.7.7 CurrencyExchangeResponseEBS

3 Process Integration for Suppliers

• 3.1 Overview
• 3.2 Business Process Flows
  • 3.2.1 Initial Load of Suppliers
  • 3.2.2 Updating Supplier Information
• 3.3 Assumptions and Constraints
• 3.4 Oracle E-Business Suite Interfaces
• 3.5 Oracle Transportation Management Interfaces
• 3.6 Core Application Integration Architecture Components
• 3.7 Integration Services
  • 3.7.1 InitialLoadSupplierPartyListEbizAdapter
  • 3.7.2 SyncSupplierPartyListEbizAdapter
  • 3.7.3 SupplierPartyListEbizJMSProducer
  • 3.7.4 SyncSupplierPartyListEbizJMSConsumer
  • 3.7.5 SyncSupplierPartyListEbizReqABCSImpl
  • 3.7.6 SupplierPartyEBS
  • 3.7.7 SupplierPartyResponseEBS
  • 3.7.8 SyncSupplierPartyListLogisticsProvABCSImpl
  • 3.7.9 SupplierPartyResponseEBS

4 Process Integration for Payable Invoices

• 4.1 Overview
• 4.2 Business Process Flows
  • 4.2.1 Sending Payable Invoices to Oracle E-Business Suite Account Payables
• 4.3 Assumptions and Constraints
• 4.4 Oracle E-Business Suite Interfaces
• 4.5 Oracle Transportation Management Interfaces
• 4.6 Core Application Integration Architecture Components
• 4.7 Integration Services
  • 4.7.1 CreatePayableInvoiceListLogisticsAQConsumer
  • 4.7.2 CreatePayableInvoiceListLogisticsReqABCSImpl
  • 4.7.3 PayableInvoiceEBS
  • 4.7.4 CreatePayableInvoiceListEbizProvABCSImpl
  • 4.7.5 CreatePayableInvoiceListEbizDBAdapter
  • 4.7.6 UpdatePayableInvoiceListEbizXref
  • 4.7.7 PayableInvoiceResponseEBS

5 Process Integration for Receivable Bills

• 5.1 Overview
• 5.2 Business Process Flows
  • 5.2.1 Sending Receivable Bills into Oracle E-Business Suite Account Receivables
• 5.3 Assumptions and Constraints
• 5.4 Oracle E-Business Suite Interfaces
• 5.5 Oracle Transportation Management Interfaces
• 5.6 Core Application Integration Architecture Components
• 5.7 Integration Services
  • 5.7.1 CreateInvoiceListLogisticsAQConsumer
  • 5.7.2 CreateInvoiceListLogisticsReqABCSImpl
  • 5.7.3 InvoiceEBS
  • 5.7.4 CreateInvoiceListEbizProvABCSImpl
  • 5.7.5 CreateInvoiceListEbizAppsAdapter
  • 5.7.6 UpdateInvoiceListEbizXref
  • 5.7.7 InvoiceResponseEBS

6 Process Integration for Accruals and Reversals

• 6.1 Overview
• 6.2 Business Process Flows
  • 6.2.1 Accruals and Reversals Integration Details
• 6.3 Assumptions and Constraints
• 6.4 Oracle E-Business Suite Interfaces
• 6.5 Oracle Transportation Management Interfaces
• 6.6 Core Application Integration Architecture Components
• 6.7 Integration Services
  • 6.7.1 CreateAccountingEntryListLogisticsAQConsumer
  • 6.7.2 CreateAccountingEntryListLogisticsReqABCSImpl
  • 6.7.3 AccountingEntryEBS
  • 6.7.4 CreateAccountingEntryListEbizProvABCSImpl
  • 6.7.5 CreateAccountingEntryListEbizDBAdapter
  • 6.7.6 AccountingEntryResponseEBS

7 Process Integration for Customer Synchronization

• 7.1 Overview
• 7.2 Business Process Flows
  • 7.2.1 Order to Cash Integration Services
• 7.3 Assumptions and Constraints
• 7.4 Oracle E-Business Suite Interfaces
• 7.5 Oracle Transportation Management Interfaces
• 7.6 Core Application Integration Architecture Components
• 7.7 Integration Services
  • 7.7.1 CustomerPartyEBSV2
  • 7.7.2 CustomerPartyResponseEBSV2
  • 7.7.3 MergeCustomerPartyListLogisticsProvABCSImpl

Part II Implementing the Delivered Process Integrations

8 Setting Up Participating Applications

• 8.1 Setting Up Oracle Transportation Management
  • 8.1.1 Setting Up Qualifiers
  • 8.1.2 Creating Contacts in Oracle Transportation Management
  • 8.1.3 Setting Up External Systems for Queues
  • 8.1.4 Set up Automation Agents in Oracle Transportation Management
    • 8.1.4.1 Create Order Release
    • 8.1.4.2 Create Buy Shipment
    • 8.1.4.3 Modify Buy Shipment Cost
    • 8.1.4.4 Create Sell Shipment
    • 8.1.4.5 Sell Shipment Cost Modified
    • 8.1.4.6 Bill Approved
    • 8.1.4.7 Voucher Created
• 8.2 Setting Up Oracle E-Business Suite
  • 8.2.1 General Setup
  • 8.2.2 Synchronizing Currency Exchange Rates
  • 8.2.3 Synchronizing Supplier Data
  • 8.2.4 Synchronizing Payable Invoices
  • 8.2.5 Synchronizing Receivable Invoices
  • 8.2.6 Synchronizing Accruals
  • 8.2.7 Synchronizing Customers
  • 8.2.8 Setting Up Organizations
    • 8.2.8.1 Obtaining Oracle E-Business Suite Operating Unit IDs
    • 8.2.8.2 Obtaining Oracle Transportation Management Domains
    • 8.2.8.3 Creating Status Type for Location in Oracle Transportation Management
    • 8.2.8.4 Populating Cross-References
    • 8.2.8.5 Validating Cross-References

9 Data Requirements and Prerequisites

• 9.1 Process Integration for Currency Exchange Rates
• 9.2 Process Integration for Suppliers
• 9.3 Process Integration for Payables Invoices
• 9.4 Process Integration for Receivable Bills
• 9.5 Process Integration for Accruals and Reversals
• 9.6 Process Integration for Customer Synchronization

10 Performing an Initial Load

• 10.1 Initial Load of Currency Exchange Rates
  • 10.1.1 How to Start and Run Initial Load of Exchange Rates
• 10.2 Initial Load of Suppliers
  • 10.2.1 How to Start and Run Initial Load of Supplier Parties
    • 10.2.1.1 Performance Tuning Parameters
    • 10.2.1.2 Alternative Option

11 Working with Cross-References

12 Working with Domain Value Maps

13 Setting Configuration Properties

• 13.1 Currency Exchange Module
• 13.2 Logistics Module
• 13.3 Oracle E-Business Suite Module
• 13.4 SyncCurrencyExchangeListEbizReqABCSImpl
• 13.5 SyncCurrencyExchangeListLogisticsProvABCSImpl
• 13.6 SyncCustomerPartyListLogisticsProvABCSImpl
• 13.7 MergeCustomerPartyListLogisticsProvABCSImpl
• 13.8 CreatePayableInvoiceListLogisticsReqABCSImpl
• 13.9 CreatePayableInvoiceListEbizProvABCSImpl
• 13.10 CreateInvoiceListLogisticsReqABCSImpl
• 13.11 CreateInvoiceListEbizProvABCSImpl
• 13.12 CreateAccountingEntryListLogisticsReqABCSImpl
• 13.13 CreateAccountingEntryListEbizProvABCSImpl
• 13.14 SyncSupplierPartyListEbizReqABCSImpl
• 13.15 SyncSupplierPartyListLogisticsProvABCSImpl
• 13.16 Handling Errors
• 13.17 Enterprise Business Object Implementation Maps