Check out the presentations listed below.



APEX 5.1: The Smaller New Features You Can't Afford to Ignore
Dietmar Aust , Opal-Consulting
When: Jun 26, 2017, Monday Session 4 , 3:15 pm - 4:15 pm
Room: Larkspur
Topic: Application Express - Subtopic: APEX New Release

With every new release of Oracle APEX, everybody talks about the major (so-called marquee) features such as Interactive Grids, Master-Detail-Detail, the new Charting Engine, and the enhancements to the Page Designer.

But aside from that, typically over 100 smaller enhancements have been added to the product that make our lives as APEX developers a lot easier and are really valuable to learn about, but typically they are not talked about that much.

These features have been analyzed by talking with the APEX team and also by comparing the differences in the data model and APIs between versions 5.1 and 5.0.

These smaller features include the new Proxy Authentication (with ORDS), the change in the architecture (moving to a JSON-based page rendering/submission that removes certain restrictions such as the number of items per page), JavaScript APIs for notifications (apex.message), improvements in the modal dialogs, the JavaScript APIs for the interactive grid, and many more.

Back to Top
Oracle ORDS 101: Jump-Start Your Development
Dietmar Aust , Opal-Consulting
When: Jun 28, 2017, Wednesday Session 16 , 4:15 pm - 5:15 pm
Room: Iris/Lily
Topic: Application Express - Subtopic: Other Application Express

In this session, we will cover: what is REST; what is ORDS; and management of the REST definitions with SQL Developer and the API, use cases and security. Join us for an information-packed hour.

Back to Top
Have You Sampled the Packaged Apps?
Paul Broughton , APEX Evangelists
When: Jun 28, 2017, Wednesday Session 13, 11:15 am - 12:15 pm
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: Other Application Express

APEX 5.1 has over 35 packaged applications, with many showing the very latest APEX enhancements. Many of these may be new to developers, and this presentation will discuss and demonstrate some of these in use, such as the Interactive Grid and Jet Charts. This presentation will dive into a number of packaged applications, looking for some of the most innovative and powerful features. It will demonstrate the basics such as simply installing and managing the packaged applications.

After demonstrating some of these unique features, the presentation will build real-life examples into custom APEX applications.

Back to Top
Going to the Grid: What the APEX 5.1 Interactive Grid Means for You and Your End Users
Karen Cannell , TH Technology
When: Jun 26, 2017, Monday Session 2 , 11:45 am - 12:45 pm
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: APEX New Release

The long-awaited APEX 5.1 Interactive Grid region is here – but what does it mean to you and your end users? Need some practical guidance on when, why, and how to adopt the interactive grid region type? This session is for those who have seen the introductory demonstrations, are looking to upgrade to APEX 5.1, and need some advice. Does the interactive grid replace interactive reports? No more tabular forms? This session answers practical functional and technical questions raised by this new region type:

• When and why should I upgrade existing regions to interactive grid?
• Is there an upgrade wizard?
• What features will I gain; what features will I lose?
• What about customizations – will they upgrade?
• How does an editable interactive grid compare to my existing tabular form?
• Which features must still be manually written? Do I still need to write all that collection logic?
• How can I customize appearance?
• How can I add dynamic actions?
• Can I extend the interactive grid functionality?
• Will my end users like it? What about data entry users?

This session compares and contrasts interactive grids with the interactive reports and tabular forms we are familiar with. We will pay particular attention to maintaining or replacing features and common customizations in existing applications: checkboxes, 32K limits, cascading select lists, row-level validations, interactions between columns, and navigation between fields. How does the interactive grid region measure up? Should you upgrade all your interactive reports and tabular forms now?

Attend and find out.

Back to Top
Securing Oracle APEX: Cross-Site Scripting
Nathan Catlow , Recx Ltd
When: Jun 28, 2017, Wednesday Session 12 , 9:45 am - 10:45 am
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: Other Application Express

Understanding the areas in Oracle APEX that typically result in security problems is essential to building robust solutions. This talk will take an in-depth look at cross-site scripting, undoubtedly the most prolific problem facing APEX applications today. We will be demonstrating the security impact of insecure applications as well as required fixes based on real-world examples.

The power of cross-site scripting attacks are regularly underestimated. In this session, we will demonstrate complex cross-site scripting attacks against APEX applications and use API calls and item settings to ensure the data within your APEX applications remains secure.

Back to Top
Explore the APEX APIs
Martin D'Souza , Insum Solutions
When: Jun 26, 2017, Monday Session 5 , 4:45 pm - 5:45 pm
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: Other Application Express

Most developers new to APEX aren’t aware that APEX comes with a plethora of very powerful APIs for both PL/SQL and JavaScript. This presentation will highlight some of these APIs and explain how and when to use them to speed up and simplify developing your APEX applications. New 5.1 APIs will also be discussed.

Back to Top
#LetsWreckThisTogether APEX Talks
Martin D'Souza , Insum Solutions
When: Jun 29, 2017, Deep-Dive Session, 9:00 am - 11:00 am
Room: Grand Oaks G
Topic: Application Express - Subtopic: APEX Detail Plunge

Just in case you have not received enough inspiring content by the end of the week, the #LetsWreckThisTogether APEX Talks are back. At last year's Kscope, this exciting new format was a success.

Instead of long, in-depth "deep dives" on a single topic, the APEX track of the conference will close with Lightning Talks presented by some of the best and most well-known speakers and personalities in the APEX world.

Learn from the following speakers presenting on diverse, entertaining topics in a fast-paced format:

Dimitri Gielis
Martin Giffy D'Souza
Joel Kallman
Cary Millsap
Vincent Morneau
Peter Raganitsch
Shakeeb Rahman
Jorge Rimblas
Scott Spendolini

