Sponsored by


The Hands-On Training Labs are back—with fresh new content for ODTUG Kscope19. These labs are BYOL—Bring Your Own Laptop (and ethernet adapter if your computer requires one)—and are included free of charge with your conference registration. Classes are limited to 50 people for Analytics/EPM sessions and 70 people for APEX/Database sessions, and will be filled on a first-come, first-served basis; there is no advance sign-up required.

 See below for the class descriptions:

Application Express


EPM Data Integration

EPM Reporting, BI Analytics, and Data Visualization


Financial Close


Application Express:

Creating REST Enabled SQL References and Web Services with Oracle Application Express
Monday, June 24, 2019 | 2:15 - 4:30 p.m. | Room 608, Level 6
Carsten Czarski, Oracle Deutschland B.V. & Co KG and Marc Sewtz, Oracle Corporation

One of the marquee features of Application Express 18.1 is the improved support to consume external REST services and REST enabled SQL. In this session, you will learn how to reference external REST services as Web Source Modules and how to use these to create reports, charts, calendars, or other components. Remote Oracle database can be accessed as REST Enabled SQL services; you can create an APEX component driven by an SQL query as before but have it executed on a remote Oracle database over a REST interface using HTTPS and JSON.

Low-Code Development with Oracle Application Express
Tuesday, June 25, 2019 | 2:15 - 4:30 p.m. | Room 608, Level 6
Chaitanya Koratamaddi, Oracle Corporation and Shakeeb Rahman, Oracle Corporation

Oracle Application Express (APEX) is a low-code development platform that enables you to build stunning, scalable, and secure apps with world-class features, which can be deployed anywhere. With Oracle APEX and low code, your organization can be more agile—develop solutions faster, for less cost, and with greater consistency. You can adapt to changing requirements with ease. Empower professional developers and everyone else in your organization to be a part of the solution.

In this lab, no prior experience with Oracle APEX is required. You will learn how to convert a spreadsheet into a multi-user, web-based, responsive APEX application in minutes! You will also learn how to rapidly prototype a data model and then create and deploy a feature-rich responsive application against this data model in minutes. Learn how you can use Oracle APEX to solve many of your business problems that have gone unsolved. Rapid application development at its finest!

Learn One, Get One for Free! CSS and jQuery for Beginners
Wednesday, June 26, 2019 | 2:15 - 4:30 p.m. | Room 608, Level 6
 Maxime Tremblay, Max Consulting IT

You’ve heard of CSS and jQuery, but are you familiar with either of them? In this presentation, we’ll take a look at the basics of CSS and how to leverage that into learning basic jQuery.

  • Basic CSS
  • Selectors
  • Pseudo-elements
  • Combinators
  • Selectors' specificity 
  • Overriding
  • Basic jQuery
  • Select and Do
  • Examples comparing CSS and jQuery selectors
  • CSS and jQuery in APEX
  • How to add/include them
  • What’s next?
  • Where and how to learn more


Git for Everyone
Tuesday, June 25, 2019 | 9:00 - 10:15 a.m. | Room 608, Level 6
ACE AlumniChristoph Martin Ruepprich, Accenture Enkitec Group

Have you heard about this fantastic open-source technology called Git? What is it and why are developers everywhere using it? Git is easier than you may think. With only a handful of commands, you can utilize the power of Git and make your development process more productive, safer, and more reliable. Whether you are a developer, administrator, or cloud architect, Git can make your job easier.

Git is a decentralized version control system which allows multiple developers to work together on a code project. By utilizing Git, code files are versioned and stored in a way that tracks your changes over time. Git can manage code or any other text file, which makes it also great for scripts, notes, and documentation.  Its built-in features allow for more accessible code organization, code reviews, and code merging.

Git experts Christoph Ruepprich and Jason Jones will walk you through this technology hands-on, while also exploring use cases for the tool. All technology communities and tracks are encouraged to attend! Find out how easy it is to get started with Git so you can use it immediately on your current projects. And best of all, you can get started for FREE!

Building an Oracle Database Web Application with ORDS and Oracle JET
Monday, June 24, 2019 | 11:00 a.m. - 12:30 p.m. | Room 608, Level 6 and
Tuesday, June 25, 2019 | 10:15 a.m. - 11:45 p.m. | Room 608, Level 6
ACE AlumniJeff Smith, Oracle Corporation and Ashley Chen, Oracle Corporation

Learn to develop and deploy a RESTful Service using Oracle SQL Developer, Oracle REST Data Services, and Oracle Database. Participants will connect these services as data sources to different Oracle JET Visualization components to quickly build rich HTML5 applications using our free and open-source JavaScript framework.

Users will need to provide their own laptop and download the following virtual image before the hands-on lab: https://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html

Bulk Processing in PL/SQL
Wednesday, June 26, 2019 | 9:00 - 10:30 a.m. | Room 608, Level 6
ACE AlumniSteven Feuerstein, Oracle Corporation

One of the most powerful performance optimization features of Oracle PL/SQL is bulk processing: BULK COLLECT and FORALL. This hands-on lab introduces the basic syntax and concepts of bulk processing and then dives into the nuances, including limiting PGA memory, handling exceptions, working with sparse arrays, and more.

