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 Integrations

1 Understanding the Oracle Customer Master Data Management Pre-Built Integration

• 1.1 Overview
  • 1.1.1 Terminology
• 1.2 High-Level Integration Flows
  • 1.2.1 Match and Fetch Organizations or Persons
  • 1.2.2 Synchronizing Organizations or Persons
  • 1.2.3 Merge Flow
  • 1.2.4 Data Enrichment Flow
• 1.3 Core AIA Components
• 1.4 AIA Integration Services
  • 1.4.1 CustomerPartyEBSV2
  • 1.4.2 CustomerPartyResponseEBSV2
  • 1.4.3 CustomerPartyOrchestrationEBSV2
  • 1.4.4 CustomerPartyOrchestrationResponseEBSV2
  • 1.4.5 ProcessCustomerPartyEBS
  • 1.4.6 CommunicationsCustomerPartyEBSV2
  • 1.4.7 CommunicationsCustomerPartyResponseEBSV2
  • 1.4.8 FetchCustomerPartyEBF
  • 1.4.9 CommsProcessFulfillmentOrderBillingAccountListEBF
  • 1.4.10 CommsProcessBillingAccountListEBF
  • 1.4.11 InterfaceContactToAccountEBF

2 Oracle Customer Master Data Management Integration Base Pack

• 2.1 Overview
• 2.2 OCH Process Flows
  • 2.2.1 Match and Fetch Organizations and Persons between OCH and Participating Applications
  • 2.2.2 Synchronization of Organizations and Persons from OCH to Oracle E-Business Suite
  • 2.2.3 Synchronizing Organizations from OCH to Oracle E-Business Suite
  • 2.2.4 Synchronizing Persons from OCH to Oracle E-Business Suite
  • 2.2.5 Synchronization of Organizations and Persons from OCH to Siebel CRM
  • 2.2.6 Synchronizing Organizations from OCH to Siebel CRM
  • 2.2.7 Synchronizing Persons from OCH to Siebel CRM
  • 2.2.8 Synchronization of Organizations and Persons from OCH to Oracle BRM
    • 2.2.8.1 OCH Publishes Updates to BRM for New Customer Data
    • 2.2.8.2 OCH Publishes Updates to BRM for Updates to Existing Customer Data
    • 2.2.8.3 Periodic Cron-Job for Re-Syncing Customer Data from OCH to Oracle BRM
  • 2.2.9 Data Enrichment Flow
  • 2.2.10 Merge Flow from Oracle Customer Hub to Siebel CRM
    • 2.2.10.1 Merging Organizations from Oracle Customer Hub to Siebel
    • 2.2.10.2 Merging Persons from Oracle Customer Hub to Siebel CRM
  • 2.2.11 Merge Flow from OCH to Oracle E-Business Suite
  • 2.2.12 Merge Flow from OCH to Oracle BRM
• 2.3 OCH Integration Services
  • 2.3.1 SyncOrganizationUCMJMSProducer
  • 2.3.2 SyncOrganizationUCMJMSConsumer
  • 2.3.3 SyncPersonUCMJMSProducer
  • 2.3.4 SyncPersonUCMJMSConsumer
  • 2.3.5 QueryCustomerPartyListUCMProvABCSImpl
  • 2.3.6 QueryCustomerPartyUCMProvABCSImpl
  • 2.3.7 SyncOrganizationUCMReqABCSImpl
  • 2.3.8 SyncCustomerPartyListResponseUCMProvABCSImpl
  • 2.3.9 SyncPersonUCMReqABCSImpl
  • 2.3.10 ProcessPersonUCMReqABCSImpl
  • 2.3.11 SyncCustomerPartyListUCMProvABCSImpl
• 2.4 OCH Interfaces
  • 2.4.1 Inbound Web Services: Match and Fetch
  • 2.4.2 Inbound Web Services: Organization and Person Synchronization
  • 2.4.3 Outbound Web Services: Organization and Person Synchronization
• 2.5 Assumptions and Constraints

3 Oracle Customer Master Data Management Integration Option for Siebel CRM

• 3.1 Overview
  • 3.1.1 Prerequisites
• 3.2 Match and Fetch between Siebel CRM and Oracle Customer Hub
• 3.3 Synchronizing Organizations and Persons from Siebel CRM to Oracle Customer Hub
  • 3.3.1 Synchronizing Organizations from Siebel CRM to Oracle Customer Hub
  • 3.3.2 Synchronizing Persons from Siebel CRM to Oracle Customer Hub
• 3.4 Siebel CRM Integration Services
  • 3.4.1 SyncAccountSiebelAggregatorAdapter
  • 3.4.2 SyncContactSiebelAggregatorAdapter
  • 3.4.3 SyncAddressSiebelAggregatorAdapter
  • 3.4.4 SyncCustomerSiebelEventAggregator
  • 3.4.5 SyncAccountSiebelReqABCSImpl
  • 3.4.6 SyncContactSiebelReqABCSImpl
  • 3.4.7 SyncCustomerPartyListSiebelProvABCSImpl
  • 3.4.8 SyncCustomerPartyListResponseSiebelProvABCSImpl
  • 3.4.9 SyncBPSiebelAggregatorAdapter
  • 3.4.10 SyncAcctSiebelAggrEventConsumer
  • 3.4.11 SyncContSiebelAggrEventConsumer
