1/16

Contents

Title and Copyright Information

Preface

• Audience
• Accessing Oracle Documentation
• Documentation Accessibility
• Document Revision History

Part I Understanding the Delivered Integrations

1 Understanding the Product Master Data Management Integration

• About Oracle AIA and Oracle Communications Solutions Integrations
• Overview of the Product Master Data Management Integration
  • Terminology
• Overview of the Business Process Flow
• Core Oracle AIA Components
• Integration Services
  • ItemEBSV2
  • ItemResponseEBSV2
  • BillOfMaterialsEBS
  • BillOfMaterialsReponseEBS
  • PriceListEBSV2
  • PriceListResponseEBSV2
  • SpecificationValueSetEBS
  • SpecificationValueSetResponseEBS
  • ClassificationSchemeEBS
  • ClassificationSchemeResponseEBS
  • CommunicationsPriceListEBSV2
  • CommunicationsPriceListResponseEBSV2
  • CommunicationsItemCompositionEBSV1
  • CommunicationsItemCompositionResponseEBSV1

2 Product Master Data Management Integration Base Pack

• About the Integration Base Pack
• About the Process Flow for Synchronizing of Items and BOMs
  • About Chunking
  • Synchronizing Items Sub-Flow
  • Synchronizing Price Lists Sub-Flow
  • Synchronizing BOMs Sub-Flow
• Common Features Supported by the Base Pack
  • Specifying Target and Destination Systems
  • Multi-Language Support for Item Synchronization
  • Communications Seeded Library Attributes
  • Updating Publishing Status in Oracle Product Hub
• Oracle Product Hub Interfaces
• Oracle Product Hub Integration Services
  • SyncItemListPIMEventConsumer
  • SyncItemListPIMReqABCSImpl
  • QueryItemListPIMAdapter
  • QueryBillOfMaterialsListPIMAdapter
  • SyncSpecificationValueSetListPIMEventConsumer
  • SyncSpecificationValueSetListPIMReqABCSImpl
  • SyncItemCatalogCategoryPIMEventConsumer
  • SyncItemCatalogCategoryPIMReqABCSImpl
• Assumptions and Constraints for Oracle Product Hub

3 Product Master Data Management Integration Option for Siebel CRM

• About the Siebel CRM Option
• About the Process Flow for Synchronizing Item Catalog Categories
  • About Multi-Language Support for Item Catalog Categories
  • About Automatically Releasing Entities
  • About Synchronizing of Relationships and Structures
  • About Synchronizing Attribute Groups
  • About Synchronizing Customer UDAs
  • About Synchronizing Transaction Attributes
  • About Synchronizing Transaction Attributes without Valuesets
  • About Synchronizing Item Catalog Category Hierarchies
  • About Associating Item Catalog Categories with Items
  • Synchronizing Item Catalog Category Implementation Flow
• About the Process Flow for Synchronizing Valuesets
  • Synchronization of Valuesets as Part of Item Catalog Categories
  • Synchronization of Valuesets Independently
• About Other Supported Features
  • Multi-Event Product Synchronization from Oracle Product Hub to Siebel CRM
  • Support for Class Type Relationship in Product Synchronization for Siebel CRM
  • Support for Controlling Auto-Release of Entities Published in the Same Batch
  • Synchronization of Promotions from Oracle Product Hub to Siebel CRM
• Siebel CRM Interfaces
• Siebel CRM Integration Services
  • SyncProductSiebelProvABCSImpl
  • SyncBillOfMaterialsListSiebelProvABCSImpl
  • SyncClassificationSchemeListSiebelProvABCSImpl
  • SyncSpecificationValueSetListSiebelProvABCSImpl
  • ProductOptimizedSyncPriceListListSiebelCommsProvABCSImpl
  • SyncItemCompositionListSiebelCommsProvABCSImpl
• Assumptions and Constraints for the Siebel CRM Option
• Multiple Price List Methodology
  • About Price Lists and Rate Plans
  • Creating or Updating Rate Plans in Oracle Product Hub/BRM
  • Associating Rate Plans in Oracle Product Hub/BRM with Siebel CRM Price Lists
  • Offering a Product in Multiple Currencies
  • Managing Pricing in Rate Plans and Price Lists
    • Changing a Product from Multiple Price Lists to a Single Price List
    • Support for Effectivity
