The ODTUG Kscope21 Virtual Event is unique in its offering of  Oracle Symposiums—included with conference registration. Join us on Monday, June 21 to start off week one of your education with this year’s Symposium for your track!

Times shown in EDT.


Analytics | APEX | Database | Emerging Technologies | EPM/Essbase | Modern Application Development


Oracle Analytics has seen tremendous innovation and growth since its introduction, and Oracle continues to enhance every aspect of the product and introduce new capabilities. In the 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 features; and uncovering its strategy for cloud, on-premises, and mobile.

11:30 a.m. – 12:30 p.m. The Future of Analytics: Strategy and Roadmap for Oracle Analytics Cloud – Jacques Vigeant, Senior Director of Product Management

With data and analytics driving virtually everything, you need to know where Oracle Analytics can take you next, whether you are in Oracle Cloud, on-premises, or a multicloud environment. In this session join Oracle Analytics Product Management to see the latest innovation in modern, augmented, and governed analytics, including machine-learning-powered data preparation, augmented insights, SaaS integration, natural language, team collaboration, and more.

12:40 – 1:40 p.m. Agile Machine Learning: How Oracle Analytics Cloud and Machine Learning Boost Your Organization’s Agility - Lalitha Venkataraman, Director of Oracle Analytics Product Management

Bring business analysts and data science together through the machine learning capabilities built in with Oracle Analytics Cloud and extending into Oracle Machine Learning Platform. In this session, see capabilities that will help your business analysts extract immediate value out of advanced analytics and machine learning techniques. See the capabilities available today and get a sneak preview of what's coming to make your life easier tomorrow.

1:40 – 2:20 p.m. Exhibit Hall Break

2:20 – 3:20 p.m. Augmented Self-Service Data Preparation in Oracle Analytics Cloud – Luis Rivas, Director of Product Management

Oracle Analytics Cloud provides a powerful tool to get insight from your data, wherever it is. In this session you will learn all about the augmented self-service data preparation capabilities of OAC. It’s easy to get your data into OAC and enrich it based on intelligent recommendations. From enterprise data sources all the way to the humble but mighty CSV file. What if your data is still on premises? No problem, learn how you can keep your data on premises and visualize it in the cloud with the easy-to-set-up Data Gateway.

3:30 – 4:30 p.m. Embed Analytics in Your Daily Decisions with Oracle Analytics Cloud Developer Capabilities – Mike Durran, Senior Principal Product Manager

You analyze information to help drive new behavior and outcomes, but that's hard if analysis is disconnected from your day-to-day work. In this session, learn how you can easily inject Oracle Analytics into your daily activities and make all your actions data driven. See how highly visual insights can be embedded into your own custom applications and webpages in a secure, interactive manner. The session also covers topics such as Oracle Analytics APIs and other functionality available for application developers.


The ODTUG Kscope21 Virtual Event kicks off on Monday with the APEX Symposium, and all presentations are done by the APEX Development Team itself. Learn about exciting new features like the new Cards and Map regions, Automations, REST Data Synchronization, charts in Faceted Search, native PDF printing and Excel export, Redwood Light Theme Style, an exceptional new code editor, and support for the Oracle Multilingual Engine (MLE). You’ll also get a preview of what’s on the roadmap for APEX 21.2 and beyond.

11:30 a.m. – 12:15 p.m. Location matters: The New Map Region Type in APEX 21.1 - Carsten Czarski, Consulting Member of Technical Staff

This presentation introduces the new APEX 21.1 Map Region Type. Attendees will learn how to easily visualize location data from an SQL query or a REST Data Source on a map—all declarative, without manual coding and without external plugins. The session will also cover how to integrate a map region with other APEX region types like charts, reports, or faceted search. Tips and tricks about visualizing larger amounts of data and how to leverage Oracle Spatial functionality will wrap the session up.

12:15 – 12:55 p.m. New & Better Report Exports in APEX - Menno Hoogendijk, Consulting Member of Technical Staff