Back to Top
This Is How We Do It
Niels de Bruijn , MT AG
When: Jun 26, 2017, Monday Session 2 , 11:45 am - 12:45 pm
Room: Iris/Lily
Topic: Application Express - Subtopic: APEX Real World

Different kinds of APEX projects lead to different implementation techniques. Let us classify the project types we had in the past and how we dealt with them, not only from an implementation standpoint but also in how we interacted with our customer.

Back to Top
Getting Your Grips on Excel Chaos
Niels de Bruijn , MT AG
When: Jun 27, 2017, Tuesday Session 9, 3:30 pm - 4:30 pm
Room: Larkspur
Topic: Application Express - Subtopic: APEX Real World

If historically grown Excel mess in your company sounds familiar to you, then this session is for you. Based on real-world projects, learn how APEX can save end users a lot of time, how the migration is done, and what the strengths/weaknesses of APEX are, as opposed to Excel.

Back to Top
Managing Node.js Instances with Oracle APEX
Kai Donato , MT AG
When: Jun 27, 2017, Tuesday Session 10 , 4:45 pm - 5:45 pm
Room: Azalea
Topic: Application Express - Subtopic: APEX Integration

You want to monitor and manage your Node.js instances using a tool you are already familiar with? One of the most famous frameworks for controlling Node.js instances will be shown integrated in Oracle Application Express. I will show you how to create, manage, and monitor your Node.js instances from an Oracle APEX application.

Back to Top
Professional JavaScript Error: Logging for Oracle APEX
Kai Donato , MT AG
When: Jun 28, 2017, Wednesday Session 11, 8:30 am - 9:30 am
Room: Larkspur
Topic: Application Express - Subtopic: APEX Integration

Are you searching for the missing piece to perform a perfect start for developing with JavaScript in Oracle APEX? This is the right session for you.

You might be familiar with the built-in debugging features in Oracle APEX and searching for a way to debug JavaScript in a similar way. I will show you how I'm setting up my environment and how I enabled my applications to report all errors to the database instead of just printing it in the local browser console.

With this approach, we are able to create additional metrics for loading times and even specific function execution times. The best part of it: we are saving them to the database and show it in an additional analytics application in Oracle APEX! Attend this session to be best prepared for any JavaScript-related work in Oracle APEX.

Back to Top
Performant Faceted Search Navigation in APEX with Oracle JET and PL/SQL Table Pipelines
Erik Espinoza , Viscosity North America
Co-presenter(s): Jason B Canada, Viscosity North America
When: Jun 28, 2017, Wednesday Session 15 , 3:00 pm - 4:00 pm
Room: Iris/Lily
Topic: Application Express - Subtopic: APEX Real World

Faceted navigation is arguably the most significant search innovation of the past decade. Leveraged by retail sites including Amazon, Home Depot, and Zappos, faceted search allows users to quickly narrow a massive result set by giving them guides (the facets) of the major groups of their results. In this session, we discuss both thick and thin ways of doing this, from enterprise applications such as Oracle Endeca to simple methods using PL/SQL pipelined functions. We show you a retail use case and PL/SQL faceted database search, APEX application, and Oracle JET extensions.

Back to Top
APEX for Beginners
Dimitri Gielis , APEX R&D
When: Jun 26, 2017, Monday Session 1 , 10:30 am - 11:30 am
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: Other Application Express

If you've heard about APEX but didn't play with it yet, or only played with it for a couple of weeks, this session is for you. My goal is to save you at least a month of searching and finding your way to build great APEX applications. I'll share how to get started, where the APEX sweet spot is, and common pitfalls you should avoid.

Back to Top
OMG! JavaScript Straight from the Oracle Database
Dimitri Gielis , APEX R&D
When: Jun 27, 2017, Tuesday Session 6 , 8:30 am - 9:30 am
Room: Iris/Lily
Topic: Application Express - Subtopic: APEX Integration

When APEX and the core database features were not enough, I started to investigate how to run JavaScript straight from the database. My results were baffling and I want to share them with you. I'll explain how you can do it yourself and show many live demos where this new technique is useful.

Back to Top
Docker for Dummies
Roel Hartman , APEX Consulting
When: Jun 26, 2017, Monday Session 4 , 3:15 pm - 4:15 pm
Room: Iris/Lily
Topic: Application Express - Subtopic: APEX Real World

You might (or might not) have heard of Docker, but you have no idea what it is and why you should care. But if you are a database or APEX developer and still work with virtual machines, it is about time to broaden your horizon.

In this session, you'll learn what Docker is and how you can benefit from it in your daily work.

Back to Top
Make Your APEX Applications Fly Using JET Components
Roel Hartman , APEX Consulting
When: Jun 28, 2017, Wednesday Session 12 , 9:45 am - 10:45 am
Room: Larkspur
Topic: Application Express - Subtopic: APEX Integration

At Oracle OpenWorld 2015, Oracle introduced JET: JavaScript Extension Toolkit. APEX 5.1 ships with JET and uses it to create the good-looking charts declaratively. But if you know JET a bit better, you can tune the look and feel of the charts even more. And apart from the exposed charts, there are more components in JET you can use in your APEX application. This session will show you how to do that and walk through a way to create plugins for JET components.

Back to Top
Know What Your Code Is Doing; Know What It's Done - How to Instrument Your Code Easily and Effectively
Sabine Heimsath , its-people GmbH
When: Jun 27, 2017, Tuesday Session 10 , 4:45 pm - 5:45 pm
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: APEX Detail Plunge

Do you measure how your code is performing? Do you have the right info at hand when your program fails? Can you monitor your program while running?

