Skip Headers
Oracle® Application Integration Architecture Oracle Product Master Data Management Integration Implementation Guide
Release 11.1
Part Number E22578-04
Home
Book List
Contact Us
Next
PDF
·
Mobi
·
ePub
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
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
Synchronization of Transaction Attributes as Part of Item Sync
3.1.8
Transaction Attributes without Valuesets
3.1.9
Synchronization of Item Catalog Category Hierarchies
3.1.10
Association of Item Catalog Category with Items
3.1.11
Publishing of Item Catalog Category from OPH to Siebel CRM Implementation Flow
3.1.12
Synchronization of Valuesets
3.1.13
Synchronization of Valuesets as Part of Item Catalog Categories
3.1.14
Synchronization of Valuesets Independently
3.1.15
Batch and Initial Load
3.1.16
Multi Language Support for Valueset Synchronization
3.1.17
Synchronization of Products, Discounts, and Associated Structures from Oracle Product Hub to Siebel CRM
3.1.18
Multi-Event Product Synchronization from OPH to Siebel
3.1.19
Support for Class Type Relationship in Product Synchronization for Siebel CRM
3.1.20
Support for Controlling Auto-Release of Entities Published from Oracle Product Hub in the Same Batch for Siebel
3.1.21
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
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
Support for Multi-Language for Item Synchronization
5.1.4
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
Part II Implementing the Delivered Process Integrations
6
Configuring the Oracle Product Hub Integration
6.1
Adding a New Spoke Instance
6.2
Post Installation Configuration Set Up
6.2.1
Extract Inventory Organization and Operating Unit IDs in Oracle E-Business Suite
6.2.1.1
Identify the Item Validation Organization for Oracle E-Business Suite
6.2.2
Extract Inventory Location and Operating Unit IDs in Oracle Product Hub
6.2.2.1
Identify Item Validation Organization for Oracle Product Hub
6.2.3
Mapping Siebel CRM
6.2.4
Extract Business Unit and Inventory Location IDs in Siebel CRM
6.3
Setting Up Oracle BRM
6.4
Setting Up Cross-References
6.4.1
Populating Seed Values in Cross-Reference Tables
6.4.2
Validating Cross-References
6.4.3
Creating a Pricelist in Siebel
6.5
Working with Cross-References
6.6
Working with Domain Value Maps
6.7
Handling Errors
6.8
Setting Configuration Properties
6.8.1
Settings for the SyncItemListEbizProvABCSImpl service
6.8.2
Settings for the SyncProductSiebelProvABCSImpl service
6.8.3
Settings for the SyncBillOfMaterialsListEbizProvABCSImpl service
6.8.4
Settings for the SyncBillOfMaterialsListSiebelProvABCSImpl service
6.8.5
Settings for the SyncItemListPIMReqABCSImpl service
6.8.6
Settings for SyncSpecificationValueSetListSiebelProvABCSImpl service
6.8.7
Settings for the SyncItemListBRMProvABCSImpl service
6.8.8
Settings for the SyncPriceListListBRMProvABCSImpl service
6.8.9
Settings for the QueryBillOfMaterialsListPIMAdapter service
6.8.10
Settings for the QueryItemListPIMAdapter service
6.8.11
Settings for the SyncSpecificationValueSetListPIMReqABCSImpl service
6.8.12
Settings for the SyncItemCatalogCategoryPIMReqABCSImpl service
6.8.13
Settings for the SyncClassificationSchemeListSiebelProvABCSImpl service
6.8.14
Settings for the SyncClassificationSchemeListSiebelProvABCSImpl service
6.8.15
Settings for the ProductOptimizedSyncPriceListListSiebelCommsProvABCSImpl service
6.8.16
Settings for the SyncItemCompositionListSiebelCommsProvABCSImpl service
6.9
Setting Up the Data for Seeded Attributes of the Telecommunications Library
6.10
Setting up List of Values in Siebel
A
Frequently Asked Questions
B
Support for Rate Tiers and Effectivity
C
User Defined Attributes Framework
C.1
Extending for Custom UDAs
C.1.1
Handling UDAs
C.1.2
Mapping Artifacts
C.1.2.1
Mapping Operational Attributes to ItemEBM
C.1.2.2
Mapping Seeded Set of UDAs for Communications library to EBM
C.1.2.3
Mapping Pricelist related UDAs for Communications Library to EBM
C.2
Implementation of UDA Transformation
C.2.1
Mapping Custom UDAs to EBM
C.2.2
Artifacts (Requester ABCS)
C.2.3
Artifacts (Siebel Provider ABCS):
C.3
Performance Optimization Using Chunking
C.3.1
Specifying the Batch Size
D
Scenarios
D.1
ASCII Code of the item version is set same in OPH and Oracle E-Business Suite
D.2
ASCII Code of the item version is set higher in OPH and is set lower in Oracle E-Business Suite
D.2.1
Assumption
D.2.2
Workaround
D.3
ASCII Code of the default item version is set higher in Oracle E-Business Suite and is set lower in OPH