The APEX team continues to improve report printing and data exports. You can now download your report regions as HTML, PDF, Excel, or CSV without an external print server. We exposed powerful APIs to export the results of any query or REST data source in these formats plus two additional formats: XML and JSON. We also allow you to configure native or remote report printing in your application. Join me to learn more about the latest features and have a glance at the future.

1:00 – 1:40 p.m. Send It to the Background: REST Synchronizations and Automations - Carsten Czarski, Consulting Member of Technical Staff

Automations and REST Synchronizations are the first declarative APEX features which execute in the background—without the developer having to manually implement a scheduler job. This makes it super easy to load data from an external REST API on schedule and to transform it using SQL or PL/SQL statements afterwards. Combined with other REST Source enhancements, like REST source plugins or the new CSV support, this becomes a powerful tool to get and transform data from external sources. The session will introduce these features, show how to use them, and provide some tips and tricks for daily usage.

1:40 – 2:20 p.m. Exhibit Hall Break

2:20 – 3:10 p.m. What’s New for Oracle APEX in Oracle Cloud Infrastructure (OCI) - Todd Bottger, Director of Product Management

Join Oracle PM Director Todd Bottger to learn what’s new for Oracle APEX in OCI. Hear about exciting advancements combining APEX low-code application development with the ease and power of OCI and Oracle Autonomous Database (ADB). Learn about Oracle’s new low-cost cloud service that is focused on APEX and comes with an ADB database included. See how Oracle APEX running in OCI frees developers from routine administrative tasks so they can focus on what matters most: developing and deploying applications.

3:10 – 4:00 p.m. Magic Tricks with APEX Cards - Christina Cho, Consulting Member of Technical Staff

The Cards component provides developers with a powerful and flexible new way to display data in bite-sized blocks, ideal for use in faceted search or presenting at-a-glance information. This flagship feature of APEX enables you to effortlessly customize nearly every aspect of the Card UI, including the layout, appearance, icon, badge, media, advanced HTML expressions that support client-side templating, and the ability to define multiple actions per card. In this session, Christina will show you how you can easily use Cards in a variety of ways to delight your users and present data in new ways. You won't need to be a wizard to add this magic to your apps!

4:05 – 5:00 p.m. APEX 21.1 New Features - Marc Sewtz, Software Development Director

APEX 20.x brought you a host of awesome new features: friendly URLs, Universal Theme and component upgrades, vastly improved REST and download capabilities, and much more, all designed to make you a more productive and effective APEX developer. APEX 21.1 promises to continue this trend, and in this session, Marc Sewtz will highlight the most significant features from last year and introduce some of the new features being introduced with APEX 21.1.


The Database—the Heart of Application Development

All development of applications deals with data in one form or another. Data can be saved in many different forms and shapes in many different databases or other storage types. Often different types of data are needed within a single application, which can lead to difficult choices.

You can utilize different storage or database types to work optimally with each type of data—at the cost of having to constantly pull the data out of their normal place into some place in the middle and join them together there. Or you can try to "bend" the data to fit into a single type of database—at the cost of not working optimally with all your data.

The Oracle database is a converged database that can work optimally with many different types of data—straight relational data, JSON, XML, Graph, Spatial, Blockchain, and a lot more.

Join the people of Oracle who develop and work with these features to know more about the future roadmap, cool new JSON features, enhanced and advanced SQL, and how this database showed its strength when COVID-19 pushed application development to unprecedented speeds.

11:30 a.m. – 12:30 p.m. Database Roadmap - Kris Rice, Vice President of Development

12:40 – 1:40 p.m. JSON_Type and Other Cool JSON Features in Oracle 21c - Beda Hammerschmidt, Architect

Oracle 21c has a new data type to store JSON. It uses a binary format—optimized for fast queries and piecewise updates. 21c also provides a new index to index JSON array values.

This presentation walks you through the latest JSON enhancements in the Oracle database and how you can best leverage them. A code demo shows how JSON in Oracle can be mapped to collections and accessed using document store Apis, similar to MongoDB.

