oracle web applications
TRANSCRIPT
![Page 1: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/1.jpg)
The Beauty of Oracle’s Web Enabled Applications
Richard Byrom
Oracle Applications Consultant
UKOUG November 2004
![Page 2: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/2.jpg)
Agenda
•Problem Statement•Solution•Oracle’s Response•Conclusion•Questions & Answers
![Page 3: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/3.jpg)
Problem Statement
•Disparate Reporting Solutions
•Application Fragmentation•Data Separation – non relational
•Lack of Standardisation•Local as opposed to shared working environments
Applications
Reports and Intelligence Tools
Database
![Page 4: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/4.jpg)
Solution – Web Services
•Applications on Demand•Secure and Universal Access •Business Integration
Applications
Reports and Intelligence Tools
Database
Web
![Page 5: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/5.jpg)
The Oracle Information Architecture
•Unified data model•Accessible by anyone, with any device•Global •Configurable•Open
![Page 6: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/6.jpg)
Oracle Product Specific Solutions
• This presentation will look at Web ADI, Web OFA/EPB and Web Discoverer
• It’s primary purpose is to encourage attendees to look at having all of these products running via a single web interface through 11i E-Business Suite.
![Page 7: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/7.jpg)
Web ADI – Product Roadmap
Web ADI•Journal Wizard – Released•Asset Wizard – Assets Team•Inventory Wizard – Assets Team•Budget Wizard – Patch Set E
Report Manager•Report Submission and Publishing – Patch Set G•Report Wizard – Patch Set H•Analysis Wizard – Patch Set H
![Page 8: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/8.jpg)
Web ADI – Journal Creation
![Page 9: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/9.jpg)
Web ADI – Coming in 11.5.10
General Ledger•Upload daily rates•Upload and download historical rates•Upload Journals
Financials Intelligence
Upload budget and forecast information
![Page 10: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/10.jpg)
Web ADI – Coming in 11.5.10
Project Accounting•Download lists of projects, issues and change documents
•Download and upload budget and forecast information
Student Systems•Download student lists•Download and upload unit grades and assessment item outcomes
•Download and upload progression outcomes
![Page 11: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/11.jpg)
Web ADI – Coming in 11.5.10
Engineering Online
Download and upload items in the engineering Catalog
Sales Compensation
Download commission statement
Internal Controls Manager
Upload all risk library objects – processes,
risks, controls, and audit procedures
![Page 12: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/12.jpg)
Web ADI – Coming in 11.5.10
Public Sector Financials International
Download and upload Inflation Accounting data
Trade Management•Create resale data (point of sales or indirect•sales data)•Customer or partner claim reason codes•Upload customer or partner claims
![Page 13: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/13.jpg)
Web ADI - Internet Computing Architecture
DatabasDatabasee
XApplicatioApplicatio
nn
ApplicatioApplicationn
ApplicatioApplicationn
ApplicatioApplicationn
ApplicatioApplicationn
ApplicatioApplicationn
BrowserBrowser
BrowserBrowser
JavaJavaApplication Application
ServerServer
ApplicatioApplicationn
ApplicatioApplicationn
2 Tier
3 Tier
![Page 14: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/14.jpg)
Web ADI – Installation Setup
Metalink•Download and install Patch Set C 2819091•Download and install Rollup Patch 5 3624372•Both of these patches are included in 11.5.10
Setup
In the System Administrator responsibility give yourself the Web ADI Responsibility – this will give you three menus•Create Document•Create Layout•Create Mapping
![Page 15: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/15.jpg)
What is OFA?
Oracle Financial Analyzer is a pre-packaged Online Analytical Processing (OLAP) application built with a Visual Basic front-end and an Oracle Express multi-dimensional data structure back-end. It is tightly integrated with Oracle General Ledger.
![Page 16: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/16.jpg)
Financial Analyzer Highlights
• Intuitive, easy information access• OFA is an “End-User Managed” Application• Utilizes Oracle Express, a specialized OLAP database designed
for powerful analysis, fast reporting, computations and modeling• Robust Data Security by user at several levels:
Financial Data Item (locking Actuals, Budget, etc.)
Dimension level (e.g. CCtr)• Deployment Architecture Flexibility
centralized (server based), distributed, stand alone • Integrated with Oracle GL via GL Link, but can run independently
![Page 17: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/17.jpg)
Oracle Financial Analyzer - Interface
The Financial Analyzer Web interface provides access to reports, graphs, and data entry forms through a Web browser.
![Page 18: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/18.jpg)
Benefits of Web Publishing
•Uses standard browser - no client s/w•Currently no license fee for web-only users•Accesses the Shared database
Simplifies administration
Minimizes disk usage
•Tremendous flexibility in distributing specific slices of data to subsets of users
![Page 19: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/19.jpg)
Limitations of Web Publishing
•Provides read-only access•Calculated rows & columns do not display Calculated FDIs and Models can be substituted
•Numeric scaling does not work•Various formatting features do not work•Licensing rules may change
![Page 20: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/20.jpg)
Oracle Financial Analyzer – Setup Information
System Requirements
In addition to the standard Financial Analyzer server components, the following server components must be installed:•Express Server, including Oracle Express Web Agent. The following configuration options must be selected in Express Configuration Manager:
The Web Authentication Type property on the Web Agent tab must be set to BASIC
The Require Password Encryption property on the Security tab must be set to NO
•A supported Web server such as Apache
![Page 21: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/21.jpg)
Oracle Financial Analyzer – Set up steps
Browser requirementsUsers must have the appropriate browser installed on the PC. User requirementsTo access Financial Analyzer through the Web interface, you must have a valid user ID. You must also be set up as a user in Financial Analyzer.Methods of AccessFinancial Analyzer can be configured for direct access, or for access through Oracle Applications.
![Page 22: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/22.jpg)
OFA – architecture
Oracle GL
OFA/Express Server
EBS Database
Express Database
OFA/Express ClientApplication S
erver
Brow
ser
![Page 23: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/23.jpg)
Enterprise Planning and Budgeting
• Product to be released end of September, 2004
• Delivered as part of Oracle Applications, but can be run standalone
• Delivered as a patch to Oracle Applications 11.5.9Included as part of the rapid install for 11.5.10
• Backports of EPB to 11.5.8 or earlier are not feasible
• Requires Oracle9i Database 9.2.0.5 plus OLAP Option
• If a customer has 10.7 or 11.0.x or no Oracle Applications, then the product can be a standalone solution
![Page 24: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/24.jpg)
Migration From OFA and OSA
•OFA and OSA 6.4 will be supported until mid 2008 with error correction support until end of 2006
•Oracle will provide a migration path for existing customers of OFA and OSA to migrate their implementations to EPB
•Migration paper on http://www.oracle.com/applications/cpm
![Page 25: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/25.jpg)
Migration Data Flow
OFA/OSAExpress
databases
1. Map dimensions and variables to standard schema for EPB
Interface Tables
Oracle9Oracle9ii
EPB Schema
EPB Tables
OLAP
Analytic Workspace
BI Beans Repository
Tables
2. Map documents, folders, saved selections to BI Beans
APPS Security
Tables3. Map users to Apps security
![Page 26: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/26.jpg)
Oracle Discoverer Features
![Page 27: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/27.jpg)
Oracle Discoverer Components
Discoverer Plus - http://hostname.domain/discwb4/html/english/welcome.htm
A web-based development tool used to access the EUL to create and modify workbooks.
![Page 28: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/28.jpg)
Discoverer Viewer
Discoverer Viewer - http://hostname.domain/discoverer4i/viewer
Oracle Discoverer 4i Viewer is a tool for viewing workbooks created by users of the client/server or web versions of Discoverer Plus.
Oracle Discoverer 4i Viewer can also be used to integrate database output into a web site and portal and is easily customized to conform to a particular web site look and feel, or to build custom Discoverer applications for the web.
![Page 29: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/29.jpg)
Oracle Discoverer Features Matrix
Function Desktop Plus Viewer Portlets Create / Edit Query Yes Yes No No View Query With Dynamic Data Yes Yes Yes No View Query With Snapshot Data No No No Yes BI Beans Based Charting No Yes Yes Yes Export To Microsoft Excel Yes Yes Yes No Deliverable As Portlet No No No Yes Integrated With Oracle Single S ign- On No Yes Yes Yes Create Worksheet Parameters Yes Yes No No Apply Parameters To Worksheet Yes Yes No No Create / Edit Conditions Yes Yes No No Create / Edit Calculations Yes Yes No No Save The Workbook Yes Yes No No
![Page 30: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/30.jpg)
Oracle Discoverer – Web limitations
Features Not Available Made Available in
SubqueriesFind in Item Navigator Oracle 9iAS Discoverer 9i (9.0.2)
Find / Find NextUndo/Redo SupportSchedule Workbooks Oracle9iAS Discoverer 9i (9.0.2) Create / Edit title Oracle9iAS Discoverer 10g (9.0.4) Exception formatting Improved Printing On going improvements to be madeSelect / select all Cut / copy / paste Item formatting Export to Reports in XML Oracle9iAS Discoverer 9i (9.0.2) Item properties
Interactive pivotDrill to detail Drill Dialog Drill to BLOB
Save/open to/from file
Query Building
Reporting
Analysis
Workbooks
![Page 31: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/31.jpg)
Discoverer Plus Architecture
Source: Oracle Discoverer 4i Configuration Guide for Oracle9i Application Server
![Page 32: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/32.jpg)
Discoverer Viewer Architecture
Source: Oracle Discoverer 4i Configuration Guide for Oracle9i Application Server
![Page 33: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/33.jpg)
Discoverer Viewer – take the guided tour
http://www.oracle.com/technology/products/discoverer/files/viewlets/9iAS_Disco_viewer_part1_viewlet.html
![Page 34: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/34.jpg)
Oracle Discoverer - Setup
Metalink Note 146468.1
![Page 35: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/35.jpg)
Single Sign-On
•Build a portal or information gateway for all of your products
•OFA, Discoverer and ADI can be run from the Apps logon page.
•Where separate roles exist linkage should be maintained
![Page 36: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/36.jpg)
Conclusions
• Web Services provide you with Platform independent solutions for your application and reporting needs.
• Use the Oracle Tools together to support your strategy.
• Oracle’s web strategy and associated products allow you to adopt a web services strategy in your organisation.
![Page 37: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/37.jpg)
AQ&
![Page 38: Oracle Web Applications](https://reader033.vdocuments.us/reader033/viewer/2022061304/54fd5a0a4a7959903c8b49fd/html5/thumbnails/38.jpg)
Speaker Information
Name: Richard Byrom
e-mail: [email protected]
Company: Thales Information Systems
Web Site: http://www.thales-is.com
http://www.richardbyrom.com
Mobile: +44-7976123106