APEX Application Upgrades:
Out With The Old, In With The New

Jeff Eberhard


About Me


  • Senior APEX Consultant
  • Insum Solutions
  • Blog: blog.eberapp.com
  • Email: jeff@eberapp.com
  • Twitter: @eberhje


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 and Methodologies
▶ Offices in Canada and USA
▶ Our Core Values : Respect, Teamwork, Integrity, Innovation, Quality and Fun ! 



  • Why?
  • Advisors
  • Manual Upgrades
    • Compatability Modes
    • Old Ways vs. New Ways



Why Upgrade?


  • Security
  • Clarity
  • Maintainability
  • Performance

(YABAOAE) Yet Another Blog About Oracle Application Express (http://joelkallman.blogspot.com)

The Ideal APEX Application (When & Where You Write Code)

  1. Use the declarative features of APEX as much as possible, don't write code.
  2. When you need to venture outside the declarative features of APEX and you need to write code in PL/SQL, be smart about it.
  3. Avoid huge sections of JavaScript and use Dynamic Actions wherever possible.
  4. APEX is just a thin veneer over your database - architect your APEX applications as such.

How do you Upgrade?


  • APEX Application Advisor / APEX Upgrade Advisor
  • Manually identify components to upgrade

APEX Application Advisor



APEX Upgrade Advisor



APEX Release Notes

  • Changed Behavior
  • New Features
  • Functionality No Longer Supported
  • Open Bugs and Known Issues


Release Notes 4.2

Release Notes 5.0 beta

Compatibility Mode

  • 4.2
  • 4.1
  • Pre 4.1

Remove Legacy Javascript




  • Avoid possible future security implications
  • Reduce size of library loaded per page view




Old vs. New

Cascading Select Lists


Old vs. New

Autofill Item Values




Thank You!

Jeff Eberhard
Email: jeff@eberapp.com
Blog: blog.eberapp.com
Twitter: @eberhje