ODTUG Kscope19 is unique in its offering of one full day—a choice of four symposiums—included with full conference registration. Sunday-only passes are available and provide access to the Oracle and Dodeca Symposiums as well as the Welcome Reception. Passes are $599.00, register here! Start your week of education with this year’s Sunday Symposium for your track! 

APEXDatabaseEPM | Analytics

Oracle Sunday Symposiums will be posted as content is available.


Fasten your seatbelts! ODTUG Kscope19 kicks off on Sunday with the APEX Symposium, and all presentations are done by the APEX Development Team itself. Learn about the exciting new features of APEX 19.1 straight from the horse's mouth. See what is on the roadmap for APEX 19 and beyond. The new slogan is: #MOCA—Make Oracle Cool Again. Come see, learn, and be amazed!

Room: 6C, Level 6 

9:00 - 10:00 a.m.

APEX 19 New Features and Roadmap

Marc Sewtz, Oracle Corporation

Over the past year and a half, Oracle APEX has made tremendous strides in opening up the platform to external data sources. REST APIs and objects stored in external Oracle databases are now first-class citizens and can be seamlessly chosen as the data source of popular components, such as classic and interactive reports, Oracle JET charts, and calendars. With Oracle APEX 19.1, REST support has been extended to APEX form regions, allowing read and write access to remote data sources. And with APEX 19.2, this is being expanded to encompass interactive grids as well. New, powerful data loading capabilities, with support for native Excel files, modern, multi-column-enabled popup LOVs and a brand-new filter report component round out the set of new features customers can look forward to in 2019. In this session, we’ll showcase all of these exciting new features and discuss what’s in store for 2020 and beyond.

10:00 - 10:30 a.m. | Break

10:30 - 11:30 a.m.

REST Integration

Carsten Czarski, Oracle Corporation

The latest Application Express Release 19.1 takes its support for external data sources (REST Services and REST Enabled SQL) to the next level. Forms do now support REST services and REST Enabled SQL. Thus APEX allows you to create, report, chart, and form pages on REST services—all declarative and without manual coding.

This session introduces this new feature and shows how to build a form on an external REST API—all without manual PL/SQL coding. Tips and tricks for practical usage will wrap the session up.

11:30 a.m. - 12:30 p.m.

APEX 19 Oracle JET Charts

Hilary Farrell, Oracle Corporation

In this session, we'll delve into the charting features and functionality available in APEX 19, based on the data visualization components of Oracle JavaScript Extension Toolkit (Oracle JET).

This JavaScript charting solution is highly customizable, accessible, and interactive, and it incorporates automatic responsive design support.

Learn how to effectively communicate your app data through the use of our extensive range of chart types and declarative capabilities, and easily utilize the JET JavaScript APIs to further customize your charts.  

12:30 - 1:30 p.m. | Lunch

1:30 - 2:30 p.m.

Universal Theme Update

Shakeeb Rahman, Oracle Corporation

The Universal Theme aims to empower developers to build beautiful, responsive, accessible apps without requiring extensive knowledge of HTML, CSS or JavaScript. This session will walk you through what is possible with Universal Theme, new features in the latest release, and how you can make the most of it in a supportable manner.  Learn how you can take full advantage of the capabilities in Universal Theme to build compelling, world-class user experiences for all of your users.

2:30 - 3:00 | Break

3:00 - 4:00 p.m.

Enhanced Popup LOVs

John Snyders, Oracle Corporation

Multiple columns and much better performance are just some of the improvements made to the Popup LOV item. Come see what the new Popup LOV can do.

4:00 - 5:00 p.m.

Using APEX on the Autonomous Database Cloud Service

Chaitanya Koratamaddi, Oracle Corporation

Oracle Cloud provides a set of autonomous and customer-managed Oracle Database services available in flexible configurations to meet your needs, large or small, with the performance of dedicated hardware. This session provides steps in detail to set up and get started with Oracle APEX environment in Oracle Cloud Infrastructure (OCI). In this session, you learn how to:

    • Set up the most affordable Oracle APEX environment on OCI Compute with Oracle Database 18c XE
    • Install Oracle APEX on your OCI DBCS using tried and true (conventional) methods or modern Terraform templates
    • Get started with Oracle APEX in the Autonomous Database

