ODTUG Kscope17 is unique in its offering of one full day – a choice of four symposiums – at no additional charge. Start your week of education with this year’s Sunday Symposium for your track. 
APEX
Business Intelligence
Database 
EPM



APEX

The APEX Symposium includes sessions delivered exclusively by the APEX Development Team. Get in-depth knowledge about the great new features in Oracle Application Express directly from those responsible for developing them. APEX 5.1 Advanced Universal Theme, Advanced Charts, Advanced Interactive Grid, and Advanced Other Features, as well as APEX 5.2 Preliminary Features will be highlighted. 

Room: Grand Oaks E/F/G

8:30 AM - 9:30 AM
APEX 5.1 Advanced Universal Theme
Shakeeb Rahman, Oracle Corporation

9:30 AM - 10:30 AM
APEX 5.1 Advanced Charts
Marc Sewtz, Oracle Corporation
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 you specific requirements.

10:30 AM - 11:00 AM
Break

11:00 AM - 12:00 PM
APEX 5.1 Advanced Interactive Grid
John Snyders, Oracle Corporation
Explore the wide range of whats 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. 

12:00 PM - 1:00 PM
Room: Begonia
Informational Lunch Session on APEX for Newbs and Others
David Peake, Oracle Corporation

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.)

12:00 PM - 1:00 PM
Room: Cibolo Canyon 5/6/7
Lunch 

1:00 PM - 2:00 PM
APEX 5.1 Other Advanced New Features
Partick Wolf, Oracle Corporation

2:00 PM - 3:00 PM
APEX 5.2/ Preliminary Features 
Marc Sewtz, Oracle Corporation
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.

3:00 PM - 3:15 PM 
Break

3:15 PM 
Update from Development
Joel Kallman, Oracle Corporation



Business Intelligence

This year’s Sunday Symposium for Business Intelligence will be divided into a morning session and two afternoon sessions. The morning session will be presented by Oracle Analytics Product Management covering the road map for Cloud, Data Visualization, and Mobile across several informative sessions. The afternoon sessions will give attendees the opportunity to choose between a Hands-on Lab for Data Visualization run by Oracle Analytics Product Management, or additional informative sessions run by the Oracle Data Integration and Big Data Product Management teams.

Room A - Cibolo Canyon 2/3/4

8:30 AM - 8:40 PM
Introduction to the Symposium from the Kscope Track Chair

Kevin McGinley, Red Pill Analytics

8:40 AM - 10:00 AM
Oracle Analytics Keynote and Product Strategy
Vasu Murthy, Oracle Corporation

10:00 AM - 10:30 AM
Oracle Analytics Cloud/BI Product Update
Alan Lee, Oracle Corporation

10:30 AM - 11:00 AM
Break

11:00 AM - 11:30 AM 
Oracle Analytics Cloud/Essbase Product Update 
Gabby Rubin, Oracle Corporation

11:30 AM - 12:00 PM 
Oracle Analytics Mobile
Jacques Vigeant, Oracle Corporation

12:00 PM - 1:00 PM
Room:
Cibolo Canyon 5/6/7
Lunch

1:00 PM - 1:10 PM 
Introductory Remarks
Kevin McGinley, Red Pill Analytics

1:10 PM - 1:30 PM
Review of Oracle Data Lake Patterns (Cloud and On-Premises)
Jean-Pierre Dijcks, Oracle Corporation

1:30 PM - 2:15 PM
Deep Dive Into Big Data Cloud Service and Embedded Components
Jean-Pierre Dijcks, Oracle Corporation

2:15 PM - 2:45 PM
Special Update on Data Warehousing in the Cloud
Yasin Baskan, Oracle Corporation

2:45 PM - 3:00 PM
Break

3:00 PM - 3:45 PM
Introducing Oracle Data Integration Platform
Denis Gray, Oracle Corporation

3:45 PM - 4:10 PM 
Hub and Spoke is Dead! Lambda/Kappa Data Integration Patterns
Denis Gray, Oracle Corporation

4:10 PM - 4:30 PM 
Demo of Oracle Data Integration Platform Cloud
Denis Gray, Oracle Corporation


Room B: Freesia

1:00 PM - 1:30 PM 
Oracle Analytics Cloud/Data Preparation
Alan Lee, Oracle Corporation

