Oracle Application Express and Oracle E-Business Suite. Love and Mariage!

Oracle Application

Express and Oracle

E-Business Suite

1 2 3 4 5 2 ► About me

► _{EBS Development Challenges}

► _{EBS and APEX}

► Examples of APEX extension for EBS ► Conclusion

3

► Oracle E-Business Suite-APEX Practice Director

► Over 14 years Oracle EBS technical / functional consultant

► Developed EBS application integration and customizations

► Involved with numerous EBS implementations and upgrades starting with release 10.7 up to R12

► Oracle SOA integration

► APEX developer since 2007

4

► Oracle APEX expert practice since 2004 ► Oracle APEX Center of Excellence

► _{Comprehensive Consulting Services}

► Training & Coaching

► Architecture & Analysis

► Project Management

► On-site / Off-site Development

► APEX Best Practices, Methodologies and Toolkit

► _{Offices in Canada and USA}

► _{Our Core Values : Respect, Teamwork, Integrity, Innovation, Quality}

EBS Development

challenges

EBS Development Challenges

6 ► Integrate more business processes in EBS

► Provide lightweight customized solutions to users

► Improve user productivity (remove manual processes) ► Excel / Access replacement improving data security and

centralization of the information ► Mobile applications

EBS Development Types

7

Extension

Personalization

EBS Development Types - Personalizations

8 ►

Options for Personalizations

► OA Framework

EBS Development Types - Customizations

9 ►

Options for Customizations

► Adding triggers to Oracle database tables

► Modifying OAF controllers, Forms code, PL/SQL code, etc.

► Modifying an existing object and saving it to a new name (forms, reports, etc.)

► Customizations-in-place will be overwritten by patches and upgrades

EBS Development Types - Extensions

10 ►

Options for Extensions

► Oracle Forms

► Oracle Reports / BI Publisher

► Oracle Application Framework (OAF)

► Application Development Framework (ADF)

E-Business Suite Extensions

11

Interfaces Mobile

Why use APEX ?

13

►

Oracle Application Express

► Rapid Application Development (RAD) browser based tool for the Oracle Database (Cloud Ready)

► Leverages full Oracle database capabilities

► Reuse your existing SQL & PL/SQL resources skillsets

► Fully supported, “no-cost” standard component with all editions of

Why use APEX ? cont’d

14 ► Fully integrate with E-Business Suite (from 11i to R12.x)

► Can provide the same look and feel as E-Business Suite

► Out of the box reporting functionalities enhancing end-user productivity:

 On screen Interactive Reports

 Searches on multiple fields

 User defined report format

Why use APEX ? cont’d

15 ► Can define RESTful services (allowing to act as web service

provider)

► Mobile Ready (Mobile or Responsive) ► Insum integration package for EBS

Recommended Architecture

16

► _{Oracle Application Express resides within the Oracle}

database in its own schema

► REST Data Services / Weblogic installed on the application

Recommended Architecture

APEX integration with EBS

18

1 – APEX application accessing EBS Data externally 2 – APEX application integrated in EBS menu structure

EBS Security Overview

EBS Security Overview cont’d

EBS Security Overview cont’d

APEX Security Overview

22

Authentication

► Oracle Single Sign-On / SSO authentication in APEX ► _{Oracle Access Manager (OAM) authentication in APEX}

► HTTP Header Based, see white paper.

► _{APEX authentication with EBS credentials (standalone)} ► Custom authentication (integrated in EBS menu)

APEX Security Overview cont’d

APEX Security Overview cont’d

24

Authorization

► Validate APEX page authorization against EBS function within

menu and responsibility

► Validation can also be against page components just like EBS

Recap : Steps for EBS/APEX Integration

25

► Install APEX as recommended

► Install the Insum integration package

► Configure the Oracle Application Express login process (authentication)

► Define Oracle Application Express authorizations

► Define EBS functions to link to APEX pages

► Define EBS Security (menu and responsibility)

Accessing EBS data from APEX

Insum Integration Package for EBS

27 The Insum Integration Package for EBS allows any APEX application to recognize the EBS context:

► Current EBS Session Data

► Profile Values

► Organisation Security (Operating Units and multi-org)

► User Security

The Insum Integration Package is created in the APPS schema (as per EBS development standards) and granted to the custom APEX schema

APEX Integration / EBS Versions

28

► Version 11i

► Version R12.1 with 12.1.3 integration patch

Technical Requirements

29

► Oracle E-Business Suite 12.1.3 or above* (custom config for 11i / 12.1)

► Oracle E-Business Suite Patch 12316083*

► Fully Licensed Oracle Database

► _{Oracle Application Express (Free Download at APEX.ORACLE.COM)} ► Oracle REST Data Services (Free Download)

*_{Note: The requirement of having EBS R12.1.3 comes from the prerequisite}

patches R12.AD.B.delta.3 and R12.ATG.B.delta.3 of the APEX support patch 12316083.

EBS Integration with APEX White Paper

EBS and APEX 5.0

31

► 100% Compatible with EBS

► New Functionalities / Rapid Development (Page Designer)

► Upgrade APEX with ZERO impact on the EBS Installation

Examples of APEX

Extensions

Examples

34

► Demo 1 : System Administrator Workbench

► Demo 2 : Supplier Trends Dashboard

► Demo 3 : Simplified Invoice Entry

Oracle Store

Conclusion

There are many advantages for using APEX to build EBS extensions. From a technical point of view, APEX is:

► Easy to install and configure

► Reuses your organization skillsets

► Supported by Oracle

► Simplifies patches and upgrades

From a business point of view, changing or adding new functionalities can be done rapidly allowing more flexibility to users at a lower cost.

QUESTIONS ?