You also learn how Oracle APEX enables you to seamlessly lift and shift apps to Oracle Database Cloud Services.


This year the database team here at Oracle is excited to bring to ODTUG Kscope an entire day of training on the core topics of interest to developers and really, ALL database professionals. You can expect more deep, fundamental knowledge of what makes the database work and less marketing or future-looking topics. The keyword here really is “training!” We'll cover design, SQL, PL/SQL, performance, and the tools you need to do your job.


Because we also want you to have fun on your day off, we’re bringing both knowledgeable AND entertaining speakers, and we’re incorporating a game show into the talks—you will get to show off your knowledge and win some fun prizes. But what we really hope you bring home to your workplace is a more valuable and productive YOU.

Room: 6A, Level 6 

9:00 - 10:00 a.m.

Data Modeling FFS: Free, Fun, & SQL Developer

Jeff Smith, Oracle Corporation

It’s the one thing we can all agree that SHOULD be done, but it quickly becomes an afterthought. Here’s a reminder why the design phase is so important, AND a boot camp how-to for quickly adding it back to your design/build/maintain lifecycle.

10:00 - 10:30 a.m. | Break

10:30 - 11:30 a.m.

HELP, I Don't Really Get How SQL Works

Connor McDonald, Oracle Corporation

Well done! You've come up with the killer idea for 2019! You've got the best UI design anyone has ever seen! Your modern application ticks all the boxes—serverless, functional, Kubernetes, Kafka, microservices, API-based, the list goes on. It runs on every OS and every type of device! But unfortunately, all of this counts for absolutely NOTHING if your data access is slow or buggy. Better data access typically means understanding how SQL is processed by the database, and who has time for that? SQL can be hard to understand and sometimes totally hidden from view under an ORM. Let's peel back the covers to show how SQL is processed, how to avoid getting hacked, and how to get data back to your application in a snappy fashion.

11:30 a.m. - 11:55 a.m.

Declarative PL/SQL

Steven Feuerstein, Oracle Corporation

Minimize the code you write and make the most of what PL/SQL can do for you by relying on these declarative features of PL/SQL. From the cursor FOR loop to the new-to-18c qualified expressions, let PL/SQL do the heavy lifting.

12:00 - 1:00 p.m. | Lunch

1:00 - 2:00 p.m.

Database Game Show!

Connor McDonald, Oracle Corporation

Members of our studio audience will get to compete in a game led by our host, Maria, and her assistant, Connor, as they show off their knowledge of the database, with some exciting prizes up for grabs. 


2:00 - 3:00 p.m.

Explaining the Explain Plan – Interpreting Execution Plans for SQL Statements

Maria Colgan, Oracle Corporation

The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task even for the most experienced DBA or developer.  This session examines the different aspects of an execution plan, from selectivity to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.

3:00 - 3:30 | Break

3:30 - 4:00 p.m.

Exceptional PL/SQL

Steven Feuerstein, Oracle Corporation

A rapid-fire review of features that help you trap and manage exceptions, including SAVE EXCEPTIONS, LOG ERRORS, user-defined exceptions, and more.

4:00 - 5:00 p.m.

REST APIs for Your Application PL/SQL and Data

Blaine Carter, Oracle Corporation

Now that you have your well designed, performant, and robust application schema ready to deploy, we will show you how to publish REST APIs to make it available to your web apps and/or automated processes using Oracle REST Data Services.


Oracle Enterprise Performance Management Cloud momentum continues to be adopted at a rapid pace by both existing on-premises Hyperion customers and new customers alike. If you were at the Sunday Symposium last year, you were among the first to see some of the latest additions before they became publicly available, and you heard from a panel of customers on their cloud journeys. Whether you have existing EPM deployments on-premises, cloud, or a little of both, this symposium is one you definitely don’t want to miss. We will cover the strategy and roadmap for all your deployment investments and continue our tradition of treating attendees to first looks at the latest innovations and works in progress. In addition, we will hear from new Oracle EPM Cloud customers.


