Bookmark and Share Subscribe You may face visibility problem if is blocked on your network

Tuesday, May 12, 2009

Product Data Hub (PDH) Fundamentals

The objective of this article is to provide Overview of Oracle Product Information Management (PIM) or also known as Product Data Hub (PDH)

Oracle Product Information Management : Business needs

  • Consolidate product information across different enterprise systems
  • Enables Product data quality
  • Reuse and source components from suppliers
  • Synchronize data with trading partners
  • Provide a centralized product and service catalog
  • Accelerate new product introductions and changes
  • Improve collaboration across the enterprise
  • Centralize multi-channel product information – configurations, pricing and sales policies

Centralized Product Data

Many companies today store product information in numerous fragmented applications scattered across the enterprise, resulting in data duplication, version inaccuracy , and difficulty in locating information

Oracle PIM enables companies to consolidate all product information into a central repository that is based in a single extensible data model. This improves item accuracy and standardizes information so items can be classified, making them easy to find and manage. The Central repository accommodates virtually all information types, including

  • Structured data such as item specifications, user-defined attributes
  • Unstructured data such as documents, spreadsheets, images, drawings and other attachments.
  • Lifecycle data (change Requests and change orders)
  • BOMs (engineering, sales, manufacturing, service and so on )
  • Oracle PIM enables you to store and manage all product data and provides you the capabilities to
  • Organize items into user-defined catalogs and categories for quick retrieval, with an easy to navigate hierarchical catalog structure
  • Capture form, fit, function and product-related information with user-defined attributes.
  • Control Business functions and operations using predefined industry standard operational attributes.
  • Compare attribution of two components and select components that best meet requirements.
  • Import and export product information, including attributes for use of updating and generating custom data sheets, collateral and reports.
  • Store all product definitions and hierarchies such as engineering and manufacturing structures in a single data model.

Oracle Product Information Management Data Hub (PIM Data Hub) enables you to synchronize product data spread across different business systems into a single master item record.

Operational Challenges

Oracle PIM addresses these operational challenges




Oracle PIM addresses islands of data created by

  • Mergers and acquisitions
  • Going Global
  • Rushing to Market
  • Departmental Priorities and Politics


Use PIM to bridge information technology gaps relating to

  • Supplier and customer mandates
  • New Government regulations
  • Isolated business processes
  • Best-of-breed applications
  • Self-service Systems

Product Data

  • Consolidate and maintain unique, complete and accurate product information across the enterprise
  • Distribute product information to all operational and analytical applications

Oracle Product Information Management : Master

Use Oracle PIM to create a master repository of product data

Master Trusted Product Data

Your master data may contain

  • Attributes
  • Policies
  • Trading partners
  • Catalogs
  • Documents
  • Organizations
  • Relationships
  • Configurations

Central Data Repository

Create a single repository based on a proven data model

Your central data repository enables a 360-degree review of product information. This central data repository may also have these attributes

  • Extensible and configurable Data model
  • Model each entity once in the data model
  • Support all business models and industries
  • Provide locations for multiple geographies ( languages, units of measure, currencies)
  • Real-time Visibility to transaction information from other systems
  • Underlying data model of Oracle E-business suite

Structured and Unstructured Data Management

Oracle PIM supports all types of information related to an item

Structured Data may consist of

  • Attributes
  • Policies
  • Catalogs
  • Configurations

Capture operational info and specifications

Manage Product configurations

Define policies for Product change and approval

Manage an item’s relationship with trading partners and locations

Unstructured Data are attachments and can consist of

  • Word Documents
  • Spreadsheets
  • PDF documents
  • Images

Attach documents to an item,BOM or change order

Check-in and check-out documents with version history

Search documents based on content or attributes.

Complete view of Product information

View and manage all product information from a single user interface

Oracle PIM enables you to view

  • Product configurations
  • Product relationships
  • Customer defined attributes
  • Operational attributes
  • Data syndication attributes

Product Information Management : Data Consolidation

PIM Data Consolidation enables

  • Data extraction and import
  • Data import through the Import Workbench
  • Data import through an Excel Spreadsheet