This session is all about instrumenting your PL/SQL code, be it inside an APEX application or in a pure PL/SQL environment. What are the alternatives to the very common hand-knitted or organically-grown solutions? We are going to look at a few open-source frameworks and analyze which requirements they can cover and what you might have to add yourself. After this session, you will know what to look for when choosing the right framework to enhance your project.

Back to Top
E-Commerce and APEX, Heaven or Hell?
Tuur Hendrickx , iAdvise
When: Jun 26, 2017, Monday Session 2 , 11:45 am - 12:45 pm
Room: Azalea
Topic: Application Express - Subtopic: APEX Integration

There are plenty of e-commerce site builders around to get your webshop in the air in no time. But can you use APEX to build a similar platform?

In this session I will give you a quick tour through some of the more popular e-commerce site builders. We will compare them and take a look at the pros and cons. Next we will look at the Universal Theme and how it can be used to build an e-commerce platform. I will demonstrate how I implemented a checkout flow and how payment was integrated. At the end of this session you will know whether building an e-commerce platform in APEX is heaven or hell.

Back to Top
Powerful JavaScript Skills for Every APEX Developer
Menno Hoogendijk , Qualogy
When: Jun 27, 2017, Tuesday Session 7 , 11:15 am - 12:15 pm
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: Other Application Express

Are you a developer looking for steady JavaScript skills? We all have to deal with the same issues sooner or later. Knowing about the most common features will help you solve issues and create advanced applications.

We'll go over a lot of topics live: fundamentals, bad practices, their improvements, and new features. The result? End up with professional, organized code.

This session is intended for beginner and intermediate developers. Join my talk and get a better understanding about the ever-changing JavaScript landscape.

Back to Top
Plugin Your APEX Widgets
Menno Hoogendijk , Qualogy
When: Jun 28, 2017, Wednesday Session 12 , 9:45 am - 10:45 am
Room: Iris/Lily
Topic: Application Express - Subtopic: APEX Detail Plunge

APEX 5.1 includes a lot of jQuery widgets and plugins under the hood. Because the development team uses them to create our beloved components as the Interactive Report and Interactive Grid, why not use the technique ourselves?

This session will demonstrate why widgets and plugins are so powerful. Did you know they can be exposed as APEX plugins to reuse them declarative? We'll explore how some of the existing widgets work in order to build our own, step by step.

Back to Top
How to Use APEX to Build and Manage Automated Browser Tests
Simon Hunt , MOD
When: Jun 27, 2017, Tuesday Session 8 , 2:00 pm - 3:00 pm
Room: Iris/Lily
Topic: Application Express - Subtopic: Other Application Express

In this session, delegates will learn how to use APEX itself to build maintainable browser-based automation scripts for fast, consistent, repeatable testing of APEX applications. All the products demonstrated are available through open-source projects, and there is no need for any specialist programming skills other than APEX. Also covered is the ability to call the automation scripts programmatically and run them on a load-testing environment or as part of an automated build process (aka continuous integration). The techniques shown will help developers become more agile in their development and greatly improve the overall quality of their applications.

Back to Top
Event-Driven Applications Using Custom JS Events
Tyson Jouglet , SkillBuilders
When: Jun 27, 2017, Tuesday Session 8 , 2:00 pm - 3:00 pm
Room: Azalea
Topic: Application Express - Subtopic: APEX Real World

Have you ever wanted to have the same dynamic action fire for different events, if the user clicks a button or if she presses enter? Out of the box, it appears that APEX cannot handle this situation. There is a very simple solution using custom events and event emitters in JavaScript.

Back to Top
APEX Sunday Symposium: Update from Development
Joel Kallman , Oracle Corporation
When: Jun 25, 2017, APEX Sunday Symposium Session 6, 3:15 pm - 4:00 pm
Room: Grand Oaks G/E/F
Topic: Application Express - Subtopic: Other Application Express

Join Joel Kallman as he gives us an Update from Development.

Back to Top
APEX Generator: The Clone Wars
Moritz Klein , MT AG
When: Jun 28, 2017, Wednesday Session 14 , 1:45 pm - 2:45 pm
Room: Iris/Lily
Topic: Application Express - Subtopic: APEX Real World

Want to see how you can build 120 fully functional APEX pages in under five minutes? Just rebuild them if the data model changed in the same time? Then this session is for you! See the APEX Generator in action and learn how to use the Data Dictionary and APEX Views to automate APEX page creation.

Back to Top
Uncover the Truth
Oliver Lemm , MT AG
When: Jun 26, 2017, Monday Session 4 , 3:15 pm - 4:15 pm
Room: Azalea
Topic: Application Express - Subtopic: APEX Real World

Got an old APEX Application to migrate or extend? Struggling by not knowing how complex the application is and which pages are full of customized code?
Furthermore, you might not know how the pages are related? Join this presentation to get fast answers for your most important questions. It will be presented how to identify which templates have been changed, how much CSS, JavaScript Code, and PL/SQL Code is hidden in your application pages. Even a tree view for the page navigation can be created automatically to understand how your pages are related.
With this information you can understand the application very fast and it’s much easier to make an effort analysis bringing new features to your application.

Back to Top
Mastering Universal Theme with Corporate Design from Union Investment
Oliver Lemm , MT AG
When: Jun 27, 2017, Tuesday Session 7 , 11:15 am - 12:15 pm
Room: Iris/Lily
Topic: Application Express - Subtopic: APEX Real World

