Contents

List of Examples

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
• Master Notes
• Additional Resources

Part I Understanding the Delivered Integrations

1 Understanding the Oracle Product Master Data Management Integration

• 1.1 Overview
  • 1.1.1 Terminology
• 1.2 Process Flows
• 1.3 Core AIA Components
• 1.4 Integration Services
  • 1.4.1 ItemEBSV2
  • 1.4.2 ItemResponseEBSV2
  • 1.4.3 BillOfMaterialsEBS
  • 1.4.4 BillOfMaterialsReponseEBS
  • 1.4.5 PriceListEBSV2
  • 1.4.6 PriceListResponseEBSV2
  • 1.4.7 SpecificationValueSetEBS
  • 1.4.8 SpecificationValueSetResponseEBS
  • 1.4.9 ClassificationSchemeEBS
  • 1.4.10 ClassificationSchemeResponseEBS
  • 1.4.11 CommunicationsPriceListEBSV2
  • 1.4.12 CommunicationsPriceListResponseEBSV2
  • 1.4.13 CommunicationsItemCompositionEBSV1
  • 1.4.14 CommunicationsItemCompositionResponseEBSV1

2 Oracle Product Master Data Management Integration Base Pack

• 2.1 Supported Features and Process Flows
  • 2.1.1 Common Features
• 2.2 Synchronization of Items and BOMs
• 2.3 Common Features Supported by the Base Pack across Process Flows
  • 2.3.1 Support for Routing Driven Through Explicit Specification of Target Systems
  • 2.3.2 Support for Multi-Language for Item Synchronization
  • 2.3.3 Support for Telecommunications Seeded Library Attributes
    • 2.3.3.1 Sellable Product Information Library-Horizontal
    • 2.3.3.2 Product Management Library-Horizontal
    • 2.3.3.3 Communications Services Billing Library-Vertical
    • 2.3.3.4 Communications Product Details Library - Vertical
    • 2.3.3.5 Component UDA for Item Synchronization
    • 2.3.3.6 Support for Multi-Row Attribute Groups
  • 2.3.4 Controlling Publishing of Items to Target System Instances
  • 2.3.5 Methodology to Set the Value for the Description System Specification Attribute Group
  • 2.3.6 Support for Updating Publishing Status in OPH upon Publication of Items
• 2.4 Oracle Product Hub Interfaces
• 2.5 Oracle Product Hub Integration Services
  • 2.5.1 Synchronize Item
  • 2.5.2 Synchronize Price List
  • 2.5.3 Synchronize Bill of Materials
  • 2.5.4 QueryItemListPIMAdapter
  • 2.5.5 QueryBillOfMaterialsListPIMAdapter
  • 2.5.6 SyncSpecificationValueSetListPIMEventConsumer
  • 2.5.7 SyncSpecificationValueSetListPIMReqABCSImpl
• 2.6 Assumptions and Constraints for OPH

3 Oracle Product Master Data Management Integration Option for Siebel CRM

• 3.1 Supported Features
  • 3.1.1 Synchronization of Metadata
  • 3.1.2 Synchronization of Item Catalog Categories
  • 3.1.3 Synchronization of Relationships and Structure Under Item Catalog Categories
  • 3.1.4 Synchronization of Attribute Groups as Part of Item Catalog Categories
  • 3.1.5 Synchronization of Customer UDA as Part of Item Catalog Categories
  • 3.1.6 Synchronization of Transaction Attributes as Part of Item Catalog Categories
  • 3.1.7 Transaction Attributes without Valuesets
  • 3.1.8 Synchronization of Item Catalog Category Hierarchies
  • 3.1.9 Association of Item Catalog Category with Items
  • 3.1.10 Publishing of Item Catalog Category from OPH to Siebel CRM Implementation Flow
  • 3.1.11 Synchronization of Valuesets
  • 3.1.12 Synchronization of Valuesets as Part of Item Catalog Categories
  • 3.1.13 Synchronization of Valuesets Independently
  • 3.1.14 Batch and Initial Load
  • 3.1.15 Multi Language Support for Valueset Synchronization
  • 3.1.16 Synchronization of Products, Discounts, and Associated Structures from Oracle Product Hub to Siebel CRM
  • 3.1.17 Multi-Event Product Synchronization from OPH to Siebel
  • 3.1.18 Support for Class Type Relationship in Product Synchronization for Siebel CRM
  • 3.1.19 Support for Controlling Auto-Release of Entities Published from Oracle Product Hub in the Same Batch for Siebel
  • 3.1.20 Synchronization of Promotions from Product Hub to Siebel CRM