1:40 – 2:20 p.m. Exhibit Hall Break

2:20 – 3:10 p.m. Pattern Matching + SQL Macros = Pure SQL Awesomeness! - Chris Saxon, Oracle Developer Advocate for SQL

Added in Oracle Database 12c, SQL pattern matching (match_recognize) makes it easy to answer many questions that were hard-to-impossible with SQL. But turning match_recognize clauses into reusable functions was tricky at best. No more!

Added in 19.6, SQL macros enable you to define reusable code fragments. These return SQL that becomes part of your final SQL statement. Using macros, you can create reusable pattern matching clauses you can apply to any table.

This session is for developers and DBAs who want to get the best out of SQL. Join this talk to learn how to combine these features and unlock pure SQL awesomeness!

3:20 – 4:10 p.m. From Requirements to Design to Deployment: A Real-World Case-Study in COVID-19 Patient Testing Deployment - Nitin Vengurlekar, Chief Technology Strategist

We all say 2020 was a crazy year; COVID-19 put a damper on everything. In 2020, an internal Oracle team was assembled along with several value-add partners to develop a patient screening, scheduling, and testing system. This system was built in rapid development mode to deal with the much-needed COVID-19 testing. The coalition executed mockups, POCs, and deployment all at unprecedented speed. Due to the short timeframe and urgent need, key decisions on Oracle stack components, governance, and long-term supportability were made quickly. This session will walk through the technical and design requirements, key governance needs, execution decisions, as well as deployment models. As part of this discussion, we describe the thought process for final stack design, how the CDC COVID-19 guidelines impacted our solution, describe the overall configuration, and outline the deployment experience. Since data privacy was of utmost importance, we will spend a large portion of time discussing data security and governance.

4:10 – 5:00 p.m. Q&A Panel on Converged Database and the future thereof. What will it mean to the lives of DBAs and Developers that the database has so many built-in capabilities? - Charlie Berger, Nitin Vengurlekar, Beda Hammerschmidt, Chris Saxon, Rich Niemiec, Jim Czuprynski

Today, an application very often has the need for not just relational data, not just JSON data, not just {insert-your-own}, but rather multiple types of data in a mix-and-match hodgepodge. Previously, these would be different data sources which would be mixed and matched in the application and/or middleware. With Oracle Converged Database you can handle the different data types all together in a single data source and join the pieces together efficiently near the data instead of pulling everything out for client-side treatment.

But what will that mean for architects, developers, and DBAs in such a setup? Some things will be a lot easier, other things need a different way of thinking, and some new tasks might be added to previous roles—like a DBA who now needs to take care of tasks which previously might have been done by application server sysadmins and therefore lets the Autonomous DB handle their previous routine tasks to free time to do the new interesting tasks. Or a developer who might need to learn slightly more advanced SQL to join their relational and JSON data but saves a lot of time by only having a single source of truth in their front-end code.

No matter what your role, Converged DB can—and probably will—change your daily life. Join our discussion—it's your future we'll be talking about.

Emerging Technologies

2:20 – 3:20 p.m. Database Multilingual Engine: The Vision and the Why – Gerald Venzl, Senior Principal Product Manager

Starting with Oracle Database 21c, Oracle introduced the Multilingual Engine, a new engine to execute JavaScript code inside the database, besides the already existing PL/SQL and Java engines. Why is executing JavaScript inside the database interesting, what does that mean for PL/SQL, and why is it called Multilingual Engine when it can only do JavaScript? The potential of the Multilingual Engine, based on Oracle's GraalVM technology, and how it could revolutionize the way we apply code to data, are manifold. Gerald Venzl will share the vision behind the Multilingual Engine, the why, and how the future may look like very soon.


Oracle Cloud EPM 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 Virtual EPM Symposium last year, you heard from our development leaders on the state of EPM and were among the first to see some really cool works in progress. 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 this year. 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 under development.  