1:30 PM - 2:15 PM
OAC Samples and Platform Capabilities
Philippe Lions, Oracle Corporation

2:15 PM - 2:45 PM
How to Find Your Way in the (Analytics) Cloud 
Mike Durran, Oracle Corporation

2:45 PM - 3:15 PM
Break

3:15 PM - 4:15 PM
Data Visualization Workshop
Philippe Lions, Oracle Corporation

4:15 PM - 4:30 PM
Closing Remarks
Kevin McGinley, Red Pill Analytics



DATABASE

The Database Symposium is super-charged and high energy this year. Sunday at Kscope17 for Database Dev, and Admins. is the place to be for a day full of fun, learning, questions, and answers. This all-day event gives you the chance to engage with some of the best product managers about existing and up-and-coming features. 

Cibolo Canyon 8/9/10

Session 1: 8:30 AM - 10:30 AM

Ten Rules for Doing a Pl/SQL Performance Experiement 
Bryn Llewellyn, Oracle Corporation
I've all too often been asked to comment on a speed difference between two tests where each is presented to me as just a SQL*Plus spool file (prompts and all). Sometimes this is copied and pasted into the text of an email. Often, the text of the second spool file differs from the text of the first in just a couple of tiny details. Worst of all, each time is measured for just a single test run using SET TIMING ON. And the times are shown, like "Elapsed: 00:00:12.36", with indefensible precision. Sometimes the times are shorter. This is no way to conduct a performance experiment. This brief talk tells you how to do your experiment properly. I said "PL/SQL" in the title, 'cos that's what I'm known for. Really, I'm talking about any single-user test that runs entirely inside Oracle Database. I said "ten rules"  'cos a talk has to have a catchy title. Of course there's many more....

Why Test Cases Matter
Chris Saxon, Oracle Corporation
On AskTOM Chris and Connor are always asking for test cases. But are they really that necessary? An excellent test case. Drawing on questions from AskTOM Chris shows why they're important and discusses what you need to do to create an excellent test case.

Lifecycle Management and Continuous Integration for Database Code 
Shay Shmeltzer, Oracle Corporation
In this session we'll show you how to effectively manage database code changes and how to automate the database development life-cycle. We'll cover tracking requirements; versioning and modifying code; conducting code reviews; testing and deploying the changes across systems - all with the help of Oracle Developer Cloud Service, which is included in your Oracle Database Cloud license.

10:30 AM - 11:00 AM
Break

Session 2: 11:00 AM - 12:00 PM

100 SQL Developer Tricks in 20 Minutes 
Jeff Smith, Oracle Corporation
Jeff will share as many developer tricks as he can in 20 minutes.

DevOps
Colm Divilly, Oracle Corporation
Kris will discuss what DevOps means at Oracle and how it works to bring you your favorite Oracle Database Cloud Services.

Oracle Optimizer Isn’t Black Magic
Maria Colgan, Oracle Corporation
It has long been felt that the internals of the Oracle Optimizer were shrouded in mystery and that a degree in wizardry is required to be able to make it do the right thing. This session aims to dispel this myth once and for all by showing exactly how the Optimizer comes up with t’s cardinality estimates. 

12:00 PM - 1:00 PM
Room:
Cibolo Canyon 5/6/7
Lunch 

Session 3: 1:00 PM - 2:45 PM

ORDS REST Development Flexibility 
Jeff Smith, Oracle Corporation
You have a lot of options when it comes to exactly how you want to REST 'enable' something in the database. 

SQL Magic: The Cups and Balls Trick
Chris Saxon, Oracle Corporation
In this talk Chris does a SQL take on the classic "cups and balls" magic trick. But, unlike real magicians, he'll show you how it's done so you can do your own SQL magic at work!

How to Protect the Crown Jewels
Maria Colgan, Oracle Corporation
Companies across the globe keep everything from their customer’s information to their financial results in databases, effectively making databases the keeper of the companies' crown jewels. But how secure are they? This session will examine the techniques deployed to protect the British crown jewels and explain how you can deploy similar strategies to keep your company's crown jewels safe.

Mobile Development via REST
Colm Divilly, Oracle Corporation
Running your favorite mobile app with dedicated database connections and transactions spanning multiple calls isn't a recipe for success. Thankfully we have this REST model to follow.