• 3.2 Siebel CRM Interfaces
• 3.3 Siebel CRM Integration Services
  • 3.3.1 SyncProductSiebelProvABCSImpl
  • 3.3.2 SyncBillOfMaterialsListSiebelProvABCSImpl
  • 3.3.3 SyncClassificationSchemeListSiebelProvABCSImpl
  • 3.3.4 SyncSpecificationValueSetListSiebelProvABCSImpl
  • 3.3.5 ProductOptimizedSyncPriceListListSiebelCommsProvABCSImpl
  • 3.3.6 SyncItemCompositionListSiebelCommsProvABCSImpl
• 3.4 Assumptions and Constraints for the Siebel CRM Option
• 3.5 Multiple Price List Methodology
  • 3.5.1 About Price Lists and Rate Plans
  • 3.5.2 Creating or Updating Rate Plans in OPH/BRM
  • 3.5.3 Associating Rate Plans in OPH/BRM with Siebel CRM Price Lists
  • 3.5.4 Offering a Product in Multiple Currencies
  • 3.5.5 Managing Pricing in Rate Plans and Price Lists
    • 3.5.5.1 Changing a Product from Multiple Price Lists to a Single Price List
    • 3.5.5.2 Support for Effectivity

4 Oracle Product Master Data Management Integration Option for Oracle E-Business Suite

• 4.1 Overview
  • 4.1.1 Support for Operational Attributes
• 4.2 Synchronizing Items and BOMs from Oracle Product Hub to Oracle E-Business Suite
• 4.3 Oracle E-Business Suite Interfaces
• 4.4 Oracle E-Business Suite Integration Services
  • 4.4.1 SyncItemListEbizProvABCSImpl
  • 4.4.2 SyncBillOfMaterialsListEbizProvABCSImpl
  • 4.4.3 SyncItemListEbizAdapter
  • 4.4.4 SyncBillOfMaterialsListEbizAdapter
  • 4.4.5 TransformAppContextEbizService
  • 4.4.6 QueryResponsibilityEbizAdapter
• 4.5 Assumptions and Constraints for the Oracle E-Business Suite Option

5 Oracle Product Master Data Management Integration Option for Oracle Communications BRM

• 5.1 Synchronization of Billing Products from Oracle Product Hub to Oracle BRM
  • 5.1.1 Multi-Event Product Synchronization from OPH to Siebel
  • 5.1.2 Synchronization of Discounts and Discount Models from Oracle Product Hub to Siebel CRM and Oracle BRM
  • 5.1.3 Viewing Publishing Status of Items
• 5.2 Oracle BRM Interfaces
• 5.3 Oracle BRM Integration Services
  • 5.3.1 SyncItemListBRMProvABCSImpl
  • 5.3.2 SyncPriceListListBRMProvABCSImpl
• 5.4 Assumptions and Constraints for the Oracle Communications BRM Option

6 Oracle Product Master Data Management Integration Option for Oracle Communications Design Studio

• 6.1 Overview
• 6.2 Assumptions and Constraints
• 6.3 Oracle Communications Design Studio Setup
• 6.4 Oracle Product Hub Web Services
• 6.5 Integration Services
  • 6.5.1 QueryClassificationListPIMCommsProvABCSImpl
  • 6.5.2 QuerySpecificationValueSetListPIMCommsProvABCSImpl
  • 6.5.3 QueryProdClassAndAttributesSCEReqCommsABCSImpl
• 6.6 Understanding the Query Item Catalog Categories Business Flow
• 6.7 Query Item Catalog Categories: Implementation
  • 6.7.1 Query ICCs and Transaction Attributes
