Analytics   |   APEX   |   Core & Database   |   Emerging Technologies   |   EPM   |   Modern App Development

Hands-On Training Sponsored by,


The Hands-On Training Labs are back—with fresh new content for ODTUG Kscope22. These labs are BYOL—Bring Your Own Laptop—and are included free of charge with your conference registration. Classes are limited to 40 people and will be filled on a first-come, first-served basis; there is no advance sign-up required.


9:00 a.m. - 12:15 p.m. | San Antonio 3

Deep Dive | Just Add Water: Building a Data Lakehouse 

For years, delivering analytics meant building data warehouses: purpose-built solutions for explicit requirements defined by data consumers. Next came the data lake and its focus on storing as much data as possible, initially powered by Hadoop but finding mass appeal with cloud native options. Now the data lakehouse is trending: a reimagining of both concepts combined into a single data platform.
Join three seasoned industry leaders on a journey to the data lakehouse. We’ll describe key patterns that define a lakehouse and the value it delivers over prior attempts at data tranquility. Finally, experience the strengths and weaknesses of three separate lakehouse demonstrations: one using the Oracle Cloud, and two others built with competitor solutions.

Presenter - ACE DirectorStewart Bryson, Qualytics

Oracle ACEHolger Friedrich, sumIT AG

ACE DirectorEdelweiss KammermannIT Convergence

9:00 - 10:30 a.m. | San Antonio 5

Hands-On Training | Oracle Analytics Cloud – Semantic Modeler

This Hands on Lab covers the Oracle Analytics Semantic Modeler used to build, modify, enhance, and manage Analytics Subjects Areas in Oracle Analytics Cloud. You will learn how to import metadata from a data source, simplify and organize the imported metadata for the data sources into a business model, and then structure the business model for presentation to users who need to perform business analysis using Oracle Analytics Cloud. You will learn how to create calculated measures, hierarchies, aggregates, and time series measures. Get to know the new features in Semantic Modeler including Git integration for version control and code centric development using Semantic Modeler Markup Language (SMML).

Presenter - Pravin Janardanam, Oracle Corporation

10:45 a.m. - 12:15 p.m. | San Antonio 5

Hands-On Training | Programmatically Managing Oracle Analytics Cloud

Oracle Analytics Cloud has recently introduced new management APIs. In this Hands-On Lab, learn about the benefits and capabilities of the available API endpoints, how to authenticate them and best practices for their usage. The APIs can dramatically improve your productivity for creating OAC instances, deploying BAR files as well as implementing an automated backup strategy.  This HOL will help you manage your OAC Instance using APIs - in order to get the most out of this HOL, you’ll need access to an OAC instance where you can create and restore snapshots in addition to access to OCI object storage and the ability to create custom applications in Oracle IDCS in the same tenancy  as that OAC Instance.  Even if you’re not able to get these requirements, please still attend if you’re interested as you will learn all the key tasks to programmatically manage OAC.

Presenter - Bret Grinslade, Oracle Corporation

Mike Durran, Oracle Corporation


9:00 - 10:30 a.m. | Texas C

Deep Dive | APEX is Formula 1 Fast: With a Good Team and the Right Tools, You Can Make APEX Even Faster

The APEX Lightning Talks are back! After a week of inspiring content, cross the finish line with this fun and informative session. Some of the best, well-known speakers and luminaries in the APEX community will give you insights and guidance on how, with the right team and tools, you can increase productivity and turbocharge Oracle APEX.

Sportscaster: Ace.jpgJorge Rimblas, DRW

Quick SQL = Faster Table Generation

Learn how to leverage the short syntax to create robust data models.

Ace.jpgMirela Ardelean, Equip GmbH

Making the Track Shorter

Reducing mouse-kilometers Pretius Developer Tool.

Ace.jpgMatthew Mulvaney, Pretius Low-Code

Pole Position

Building a volunteer handling Application to help Ukrainian refugees  two-hours. 

Michał Lipiński, Pretius Low-Code 

Avoid the Road Hazards

Using APEX Project Eye to accelerate error detection.

ACE Director.pngDimitri Gielis, United Codes

A Good Pit Crew Makes the Race

What makes this APEX community so special?

ACE Director.pngNiels de Bruijn, MT AG

10:45 a.m. - 12:15 p.m. | Texas 3

Hands-On Training | Build and Deploy a Fully Functional Low Code APEX PWA App in the Cloud!

Get your feet wet learning how to build a fully functional low code APEX app in no time. You will be amazed at how you went from a spreadsheet to a fully featured, responsive web app in minutes! Learn how with a single switch, you can change your APEX app to look and feel like a native app and then deploy it to the cloud.