This hands-on lab on Oracle PL/SQL features will be done via a LiveSQL tutorial (livesql.oracle.com). Attendees will need to bring their own device, preferably a laptop.

All attendees will need their laptops and an oracle.com account. If they don’t have an Oracle account, they can create their free account before coming at https://profile.oracle.com/myprofile/account/create-account.jspx

Getting Started with APEX on Oracle Autonomous Database
Wednesday, June 26, 2019 | 10:45 a.m. - 12:45 p.m. | Room 608, Level 6
Marc Sewtz, Oracle Corporation
Hilary Farrell, Oracle Corporation
John Snyders, Oracle Corporation
ACE AlumniMenno Hoogendijk, Oracle Corporation
Bo English-Wiczling, Oracle Corporation

This hands-on-lab introduces APEX within context of Oracle Autonomous Database Cloud accounts. The lab will take you through apportioning an APEX workspace inside an Autonomous Cloud account, building and then refining an APEX application and its components declaratively. Individual exercises focus on uploading data for your application, building and improving reports, updating page and report items, working with calendars, navigation menus, managing application users and more. Attendees will leave with foundational knowledge of Oracle APEX and where it fits in the Autonomous Cloud.

EPM Data Integration:

Mastering Changes Across the Enterprise with EDMCS
Monday, June 24, 2019 | 2:15 - 4:30 p.m. | Room 607, Level 6
Julia Radovani, Peloton Group

Attend Peloton’s session to learn how you can configure Oracle Enterprise Data Management Cloud Service (EDMCS) to create a flexible data mastering experience across enterprise applications.

• EDMCS Intro & Use Cases: How can your organization consider using EDMCS, and how does it compete with other master data management tools?

• EDMCS End User Experience: How can end users request changes to data structures in a target application? What workflow approval and notification options are available to support change management processes? What are the tools at disposal for modeling and visualizing changes to metadata, reference data, and hierarchy changes in target applications?

• EDMCS Administrator Experience: What configuration steps are involved in receiving or publishing data structures to/from external applications? How can business logic be configured in the tool to speed up metadata creation processes and prevent errors?

Data Management Hacks to Turn You into a FDMEE Cloud Ninja!
Wednesday, June 26, 2019 | 9:00 - 11:00 a.m. | Room 607, Level 6
Doug Correa, Peloton Group

You don’t need to be an expert to go beyond standard file-based data loading, but chances are, if you’re loading data to EPM Cloud apps such as EPBCS or FCCS, you are using data management in the form of FDMEE Cloud. Attend Peloton’s hands-on training session to learn about some of our favorite time-saving integration options, utilizing often overlooked features within FDMEE Cloud.

During this session, Peloton’s team of experts will cover:

• All data type integrations for loading non-numeric data, such as text, dates, and Smart List values

• Multi-column integrations to load data for multiple dimension members in a single row of data

• Driver-dimension data loads to specify target values by dimension

• Loading periods as a column to support multi-period single row files

• Data Sync to synchronize data between EPM target applications

EPM Reporting, BI Analytics, and Data Visualization:

Introduction to EPRCS
Monday, June 24, 2019 | 11:00 a.m. - 12:30 p.m. | Room 607, Level 6
Oracle ACEEric Erikson, PQR Company

Attend this lab to get deeper hands-on experience with EPRCS (Enterprise Performance Reporting Cloud Service). Learn the ins and outs of this product with live experience in the tool. A browser and Smart View will be needed to participate in this session.

Visual Analytics Made Simple with Oracle DV

Tuesday, June 25, 2019 | 10:15 a.m. - 11:45 p.m. | Room 607, Level 6
Philippe Lions, Oracle Corporation

Come try visualizing data with latest capabilities of Oracle Data Visualization live. This hands-on lab will walk you through several analytics and visualization features of Oracle Data Visualization.
Attendees are required to have a laptop connected to network.

OAC Data Visualization Workshop
Tuesday, June 25, 2019 | 2:15 - 4:30 p.m. | Room 606, Level 6
Jeremy Simmons, Qubix

Come to this hands-on training session to get first-hand experience with the machine learning tools built into Oracle Data Visualization. Learn how to prepare your data, utilize algorithms to train data models, and apply machine learning to datasets for prediction.

•  Introduction to Oracle Data Visualization

•  Create a data visualization project

•  Use different tools to explore and interact with your data

•  Work with different data sources and build data models

•  Prepare your data for analysis using data flows

•  Use data flows for data preparation

•  Use “Explain” in Oracle Data Visualization

•  Learn how to create a new machine learning model

•  Use confusion matrix to compare models

•  Learn how to create a new data set for prediction

•  Learn how to apply a machine learning model to a new dataset


OAC Essbase Workshop

Wednesday, June 26, 2019 | 9:00 - 11:00 a.m. | Room 606, Level 6
Jeremy Simmons, Qubix