• 3.5 Siebel CRM Interfaces
  • 3.5.1 Inbound Web Services: Organization and Person Synchronization
  • 3.5.2 Outbound Web Services: Organization and Person Synchronization
  • 3.5.3 Inbound Web Services: Match and Fetch
    • 3.5.3.1 Account Synchronization
    • 3.5.3.2 Contact Synchronization
  • 3.5.4 Outbound Web Services: Match and Fetch

4 Oracle Customer Master Data Management Integration Option for Oracle Communications BRM

• 4.1 Overview
• 4.2 Oracle BRM Interfaces
• 4.3 Oracle BRM Integration Services
  • 4.3.1 Core2CommsCustomerPartyBridge
  • 4.3.2 CommunicationsCustomerPartyEBSV2
  • 4.3.3 SyncCustomerPartyListBRMCommsProvABCSImpl
  • 4.3.4 CommunicationsCustomerPartyResponseEBSV2
  • 4.3.5 SyncCustomerPartyListBRMCommsJMSProducer
  • 4.3.6 SyncCustomerPartyListBRM_01CommsJMSConsumer

5 Oracle Customer Master Data Management Integration Option for Oracle E-Business Suite

• 5.1 Overview
  • 5.1.1 Prerequisites
• 5.2 Match and Fetch between Oracle E-Business Suite and Oracle Customer Hub
• 5.3 Synchronization of Organizations and Persons from Oracle E-Business Suite to Oracle Customer Hub
  • 5.3.1 Synchronizing Organizations from Oracle E-Business Suite to Oracle Customer Hub
  • 5.3.2 Synchronizing Persons from Oracle E-Business Suite to Oracle Customer Hub
• 5.4 Oracle E-Business Suite Integration Services
  • 5.4.1 SyncCustomerPartyListEbizProvABCSImpl
  • 5.4.2 QueryPersonAccountEbizUpdateAdapter
  • 5.4.3 QueryCustomerPartyListEbizCreateAdapter
  • 5.4.4 QueryCustomerPartyListEbizUpdateAdapter
  • 5.4.5 SyncPersonAccountEbizReqABCSImpl
  • 5.4.6 SyncPersonAccountEbizEventConsumer
  • 5.4.7 SyncCustomerPartyListEbizEventConsumer
  • 5.4.8 SyncCustomerPartyListResponseEbizProvABCSImpl
  • 5.4.9 SyncCustomerPartyListEbizAdapter
  • 5.4.10 SyncCustomerPartyListEbizReqABCSImpl
  • 5.4.11 QueryPersonAccountEbizCreateAdapter
• 5.5 Oracle E-Business Suite Interfaces
  • 5.5.1 Inbound Web Services: Fetch
  • 5.5.2 Outbound from E-Business Suite or Composite App Event Interfaces: Match and Fetch
  • 5.5.3 Inbound Web Services: Person or Organization Synchronization
  • 5.5.4 Outbound from E-Business Suite Event Interfaces: Organization or Person Synchronization

Part II Implementing the Delivered Integrations

6 Reviewing Prerequisites

• 6.1 Prerequisites: Match and Fetch Flows
• 6.2 Prerequisites: Synchronization Flows
• 6.3 Prerequisites: Merge Flows

7 Configuring the Customer MDM Pre-Built Integration

• 7.1 Configuring Siebel CRM
• 7.2 Setting Up Organizations
  • 7.2.1 Oracle Customer Hub
  • 7.2.2 Obtaining Oracle E-Business Suite Operating Unit IDs
  • 7.2.3 Mapping Siebel CRM Organizations
• 7.3 Setting Up Cross-References
  • 7.3.1 Identifying Siebel Row IDs
  • 7.3.2 Identifying Oracle E-Business Suite Entities
  • 7.3.3 Identifying Oracle Customer Hub Row IDs
  • 7.3.4 Populating Seed Values in Cross-Reference Tables
  • 7.3.5 Validating Cross-References
• 7.4 Working with Cross-References
• 7.5 Working with Domain Value Maps
• 7.6 Creating Oracle E-Business Suite System Profiles
• 7.7 Scheduling Concurrent Processes
• 7.8 Configuring Sequencing for the Synchronize Flows from Siebel CRM to Oracle Customer Hub
• 7.9 Handling Errors
• 7.10 Using the Composite Application Framework
• 7.11 Setting Configuration Properties

8 Customer Data Enrichment

• 8.1 Overview
  • 8.1.1 Prerequisites
• 8.2 Process Flow
• 8.3 Data Enrichment Integration Services
• 8.4 Working with Cross-References
• 8.5 Working with Domain Value Maps
• 8.6 Handling Errors
• 8.7 Setting Configuration Properties

9 Deploying the Match and Fetch Enterprise Composite Application with the Customer MDM Pre-Built Integration

• 9.1 Security Considerations
• 9.2 Invoking Match and Fetch from Oracle E-Business Suite
  • 9.2.1 Instructions for Oracle E-Business Suite 11.5.10.x
  • 9.2.2 Instructions for Oracle E-Business Suite 12.1.x