September 10, 2013

8:30 - 9:30 a.m.

Keynote Address: Update from Development
Joel Kallman, Oracle Corporation

Joel Kallman, Director of Software Development for Oracle Application Express and co-founder of the framework, will provide an insight into Oracle Application Express and Oracle Database features pertinent to the Application Express development community.

Session 1
9:45 - 10:45 a.m.

My First Mobi : Starting Mobile Development with APEX
Roel Hartman, APEX Evangelists

With the release of APEX 4.2 we can develop applications for mobile devices like we've never done before. In this session you will learn (and see) how to develop an application that doesn't only look awesome, but is also full of functionality. Forms, Reports, transitions, etc : After this session you can build everything you've seen in a native application yourself!

Instrumenting your PL/SQL and APEX Applications
Martin D'souza, Clarifit 

Code instrumentation is critical in helping developers debug applications. This presentation will cover various instrumentation tools including Logger which is an open sourced PL/SQL logging tool used in many organizations. The latest features of Logger will be discussed along with integration into APEX, and how to take proactive approaches to error handling in your applications.

Session 2
11:00 a.m. - 12:00 p.m.

Preventing Unintended Denial of Service (or Politely Asking Users to Be Patient)
Anton Nielsen, C2 Consulting

The APEX architecture provides rapid access to Oracle data and powerful reporting capabilities. Some situations can inadvertently cause huge numbers of connections to the database, causing the application or the entire database to become unusable. This session will demonstrate the scenarios that can cause this situation and provide solutions and discuss new APEX features that apply.

Building Commercial Applications with APEX
Scott Spendolini, Enkitec

Oracle Application Express has proven itself as a powerful development platform for internal development needs in countless organizations worldwide. One of the new frontiers it is starting to conquer is building commercial applications. This session covers what it takes to use Oracle Application Express as a platform for building commercial applications. It looks at all facets of the software development lifecycle and discusses different infrastructures, deployments,
processes, and tools used to make development with Oracle Application Express as streamlined and cost-effective as possible. Real-world examples are given throughout the session. Much of what is discussed in this session can also be applied to medium to large Oracle Application Express projects.

Session 3
1:00 - 2:00 p.m.

Projet la Ruche, expérience client d'un projet majeur avec APEX
Michel Brunelle, Marc Groleau, École Polytechnique de Montréal

Expérience vécue d'un développement de gestion des stages "La Ruche" à l'école Polytechnique de Montréal. Cette application gère le cycle complet d'attribution des stages autant du côté employeur, stagiaires que du côté administratif.

Entièrement développée avec APEX par une équipe de plus de 15 personnes sur un échéancier de plusieurs mois, venez apprendre comment s'est déroulé le projet du point de vue de l'utilisateur principal.

I Have Been Doing It In Excel… Can I Do It In Application Express?
Chandra Movva, Synerz Technologies Inc.

Your organization is struggling with a proliferation of spreadsheets. So you decided to use Oracle APEX and converted Excel spreadsheets into an Oracle APEX app. Now you are tasked and challenged by your business user to format the data in Interactive and Classic reports that should look exactly like Excel spreadsheets.
 
In this presentation, you will learn to customize Interactive as well as Classic reports to your business user (more specifically financial business user) needs by exploring under the skin of APEX and also learn various tips and techniques to provide visual appeal.

Session 4
2:15 - 3:15 p.m.

Automatic For The People - End To End Automatic Testing of Your APEX Application
Roel Hartman, APEX Evangelists 

Continuous integration is a well known aspect of Java development projects. Key here is automated testing of all parts of the solution, back-end as well as front-end. In this session you will learn how to use not only the already better known automated back-end testing facilities for PL/SQL, but also how to automate testing of your user interface. Using this approach you can execute regression tests, aiming at a reliable and stable outcome.

APEX Multilingual Applications
Francis Mignault, Insum Solutions