Presented by Oracle EPM product management and development leaders, you will get unfiltered insight into our key R&D initiatives. Our goal at the EPM Sunday Symposium is to expose attendees to the latest and greatest from Oracle EPM development in these areas and offer you the opportunity to learn more in the detailed conference sessions. In keeping with our goal, the EPM Symposium's agenda reflects the late-breaking R&D efforts in the cloud which are not covered by sessions, while also relaying key efforts for on-premises EPM. We look forward to your attendance at this year's symposium.

Room: 6B, Level 6

1:00 - 1:15 p.m.

Opening Remarks

Al Marciante, Oracle Corporation

Introduction to the EPM Symposium

1:15 - 2:00 p.m.

Keynote: EPM Strategy and State of the Business

Matt Bradley, Oracle Corporation

The State of EPM Business and Strategy Review will set up themes for the EPM sessions to follow and introduce the agenda for the rest of the day. We’ll highlight EPM Cloud portfolio growth, market momentum, and customer adoption, including a discussion of product to process shift leveraging.

2:00 - 2:45 p.m.

Oracle EPM Cloud Walk-Through—The “Art” of the Possible?

Oracle EPM Product Management: Hari Sankar, Rich Wilkie, Marc Seewald, Al Marciante, & others, Oracle Corporation

June begins our new fiscal year, and we just made major announcements in regards to Oracle EPM Cloud. We’ll walk through self-activation and initialization of an environment for your business process, the ease of creating a new “free form” planning application, easily integrating into your overall EPM Cloud deployments with EPM Task Manager, comprehensive financial close,  and commentary collection to narrative reporting with one-click refresh of Smart View content (without downloading to Excel on the client).

2:45 - 3:15 p.m. | Break

3:15 - 4:00 p.m.

EPM Cloud Innovation Showcase—What Is the future?

Oracle EPM Product Management: Hari Sankar, Rich Wilkie, Marc Seewald, Al Marciante, & others, Oracle Corporation

A showcase of the future functionalities in Oracle EPM Cloud R&D.

4:00 - 4:30 p.m.

EPM Cloud Customer Panel

Hari Sankar, Oracle Corporation, Moderator

Customer Panelists

  • Jon Champion, C.H. Robinson 
  • Allan Mossier, FedEx
  • Tim Walsh, Global Payments

An interactive session to hear from customers who have adopted Oracle EPM Cloud. Learn from their journeys as they tell tales from the front and share benefits, challenges, and tips and tricks. Whether your organization is just starting its cloud journey or looking to expand, this session will be chock full of valuable information.

4:30 - 5:00 p.m.


Al Marciante, Oracle Corporation

Analytics (Business Intelligence and Essbase)

Oracle Analytics has seen tremendous innovation and growth since its introduction two years ago, and Oracle continues to enhance every aspect of the product and introduce new capabilities. In the Sunday Symposium, the Oracle Analytics Product Management team will provide deeper insight into the Oracle Analytics portfolio strategy and roadmap by exploring recent achievements in enterprise, self-service, and augmented analytics; discussing new and upcoming Essbase features; and uncovering its strategy for cloud, on-premises, and mobile.

Room: 6B, Level 6

9:00 - 10:20 a.m.

Oracle Analytics' New Capabilities, Roadmap, and Strategy

Gabby Rubin, Oracle Corporation

This last year had been very busy for the Oracle Analytics team and customers. With over a 100 new features and capabilities delivered in the last 12 months, Oracle is not planning to slow down. Join us as we explore the highlights, as well as future investment in cloud and on-premises, machine learning, EPM and Essbase integration, and other capabilities. 

10:20 - 10:35 a.m. | Break

10:35 - 11:20 a.m.

Oracle Analytics' New Community Resources and Extensibility Capabilities

Philippe Lions, Oracle Corporation

One of the leading requests that we get from customers is to increase our roadmap transparency and community outreach. Join Philippe Lions as we cover new community resources, the Oracle Analytics public roadmap, and the updated developer capabilities of the platform.

11:20 a.m. - 12:00 p.m.

Essbase Product Update

Karen Zubetz, Oracle Corporation

Essbase had always been a strategic product in Oracle, used extensively both internally and by our customers. Over the last several years it had gone through many transformations as we modernized its architecture with in-memory capabilities, hybrid aggregations, and many new cloud-based capabilities and tools. In this session, the Essbase team will preview its plans for next year, which will cover new on-premises and cloud offerings, planned capabilities, and more.