Come to this hands-on training session to get first-hand experience with Essbase Cloud (part of the Oracle Analytic Cloud Service). The lab will provide a hands-on walkthrough of building an Essbase cube from the ground up and visualizing that data in Smart View and Oracle Data Visualization.


1) Introduction to Essbase

2) Creating Essbase cube outline from existing data source

     a. Modifying dimension and measures

     b. Loading data into new cube outline

     c. Creating additional calculations

3) Accessing the new cube from JET interface

4) Creating a report of the cube data with Smart View

5) Creating a visualization of the cube data with Oracle DV

6) Importing the cube into OBI RPD and creating a pivot of the cube data in OBI (optional, time permitting)

The New Face of Oracle Analytics
Wednesday, June 26, 2019 | 2:15 - 4:30 p.m. | Room 606, Level 6
Oracle ACEStewart Bryson, Red Pill Analytics and Mike Jelen, Red Pill Analytics

We are creatures of habit. Oracle Analytics is a mature solution, and inertia may cause us to stay the course regarding the content we build and how we build it. But is inertia causing us to settle for “just good enough?" Now is the time to experience modern cloud-based data and analytics tools.

Join us for a hands-on lab using Oracle Analytics Cloud as the centerpiece for developing a data-driven culture. Experience the difference developing visualizations using cloud-native data warehouse technologies including Snowflake and Oracle Autonomous Data Warehouse services. We think you’ll agree: this is not your grandparents’ BI solution.

Financial Close:

Introducing Calculations for FCCS
Tuesday, June 25, 2019 | 2:15 - 4:30 p.m. | Room 607, Level 6
Guy Rogers, Keyteach Limited and Chris McManus, Keyteach Limited

AFCCS includes six seeded calculation rules that can be customized using Calculation Manager. This session introduces techniques for how to manipulate these pre-defined calculations as well as writing custom business logic for FCCS.

Explore the concepts behind writing calculations in a multi-dimensional environment and gain an understanding of the capabilities that FCCS provides for the configuration of calculation and consolidation.

Introduction to FCCS
Wednesday, June 26, 2019 | 11:15 a.m. - 12:45 p.m. | Room 607, Level 6
Oracle ACEEric Erikson, PQR Company

Attend this lab to get deeper, hands-on experience with FCCS (Financial Consolidations Cloud Service). Learn the ins and outs of this product with live experience in the tool.

Getting Started with ARCS
Wednesday, June 26, 2019 | 2:15 - 4:30 p.m. | Room 607, Level 6
Guy Rogers, Keyteach Limited and Chris McManus, Keyteach Limited

The Account Reconciliation Cloud Service (ARCS) offers combined functionality to help streamline close processes and deliver insight about the real-time status of account reconciliations.

This session will introduce both the reconciliation compliance and transaction matching modules within ARCS. Find out how to manage account reconciliation compliance processes and explore automation of high volume/labor intensive transaction matching.


Introduction to PBCS
Monday, June 24, 2019 | 11:00 a.m. - 12:30 p.m. | Room 606, Level 6
Suzy Gallivan, Peloton Group

Oracle PBCS is a flexible application based on Oracle Hyperion Planning which supports enterprise-wide planning, budgeting, and forecasting in a cloud-based deployment model. Attend this session to learn how you can meet your immediate financial planning, budgeting, and forecasting needs while enabling a platform for future cross-functional expansion and automated process integration by leveraging PBCS.

Introducing the EPBCS Frameworks
Monday, June 24, 2019 | 2:15 - 4:30 p.m. | Room 606, Level 6
Chris McManus, Keyteach Limited and Guy Rogers, Keyteach Limited

EPBCS includes five “out-of-the-box” frameworks. This hands-on session will introduce each of these frameworks and will explore their capabilities. We’ll discover how each framework can be enabled independently and how they can also be integrated for a more unified approach.

This introductory hands-on session investigates the pre-packaged functionality of EPBCS, providing an insight into how the various frameworks can be configured and the methods they facilitate.

EPBCS Beyond the Basics—New Features, Tips, & Advanced Functionality
Tuesday, June 25, 2019 | 10:15 a.m. - 11:45 p.m. | Room 606, Level 6
Suzy Gallivan, Peloton Group

Oracle's Planning solutions in the cloud are continuously innovative, constantly providing new capabilities. This session will offer insights into the latest and greatest features. Join Peloton as we explore the lesser-known corners and advanced functionality available in these tools. From infolets to navigation flows, job scheduling, and more—Peloton cloud experts will show you how to get the most out of your EPBCS investment.

Introducing Groovy Scripting for EPBCS
Wednesday, June 26, 2019 | 11:15 a.m. - 12:45 p.m. | Room 606, Level 6
Chris McManus, Keyteach Limited and Guy Rogers, Keyteach Limited

EPBCS supports the writing of rules using the Groovy programming language. We’ll explore the capabilities of using Groovy with EPBCS and find out how Groovy rules can be written in Calculation Manager as an alternative to traditional business rules.

In this hands-on session, we’ll explore the use of pure Groovy rules for performing data validations. We’ll also discover how Groovy rules can be used to generate dynamic calc scripts at runtime, based on their execution context.