You want to migrate to APEX 5 and the Universal Theme but, until today, you've only seen a few trivial presentations? Furthermore, you want to integrate your's or your customer's corporate design? In this presentation, you will get a bunch of knowledge which will help you to migrate to the Universal Theme. The APEX Application FondsProfiler was created in 2011 with APEX 4.1 and Theme 22.
The first step to the Universal Theme is to choose which old templates should be mapped to which templates from the Universal Theme. Then you have to make the choice between keeping the subscription to the Universal Theme and trying to make the design changes only with CSS, jQuery and some copied templates. Or you release the subscription and make changes easier now, but resulting in problems later when going to Universal Theme 1.x.
Another problem in many migrated applications is the big space between your items and the grid layout from the Universal Theme. You will get solutions how to arrange your items near to each other and still using Universal Theme templates.
Mastering design changes with theme roller, be aware of problems like !, important in your and theme roller's CSS. Having customized Tooltips, locking mechanism, or want to color your input fields based on the user's right - these questions will be answered in this presentation.
This presentation will be far more detailed than every other migration presentation you've heard before.

Back to Top
Creating an APEX Theme for Non-Designers
Vincent Morneau , Insum Solutions
When: Jun 26, 2017, Monday Session 3 , 2:00 pm - 3:00 pm
Room: Larkspur
Topic: Application Express - Subtopic: APEX Integration

The fastest way to produce a beautiful application is by using APEX 5’s Universal Theme. The fastest way to customize that look and feel is by using Theme Roller. In a matter of hours you can have a unique design using built-in options only. But sometimes that simply won’t fit your client needs.

Not everyone can be a designer, write CSS, or is able to recognize a good design. That being said, I think every APEX developer has the skills to look at any online design and integrate it into APEX.

Integrating a theme is mostly about understanding how to properly copy/paste code in the designated sections of APEX and replacing the hard-coded content with APEX substitution strings.

This session will explain how you can use bits and pieces of an online design to create your own beautiful application. You should be able to ask your client to choose his/her preferred design through an online store and make your application look exactly like it.

Back to Top
Modern JavaScript in APEX: What to Take and What to Leave
Vincent Morneau , Insum Solutions
When: Jun 27, 2017, Tuesday Session 10 , 4:45 pm - 5:45 pm
Room: Iris/Lily
Topic: Application Express - Subtopic: APEX Detail Plunge

By now, JavaScript is inevitable for all APEX developers.

The rising popularity of JavaScript didn’t make everyone happy. There has rarely been a language that changes so much over time, making it hard to keep up with all the new tools and frameworks that emerge every now and then. This causes most APEX developers to stick to basic JavaScript functionalities.

This session will appeal to intermediate and advanced developers who want to learn more about modern JavaScript but don’t know where to start.

Among a lot of extraneous tools and frameworks, there has been a few highly adopted standards. We will be exploring the usefulness of MVC Frameworks such as Angular and it’s alternatives like React. We will see how to write cleaner code with namespacing and promises. We will talk about using upcoming JavaScript features with ES6 and Babel and we will look into modularizing code with Browserify.

This session is a go-around what’s available in JavaScript today and knowing what’s useful (or not) as an APEX developer.

Back to Top
APEX and the Thick Database Paradigm
Anton Nielsen , C2 Consulting, Inc.
Co-presenter(s): Richard Soule, C2 Consulting, Inc.
When: Jun 26, 2017, Monday Session 4 , 3:15 pm - 4:15 pm
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: APEX Detail Plunge

The "thick database" concept relies on encapsulating business logic into a PL/SQL layer and isolating the presentation layer by providing access only to the PL/SQL layer. Thick database benefits include improved adherence to business rules, enhanced security, and improved performance. This approach is often discussed in relationship to Java, Pearl and other mid-tier-centric development tools. APEX applications reside in the database, but they benefit from the thick database paradigm as well. This presentation will provide best practices and real-world considerations for thick database implementation within the APEX development realm.

Back to Top
Hands-On Lab: IoT, ORDS, APEX, and JET
Anton Nielsen , C2 Consulting, Inc.
Co-presenter(s): Hayden Hudson, C2 Consulting, Inc.
When: Jun 28, 2017, Hands on Lab Sessions 15-16, 3:00 pm - 5:15 pm
Room: Goldenrod
Topic: Application Express - Subtopic: APEX New Release

Oracle REST Data Service (ORDS), Oracle Application Express (APEX), and Oracle JavaScript Extension Toolkit (JET) have disparate, sometimes overlapping, functionality. This session will review these products and focus on how they compliment the Internet of Things. Hands-on participants will build an IoT device that communicates with an Oracle Database via ORDS. Device data will be displayed via JET components and the device will be controlled by an APEX application. Participants will gain hands-on experience in ORDS, APEX, JET, and IoT hardware. (A laptop computer is necessary. Tablets are not sufficient.)

Back to Top
Unlocking the Power of the APEX Plugin Architecture
Matt Nolan , FOEX GmbH
When: Jun 28, 2017, Wednesday Session 13, 11:15 am - 12:15 pm
Room: Iris/Lily
Topic: Application Express - Subtopic: APEX Integration

In this session you will get an in-depth look into the APEX plugin architecture using a real-world example where performance is critical and the techniques used to optimize performance.

We will explore the best practices when it comes to designing plugins, event usage, increasing code centralization, and decreasing maintenance while plugging the functionality gaps in your APEX applications.

Back to Top
Life After Forms: The Move to APEX
Alex Nuijten , allAPEX
When: Jun 27, 2017, Tuesday Session 6 , 8:30 am - 9:30 am
Room: Larkspur
Topic: Application Express - Subtopic: APEX Real World

Companies struggle with the question: Should we move to APEX when the time has come to let go of Oracle Forms?
This session will tell the story of a migration project where the Oracle Forms application needed to be replaced with an APEX application. What could we have done better? What are the lessons learned? What was the best choice that we made during this project? Not from the books, but from experience.