Presenter -  Vincent Morneau, Oracle Corporation
Co-presenter -
Vladislav Uvarov, Oracle Corporation 

Core & Database

9:00 a.m. - 12:15 p.m. | Dallas 5 

Deep Dive | Faster: How to Optimize a System

A talk about selected chapters from Faster: How to Optimize a System, the latest book by Cary Millsap with Jeff Holt. The talk is for anybody who is curious about how computer programs and other processes spend their time, and what you can do to improve them (that is, developers, database administrators, and project/program leaders at any experience level).

Making things faster is about making things better. Making life better. The faster your tools can work, the more time you have for doing the things you want to be doing. If your tools help you process information, then the faster they work, the better decisions you can make.

Optimizing – whether a computer, or a plow, or anything in between – requires two separate skill sets: one, asking the right questions; and two, of course, answering those questions. Most people who think about optimizing are well aware of this second skill set. Fewer seem aware of the first one. But this first one – the mere act of asking the right questions – is the skill you need to develop first, especially if you’re a leader. You might be surprised at how quickly you’ll be able to learn it.

Presenter -  ACE DirectorCary Millsap, Method R Corporation

Emerging Technologies

9:00 - 10:30 a.m. | Dallas 6

Deep Dive | What AI Services Does Oracle Offer and How Does that Apply to the Technical and Functional Users?

Oracle has released several AI services recently and learning when and how to use them can seem daunting. However, these tools have been built so that a range of technical and functional users can consume the service and data for deeper analysis and utilization. This session will review the services offered, how to use the services in the workplace, and how different business departments can use the services for deeper insights into their data.

How can a financial analyst utilize the Vision service to make their job easier? How can the supply chain professional utilize the Language service to hedge shipping delays? How can an accounting manager utilize Anomaly Detection to manage expenses? We will go into an array of scenarios for AI service understanding.

Presenter - Sarah Zumbrum, Oracle Corporation

10:45 a.m. - 12:15 p.m. | San Antonio 6

Hands-On Training | Hands-On with Oracle AI Services

The goal of this session is primarily informational for attendees in understanding what the AI services are and how to use them. A close second is challenging attendees to think beyond the typical uses of AI for Vision, Language, and Anomaly Detection so that they can apply these services in their daily work to drive more efficient departmental and business outcomes.

Presenter - Sarah Zumbrum, Oracle Corporation 


9:00 - 10:30 a.m. | Texas D

Deep Dive | EPM Automate Crash Course

Is it your first time using EPM Automate, or maybe you're a seasoned user, but would like to leverage it more for end-to-end automation across Oracle EPM and third-party processes? Join us to learn about the considerations and various scenarios where it makes sense to use this helpful utility, versus other tools to accomplish multiple steps for Oracle EPM applications. Whether you're interested in automating data flows, transferring/storing secure data, completing application backups, customizing file names, or other helpful use cases, come to understand best practices, instructions, tips/tricks, and lessons learned!

Ian Terry, EPM Intelligence

10:45 a.m. - 12:15 p.m. | Texas D

Deep Dive | How to Implement Close Task Manager without Consultants - Extended Version!

The Close Task Manager is one of the integrated and self-service features of the Oracle EPM Cloud that can add immediate value to any business process. In this session, learn the key considerations, as well as tactical tips when setting up task types, templates, workflow, rules, key attributes, and security features. You will also get insider detail on the dos and don'ts of various options, such as setting up predecessors, teams, holiday rules, and a future maintenance model. And finally, learn specific features that your auditors will love!

Kelliann Hoelscher, Peloton 

Ace.jpgGeordan Drummond, Alithya 

Modern App Development 

9:00 - 10:30 a.m.  | San Antonio 6

Hands-On Training | Visual Builder – Building JavaScript/HTML Apps Faster

In this lab you’ll learn how to leverage the visual development experience of Oracle Visual Builder to accelerate application development.

Create responsive web interfaces leveraging Oracle JET components and the Redwood look and feel.

Bind them to business objects that store your data in an Oracle Database.

And visually define your application logic flows.

Create a complete app developing both the frontend and backend of the app, with Oracle’s JavaScript/HTML/REST based dev tool.

Prior to the session please go to the following link to get setup.

Presenter -Vivek Kumar, Oracle Corporation

10:45 a.m. - 12:15 p.m.| Dallas 6

Deep Dive | Oracle Digital Assistant: No Slides, Just Code!

As the title says, in this session you will learn what are the most important parts, or terms to be aware of within Oracle Digital Assistant, how to implement skills, how to integrate with any external system using its own node.js container and how to expose them via different channels. I will demonstrate how to create a weather chatbot integrated with a free weather API.

Presenter - ACE DirectorRuben Rodriguez, CGI