• Synchronizing Sponsorship Items from Oracle Product Hub to Siebel CRM
  • Sharing Group Components
    • Sponsorship
    • Discounts
    • Membership
    • Promotion Groups
  • Defining a Charge Sharing Group and Publishing to Siebel CRM
  • Defining a Charge Discount Group and Publishing to Siebel CRM
  • Synchronizing Multiple Product Lines from Oracle Product Hub to Siebel CRM
  • Synchronizing Promotion Enhancements from Oracle Product Hub to Siebel CRM
  • Integration Services
  • Cross References
  • Assumptions and Constraints

4 Product Master Data Management Integration Option for BRM

• Synchronization of Billing Products from Oracle Product Hub to BRM
  • Multi-Event Product Synchronization from Oracle Product Hub to Siebel CRM
  • Synchronizing Discounts and Discount Models to Siebel CRM and BRM
  • Viewing Publishing Status of Items
• BRM Interfaces
• BRM Integration Services
  • SyncItemListBRMProvABCSImpl
  • SyncPriceListListBRMProvABCSImpl
• Assumptions and Constraints for Oracle Communications BRM Option

5 Product Master Data Management Integration Option for Design Studio

• Overview
• Assumptions and Constraints
• Oracle Communications Design Studio Setup
• Oracle Product Hub Web Services
• Integration Services
  • QueryClassificationListPIMCommsProvABCSImpl
  • QuerySpecificationValueSetListPIMCommsProvABCSImpl
  • QueryProdClassAndAttributesSCEReqCommsABCSImpl
• Understanding the Query Item Catalog Categories Business Flow
• Query Item Catalog Categories: Implementation
  • Query Item Catalog Categories and Transaction Attributes
• Query Item Catalog Categories: Integration Flow
• Support for Effectivity during Design-Time - Methodology
  • Deciding on Effectivity and Cartridge Deployment

6 Oracle Product Master Data Management Integration Option for PDC

• Overview
• Integration Process Flow
• Synchronization of Oracle Product Hub and Pricing Design
• Integration Services
  • SyncItemListPDCProvABCSImpl
  • SyncPriceListPDCProvABCSImpl
  • CreateProductXrefBRMAQ
  • CreateSponsorXrefBRMAQ
  • CreateDiscountXrefBRMAQ
• Terminology Mapping Between Pricing Design Center and BRM
• Pre-requisites for Multi-BRM Setup
• Assumptions and Constraints

Part II Implementing the Delivered Process Integrations

7 Configuring the Oracle Product Hub Integration

• Adding a New Spoke Instance
• Post Installation Configuration Set Up
  • Extract Inventory Location and Operating Unit IDs in Oracle Product Hub
    • Identify Item Validation Organization for Oracle Product Hub
  • Mapping Siebel CRM
  • Extract Business Unit and Inventory Location IDs in Siebel CRM
• Setting Up BRM
• Setting Up Cross-References
  • Populating Seed Values in Cross-Reference Tables
  • Validating Cross-References
  • Creating a Pricelist in Siebel CRM
  • Configuring the Integration to Support 100 Characters
    • Assumptions
    • Setup in Oracle AIA
• Working with Cross-References
• Working with Domain Value Maps
• Handling Errors
• Setting Up Configuration Properties
• Setting Up the Data for Seeded Attributes of the Telecommunications Library
• Setting up List of Values in Siebel CRM

A Frequently Asked Questions

B Support for Rate Tiers and Effectivity

C User Defined Attributes Framework

• Extending for Custom UDAs
  • Handling UDAs
  • Mapping Artifacts
    • Mapping Operational Attributes to ItemEBM
    • Mapping Seeded Set of UDAs for Communications library to EBM
    • Mapping Pricelist related UDAs for Communications Library to EBM
• Implementation of UDA Transformation
  • Mapping Custom UDAs to EBM
  • Artifacts (Requester ABCS)
  • Artifacts (Siebel CRM Provider ABCS):
• Performance Optimization Using Chunking
  • Specifying the Batch Size

D Scenarios

• ASCII Code of the Item Version is Higher in Oracle Product Hub
  • Workaround
• ASCII Code of the Default Item Version is Higher in Oracle E-Business