During this session, the participant will learn how to create and maintain multilingual applications. I will show how to run the APEX builder in multiple languages and explain the translation process. I will also demonstrate how to export and import the translated applications and how to add the ability to switch from one language to another during the execution of an application.This session contains technical information as well as some live demonstrations.

Session 5
3:30 - 4:30 p.m.

High Performance PL/SQL
  Steven Feuerstein, Dell 

Users hate to wait - for anything. For our applications to be successful, they not only must be correct (meet user requirements) and maintainable. They must also execute efficiently enough to avoid user frustration. This session reviews the most important techniques for improving PL/SQL performance, including data caching, FORALL and BULK COLLECT. After attending this session, you will be able to proactively identify opportunities for applying techniques that will most dramatically (generally, an order or magnitude or more) improve the performance of your PL/SQL code.

Deploying and Developing Application Express with Oracle Database 12c
David Peake, Oracle Corporation

Learn how you can take full advantage of the new Oracle Database 12c Multitenant Architecture with various deployment options for Application Express. This new architecture provides great flexibility and will change the way you manage your Application Express environments for development, test and production. This session will also cover new capabilities defined within Application Express to take advantage of other Oracle Database 12c features.

8:30 - 9:30 a.m.

Keynote Address: Coding Therapy for Software Developers, aka "How Does This Code Make You Feel?"
Steven Feuerstein, Dell

We can't write software without our brains, and our brains come with a full load of "issues." The way our brain remembers the past and projects into the future has a big impact on how we write code. Moving beyond physiology, human psychology also plays its role, making it difficult for us to acknowledge ignorance and ask for help. Steven will in this session address offer an intensive coding therapy session (including couples therapy, dream therapy, game theory, and shock therapy) to help all attendees come to grips with their innate, unavoidable "issues", making it easier to write better code -- and help others on their team write better code.

Session 6
9:45 - 10:45 a.m.

APEX Single Sign On
Anton Nielsen, C2 Consulting

  This session will cover single sign-on among APEX applications within the same workspace, separate workspaces and separate databases.  It will also provide a method for secure single sign on from other applications to APEX applications.

APEX Technical FAQ
Francis Mignault, Insum Solutions

Common questions on APEX often are about the infrastructure and on how complex it is to install, maintain, and upgrade. This session will demystify the APEX installation based on Frequently Asked Questions from customers, dba and developers. Architecture, install, upgrade, schema management, installing APEX with EBS, and backups will be some of the subjects covered in this session.

Session 8
1:00-2:00 p.m.

APEX Behind the Scenes
Scott Spendolini, Enkitec

Oracle Application Express is truly an amazing and robust development platform, enabling developers to build applications to meet almost any requirement. But behind the scenes, this sophisticated development tool is quite simple.
This session will explore the inner-working of APEX and describe just what happens when you view or submit a page. The overall intention of discussing APEX at such a low level is to provide APEX developers -beginners & advanced alike - with a better understanding of the environment, which will enable them to build better applications.

APEX Development Best Practices
Martin D'Souza, Clarifit

With Application Express developers can develop with various coding standards and techniques. Though no one practice is better than the rest there are some best practices that developers should adhere to. This presentation will cover such best practices for developing your applications. Topics include backups, version control, and security

Session 9
2:15 - 3:15 p.m.

Finding the Needle in a Haystack or Troubleshooting an APEX Issue
Roel Hartman, APEX Evangelists

An ORA-4030 error (out of process memory) in the alert.log of the database; a trace file with a PL/SQL snippet containing wwv_flow calls and a Linux server that uses way too much memory. What can you do to find the cause and - hopefully - solve this problem?

Follow a real live step-by-step approach on troubleshooting this particular APEX issue - but the process can be applied on any APEX issue you might encounter.

New Development Techniques in Application Express 5.0
David Peake, Oracle
Application Express 5.0 introduces a new page designer together with new region and item types. Learn about how these new capabilities will make it easier and more productive to build APEX applications in Application Express 5.0.

Session 10
3:30 - 4:30 p.m.

Expert Panel