oracle application express (apex) for e-business suite ... materials_ analytics for... · 2 oracle...
TRANSCRIPT
1
Your friend in the business.
Oracle Application Express (APEX) For E-Business Suite Reporting
2
Oracle Application Express (APEX) What is Oracle APEX?
• Database centric Rapid Application Development (RAD) Tool
• No cost feature of the Oracle Database – All Editions
• 100% Browser-Based and Declarative (Limited Coding)
• Use SQL Workshop to create and manage DB objects
• Use Application Builder to create Web 2.0 Applications
• Leverage SQL skills to build reports, charts and data entry forms
• Out of the box Excel import and export capabilities
• No additional development tools needed to get started
3
Data-driven Applications
Develop opportunistic and
departmental productivity
applications
Online Reporting Build SQL-based reporting applications
on existing database schemas
Access Replacement Consolidate outgrown Access
applications to the Oracle database with
an APEX Web front end
Spreadsheet Web-ification Convert spreadsheets to Web applications
where they can be concurrently viewed and edited
Application Modernization Leverage your existing SQL skills to
move applications to HTML / Web 2.0
Oracle Application Express (Oracle APEX)
Use Cases
4
Oracle Application Express (Oracle APEX) Powerful User Driven Interactive Reports
• Case in Point: Oracle Audit Vault used to have over 300 reports defined that they replaced with approx. 30 Interactive Reports.
• Much lower development and maintenance effort and much more capabilities for the end users.
• Now auditors can pick the columns that are important to them and arrange the information as they need to for each specific audit rather than trying to find a
• pre-defined report that is close to their requirements.
• Interactive Reports are very simple to write “SELECT * FROM My_Favorite_Table” but very powerful reporting capability
• End Users can manipulate the data by selecting columns, sorting, filtering, adding computations, highlights, aggregates and more.
• Then they can save the reports, download them or subscribe to them.
5
Oracle Application Express (Oracle APEX) Robust SQL based Charts, Maps, and Gantts
• APEX includes a wide variety of “Flash-preferred” or HTML5 Charts to visually show your data
• When defined as “Flash-preferred” then if Flash is not available such as on an iPad, then the chart will be rendered using HTML5.
• Maps can show country or state aggregates • You can also define Project and Resource Gantt Charts • You simply define the chart type and corresponding SQL source
6
• Declarative support for building mobile web applications
– The Application Builder is enhanced to support the declarative building of mobile applications. Among the numerous changes made are: Updated Create Application wizard to support generation of applications for Desktop or Mobile; Updated Create Page and Region wizards, to expose Components applicable to Mobile applications
• APEX Applications support multiple user interfaces: e.g. Desktop and Smartphone
• Mobile pages use jQuery Mobile through jQuery Mobile based themes and templates
– By incorporating jQuery Mobile application wills render correctly on all mobile devices, old and new. Applications will run on iOS, Android, Blackberry, Windows Mobile etc.
– For older devices that don’t fully support HTML5 equivalent components will be rendered so that users can still maintain data.
• HTML5 charts and new HTML5 item types
– Updating charting engine allows defining HTML5 charts for mobile applications
– Text fields can now have sub-types of Email, Phone and URL which will bring up appropriate keyboards on HTML5 compliant devices
Oracle Application Express (Oracle APEX) Mobile Support
7
Extending Oracle EBS R12 w/ APEX Web Enable Your EBS Data
8
Extending Oracle EBS R12 w/ APEX Utilize EBS Authentication & Authorization
Authorization • Responsibilities
• Menus
• Functions
Authentication • User Accounts
9
Extending Oracle EBS R12 w/ APEX Dashboards & Analytics
10
Extending Oracle EBS R12 w/ APEX Mobile EBS
11
Extending Oracle EBS R12 w/ APEX Modernize Existing Custom Forms
12
Extending Oracle EBS R12 w/ APEX Connect Through Web Services
Restful Web
Services
13
Oracle Application Express (APEX) OTN downloads by Calendar Year
• Oracle Application Express is distributed on OTN and with all editions of the database including Oracle XE.
• APEX is the number 3 most popular discussion forum on OTN, only behind “Database” and “SQL”
• Over 25 books have been published in the last 3 years on APEX
14
Extending Oracle EBS R12 w/ APEX Architecture
• Application Express installed in EBS Database
• Java based APEX Listener provides web server
15
Oracle Application Express (Oracle APEX)
Browser Based Application Development & Runtime
You do not need any client software – simply a web browser and URL to access development environment and to run applications
16
Oracle Application Express (Oracle APEX)
Pre-Built Administration & Analytics
Workspace Administrators can administer their workspace and use the various reports to monitor activity Manage Service allows them to request more space or access to another schema Manage Users and Groups allows them to define developers and end-users
17
Screen Shots from
APEX EBS Application
18
APEX Online Invoice Solution
Security
Tab options controlled by EBS
Functions assigned to user’s menu
Dynamically filtered
parameters based on
logged in user
19
APEX Online Invoice Solution
Feature Rich UI
View on aging
for customer
Drill down to
invoice line
Optional parameters
to filter on date
Search within results
20
APEX Online Invoice Solution
Feature Rich UI
Drill down to
lines view
Breadcrumb to
Invoice view
21
APEX Online Invoice Solution
Feature RICH UI
Utilize Standard APEX features:
Download, saved views, graphing,
conditional highlighting etc.
22
APEX Online Invoice Solution
Export Capabilities
Customer can adjust data in their
view and export data to csv for
integration with their own systems
23 Copyright 2014 SmartDog Services, LLC
Contact Us For More Information:
1.800.309.1213 Toll Free
www.smartdogservices.com/who-we-are