Presented by Oracle EPM Product Management and development leaders, Al Marciante, Matt Bradley, Hari Sankar, Marc Seewald, Rich Wilkie, and Brian Casey you will get unfiltered insight into our key R&D initiatives. Our goal at the EPM 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.

11:30 a.m. - 12:30 p.m. Essbase Roadmap – Ashish Jain, Senior Product Manager and Patrick Wheeler, VP of Product Management
Essbase has seen major changes over the past few years from the introduction of Essbase 19c as a standalone product deployed via the Oracle Cloud Marketplace to the most recent release of Essbase 21c for both cloud and on-premises customers, bringing enhancements to interfaces, engine, and supporting tools such as Cube Designer. In the Essbase Symposium, we will hear from the Product Management team on the exciting roadmap for the product. Learn about the new upcoming features such as integration with Autonomous Database in the cloud, UI improvements, and have an opportunity to put questions to the team.

12:30 – 1:40 p.m. State of EPM Keynote – Matt Bradley, Senior VP of Development and Hari Sankar, VP of Product Development

1:40 – 2:20 p.m. Exhibit Hall Break

2:20 – 3:30 p.m. Cloud EPM – One Platform Topics
Oracle will discuss various projects, modes of access and performance—including Redwood, APIs, OOTB content, etc.

3:00 - 4:00 p.m. Essbase and Freeform Apps - The Road Ahead - Ashish Jain, Senior Product Manager and Shankar Viswanathan, Senior Director, Product Management
When it comes to deciding your migration options for Essbase on-prem to the cloud, Oracle has many compelling options for you to choose from. This is the session to attend to ensure you have the right information to make the right decision for your organization. We will dive deeper into when to choose Essbase on OCI or FreeForm Apps with EPM Cloud. This session will help you evaluate these choices and the questions you need to ask before you make the move. This session will complement the Essbase roadmap session and provide the roadmap with Freeform Apps within EPM Cloud.

3:30 – 4:45 p.m. Innovation Showcase
This section will highlight key functional innovations coming in Cloud EPM, including machine learning, automation, and insights projects.

4:45 – 5:00 p.m. Wrap-up

Modern Application Development

11:30 a.m. – 12:30 p.m.  Hey Google, What Are the Core Concepts of Chatbots and Digital Assistants? O-Ace-Director-Icon-rgb.pngLuc Bors, eProssed

Chatbot technology has been around for quite a few years. On many websites and in many apps, there is a chatbot that offers to help you. Unfortunately, not all of these are helpful, and some are even awful. It all comes down to one question: “What makes a good chatbot, and what makes a good digital assistant?”

There are many vendors that provide technology to allow you to build great solutions. They all try to implement the same core concepts. Do you know these concepts, and do you know how to properly use these? It might sound simple, but when applied improperly, these core concepts can work against you.

Based on some real examples of good and bad solutions, you will learn how to apply the concepts of chatbots and digital assistants. In this session I will show several vendors of chatbot technology and explain how these compare to Oracle Digital Assistant. You will get a good understanding of chatbot technology, and I will provide you an on-ramp for the deep dive session later in the week.

12:30 – 1:30 p.m. Extending in the New UI, Tailoring Digital Assistants for Cloud SaaS - O-Ace-Director-Icon-rgb.png Gustavo Gonzalez, IT Convergence

There was a lot of hype around chatbots, and they were expected to replace apps. Chatbot technology fell short in many ways, including algorithms that relied on customers asking the right questions. The lack of a proper AI also forced the developers to rely on input buttons, almost entirely removing the conversational element.

Digital assistants (DA) for enterprise applications is the evolution of the original chatbots and is now reaching places nobody has ever imagined. During this session, we will analyze and share how DA can be used in "Oracle Cloud SaaS" to access multiple ERP/HCM/SCM/CX SaaS services through a digital assistant pre-provisioned and an out-of-the-box digital assistant (FADigitalAssistant) with numerous skills. Also, we will cover aspects of how you will extend the existing digital assistants or specific skills.

We'll share what the process and implications of building custom components look like from a technical and subscription's perspective.