Oracle Fusion Product Hub

Oracle Fusion Product Hub Oracle Fusion Product Hub - Start

Added : 2018-12-08 Views :6K

Download Presentation

Oracle Fusion Product Hub




Download Presentation - 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.



Presentations text content in Oracle Fusion Product Hub

Slide1

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

Slide5

Consolidate

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

Slide6

Implementation 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

Slide7

Oracle 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

Slide8

Native 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

Slide9

Enterprise 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

Slide10

Fusion Product Hub: Reference Architecture

Copyright © 2012, Oracle and/or its affiliates. All rights reserved.  Oracle Proprietary and Confidential

Slide11

Custom/ 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

Slide12

Fusion

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

Slide13

Copyright © 2012, Oracle and/or its affiliates. All rights reserved.  Oracle Proprietary and Confidential

Fusion Product Hub: Technology Components

Slide14

Technology 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

Slide16

Key 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

Slide17

EFF (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

Slide18

EFF 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

Slide19

Item 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

Slide20

Domains, 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

Slide21

Topology

Slide22

Copyright © 2012, Oracle and/or its affiliates. All rights reserved.  Oracle Proprietary and Confidential

Fusion Product Hub: Integration Architecture

Slide23

Oracle Enterprise Repository (OER)

https

://fusionappsoer.oracle.com/oer/Repository of components for IntegrationSome of the components listed areData Model Diagrams

TablesViewsWeb ServicesSOA CompositesTopology

Slide24

Comprehensive 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

Slide25

Service Architecture

Copyright © 2012, Oracle and/or its affiliates. All rights reserved.  Oracle Proprietary and Confidential

Slide26

Trusted

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

Slide27

Consolidate

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

Slide28

Batch

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

Slide29

Trusted 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

Slide30

Fusion 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

Slide31

Copyright © 2012, Oracle and/or its affiliates. All rights reserved.  Oracle Proprietary and Confidential

Fusion Product Hub:

On The Cloud

Slide32

Cloud

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)

Slide33

Cloud 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

Slide34

Cloud

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

Slide35

Copyright © 2012, Oracle and/or its affiliates. All rights reserved.  Oracle Proprietary and Confidential

Fusion Product Hub: Data Model

Slide36

Item

: 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

Slide37

Logical Data Model

Copyright © 2012, Oracle and/or its affiliates. All rights reserved.  Oracle Proprietary and Confidential

Slide38

Items

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

Slide39

Extended 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

Slide40

Item 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

Slide41

Product 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

Slide42

Change 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

Slide43

Item 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

Slide44

Questions & Answers

Slide45


About DocSlides
DocSlides allows users to easily upload and share presentations, PDF documents, and images.Share your documents with the world , watch,share and upload any time you want. How can you benefit from using DocSlides? DocSlides consists documents from individuals and organizations on topics ranging from technology and business to travel, health, and education. Find and search for what interests you, and learn from people and more. You can also download DocSlides to read or reference later.
Youtube