Cliff Godwin Senior Vice President Oracle Corporation
Conventional Wisdom Financials
CRM
Supply Chain
Conventional Wisdom Financials
CRM
Supply Chain
Conventional Wisdom Financials
CRM
Supply Chain
Conventional Wisdom Financials
CRM
Supply Chain
To get any meaningful information, you need a warehouse, which means you need….
Conventional Wisdom Financials
CRM
Supply Chain
Warehouse
Conventional Wisdom Financials
CRM
Supply Chain
Warehouse
Why?
Why Fragmented Systems? y “Best of breed” strategy y Application vendor recommendations or requirements (even by “suite” vendors) y Isolation of warehouse inquiry load from OLTP load
Oracle’s Vision: A Single Global Database
Single Global Database y Better Information y More Complete Automation y Lower Cost
Fragmented Information
1 Global System
Single Global Database y Single, Complete Data Model
Supply Supply Chain Chain
Marketing Sales
HR
Customers, Products, & Everything Else!
Financials Order Management
Service
Contracts
Single Global Database y All Global Information in A Single Database
Supply Supply Chain Chain
Marketing Sales
HR
Customers, Products, & Everything Else!
Financials Order Management
Service
Contracts
Daily Business Intelligence y Radical simplification: Same database for summaries and transactions
Supply Supply Chain Chain
Marketing Sales
HR
Customers, Products, & Everything Else!
Financials Order Management
Service
Contracts
Daily Business Intelligence y Radical simplification: All detail data available for drilldown
Supply Supply Chain Chain
Marketing Sales
HR
Customers, Products, & Everything Else!
Financials Order Management
Service
Contracts
More Complete Automation y Integrated flows across functional areas y Any application can efficiently access any data
Supply Supply Chain Chain
Marketing Sales
HR
Customers, Products, & Everything Else!
Financials Order Management
Service
Contracts
Lower Cost y Consolidate data centers y Administer fewer systems
Supply Supply Chain Chain
Marketing Sales
HR
Customers, Products, & Everything Else!
Financials Order Management
Service
Contracts
Lower Cost y Each new flow you implement leverages setups and reference data your are already maintaining
Supply Supply Chain Chain
Marketing Sales
HR
Customers, Products, & Everything Else!
Financials Order Management
Service
Contracts
Lower Cost y Having your data in one place is inherently simpler than synchronization approaches
Supply Supply Chain Chain
Marketing Sales
HR
Customers, Products, & Everything Else!
Financials Order Management
Service
Contracts
Enabling a Single Global Database
Oracle Platform Support for a Single Global Database y Oracle9i Real Application Clusters y Oracle9i Materialized Views with Incremental Refresh
Quiz
Which is a peripheral device? (a) computer (b) disk
Real Application Clusters y Multiple Oracle instances access a single database y Think of servers as peripherals to the storage array
Single Database
Database Servers
Real Application Clusters y Lets you direct OLTP and Warehouse load to different servers if you wish y No need to fragment data
Single Database
Database Servers
Real Application Clusters and Oracle e-Business Suite 89% Scalability
4,000 3,500
3,648
3,000 2,500 # Users
2,000 1,900
1,500 1,000 500 0
Running on HP Computers
1,026
Single Node
2 Nodes
4 Nodes
Materialized Views
Performance Breakthrough y Initial load for 2 yrs of history: –
AR Invoice Lines
7M records in 2.5 hrs
–
AP Invoice Lines
1.3M records in 1 hr
–
GL Journal Lines
9M records in 1 hr
y Incremental update for 2 wks of transactions: –
AR Invoice Lines
650K records in 30 min
–
AP Invoice Lines
40K records in 5 min
–
GL Journal Lines
770K records in 18 min
Bookings, Billings and Backlogs OM Headers & Lines
Incremental Refresh
Product
Bookings Summary Fast Refresh
Product Category
Operating Unit
Bookings, Billings, and Backlogs by OU, Product/Category, Time
Time
Bookings, Billings and Backlogs OM Headers & Lines
Incremental Refresh
Product
Bookings Summary Fast Refresh
Product Category
Operating Unit
Bookings, Billings, and Backlogs by OU, Product/Category, Time
All transaction details are present. Complete drilldown is possible.
Time
Bookings, Billings and Backlogs OM Headers & Lines
Incremental Refresh
Product
Bookings Summary Fast Refresh
Product Category
Operating Unit
Bookings, Billings, and Backlogs by OU, Product/Category, Time
Transactions and summaries refer to the same reference data, so drilldown is easy
Time
Revenue Summarization AR Headers & Lines
CCID Dimension Mapping
AR Distribution
Company
Sales Order Customer
Incremental Refresh
Natural Account
Sales Channel Company Cost Center
AR Revenue Base Summary Product Full Refresh
Product Category
MV AR Revenue by Manager, LOB, Sales Channel
Manager
LOB Financial Item
Fin Item Assignment
Revenue Summarization AR Headers & Lines
CCID Dimension Mapping
AR Distribution
Company
Sales Order Customer
Incremental Refresh
Natural Account
Sales Channel Company Cost Center
AR Revenue Base Summary Product Full Refresh
Product Category
MV AR Revenue by Manager, LOB, Sales Channel
Summaries draw on dimension data from all functional areas
Manager
LOB Financial Item
Fin Item Assignment
Revenue Summarization AR Headers & Lines
CCID Dimension Mapping
AR Distribution
Company
Sales Order
Incremental Refresh
Customer
Natural Account
Sales Channel Company Cost Center
AR Revenue Base Summary Product Full Refresh
Product Category
MV AR Revenue by Manager, LOB, Sales Channel
No need to replicate data, remap foreign keys, etc.
Manager
LOB Financial Item
Fin Item Assignment
All At Once?
All At Once? Does Oracle make it easy to implement in phases and integrate with my other systems?
All At Once? You can start with one business flow…
All At Once? … and implement more when you’re ready
Phased Implementation
Business Flow Accelerators Low Risk, Rapid Deployment y Leverage the setups and reference data you are already maintaining y Business Flow Accelerators give you a baseline implementation of each business flow –
Tested and ready to go if it meets your needs
–
A great starting point if your situation is more complex
y Both horizontal flows and industry specific flows
Integration
What Does Integration Require? y From the Applications –
Event detection and APIs
–
Ability to read and write standards-based XML messages
y From the Integration Platform –
Transform messages as needed for other systems
–
Transport messages and enforce security
–
Model and execute “public processes” that span systems and track status in a single place
–
Provide adapters to many systems
Open for Integration
Marketing Supply Chain Sales
Customers, Products, & Everything Else!
HR
y E-Business Suite facilitates integration by:
Financials
Service
Contracts Order Management
–
Detecting business events
–
Creating XML messages encapsulating transaction data
–
Receiving XML messages and routes to appropriate APIs
–
Following OAG standards for XML documents
–
Publishing messages to JMS queues or as Web Services responses
Integration Points: Business Events and Messages y The E-Business Suite provides: –
Over 500 business events to be used as integration points
–
Over 150 OAG implementations
–
Over 30 non-OAG implementations, for certain industries in which a specific standard prevails (e.g. RosettaNet ) Marketing Supply Chain
Sales HR
Customers, Products, & Everything Else!
Financials
Service
Contracts Order Management
XML Transactions: 150+ OAG Implementations Acknowledge PO
Add PO Requisitn
Cancel PO Requisitn
Change PO
Confirm BOD
Create ProdOrder Requisitn
Process Invoice Payment PO
Show Shipment Delivery SalesOrder PmtError PmtAdvice Requisitn PlanSchd
Update Delivery
Sync PO Supplier Item UOMGroup Field Exchngrate COA PlanSchd ShipSchd
ProdOrder
ProdOrder
Requisitn
Inventory SalesOrder
XML Transactions: 30+ Non-OAG Implementations Rosettanet 3A4 3A6
IFX Bank Statements
SEVIS Students Transcripts
US Dept of Education Financial Aid (Grant/Loan)
PESC Degree Audit
Proprietary Lease Booking Lease Quote Lease Restructure Loan Booking Loan Restructure
Web Services Available in 11i.8 Full Support for TCA y 6 “high level” business object web services y Create, Update, and Query services for –
Person
–
Organization
y Each service encapsulates all TCA-related information about the person or organization
Web Services Available in 11i.8 Full Support for TCA y 53 TCA public API-based XML web services y Create and Update services y Available for TCA entities
Web Services in 11i.8 Party Services CreateOrganization CreatePerson CreateGroup UpdateOrganization UpdatePerson UpdateGroup
Party Contact Services CreateOrgContact CreateOrgContactRole UpdateOrgContact UpdateOrgContactRole
Person Info Services CreatePersonLanguage UpdatePersonLanguage
Location Services CreateLocation UpdateLocation
Party Site Services CreatePartySite UpdatePartySite CreatePartySiteUse UpdatePartySiteUse
Contact Point Services CreateContactPoint UpdateContactPoint
Relationship Services CreateRelationship UpdateRelationship
Classification Services CreateClassCategory CreateClassCategoryUse CreateClassCodeRelation CreateCodeAssignment UpdateClassCategory UpdateClassCategoryUse UpdateClassCodeRelation UpdateCodeAssignment
Contact Preference Services Relationship Type Services CreateContactPreference CreateRelationshipType UpdateRelationshipType
UpdateContactPreference
Web Services in 11i.8 Customer Account Services CreateCustAccount (for org) CreateCustAccount (for person) CreateCustAcctRelation UpdateCustAccount UpdateCustAcctRelation
Customer Account Site Services CreateCustAcctSite CreateCustSiteUse UpdateCustAcctSite UpdateCustSiteUse
Customer Profile Services CreateCustomerProfile CreateCustProfileAmount UpdateCustomerProfile UpdateCustProfileAmount
Customer Account Role Services CreateCustAccountRole CreateRoleResponsibility UpdateCustAccountRole UpdateRoleResponsibility
Tax Assignment Services CreateLocAssignment UpdateLocAssignment
Data Transformation Transport & Security
y iAS facilitates integration by:
Oracle9iAS
–
Providing a delivery mechanism for standards-based messages
–
Providing packaged adapters to transform messages for a broad set of systems
–
Modeling public processes that involve multiple systems
–
Providing information about status of multisystem processes
Adapters
Integration
Business Process Mgmt
Complete Integration Platform y Built on J2EE Architecture y Based on Open Standards • B2B Integration
Supply Supply Chain Chain
• Packaged Applications
Marketing Sales
HR
Customers, Products, & Everything Else!
Financials
9iAS Service
Contracts
• Databases • Messaging Systems
Order Management
• Mainframes • TPMonitors • CICS
Open Standards-Based Integration Built on a J2EE Architecture
Integration Services
Technology/Standard
Business Process Mgmt
W3C Process Modeling, BPML, BPEL
Web Services
WSDL, UDDI
Adaptors
J2CA, Web Services
Documents
XML, OAG, RosettaNet, ASC X12, EDIFACT
Messaging
JMS
Transport
SMTP, HTTP, HTTPS, SOAP, FTP, RNIF
Security
SSL, LDAP, X.509, PKCS7
Complete Integration Platform y Single Platform for EAI and B2B Integration y Comprehensive Web Services Infrastructure y Broad Connectivity via Adapters • B2B
Integration
Supply Supply Chain Chain
• Packaged Applications
Marketing Sales
HR
Customers, Products, & Everything Else!
Financials
9iAS Service
Contracts
• Databases • Messaging Systems
Order Management
• Mainframes • TPMonitors • CICS
Fast Deployment via Packaged Adapters – Oracle Provided Databases Oracle7.3, 8.0, 8i, 9i MS SQL-Server IBM DB/2 UDB DB/2 on Mainframe Sybase Informix JCA Datasources
Messaging Any JMS Provider Oracle AQ MQ-Series TIBCO SONIC
Components Web Services EJB, CORBA
Applications SAP R/3 SAP R/4 Oracle 10.7 Oracle 11.5.X Peoplesoft 7 Peoplesoft 8 Siebel 7 Siebel 2000 JDEdwards
Mainframe & TPM CICS Encina Tuxedo IMS VSAM 3270 Screenscrape
Transports HTTP, HTTP-S FTP, FTP-S SMTP RMI, RMI/IIOP SOAP Flat File
B2B Connectivity RosettaNet 1.1, 2.0 HL7 2.0, 3.0 EDI X.12, EDIFACT
Datatypes SQL, XML IDOCs, PS MADs OAGIS 7.0, 8.0 EDI X.12, EDIFACT RNIF 1.1, 2.0
Complete Integration Platform y Business Processes Modeled in Metadata –
Facilitates reuse, extension, versioning
y Business Process Intelligence
Supply Supply Chain Chain
• B2B Integration
• Packaged Applications
Marketing Sales
HR
Customers, Products, & Everything Else!
Financials
9iAS Service
Contracts
• Databases • Messaging Systems
Order Management
• Mainframes • TPMonitors • CICS
Minimizing the Cost of Customization
Standards-Based Extension Minimizing the cost of custom development y Highly configurable system allows extensive tailoring without code changes –
Flexfields
–
Folders
–
HTML Self Service Personalization Framework
–
Workflow
y Event-based callouts let you integrate your extensions without changing shipped code –
Business Event System
–
Custom Library
y Many customers have implemented 11i without customizing Oracle code
Standards-Based Extension Minimizing the cost of custom development y Program in Java –
Java is industry standard technology
–
Easy to find people with the right skills
–
Java skills can be leveraged across your other projects
y JDeveloper lets us build business logic that can be reused in user interfaces, Java APIs, and web services
Summary
Why Would You Do This… Financials
CRM
Supply Chain
Warehouse
Why Would You Do This… Financials
CRM
Supply Chain
Warehouse
…When You Could Do This?
Single Global Database
Only Oracle’s E-Business Suite… y Assumes the advanced features of the Oracle database in designing applications y Real Application Clusters y Materialized Views with Incremental Refresh
Single Global Database
Only Oracle’s E-Business Suite… y Breaks from conventional limitations that constrain database-independent vendors
Single Global Database
Integration y It is better to implement pre-integrated applications than to integrate disparate systems • B2B Integration
Supply Supply Chain Chain
• Packaged Applications
Marketing Sales
HR
Customers, Products, & Everything Else!
Financials
9iAS Service
Contracts
• Databases • Messaging Systems
Order Management
• Mainframes • TPMonitors • CICS
Integration y When you do need integration, we minimize your cost with a standards-based approach • B2B Integration
Supply Supply Chain Chain
• Packaged Applications
Marketing Sales
HR
Customers, Products, & Everything Else!
Financials
9iAS Service
Contracts
• Databases • Messaging Systems
Order Management
• Mainframes • TPMonitors • CICS
Integration: Only Oracle Has Both y A full suite of integration-ready applications y An integration platform competing in the systems product market
Supply Supply Chain Chain
• B2B Integration
• Packaged Applications
Marketing Sales
HR
Customers, Products, & Everything Else!
Financials
9iAS Service
Contracts
• Databases • Messaging Systems
Order Management
• Mainframes • TPMonitors • CICS