Product Information Management

Production Information Management (PIM) systems available (from):

1. SAP
2. Oracle (under Oracle MDM)
3. Stibo Systems
4. Hybris
5. Riversand
6. Heiler
7. Enterworks
8. WebOn
9. Agility
10. PCS (from Pegasystems)

Oracle MDM

Oracle Master Data Management (MDM) offers a source of clean data for enterprises dealing with fragmented master data topology with duplicated, incomplete and inaccurate information.

MDM consolidate/federate shared info into one place, cleanse data centrally and share data as a single point of truth as a service.

MDM Business Drivers:

1. CRM booster
2. IT agility
3. Operational processes enablement & optimization
4. Compliance, Risk mitigation & BI enablement

Oracle MDM offering:

• MDM suite EBS based: CDH for Customers/Suppliers & PIM for Products
• PIM forRetail
• Site Hub
• AIA 2.3 for MDM / Foundation Pack
• Ledger & Analytical Hub: DRM
• Data Watch & Repair

MDM can be stand-alone install or as add-on to CRM/ERP/SCM

Application Integration Architecture (AIA) is MDM's critical differentiator.

Oracle PIM

Oracle Product Information Management (also called Advanced Product Catalog) has three main product components:

1. PIM Data Hub
2. PIM Data Librarian
3. Product Data Synchronization for GDSN and UCCnet Services

Oracle PIM Data Hub , an enterprise data management solution that enables customers to centralize all product information from heterogeneous systems, creating a single product repository that can be leveraged across all functional departments.

PIM Data Librarian is a new product released in May'05, offers an easy-to-use HTML/Windows interfaces for creating, managing, consolidating, enriching and standardizing product information. Provides secure way to share product info within enterprise and with partners.

All business rules in PIM are based on one important concept - Primary Hierarchy which classify products in Primary Item Master Catalog.

Attributes & Attribute Groups

You can define upto 70 attributes per attribute group but there can be unlimited attribute groups.

Concurrent Programs in PIM:

• Bulkload Program For Spread Sheet Upload
• Item/Item Revision Implement Pending Changes Concurrent Program
• Import Catalog Items - Java Concurrent Program to Bulkload items from the interface table.
• Item Org Import - Item Organization Assignment Import
• Item People Import
• Purge Item People Interface Lines - Purge Program for Item People Interface Lines
• Item/Item Revision User-Defined Attributes Concurrent Program - For importing User Attributes for Items and Item Revisions
• EGO Item Import Batch Matching Concurrent Program - EGO Bulk matching engine of the item import process
• Purge Item Massupdate Temporary Tables - Mass update Temporary table purge program
• Optimize Item Catalog Text Index
• EGO Spreadsheet Java Concurrent Program - EGO Java Loader to Bulkload Item, BOM Attrs, User-Defined Attrs, UCCnet Attrs
• Item Catalog Text Index Build - Create/Rebuild Item Catalog Text Index
• EGO Setup Default Organization for User
• Catalog Categories Assignment Open Interface - Import Catalog Categories Assignments from the Open Interface table
• User-Defined Attribute Groups View (AGV) Compilation Executable