Back to Top
APEX Plugins That I Use in Every Project
Bartosz Ostrowski , Pretius
When: Jun 27, 2017, Tuesday Session 8 , 2:00 pm - 3:00 pm
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: APEX Real World

Thanks to APEX architecture we - the developers - can create advanced and reusable components called plugins. Ingenuity and creativity of developers results in many free and handy plugins that save time, enhance application, and show that APEX is not just a collection of basic charts and reports.

During this presentation I will talk about APEX plugins that I use in big commercial projects. I will show how you can extend your application and add today's features that are listed in the APEX roadmap for tomorrow.

Back to Top
Informational Lunch Session on APEX for Newbs and Others
David Peake , Oracle Corporation
When: Jun 25, 2017, Apex Lunch for Newbs, 12:00 pm - 1:00 pm
Room: Begonia
Topic: Application Express - Subtopic: Other Application Express

The APEX community is passionate yet very open to newcomers! If you're here for another track, or new to APEX, come to this informal session on what sessions to attend during the conference. Learn the best way to expand your knowledge of APEX while having a nice lunch. Some of the luminaries from the APEX community will be in attendance so join them for a chat and to answer your questions. (This lunch is limited to a maximum of 48 people.)

Back to Top
Migrating Oracle Forms to the Cloud Using Application Express
David Peake , Oracle Corporation
When: Jun 26, 2017, Monday Session 1 , 10:30 am - 11:30 am
Room: Larkspur
Topic: Application Express - Subtopic: Other Application Express

Oracle Forms is still being developed and for those whose requirements are being fully met, and are up on a supported release, there is no reason to move off Forms. However, if you are on an older release of Oracle Forms, or need to deliver modern, intuitive, self-service or mobile applications then Application Express is an excellent option.

Learn what is involved in building out using Application Express, the dos and don’ts, how to use the APEX Migration Project, and more.

Back to Top
Introduction to APEX
David Peake , Oracle Corporation
When: Jun 26, 2017, Monday Session 2 , 11:45 am - 12:45 pm
Room: Larkspur
Topic: Application Express - Subtopic: Other Application Express

Learn for yourself just why Oracle Application Express is such a powerful, easy to use development tool. This session is designed to give you an overview of the tool complete with demonstrations on how you can maximize your Oracle Database investment. This session is aimed squarely at those who’ve only ever heard of Application Express or are just starting out.

Back to Top
Low Code Challenge: Build a Real-World Application in 60 Minutes
David Peake , Oracle Corporation
When: Jun 27, 2017, Tuesday Session 7 , 11:15 am - 12:15 pm
Room: Larkspur
Topic: Application Express - Subtopic: APEX New Release

Your primary users have just defined a brand new business requirement they want to prototype! See how in the space of 60 minutes you can go from napkin design to working prototype.

Starting with Quick SQL, a new packaged app introduced in APEX 5.1, build out the required tables and even populate them with some sample data. Then using a new extension framework build out the initial application, complete with some primary components needed to deliver a fully featured prototype application.

Back to Top
jQuery Widgets in APEX
Tom Petrus , iAdvise
When: Jun 28, 2017, Wednesday Session 11, 8:30 am - 9:30 am
Room: Iris/Lily
Topic: Application Express - Subtopic: APEX Detail Plunge

In our everyday APEX life, we're using many items and regions, which have a lot of settings. What you may not have realized yet is that many of the implementations are done through jQuery widgets. Sometimes direct, sometimes inderect through a namespaced wrapper. At times, it's very interesting to know what's actually under the hood and how and why things happen. Maybe there are some things that can even be influenced or altered.
In this session, we'll be taking a look at some of the widgets which APEX implements, or in some cases, have been created by the APEX team. We'll see how they function and how they can be manipulated or expanded upon.

Back to Top
Capturing and Manipulating Images with APEX and More!
Adrian Png , Insum Solutions
When: Jun 27, 2017, Tuesday Session 10 , 4:45 pm - 5:45 pm
Room: Larkspur
Topic: Application Express - Subtopic: APEX Real World

A picture is worth a thousand words. It is common to receive project requirements that include image capture, manipulation, or both. We can opt to manipulate captured images either on the client-side using JavaScript or server-side using Oracle Multimedia. This session will examine the various methods and approaches for implementing an image manipulation solution with APEX. We will also look at computer vision and how to integrate this cutting-edge technology in your applications to make users say, "WOW!"

Back to Top
Building in Blocks
Adrian Png , Insum Solutions
When: Jun 28, 2017, Wednesday Session 15 , 3:00 pm - 4:00 pm
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: APEX Real World

Communications is an integral tool for building communities. The team behind apex.world wanted an effective communication platform for members to interact, and were confronted with the decision to build or integrate. Find out how popular products like MailChimp and Slack were integrated with the apex.world portal. Learn about the challenges faced by the team and how they were solved with some help from the same community for which that the portal was built. Take home tips and tricks that you can use in your projects!

Back to Top
Why APEX Is Important to Information Security in Oracle
Michael Potter , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 15 , 3:00 pm - 4:00 pm
Room: Larkspur
Topic: Application Express - Subtopic: Other Application Express

This is not a discussion on how to make APEX secure, it’s an overview of how APEX has become integral to various security-focused groups at Oracle. From incident handling, security architecture, to Investigations and forensics, and tracking the hardening of critical systems, even physical security uses APEX in the field. I aim to show why APEX has become the tool of choice for so many areas within the IS space.