• 6.8 Query Item Catalog Categories: Integration Flow
• 6.9 Support for Effectivity during Design-Time - Methodology
  • 6.9.1 Deciding on Effectivity and Cartridge Deployment

Part II Implementing the Delivered Process Integrations

7 Configuring the Oracle Product Hub Integration

• 7.1 Adding a New Spoke Instance
• 7.2 Post Installation Configuration Set Up
  • 7.2.1 Extract Inventory Organization and Operating Unit IDs in Oracle E-Business Suite
    • 7.2.1.1 Identify the Item Validation Organization for Oracle E-Business Suite
  • 7.2.2 Extract Inventory Location and Operating Unit IDs in Oracle Product Hub
    • 7.2.2.1 Identify Item Validation Organization for Oracle Product Hub
  • 7.2.3 Mapping Siebel CRM
  • 7.2.4 Extract Business Unit and Inventory Location IDs in Siebel CRM
• 7.3 Setting Up Oracle BRM
• 7.4 Setting Up Cross-References
  • 7.4.1 Populating Seed Values in Cross-Reference Tables
  • 7.4.2 Validating Cross-References
  • 7.4.3 Creating a Pricelist in Siebel
• 7.5 Working with Cross-References
• 7.6 Working with Domain Value Maps
• 7.7 Handling Errors
• 7.8 Setting Configuration Properties
  • 7.8.1 Settings for the SyncItemListEbizProvABCSImpl service
  • 7.8.2 Settings for the SyncProductSiebelProvABCSImpl service
  • 7.8.3 Settings for the SyncBillOfMaterialsListEbizProvABCSImpl service
  • 7.8.4 Settings for the SyncBillOfMaterialsListSiebelProvABCSImpl service
  • 7.8.5 Settings for the SyncItemListPIMReqABCSImpl service
  • 7.8.6 Settings for SyncSpecificationValueSetListSiebelProvABCSImpl service
  • 7.8.7 Settings for the SyncItemListBRMProvABCSImpl service
  • 7.8.8 Settings for the SyncPriceListListBRMProvABCSImpl service
  • 7.8.9 Settings for the QueryBillOfMaterialsListPIMAdapter service
  • 7.8.10 Settings for the QueryItemListPIMAdapter service
  • 7.8.11 Settings for the SyncSpecificationValueSetListPIMReqABCSImpl service
  • 7.8.12 Settings for the SyncItemCatalogCategoryPIMReqABCSImpl service
  • 7.8.13 Settings for the SyncClassificationSchemeListSiebelProvABCSImpl service
  • 7.8.14 Settings for the SyncClassificationSchemeListSiebelProvABCSImpl service
  • 7.8.15 Settings for the ProductOptimizedSyncPriceListListSiebelCommsProvABCSImpl service
  • 7.8.16 Settings for the SyncItemCompositionListSiebelCommsProvABCSImpl service
• 7.9 Setting Up the Data for Seeded Attributes of the Telecommunications Library
• 7.10 Setting up List of Values in Siebel

A Frequently Asked Questions

B Support for Rate Tiers and Effectivity

C Scenarios

• C.1 ASCII Code of the item version is set same in OPH and Oracle E-Business Suite
• C.2 ASCII Code of the item version is set higher in OPH and is set lower in Oracle E-Business Suite
  • C.2.1 Assumption
  • C.2.2 Workaround
• C.3 ASCII Code of the default item version is set higher in Oracle E-Business Suite and is set lower in OPH

D User Defined Attributes Framework

• D.1 Extending for Custom UDAs
  • D.1.1 Handling UDAs
  • D.1.2 Mapping Artifacts
    • D.1.2.1 Mapping Operational Attributes to ItemEBM
    • D.1.2.2 Mapping Seeded Set of UDAs for Communications library to EBM
    • D.1.2.3 Mapping Pricelist related UDAs for Communications Library to EBM
• D.2 Implementation of UDA Transformation
  • D.2.1 Mapping Custom UDAs to EBM
  • D.2.2 Artifacts (Requester ABCS)
  • D.2.3 Artifacts (Siebel Provider ABCS):
• D.3 Performance Optimization Using Chunking
  • D.3.1 Specifying the Batch Size