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
Patrick Wolf, Oracle Corporation

2:00 PM - 3:00 PM
Advances with Packaged Apps
Marc Sewtz, Oracle Corporation
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.

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
Welcome Notes and Introduction to the Symposium from the ODTUG Kscope17 Track Chair

Kevin McGinley, Red Pill Analytics

8:40 AM - 10:00 AM
Oracle Analytics Keynote and Product Strategy
Gabby Rubin, Oracle Corporation
Learn about the strategy behind the Oracle Analytics cloud and the future road map.

10:00 AM - 10:30 AM
What is New in Oracle BI Extended Universe (OBIEU)? 
Alan Lee, Oracle Corporation
Overview of new and updated capabilities in OAC/BICS and OBI.

10:30 AM - 11:00 AM
Break

11:00 AM - 11:20 AM 
The Ultimate Guide to Oracle Cloud Acronyms and Experiences
Mike Durran, Oracle Corporation
Have your Analytics Cloud questions answered. What is an OCPU? How is patching different between on-prem, BICS, and OAC/BICS? How do I provision a cloud instance?

11:20 AM - 12:00 PM 
OAC Samples and Platform Capabilities for Application Developers
Philippe Lions, Oracle Corporation
Discover the wonderful world of custom visualizations, plug-ins, and sample applications.

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

 

Afternoon Sessions

Room A: Cibolo Canyon 2/3/4

1:00 PM - 1:10 PM
Introductory Remarks from the ODTUG Kscope17 Track Chair
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 
The Essbase Session
Gabby Rubin, Oracle Corporation
Everything you want to know about Essbase in Oracle Analytics Cloud

1:30 PM - 2:15 PM
The Next Next-Gen of Mobile Analysis
Jacques Vigeant, Oracle Corporation
Explore the newly released Day by Day and Synopsis mobile apps and have a glimpse into Oracle future research and development in this area. 

2:15 PM - 2:45 PM
The Analytics Wipe Out 
Matt Milella and Jacques Vigeant, Oracle Corporation
See some of the new and upcoming DV features showcased as Matt tries to beat the clock solving the world's most critical problems with Analytics Cloud. 

2:45 PM - 3:15 PM
Break

3:15 PM - 4:35 PM
Data Visualization Workshop
Philippe Lions, Oracle Corporation
Get your hands dirty and learn some of the basics and not so basic capabilities of OAC/Data Visualization.

4:35 PM - 4:45 PM
Closing Remarks from ODTUG Kscope17 Track Chair 
Kevin McGinley, Red Pill Analytics

 



DATABASE

 
The Database Sunday Symposium
Cibolo Canyon 8/9/10

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. 

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

Ten Rules for Doing a Pl/SQL Performance Experiment 
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.

Leveraging Hyperlinks in REST APIs
Colm Divilly, Oracle Corporation
Colm will describe why hyperlinks are essential to good REST APIs, how to generate them using Oracle REST Data Services and cover tips and best practices for hyperlinks.

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.

Welding Together REST APIs
Colm Divilly, Oracle Corporation
Colm will describe how to securely combine disparate REST APIs in a single web app by leveraging the Cross Origin Request Sharing (CORS) protocol.

Building Your Own Oracle Developer Day VM
Barry McGillin,
Oracle Corporation
Barry will show how the VM is built automatically with VirtualBox and what you use it for. SQL sandbox, Apex SandBox, Ords sandbox. The choice is yours.

 

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.

New Open Source Projects from Database Tools
Barry McGillin,
Oracle Corporation
Barry will share what projects are being presented on Open source on Github and how you can use them or contribute to them. In particular, we’ll show the upcoming REST based JDBC driver and how REST enabling does not mean rewriting your application.

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 and 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!