Data extraction and Import

  • Aggregate product data from multiple sources into one repository
  • Combine smaller loads for business users and trading partners
  • Stage data to review exceptions to incoming data before loading
  • Match and remove duplicate data to create a single blended records
  • Handle High Data volumes with batch import

Data Import through the Import Workbench

  • Assign import batched to appropriate users to avoid processing conflicts
  • Track Status of all import batches from a single screen
  • Review items and structures prior to import

Data Import through an excel spreadsheet

  • Import and export product data to excel
  • Make Attribute changes in excel and load directly to repository

Blended Product Record

Create a single, blended record from multiple sources

  • Create data blending rules and combine all data sources
  • Display “single source of truth” blended record to end users while maintaining original source data

Oracle Product Information Management Solution : Cleanse
    • Standardization Data
    • Match and remove duplicates
    • Automatically generate item numbers and descriptions

Data Standardization

  • Standardize item descriptions
  • Translate into any language
  • Convert non-standard data
  • Extract and standardize attributes
  • Apply company and industry standards

Match and Remove Duplicates

  • Develop and Apply rules to eliminate duplicate data
  • Identify match rules by source system
  • Add granular match rules based on item specific criteria
  • Map items in source systems to items in repository

Automatically Generate Item Numbers and Descriptions

  • Reduce Manual entry
  • Generate Sequence part numbers based on user-defines rules
  • Generate system

Attribute Validation Rules

Validation rules enable you to set up attribute validate rules to improve data quality at the point of entry

Create validation rules for :

  • Data Type validation, such as numeric values versus date
  • List of values in drop-down menus
  • Range validations
  • Other user-defined rules

Oracle Product Information Management Solution : Govern

Oracle PIM enables you to govern and control the following

  • Change Management
  • Catalog Adminstration
  • Security
  • Events and policies

New Item Definition and Approval

Use the new item request process to prevent item duplication, and to control the process

New Item Request process

  • Submit the new item request
  • Check for any redundancy
  • Define the item
  • Verify accuracy and completeness
  • Approve the item

Oracle Product Information Management Solution : Share

Share product information with appropriate individuals and enable them to

  • Access and search product data
  • Publish and subscribe product data
  • Register product information
  • Generate reports

Content Based search

  • Search for words and phrases within files
  • Search for files using the basic metadata of the attachment

Multi-system synchronization

Drive accurate information to your entire enterprise

  • Integrate synchronously or asynchronously with other systems
  • Create single blended record from multiple sources and then synchronize from product data repository to other systems
  • Connect via embedded integration services, such as set of public APIs and business events
  • Apply cleansing and transformation rules to consistently interpret source data for ongoing synchronization

Comprehensive Integration Repository

  • Apply a set of APIs for synchronization
  • Search through a catalog of APIs
  • Search for different APIs and API types
  • Drill down to detailed API specifications

Template-Based XML publishing

Supported formats





Generated Outputs


Data sheets


Print Catalogs

XML/EDI Messages - Beauty of 12

NOTE: Writup for this article is not done by me... it is compiled and edited from various documents...


  1. Thanks Devendra,

    Very good doc as an initial reference for Oracle PDH


  2. Hello Devendra,
    This is a nice article. We are implementing PDH and wanted to make sure that we could search content with unstructured data such as word files,etc but we are not getting a direction. could you provide some direction.

    any help would be deeply appreciated.

  3. This document is definitely awesome . I find that you mentioned about searching content in unstructured data such as word,excel,etc.
    I am not finding the right document or direction.could you point me to the right direction.

  4. congratulations guys, quality information you have given!!!, It's Really useful..

    Oracle Training

  5. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Android Training in Chennai
    Ios Training in Chennai


Please add your valuable feedback / comments


This blog is purely personal and the thoughts expressed here represent only me. The purpose of this blog is to share information and knowledge about Oracle's product which I have come across with my exposure to the product, practice and observations. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. The blog has been created solely as a educational, for storing portions of the vast Oracle knowledge world. Oracle EBS is an Oracle Corp. product and you should contact Oracle directly for any specific fact or issue.

*NOTE: Few articles on this blog are not completely prepared by me, content is edited and complied after referring various sites to make visitor's job easy