SQL Developer in Your Browser
Jeff Smith, Oracle Corporation
Overview/Preview of the next evolution of your favorite desktop database development, administration, and design tool. 

2:45 PM - 3:15 PM
Break

Session 4: 3:15 PM - 5:00 PM

The "Hot Patching" Myth—Or Why You Have No Choice But to Use EBR for Zero-Downtime Patching
Bryn Llewellyn, Oracle Corporation
My scope is doing patching among the set of artifacts inside an Oracle Database that implement an application's back end. A myth has arisen that certain changes can be made safely with "create or replace" while the application is still available for normal, highly concurrent use. Managers seem to be especially attached to this myth. I'll go through a couple of examples that seem, on intellectual analysis by the uninitiated, to be safe. And I'll show you, with naively designed tests, that the "no danger" hypothesis isn't disproved. Of course, these are simulated multi-user tests. But then, by tweaking some timing knobs, I'll bring the hidden danger out into the open. It's all about relatively unlikely race conditions that, nevertheless, are bound, sooner or later, to occur in a busy production system. Then I'll explain that, should Oracle Database implement a much more pessimistic locking strategy, the race condition errors could be prevented. But if we did that, you'd hate us 'cos everything would slow down. I'll remind you that Oracle Database, therefore, is designed to perform very well in the optimistic, common-sense, scenario: that you "just say no" to doing DDLs on an application's within-database artifacts while it's available for normal highly concurrent use. I'll conclude by reminding you that EBR isn't a luxury. Rather you have a simple stark choice: always take downtime for all patching; or adopt and use EBR to allow safe zero-downtime patching.

Hacking into Oracle Database
Chris Saxon, Oracle Corporation
The Danger of SQL Injection: Chris will show how easy it is to access "private" data in applications vulnerable to SQL injection. He'll then go on to discuss steps you should take to keep your data safe.

SQL Developer in Your Browser
Jeff Smith, Oracle Corporation
Overview/Preview of the next evolution of your favorite desktop database development, administration, and design tool. 

30 Minute Q&A Panel - Questions/discussion points to be submitted in advance.
Everyone is encouraged to participate. Panel will be moderated by Helen Sanders.


 

EPM

Oracle Enterprise Performance Management Cloud has seen tremendous growth and maturation since Kscope16. And, 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. With the increased coverage of our cloud solutions across the EPM/CPM spectrum, never has there been a better time to take a deeper look. 

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 new offerings and functionalities.  

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 that 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.

Grand Oaks A-D, H, I

8:45 AM - 9:30 AM 
Keynote: Join Matt Bradley, Sr. VP of Business Analytics Product Development as he shares insights into the status, roadmap and strategy of Enterprise Performance Management (EPM), and sets the stage for the day's remaining sessions.

9:30 - 10:45 AM
On-Premise Update: Join development leaders in our Planning and Budgeting, Financial Close, and Profitability & Cost Management teams as they share information on key initiatives and achievements to help optimize your investment in these market leading EPM on-premises solutions.

10:45 AM - 11:00 AM
Break

11:00 AM - 11:40 AM
Bridge to Cloud (Hybrid): As customers remain on-premises, migrate to the cloud, or maintain a hybrid environment, we have you covered.  This session will focus on key innovations in data management, analytics, and reporting that help users have a consistent and integrated approach in their EPM deployments. 

12:00 PM - 1:00 PM
Room: 
Cibolo Canyon 5/6/7
Lunch

1:00 PM 2:30 PM 
EPM Cloud: This session will focus on EPM Cloud innovations in Financial Close-related cloud solutions.

2:30 PM - 2:55 PM
Special Preview: This session will highlight Data Relationship Management team's plans for an upcoming cloud-based service to manage data relationships and dimensions.

2:55 PM - 3:10 PM
Break

3:10 PM - 4:30 PM
EPM Cloud (Continued): This follow on session will continue the discussion and presentation of EPM Cloud innovations in Planning and Profitability.

4:30 PM - 5:00 PM 
BI Cloud Services for EPM: The day will close with a focus on Oracle Analytics Cloud related offerings with an EPM flavor.  Key topics will focus on Essbase Cloud (for EPM deployments) and BICS offerings. 

5:00 PM 
That's a wrap!