Overview, Technical Architecture & Data . Model. Siva . Dirisala. Senior Director, Product Development. <Insert Picture Here>. Agenda. . Fusion . Product Hub: Reference Architecture. Fusion Product Hub: Technology Components. ID: 738684
DownloadNote - The PPT/PDF document "Oracle Fusion Product Hub" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Oracle Fusion Product Hub
Overview, Technical Architecture & Data
Model
Siva
Dirisala
Senior Director, Product Development
Slide2<Insert Picture Here>
Agenda
Fusion
Product Hub: Reference ArchitectureFusion Product Hub: Technology ComponentsFusion Product Hub: Integration ArchitectureFusion Product Hub: On The CloudFusion Product Hub: Data ModelQ&A
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide3<Insert Picture Here>
Agenda
What is MDM?
Fusion Product Hub: Reference ArchitectureFusion Product Hub: Technology ComponentsFusion Product Hub: Integration ArchitectureFusion Product Hub: On The CloudFusion Product Hub: Data ModelQ&A
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide4<Insert Picture Here>
What is MDM?
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide5Consolidate
information into one master repository from disparate systems and business lines
Distribute
data as a single point of truth for a consistent enterprise view
Leverage
master data to service consuming applications, enterprise business processes and decision support systems
Cleanse and Enrich
data centrally
Is the Ability to…
Delivering Key Business Benefits
Improve Governance
Manage & Avoid Risk
Attain Compliance
Master
Data
Management
Streamline Processes
Decrease Costs
Improve Customer/Distributor Service
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide6Implementation Styles of MDM
Coexistence
Large-scale distributed model
Largest change to information infrastructure
Greatest need to mirror data
Global and local governance
Greatest risk over control, security
Focused on shared services
Centralized
High control, top down environments
Largest change to application infrastructure
Hugely invasive to the business
Centralized governance
Greatest control over access, security
Focus on common services
Consolidation
Ideal for reporting or analytics that reside in a BI/data warehouse
Nonintrusive to the business
BI is the business platform
Any industry
Benefits dependent on success of BI strategy
No attempt to clean up source data
Registry
Low control, autonomous environments
Nonintrusive of edge applications
Emphasis is on remote data and application to application integration (lots of real time network access)
Distributed governance
Faster to implement then coexistence and centralized
Courtesy : Gartner - Where is MDM Going in the Next 5 Years
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide7Oracle Enterprise MDM:
Fusion V1
Budgeting
Data Governance & Compliance
Analytical MDM Apps
Operational MDM Apps
Operational
Systems
Analytical
Systems
Customer
Supplier
Financial
EBS
Siebel
SAP
Custom Apps
External
Apps
DW
BI &Datamarts
Planning
Financial Consolidation
Asset
Analytical
Integration
Architecture
MDM Platform Foundation
Enterprise schema & Common services
Product
Location
Employee
Oracle Fusion Middleware
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide8Native SOA Based Hubs
Best in class
standards based J2EE applications
leveraging latest Fusion Middleware technology providing
technical adaptability
Single Tech Stack for Multi Domain, Multi Form MDM Needs
Single code line for
On- Premise and On-Demand with support for
multi-domain, multi form MDM
on single platform featuring common services reducing
total cost of ownership
Comprehensive Embedded Data Intelligence/Governance
Proactive monitoring, governing of critical data, trends, with integrated dashboards; advanced ad hoc analytic capabilities using embedded
Oracle Business Intelligence Applications
Pervasive and Proactive Data Quality Management
Leverage best in class native
Data Quality
solutions to
reduces data quality problems
at point of entry & continuously monitors data issues
Standard Based Integration Framework
Comprehensive
Web Service/Java API, ODI
based batch framework with what-if analysis capability to
reduce implementation effort/cost
Embedded Enterprise Search, Web 2.0 Features
Enhanced information retrieval and sharing, Interactive and efficient rich
Web 2.0
User Interface to
improve end user productivity and enhance collaboration
End to End Business Process, Policies Support
Business process orchestration using
BPEL
, governance/ approval via
AMX
, declarative specification of data policies, and improved manageability and upgradability
Fusion MDM:
Technology Differentiators
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide9Enterprise Common Product Model
Single Product Data Model
with
extensibility
leveraged by all Fusion Apps
eliminating complex integrations
and
administration overhead
associated with disparate data models
Integrated Catalog Management
Model functional and business categorization of products with
master catalogs
and
shareable categories
allowing
reuse of hierarchies
and
reducing maintenance
Pervasive and Proactive Data Quality Management
Natively integrated
Real time and Batch data cleansing
services
reduces data quality problems
at point of entry
Configurable and Auditable Governance Process/Policies
Dynamic rule based routing, approval and orchestration
for product data across internal/external systems
enforces policies
and
speeds up product definition
cycle times
Streamlined Release Management Process
Version management
for tracking and auditing
granular data changes
allows for
effective concurrent product administration
and
release management
Intuitive, Interactive UI with Contextual Actions
Rich interactive UI
with
Web 2.0 features
for product administration and governance that significantly
improves productivity
Comprehensive Embedded Product Data Analytics
Integrated Product Dashboard
provides proactive monitoring of
critical product data, status, trends
and
actionable insight
for all data management tasks.
Fusion Product Hub:
Product Differentiators
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide10Fusion Product Hub: Reference Architecture
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide11Custom/ 3
rd
Party/AU Applications
Fusion Product Hub:
Solution Architecture
ERP
Multichannel Commerce
Collateral
Data Pools
Print Catalog
Reports
PLM
3
rd
Party Catalogs
CRM
Product & Catalog Management
Product Model
Syndicate & Publish
Web Services
Local
DB
Web Services
Cleanse & Consolidate
PIM
Trading Partners
Enrich & Access
Buy Side
Procurement Catalog *
Supplier Portal *
Pricing/Promotions
Quote/Order Capture
Configurator
Integration Architecture
POS
Web
Kiosks
Sell Side
Product Hub
DOO *
Inventory *
Costing *
In Side
Logistics *
Manufacturing
Sales Catalog *
Sales/Marketing *
Lead/Oppty Mgmt *
*V1 Products
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide12Fusion
ADFui
Groovy
Product Data Quality
Open InterfaceCSV UploadWeb Services
BPEL/AMX
Oracle Enterprise Repository (OER)
Fusion
ADFdi
Fusion IDM
Fusion Product Hub:
Technical Architecture
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide13Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Fusion Product Hub: Technology Components
Slide14Technology Components:
Comparison
EBS Product Hub
Fusion Product Hub
Fusion Description
OA Framework
ADFui
Fusion Application Developer Faces (user interface)
BC4J
ADFbc
Business components for ADF
Workflow, XML Gateway
BPEL, BPM, AMX
Human workflow and Approvals management
WebADI
ADFdi
Microsoft Office Excel 2007 and above
(
support matrix
)
Concurrent Program Manager
ESS (Enterprise Scheduler Service)
Concurrent jobs and background processes
UDA (User Defined Attributes)
EFF (Extensible Flex Fields)
User defined attributes
FND Attachments, Files Online
UCM (Universal Content Manager)
Attachments for products
FND_XXX tables
Identity Manager, JAZN
User and role provisioning
Secure Enterprise Search (SES)
Secure Enterprise Search (SES)
Enterprise search for business objects
PIM Rules
Groovy (PIM) / OBR (Customer Hub)
Expression based validation/assignment rules
Web Center (Personalization, Collaboration)
Personalization and collaboration
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide15
Data Extensibility
Fusion Middleware
Fusion Applications:
Technology
Jdeveloper
/ADF
Fusion
Schema
DQ
Schema
3rd Party
Schema
UI
Extensibility
Validations
BPEL/AMX
UI
Layer
Logic
Layer
Tooling
Web
Services
Framework
Web
Services
Interfaces
Color Key:
Integration
Layer
Data
Web Based UI
Product
Dashboard
CPUI
Extensibility
Admin
Product Hub
Configuration
Data Quality Services
VO
EO
Schema
Rules
Scripting
Groovy
ESS
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide16Key Technology
Components
ADFbcMetadata driven validators
EL expression supportADFuiMetadata driven control logic
Model abstraction through data bindingsADFdiWorks closely with ADFbc & uiRequires Microsoft Excel 2007 or aboveUCMStore attachments for a business object
Web CenterWYSIWIG personalizationWeb 2.0 features like Tagging, Group Spaces for fast searching and Collaboration
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide17EFF (Extensible Flex Fields)
Functionally Similar to UDA in R12
Uses ADF technologyUses
DT@RT requires deployment (Compilation)i
mproves runtime performanceprovides seamless access of EFF to all Fusion Technology ComponentsOut of the box integration inUISearch (Query Panel)ADFdiWeb ServicesPIM RulesApproval Rules (OBR)
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide18EFF and UDA differences
Reduced Data Levels
ItemRevisionSupplierControlled AtMaster
vs OrgStyle vs SKUTranslatable at Attribute Group levelNo data partitioning by attribute group
No automatic index creationDynamically generated web service makes them first class entities
Slide19Item Import
Re-architected in Fusion to take advantage of Fusion
TechstackSame business validation code used between UI and Interface Tables processingPre-processing logic is parallelized and mostly uses database resourcesProcessing logic is parallelized and mostly uses middle-tier resources (load on database is not as intensive as during pre-processing)
Processing performance is controlled byNumber of items per batchNumber of threads to run in parallel
Slide20Domains, Servers and Web Apps
SCM Domain
SCM Common ServerProduct Management Common Web AppProduct Management ServerProduct Management Web App
UI Scale outProduct Management ServerItem Import Scale outSCM Common Server
Slide21Topology
Slide22Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Fusion Product Hub: Integration Architecture
Slide23Oracle Enterprise Repository (OER)
https
://fusionappsoer.oracle.com/oer/Repository of components for IntegrationSome of the components listed areData Model Diagrams
TablesViewsWeb ServicesSOA CompositesTopology
Slide24Comprehensive Web Services Repository
Easy to service enable ADF business components
ADFbc
generates SDOs for marshalling and
unmarshalling data along with XSDs and WSDLs
Comprehensive granular web services provided for master entities26 Services, 350+ Service Operations available Supports CRUD
Partial
List of Entities with Public Web Services:
Item
Item Revision
Item Relationships
Item Associations
Product
Structures / BOM
Product Catalog
Item Batch
Change Orders
Item Class
New Item Request
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide25Service Architecture
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide26Trusted
Product
Data
Profile & Correct
Catalog Admin
& Security
Events &
Policies
Change
Management
Import Workbench
Identification
& Cross-Reference
Source Data
History
Blended
Record
Parse
Standardize
Enrich
Validate
Match &
De-Duplicate
Attributes
Policies
Trading Partners
Catalogs
Documents
…
Publish &
Subscribe
Transports &
Connectors
Registry
Reporting
Access
& Search
Fusion Product Hub
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide27Consolidate
Import Workbench
Source Data
History
Blended Record
Trusted
Product Data
CSV, Excel, SQL
Loader
Import Maps with expressions for CSV and XML
Data Stage
High
Volume Batch & Real time Integration
1:M
Cross-Referencing
Cleansing
and de-dup while importing
Track all changes to Master
Record
Business Analytics
Identification & Cross Reference
Fusion Product Hub:
Consolidate
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide28Batch
Import
Process
Data
Onboarding
XML
Implementation
Excel
Validation Engine
Seeded Validations & Customer Defined Rules (Groovy)
Production
Data
Pending
Data
EBS
Agile
Siebel
1SYNC
Other
...
Canonical Objects (EBO)
Stage
SQL
ODI
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
CSV
Slide29Trusted Customer Data
Share
Web Services
/ Java API
Business Events
Transports &
Connectors
Authorization
Registry
Provides commonly used functions as business services/events and web services
Entity level business events for subscription by other apps
Support multiple protocols and transport utilizing Fusion middleware, BPEL infrastructure
26
Services, 350+ Service Operations avalable (Item, Structures,
Catalogs
, Change
Orders
, Versions
etc
)
Publication
framework
to
validate
,
filter
and
propagate
changes to
spoke
systems
Fusion Product Hub:
Share
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide30Fusion Product Hub
Item Import
Services
Item Import
Item Publish
/
QueryService
Item
Item Class
Item
Catalog
ABCS
Item
EBS
ABCS
Item
EBS
Item
ABM
Item/Catalog
EBM
Item
EBM
Item Revision
/Version
Item
Specification
Sample Integration
Custom
Connector
Item
ABM
Item
EBM
Item
ABM
Custom
Connector
Siebel CRM
Item
ABM
Agile
Prebuilt
AIA
PIP’s for end-to-end (*Post V1)
Provide AIA
Foundation Pack(Standard EBOs,
services,standard
SOA integration with
EIL)
EBS/PSFT/JDE
Legacy/3
rd
Party
AddtoBatch
Agile
EBS/PSFT/JDE
Legacy/3
rd
Party
Data Pools
Legacy/3
rd
Party
Product
Structure
Change
Order
Item
EBM
Siebel CRM
Data Pools
Legacy/3
rd
Party
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide31Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Fusion Product Hub:
On The Cloud
Slide32Cloud
Cloud Enabled Starting Release 5
Enhanced interface tables to support external values in addition to internal idsCommon CSV file upload framework to interface tablesExternal Web Services (not in Release 5 to 7)
Slide33Cloud Limitations
Oracle Public Cloud != Oracle
OnDemandAdministrationNo direct database accessNo EM accessData Quality
No integration with Oracle EDQ yetNo support for co-location of non-FA serversNo support for service callouts to integrate with on-premise EDQ serverReviewing options
Data InCSV and Web Services in addition to UI and ADFdiNo direct database dump using tools such as ODIData OutPublication Framework (not in Release 5)SOA/BPEL/EventsReviewing options based on use cases
Slide34Cloud
Item Import
Create Batch
Get Batch Id
On Premise
Oracle Public Cloud
Upload Zip file
using SFTP
Submit ESS Job
For Upload Data Into
Interface Tables
Submit ESS Job
For Item Import
Query Batch
Review Batch Details For Errors
Data Files In SFTP Folder
Interface Tables
Data Upload
ESS Job
Production Tables
Item Import
ESS Job
Oracle Fusion
PIM Data Hub
Oracle Public Cloud
Infrastructure
Using batch id, create (manually or automated)
csv
data files one per entity
Zip the files for upload
Slide35Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Fusion Product Hub: Data Model
Slide36Item
: An entity that represents products/services that a business manufacturers, stocks or sells
Item Revision: Allows tracking changes to an item or its data over a period of time and generally represents a form/fit/function of the item at a given point in time.
Item Version: allows tracking of granular change to item data(that typically does not constitute a form/fit/function change) within a given revision
Item Attributes: Attributes describe a product or a service in terms of its characteristics, features or properties. Operational Attributes (pre-defined attributes)Transactional Item AttributesExtended or User Defined AttributesItem Relationships: Allows you to relate an item to another item for various contextsItem Associations:
Allows you to associate items to different business contexts i.e. organization, supplier items, sites. These are also sometimes referred to as intersectionsTrading Partner Items: Items that represent products from external parties such as manufacturers, customers, competitors
Item Class
:
A classification hierarchy to logical group products sharing similar characteristics to create a product taxonomy
Item Catalogs:
A hierarchy for categorizing products belonging to similar product families
Product Structure/Bills of Material
:
A product hierarchy consisting of child items that make up an end item
New Item Request
:
A formal workflow to orchestrate the definition and approval of an items
Change Order
:
A formal workflow to define, manage, approve and implement product changes
Terminology
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide37Logical Data Model
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide38Items
Related Items
Cross References
Trading Partner
GTIN
Source System
Manufacturer Part #’s
Customer Items
Competitor Items
Operational Attributes
Extended Attributes
Transactional Attributes
Items can be associated with Organization
Attributes values can be maintained at an organization level
Item Revisions allow for tracking changes overtime
Attributes values can be maintained at an item revision level
Item Versions provide more granular tracking and managing of item related data
Items can be associated with supplier/site
Attributes values can be maintained at an supplier/site level
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide39Extended Flex Fields (EFF’s)
Values can be maintained at different lntersections
Item, Item/Revision/Version
Item/Supplier/Site/Organization
Item/Organization
Unlimited
3 Types:
Single Row
Multi-Row
Variant – Drives SKUs
Attribute is mapped to an existing database column
May be Indexed
Character, Number, Date, Translatable Text
Poplist, Radio Button, Check Box,, Static URL, Dynamic URL
Value Set (List of Values)
Complex Validation & Defaulting Rules for 1 attribute or across many attributes
Consumed by other transactions
Attribute values specified during transaction
Meta data controls behavior downstream
Example: Monogram
Logical Grouping of attributes
Security maintained at this level
Allows grouping of Attribute groups for runtime display
UI dynamically generated based on metadata
Defined in context of Item Classes
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide40Item Classes and Catalogs
Functional Catalogs to categorize products based on function
Example Inventory, Purchasing etc
Allows mapping of categories across catalogs
Allows for categorization of products for reporting, rollup and other orthogonal categorization
To aggregate external catalogs into a master production catalog
Primary Item Class
Inheritance
Attribution & validation rules
Number/Description Generation
Security
Workflow rules
Templates
Lifecycle Phases
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide41Product Structures/BOM’s
User Defined and provides naming for different structures of a similar type e.g. EBOM1,EBOM2
Allows to specify alternate components that can be substituted
User Defined and allows for categorizing different structures
User Defined and provides naming for different structures of a similar type e.g. EBOM1,EBOM2
Multi Level Parent-Child Hierarchy
9,99,999 Components per level
Limited to 60 Levels Deep
Allows for defining locator information for components
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide42Change Orders
Change Tasks and Lines to represent changes that need to be implemented
Items that have changes that need to be implemented
Revisions/versions can be created as part of the change
Structure Components that have changes to be implemented
Mapping to propagate changes to multiple organizations
Definition Steps to allocation product definition to different users
Multiple participants(authors,reviewers,approvers for definition and approval workflow
Multi-Threaded discussions for collaboration as well as audit log of all actions performed on a change
Change Statuses to represent the lifecycle of an change for example, open, approval,implement
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide43Item Batches
Item Batches for grouping items being imported from external sources
Staging Tables for populating data before importing into product schema
Import Options allow for specifying how data needs to be processed
Source Systems from which product data is being consolidated or harmonized
Items in pending schema that are being imported/consolidated
Duplicate Items that have been matched by the data quality engine
Items that have been rejected or excluded from being imported as part of the batch import
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential
Slide44Questions & Answers
Slide45
Next Slides
An oracle white paper april oracle fusion alent management
Foundation for enter
Introducing oracle fusion financials
Techleads it fusion financials
Oracle workforce rewards oracle fusion workforce compensatio
Oracle fusion
Oracle data visualization content in oracle fusion applicati
Oracle product data
Oracle product line card storage systems portfolio highligh