1/19
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
3.6
Synchronizing Sponsorship Items from OPH to Siebel CRM
3.6.1
Sharing Group Components
3.6.1.1
Sponsorship
3.6.1.2
Discounts
3.6.1.3
Membership
3.6.1.4
Promotion Groups
3.6.2
Defining a Charge Sharing Group in OPH and Publishing to Siebel CRM
3.6.3
Defining a Charge Discount Group in OPH and Publishing to Siebel CRM
3.6.4
Synchronizing Multiple Product Lines from OPH to Siebel CRM
3.6.5
Synchronizing Promotion Enhancements from OPH to Siebel CRM
3.6.6
Integration Services
3.6.7
Cross References
3.6.8
Assumptions and Constraints
4
Oracle Product Master Data Management Integration Option for Oracle Communications BRM
4.1
Synchronization of Billing Products from Oracle Product Hub to Oracle BRM
4.1.1
Multi-Event Product Synchronization from OPH to Siebel
4.1.2
Synchronization of Discounts and Discount Models from Oracle Product Hub to Siebel CRM and Oracle BRM
4.1.3
Viewing Publishing Status of Items
4.2
Oracle BRM Interfaces
4.3
Oracle BRM Integration Services
4.3.1
SyncItemListBRMProvABCSImpl
4.3.2
SyncPriceListListBRMProvABCSImpl
4.4
Assumptions and Constraints for the Oracle Communications BRM Option
5
Oracle Product Master Data Management Integration Option for Oracle Communications Design Studio
5.1
Overview
5.2
Assumptions and Constraints
5.3
Oracle Communications Design Studio Setup
5.4
Oracle Product Hub Web Services
5.5
Integration Services
5.5.1
QueryClassificationListPIMCommsProvABCSImpl
5.5.2
QuerySpecificationValueSetListPIMCommsProvABCSImpl
5.5.3
QueryProdClassAndAttributesSCEReqCommsABCSImpl
5.6
Understanding the Query Item Catalog Categories Business Flow
5.7
Query Item Catalog Categories: Implementation
5.7.1
Query ICCs and Transaction Attributes
5.8
Query Item Catalog Categories: Integration Flow
5.9
Support for Effectivity during Design-Time - Methodology
5.9.1
Deciding on Effectivity and Cartridge Deployment
6
Oracle Product Master Data Management Integration Option for Oracle Communications Pricing Design Center
6.1
Overview
6.2
Integration Process Flow
6.3
Synchronization of OPH and PDC
6.4
Integration Services
6.4.1
SyncItemListPDCProvABCSImpl
6.4.2
SyncPriceListPDCProvABCSImpl
6.4.3
CreateProductXrefBRMAQ
6.4.4
CreateDiscountXrefBRMAQ
6.4.5
CreateSponsorshipXrefBRMAQ
6.5
Terminology Mapping Between PDC and BRM
6.6
Pre-requisites for Multi-BRM Setup
6.7
Assumptions and Constraints
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 Location and Operating Unit IDs in Oracle Product Hub
7.2.1.1
Identify Item Validation Organization for Oracle Product Hub
7.2.2
Mapping Siebel CRM
7.2.3
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.4.4
Configuring the Integration to Support 100 Characters
7.4.4.1
Assumptions
7.4.4.2
Setup in AIA
7.5
Working with Cross-References
7.6
Working with Domain Value Maps
7.7
Handling Errors
7.8
Setting Up Configuration Properties
7.8.1
Settings for the SyncItemListPIMReqABCSImpl service
7.8.2
Settings for SyncSpecificationValueSetListSiebelProvABCSImpl service
7.8.3
Settings for the SyncItemListBRMProvABCSImpl service
7.8.4
Settings for the SyncPriceListListBRMProvABCSImpl service
7.8.5
Settings for the QueryBillOfMaterialsListPIMAdapter service
7.8.6
Settings for the QueryItemListPIMAdapter service
7.8.7
Settings for the SyncSpecificationValueSetListPIMReqABCSImpl service
7.8.8
Settings for the SyncItemCatalogCategoryPIMReqABCSImpl service
7.8.9
Settings for the SyncClassificationSchemeListSiebelProvABCSImpl service
7.8.10
Settings for the SyncClassificationSchemeListSiebelProvABCSImpl service
7.8.11
Settings for the ProductOptimizedSyncPriceListListSiebelCommsProvABCSImpl service
7.8.12
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 higher in OPH and is set lower in Oracle E-Business Suite
C.1.1
Assumption
C.1.2
Workaround
C.2
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
Scripting on this page enhances content navigation, but does not change the content in any way.