Back to Top
Let APEX Access Your Computer
Peter Raganitsch , FOEX GmbH
When: Jun 26, 2017, Monday Session 1 , 10:30 am - 11:30 am
Room: Iris/Lily
Topic: Application Express - Subtopic: APEX Integration

Web applications are awesome, easy to access from anywhere, but also limited in what they can do. All of that happens for security reasons, of course, and that makes us accept that browser apps (like APEX) can't access any client resources like the filesystem, a printer, or a scanner.

Using the open source Electron project we can build a custom browser, to work around those limitations and extend our APEX applications to do what they need to do.

In this session we will look at what Electron is, how to set it up, and what possibilities there are.

There will also be some easy-to-use prebuilt examples for you to use after the session.

Back to Top
Finally Understand How APEX Works
Peter Raganitsch , FOEX GmbH
When: Jun 28, 2017, Wednesday Session 11, 8:30 am - 9:30 am
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: APEX Detail Plunge

I know, I know, you already use APEX and have built some fine applications. But do you really understand how APEX works and why it behaves as it does?

Have you ever just tried different things until finally something seemed to work, without actually understanding the what and the why?

Let me try to explain the basics of APEX: the foundation on that all fancy components (IR, Grid, Charts, etc.) build up on.

After this session you should be able to understand all the important things: session state, communication, bad and good AJAX calls, and much more.

Back to Top
APEX Sunday Symposium: APEX 5.1 Advanced Universal Theme
Shakeeb Rahman , Oracle Corporation
When: Jun 25, 2017, APEX Sunday Symposium Session 1, 8:30 am - 9:30 am
Room: Grand Oaks G/E/F
Topic: Application Express - Subtopic: Other Application Express

Please join us for a look into Apex 5.1 Advanced Universal Theme.

Back to Top
Hands-On Lab: Transitioning to Oracle Application Express 5 Universal Theme
Shakeeb Rahman , Oracle Corporation
When: Jun 27, 2017, Hands on Lab Session 8, 2:00 pm - 3:00 pm
Room: Goldenrod
Topic: Application Express - Subtopic: APEX Real World

Oracle Application Express 5 introduces many new features that enable you to quickly build modern and beautiful HTML5 applications. The new Universal Theme implements current design trends and utilizing the new declarative template options, and puts powerful CSS3 techniques at your fingertips. In this session, you will walk through transitioning your existing application to the new Universal Theme. Using some of the packaged apps included with Oracle Application Express 4.2 as examples, we’ll demonstrate step-by-step how to transition these apps to Oracle Application Express 5.

Back to Top
JavaScript and CSS for PL/SQL Developers
Jorge Rimblas , Insum Solutions
When: Jun 27, 2017, Tuesday Session 6 , 8:30 am - 9:30 am
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: APEX Integration

If you have been working with the Oracle Database for a while, but still feel lost when working with JavaScript and CSS in your APEX applications, then this session is for you. Working with HTML, JavaScript, and CSS doesn't have to be hard. Learn about CSS selectors, what is the DOM and working with it, JavaScript functions, and even some jQuery. This session will provide you some tools to work better with web technologies.

Back to Top
Deliver a Knockout with Your APEX Applications
Jorge Rimblas , Insum Solutions
When: Jun 27, 2017, Tuesday Session 9, 3:30 pm - 4:30 pm
Room: Iris/Lily
Topic: Application Express - Subtopic: APEX Integration

KnockoutJS provides two-way data binding between JavaScript and DOM elements and it's also the foundation for OracleJET. Whether you use OracleJET or not, KnockoutJS can deliver more pizzazz to your APEX pages. If you often feel your dynamic actions are getting too complex, or they are one line of code away from disaster, this session is for you. Come and get a short KnockoutJS tutorial and learn how to integrate it with APEX.

Back to Top
Browser Developer Tool Essentials for APEX Developers
Christian Rokitta , rokit - themes4apex - APEX SmartPivot
When: Jun 26, 2017, Monday Session 3 , 2:00 pm - 3:00 pm
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: APEX Detail Plunge

If you are an APEX developer, you do use a browser to create applications that do run in a browser. Thus the browser is one of your primary tools. When you are developing in SQL or PL/SQL, your IDE (SQL Developer, TOAD, PL/SQL Developer, …) offer you lots of functionality to support your work and enhance productivity. But building web applications, development is not limited to database objects. Suddenly you need to work with HTML, CSS, and JavaScript. Although APEX is doing a great job in hiding this complexity with a declarative approach, the more you develop with APEX, the more you will get into these techniques. Suddenly, you will need your browser beyond it’s rendering capabilities, and indeed, modern browsers are more like an IDE nowadays.
Debugging, testing, performance tuning, these are just a few aspects that you can do with your browser. This presentation will go through the latest techniques and features that browsers have to offer for us (APEX) developers, things you should know and use.

Back to Top
Hitchhiker’s Guide to the Universal Theme
Christian Rokitta , rokit - themes4apex - APEX SmartPivot
When: Jun 27, 2017, Tuesday Session 6 , 8:30 am - 9:30 am
Room: Azalea
Topic: Application Express - Subtopic: Other Application Express

When APEX 5.0 was released, it came with an entirely new theme: The Universal Theme. This theme impressively showcased several new features that where built into this new Application Express release: Themestyles, Template Options, Themeroller. These features, and how these are leveraged by the Universal Theme, made building a modern UI much easier and enhanced the User Experience of APEX applications. All an APEX developer must know is how to use these declarative features. So, let’s have a look at these in detail and the state of Universal Theme in APEX 5.1.

But with declarativity comes limitation, and for someone familiar with CSS, Themeroller is “Mostly Harmless." Using the Universal Theme as a standard, the “Answer to Life, Universe and Everything …”: 42, eventually all APEX applications will somewhat look similar. So, what about customizing Universal Theme to really fit your design needs? Well, it’s not that easy, but possible. I’ll show(case) some options.

