Contents

List of Figures

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Overview

• Integration with Oracle Product Data Hub R12
  • R12 PIM Connector Configuration
    • ICC Structure as Product Hierarchy
    • Relationship Between ICC and Semantic Model
  • Cleansing and Matching Item On-Boarding Process
• Getting Started

2 Creating the Initial Data Lens

• 1. Setting the Profile Options
• 2. Setting the Display Format
• 3. Creating the PIM_Connector Database Connection
• 4. Processing the ICC Import from Excel
• 5. Using Services for Excel AutoBuild to Create a Data Lens
  • Using Value Sets when Creating a Data Lens
• 6. Reviewing and Refining the Data Lens
  • Refining Value Sets in a Data Lens
• 7. Refining Standardization and Match Rules
• 8. Testing a Data Lens on Sample Data and Create Base File
• 9. Creating Semantic Key 1 Cache

3 Cleansing and Matching R12 PIM Connector Batches

• Creating an R12 PIM Connector Batch
  • Creating an R12 PIM Connector External Data Source Batch
  • Creating an R12 PIM Connector Production Pull Data Source Batch
    • Reviewing Items for Enrichment
    • Reviewing Duplicates Within the Batch
    • Reviewing Matches Against PIM
    • Reviewing Exceptions
    • Reviewing Ready for Load
    • Reviewing the Release Batch

A Creating R12 PIM Connector Users