oracle product hub cloud item master made simple for erp
TRANSCRIPT
Oracle Product Hub Cloud Item Master Made Simple for ERPCase Story
05/02/20232
Executive Summary
1. About Company and the Objectives
2. Business Challenges in Existing System
3. Current Architecture State
4. End State Architecture
5. Why Oracle Product Hub Cloud and Benefits Stand to Achieve
6. Implementation Best Practices
Large Pharmaceutical multinational corporation running their Business with SAP and Oracle JDE E1 looking for Item Master Tool to achieve below Objectives
05/02/20233
Simplify and Expedite Legacy site migration into JDE E1
Improve operational efficiency of New Item Request and Change management Process
Ability to track and govern Product Data
Role based access control enforcing data ownership
05/02/20234
Business Challenges with Existing System
4
Operational Efficiency in New Item Request Process in JDE E1 Item Data Uploads from Legacy Sites to JDE E1
Quality and Compliance GovernanceFuture Rollout Flexibility
Disparate Control Mechanism and Adhoc Processes for Item Management• No clear
defined Accountability of respective Departments on entering required Item information.
• No Governance to ensure data completeness
• Lacking automated work flow, rules repository, and cross-referencing
Onboarding of new site data into JDE E1• Manual
Transformation.
• Manual Validations and duplicate search
• Manual data classification & mapping
• Adhoc Error Correction and Upload Process
Managing Quality and Compliance Related Product Information• Cannot enforce
Quality and Compliance department to enrich respective information
• Cannot track and Audit changes around it
• Cannot force data standards across products
Flexible and Scalable• Identify existing
versus new master items
• Manage Regional item/branch Information like UOM.
• Reduce iteration of Validations Errors
• Flexible to handle future rollout changes in data loads.
BOM ManagementITChange Management of BOM• Ability to
enforce add/delete/ update through workflow driven approval process
Data integrity failure due to attribute, format inconsistency• Store 40
Character Long Description
• Ensure invalid characters removed
1 Slower new product onboarding into JDE
2 Errors in Sales, Order and Procurement because of bad/incomplete data
3 As data grows, more staff needed to support manual processes & compliance
4 Poor quality item Data impact reporting
5 Supplier Spend analytics impacted
6 Limited ability to cross-sell
NEGATIVEIMPLICATIONS
Current State of Master Data Management
5
JDE E1
05/02/2023
Manual/Non Automated Item Creation and Change Mgmt. Process
Legacy Site 1
Legacy Site 2
Legacy Site ..
Non Validated Time Consuming Process of Legacy Data Onboarding into JDE E1
05/02/20236
Item Master Tool Selection Criteria
S.NO.
Item Management Requirements
1. New item creation workflow2. Change Management workflow on Existing
items3. Reduce reliance on manual effort for Data
Uploads4. Item Audit History management 5. Roles based Accountability6. Approval Based BOM management 7. Management of multiple unit of measures and
conversion logic8. Maintain complete Item information obtained
from Legacy Systems9. Data Quality Governance10. Fasten future Rollouts of JDE E1 Scalability
and Flexibility for other geographies/plants
Need a Tool to fill all these 10
Business Requirement/Ga
ps
7 05/02/2023
Oracle Product Hub Cloud – Near End State Solution Consolidate, Cleanse, Enrich, Govern, Harmonize
Oracle Product Hub Cloud
Data Stewards& CategoryManagers
Item Maintenance Workflow
Product ManagersQuality TeamCompliance Team
Data Governance Data Validations
MonitorData Quality
Search and
Access
Item WorkflowsItems Data MonitoringConversion from Legacy Systems
Processes
Data PublishData
Im
port
(Bat
ch )
Integration to JDE E1- KPIT iLink
JDE E1KPIT
iLink
Legacy Site 1
Legacy Site 2
Legacy Site ..
Simplify Legacy
Onboarding
New Item Request Process
05/02/20238
End State Item Management Process FlowOracle
Product HubCloud
KPIT
iLink
Auto Sync
Manage Synchronize Execute
Manage IntegrationManage Integration
05/02/20239
Why We Selected Oracle Product Hub Cloud?
Significant reliance on manual effort for Data Uploads
Item Audit History management
New item creation / Maintenance workflow
Roles based Accountability and Quality Standard Governance
Key Requirements• Solution Completeness:
Define NIR and CM workflows
Use pre-build data models
Use data steward workbenches to convert data
Use Audit Workbench
• iLink PDH to JDE E1 Adapter to synchronize item, attributes, item categories, BOM and related information from Hub to JDE E1
Oracle Product Hub Cloud Solution Completeness
Quick ValueSignificant reduction in manual, repetitive tasks (in Quality , Compliance , others) required for Product data maintenance and approvals
Improved ability to quick onboarding of new Plants
Resource time savings by not manual validating/cleansing data for future rollout load in JDE E1
SaaS Solution - IT Cost Saving in build and Maintaianance
05/02/202310
Before and After Oracle Product Hub Cloud
Without Product Hub With Product HubManual Item approval processes
Automated Workflow/Processes
Disparate Control Mechanism Role Based AccountabilityManual/Error prone clean up/Validations during Data Load
System based profiling, cleanup and transformation data uploads
Missing Item Changes Traceability
Audit History/Reporting
No Data Quality Governance Auto Quality and compliance checks
Adhoc Data Load Process Repeatable Data Load ProcessSuspect Quality of item data Trust in item Data
Manual/No
ItemdefinitionWorkflow
Data Uploads is not
governed and
Complex
Approval Process
don’t extend
across all the
departmentsQuality
and Complian
cemissing
Standards governan
ce
05/02/202311
Quantified and Strategic Benefits with Oracle Product Hub Cloud
Quantified Value
Strategic Value Drivers
Additional Value • Better Product Taxonomy
• Non- IT ways of Metadata Definition ( New Category and Attribute Creation)
• Complete 360 degree View of Product Data for JDE E1.
• Help with M&A strategy by cutting cycle time for on-boarding new companies item data
• Support for future initiatives: BI, Ecommerce require JDE Data
• Productivity gains (Cost Savings) in ….– Data Migration– Data Uploads– Faster Onboarding– IT Customizations– Application Life cycle
Management
Not Quantified• Single portal • Operating Efficiency
improvement• Simplified Governance
Process
Benefits $$$$
Best Practices- Key Areas of Implementation Focus
05/02/202312
Synchronize metadata and processes between Product Hub to JDE
Involvement of right Stakeholders
Educate and Train IT and end users on Product Hub Cloud functionality and values
Taxonomy for : Product
Categorization Attributes
Metadata for Single Source of Truth for Product Data
Global and Regional Attributes
Data Extraction from Legacy Sources
Products are to be loaded from Legacy to Product Hub
The data should be classified into standard product taxonomy and Attributes
Item onboarding and Maintaianance Workflows
Item validation and Business Rules.
Audit History
Reports on Product Data Tracking
Integration with Product Hub Cloud to JDE E1
Synchronize item and Attributes
Flexible
mapping of attributes from Product Hub Cloud to JDE E1
Impa
ct
Product Hub Cloud Implementation Best Practices
Com
plex
ity
Product Data Governance
Cloud to On-Premise
Integrations
Mastering the Product
Metadata
Product DataQuality and
Import
1 2Change and
CommunicationManagement
53 4
05/02/202313
Thank You