Back to Top
Natural Language Voice Interface to the Oracle Database
Christoph Ruepprich , Accenture Enkitec Group
When: Jun 26, 2017, Monday Session 5 , 4:45 pm - 5:45 pm
Room: Iris/Lily
Topic: Application Express - Subtopic: APEX Real World

Natural language voice interfaces have become quite popular, especially with mobile devices. Apple's Siri and Google's "OK Google" have come quite a long way, and are very good at interpreting the human language. A relatively new player on the market is Amazon's Echo, a standalone speaker that accepts voice commands and questions, searches for answers online, and answers back in a human voice.
The technology behind the Echo is Amazon's Alexa API. This API is available for developers to create their own natural voice interfaces.
We are going to explore how we can use the Alexa API to access an Oracle database to perform spoken inquiries like "How much does Miller earn?", "Who works in the research department?", or "Who earned the highest commission in sales?"
The results will not only be spoken back to the user, but can also be displayed in the Alexa mobile app as well as in APEX.
There will be a live demo of asking questions to an Amazon Echo device, and have it answer with data queried from the database.
A basic understanding of JavaScript and PL/SQL will be beneficial to the participants.

Back to Top
High Performance APEX (or Don't Keep the Users Waiting)
John Scott , APEX Evangelists
When: Jun 26, 2017, Monday Session 3 , 2:00 pm - 3:00 pm
Room: Iris/Lily
Topic: Application Express - Subtopic: APEX Real World

Whether you need to support 10 users or 1,000 users, it's important to understand how your application performs. In this session, I will cover the entire stack performance and show how you can debug which area of your APEX application is causing the bottleneck.

Back to Top
Oracle APEX - NLP, AI, and Bot Integration
John Scott , APEX Evangelists
When: Jun 28, 2017, Wednesday Session 16 , 4:15 pm - 5:15 pm
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: APEX Integration

Natural Language Processing (NLP), combined with AI, and Bots are hot topics right now. In this session we will cover exactly how you can integrate these technologies into your APEX applications to really make your APEX applications user-friendly.

Back to Top
APEX Sunday Symposium: APEX 5.1 Advanced Charts
Marc Sewtz , Oracle Corporation
When: Jun 25, 2017, APEX Sunday Symposium Session 2, 9:30 am - 10:30 am
Room: Grand Oaks G/E/F
Topic: Application Express - Subtopic: Other Application Express

Oracle Application Express 5.1 introduced a new charting engine based on the data visualization components of Oracle JavaScript Extension Toolkit (Oracle JET). This JavaScript charting solution is highly customizable, accessible, interactive, and incorporates automatic responsive design support. In this session, we’ll explore how you can take full advantage of the built-in capabilities, how you can link up your charts with dynamic actions to create a truly interactive experiences for your users, and how you can utilize the Oracle JET JavaScript APIs to further customize your charts to meet your specific requirements.

Back to Top
APEX Sunday Symposium: Advances with Packaged Apps
Marc Sewtz , Oracle Corporation
When: Jun 25, 2017, APEX Sunday Symposium Session 5, 2:00 pm - 3:00 pm
Room: Grand Oaks G/E/F
Topic: Application Express - Subtopic: Other Application Express

The packaged apps included in Oracle Application Express have grown to become popular business solutions in their own right. “Turn-key” productivity applications like P-Track, Customers Tracker and Opportunity Tracker are widely used by customers inside and outside Oracle. And the collection of Sample Apps is an indispensable tool to learn more about how to take full advantage of product features like the Universal Theme and the Interactive Grid. In this session we will showcase some of the most commonly used apps, highlight the coding standards and best practices that are used in packaged app development and demonstrate how you can unlock and fork these apps to review their implementation and add your own extensions.

Back to Top
Hands-On Lab: Creating Mobile Applications Using Application Express 5
Marc Sewtz , Oracle Corporation
When: Jun 28, 2017, Hands on Lab Session 13, 11:15 am - 12:15 pm
Room: Goldenrod
Topic: Application Express - Subtopic: APEX New Release

Learn how you can declaratively build a compelling mobile application that uses some of the latest HTML 5 capabilities, with Application Express. No hand-crafting or in-depth knowledge of JavaScript or AJAX is required. Instead bring your SQL knowledge and discover how quickly you can build web-based mobile applications using the Oracle Application Express declarative framework.

Back to Top
APEX 5.2 Preliminary Features
Marc Sewtz , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 16 , 4:15 pm - 5:15 pm
Room: Larkspur
Topic: Application Express - Subtopic: Other Application Express

Oracle Application Express 5.2 will focus on declaratively integrating data sources from remote databases and extending applications running on the cloud via REST. A new Create Application Wizard will enable you to add components and features to new and existing applications. Upgrading to the latest Oracle JET and jQuery JavaScript libraries will further allow APEX to take advantage of new and improved data visualizations and widgets. In this session we will preview those new capabilities and show some of the numerous enhancements to Page Designer and the Interactive Grid.

Back to Top
From APEX App to Apple App Store – Simple Steps for Successful Submission
Stephen Smith , CampaignShortCuts
Co-presenter(s): Roel Hartman, APEX Consulting
When: Jun 27, 2017, Tuesday Session 8 , 2:00 pm - 3:00 pm
Room: Larkspur
Topic: Application Express - Subtopic: APEX Real World

Want to learn how to prepare your APEX app for successful submission to the Apple App Store? This session will show you how to program the needed requirements and navigate the process steps to publish your app in the App Store.

Back to Top
APEX Sunday Symposium: APEX 5.1 Advanced Interactive Grid
John Snyders , Oracle Corporation
When: Jun 25, 2017, APEX Sunday Symposium Session 3, 11:00 am - 12:00 pm
Room: Grand Oaks G/E/F
Topic: Application Express - Subtopic: Other Application Express

Explore the wide range of what's possible with APEX Interactive Grids.This session will take you on a tour of Interactive Grid advanced use cases that highlight how you can enable your users to work more efficiently and be more productive. Learn how, with a little JavaScript and CSS, you can go beyond the basics of reporting, editing and master detail. Techniques described include: toolbar and menu customization, advanced configuration options, client and server side custom data processing, and automated control.

Back to Top
GET POST ORDS JSON: Web Services for APEX Decoded
Scott Spendolini , Sumner Technologies
When: Jun 26, 2017, Monday Session 5 , 4:45 pm - 5:45 pm
Room: Larkspur
Topic: Application Express - Subtopic: APEX Real World

Web services in the APEX world are becoming more and more popular. However, there is still a lot of confusion as to what they are and how they could benefit the APEX developer. After a review of the syntax and jargon associated with web services, this session will review and boil down web services to their basic components. It will then demonstrate how APEX developers can start to use these powerful components - both to send and receive data from other sites.

Back to Top
Secure Your APEX Applications with APEX-SERT
Scott Spendolini , Sumner Technologies
When: Jun 27, 2017, Tuesday Session 9, 3:30 pm - 4:30 pm
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: APEX Real World

Application security is at the forefront of IT and will remain there for a long time. Thus, it is important to consider security on day one of your application’s development. APEX-SERT is an open-source tool built in APEX that is designed to help evaluate your APEX applications for potential security issues. Not only will it identify them, but it will also offer advice on how to remedy them. APEX-SERT also offers the ability to create and approve exceptions in the case of either a false positive or an issue that is mitigated outside of APEX.

Back to Top
APEX Localization
When: Jun 28, 2017, Wednesday Session 14 , 1:45 pm - 2:45 pm
Room: Cibolo Canyon 5
Topic: Application Express - Subtopic: APEX Real World

Terms "translation" and "localization" are often used interchangeably, while the differences are quite significant. If we want to create professional international application we must not only care about language, but also about elements that appeal to regional or cultural preferences including text direction, formats, calendars etc.
During this presentation I will show:
- how localization process works
- how you can cover it in APEX using built-in features, plugins and open source projects like OraOpenSource and translate-apex.com
- how you can use good practice from video game industry to create international APEX applications

Back to Top
Hands-On Lab: Building a Basic Demo Application Using Oracle Application Express
Jason Straub , Oracle Corporation
Co-presenter(s): David Peake, Oracle Corporation
When: Jun 26, 2017, Hands on Lab Session 5, 4:45 pm - 5:45 pm
Room: Goldenrod
Topic: Application Express - Subtopic: APEX Real World

This one session is designed to take you through building a comprehensive application using Application Express. It is designed for people with no prior knowledge or very little experience developing with Application Express. You will learn how to develop a large number of different application components and walk out with the confidence and understanding of how to start building your own applications using Oracle Application Express.

Download and Install Oracle Virtual Box (http://www.oracle.com/technetwork/server-storage/virtualbox/downloads/index.html)
Download the latest Database App Development VM (http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html)
{Note: This file is 7.7 GB so may take significant time based on the network. Trying to download from the JW Marriott will probably not work, so it strongly recommended you download the VM before leaving for the conference}
Import the VM into VirtualBox on your machine.
Update the VM Settings to maximize the System > Base Memory and Processor(s).
Start the VM.

Back to Top
Using the Developer Cloud Service with Exadata Express Cloud Service
Jason Straub , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 13, 11:15 am - 12:15 pm
Room: Larkspur
Topic: Application Express - Subtopic: Other Application Express

The Oracle Developer Cloud Service is a team development environment that includes automation for building software releases, and continuous integration during your development lifecycle. The Oracle Exadata Express Cloud Service is a full Oracle Database experience delivered as a managed cloud service running on Exadata and provisioned in minutes - all at an affordable entry-level price. This session will give an overview of each cloud service, and describe how the two services can be easily integrated together, to provide a very robust development platform.

Back to Top
Visualizing Air Traffic Data with the FAA’s Satellite-Based Surveillance System, a Pizza Box, a Raspberry Pi, APEX, JET, and the Oracle IoT Cloud
Jerry Ward , Viscosity North America
Co-presenter(s): Paul Hicks, Kaminario
When: Jun 28, 2017, Wednesday Session 14 , 1:45 pm - 2:45 pm
Room: Larkspur
Topic: Application Express - Subtopic: APEX Integration

In this session we “science the #$%!”* out of a Raspberry Pi 3, APEX and the Oracle Internet of Things Cloud (*ref. The Martian Film). The Automatic Dependent Surveillance–Broadcast (ADS-B) is a precise satellite-based surveillance system that broadcasts real-time weather and uses GPS technology to determine any aircraft's location, airspeed, other date, and relays that data to air traffic control, aircraft, and to us because we are listening! We log and store this data in the Oracle IoT Cloud, then use APEX to build a simple application to view this data in real-time and report on it over time.

Back to Top
APEX Sunday Symposium: APEX 5.1 Other Advanced New Features
Patrick Wolf , Oracle Corporation
When: Jun 25, 2017, APEX Sunday Symposium Session 4, 1:00 pm - 2:00 pm
Room: Grand Oaks G/E/F
Topic: Application Express - Subtopic: Other Application Express

Please join Patrick Wolf as he explores APEX 5.1 Other Advanced New Features.

Back to Top