Analytics & Machine Learning  | Oracle APEX  |  Database Engineering & Development  | 

                                                                Emerging Technologies |  Enterprise Planning  |  EPM Foundations & Reporting  |  Essbase |

Extending Oracle Cloud Applications  |  Financial Close  |  ProfitabilityStrategic EPM

Analytics & Machine Learning

Analytics & Machine Learning at ODTUG Kscope23:

In today's data-driven culture, Analytics and Machine Learning are critical and necessary for companies to grow, innovate, and succeed in the current marketplace. The ODTUG Kscope23 conference is the premier Analytics and Machine Learning conference for developers, data scientists, analysts, and data lovers. If you can’t measure it, why bother? Data loving professionals converge at the ODTUG Kscope23 to share the best presentations, new insights, knowledge, and information.

Oracle Analytics:

Dive into all things Oracle Analytics and learn about various Oracle Analytics products, tools, and features. Whether you are in the Oracle Analytics cloud, on-premises, or a little of both, these sessions will help you get the most out of your Oracle Analytics investment.

Data Engineering:

If you need to stream, extract, replicate, transform, wrangle, cleanse, mask, and load data in one or more platforms, this subtopic is for you. Whether you need self-service desktop capabilities or full-blown enterprise data integration and data quality, sessions in this subtopic will give you the information you need to better manipulate data. Platforms include Oracle Integration products, Spark, GoldenGate, dbt, Airflow, Python, and more.

Data Architecture and Ecosystem:

Explore the variety of databases, storage, and technologies for data from Oracle and other vendors – from traditional to open-source platforms to determine the best fit for your organization. Where should data live? Understand cloud and hybrid strategies. Delve into the entire data ecosystem including reporting tools, machine learning environments, data storage, and how they all integrate together.

Advanced Analytics/Machine Learning:

Understanding and use of data can be substantially enhanced by the complementary capabilities through deeper insights provided by Advanced Analytics including artificial intelligence (AI) and Machine Learning (ML). Machine Learning can help to process huge quantities of data and offer focused insights by discovering patterns in the data, such as the relative importance of certain attributes to an event occurring. Artificial intelligence helps machines make decisions that normally would require expertise at a human level. Explore applications of Advanced Analytics and ML to understand how it can be integrated into processes at your organization. Gain knowledge of how to build systems that leverage Advanced Analytics.

Data Visualization:

The ability to communicate effectively with data is a skill and an art. Building a clear and concise visualization that helps the audience understand the key takeaways of visualization takes a thoughtful process. How do you help executives understand a complex analysis? Sessions will guide the audience through effective visualization best practices, newer visualization types and techniques including spatial, and how to tell a story with data.

Data Strategy:

“Build it and they will come” does not apply to data. Successful organizations leverage data at all levels, have a pervasive data culture, and high data literacy among leadership and employees. These companies understand their data maturity level and have a vision as to where they are going. They are thoughtful about the tools they use, who uses them, and how they use them, including training and advocacy. Understand how effective data governance helps with a data strategy. Case studies and best practices can be shared to help audiences see possibilities of how to lead a successful data strategy at their organizations.

Back to Top

 Oracle APEX   

Track Sponsored by

Insum logo_V2.png

APEX at ODTUG Kscope23:

ODTUG Kscope23 continues to lead the pack by providing the best educational experience for Oracle APEX developers. As always, we'll ensure content is available for all skill levels—from beginners to the advanced APEX developers—there is something for everyone.

We're also exploring more challenging issues that APEX developers face—such as integration, extensions, lifecycle management, and security. We'll continue to have a track dedicated to the core components of APEX, as they are some of the tool's most powerful features and are often the most overlooked. We have expanded our content to include ORDS, REST, and the various APEX Server Infrastructures that are becoming increasingly popular. And we look forward to seeing what the Future of APEX looks like through your eyes, whether it be through combining APEX with new 21c features, MLE, JavaScript in the database, or something only you can imagine!

Core Components:

While there are many ways to integrate all kinds of things with APEX (see the Extensions/Integration track, for example), the core components of APEX should not be overlooked. This track highlights what can be done by staying "inside the box"—using only the core components of APEX and associated best practices. There's no limit to the sophistication of the content here (we have a beginner track for the basics), so let your imagination run wild.

ORDS and the REST:

A core component of the Oracle RAD stack, REST Data Services (ORDS), goes hand-in-hand with APEX. With ever-increasing native support for REST Data Sources, REST Enabled SQL, and APIs, creating components in APEX with external data via REST is as easy as creating them via a local table. The sky's the limit! This track contains all things pertaining to ORDS.

Extensions / Integration:

With Oracle APEX, you rarely build a standalone application. In most cases, you need some integration, either with other products (e.g., MS Outlook, Google Calendar, SAP, Oracle eBusiness Suite), other technologies, or even other languages and tools (e.g., Java, SQLcl, JavaScript). This track highlights ways to integrate with and extend the APEX platform using non-APEX technologies.

Lifecycle Management & Security:

Application development is not a discrete process anymore—whether with APEX or any other technology. With more emphasis on things such as CI/CD & DevOps in general, can APEX play in that world? Of course, it can! This track will highlight anything that has to do with the overall management of applications throughout their lifetimes—from configuration management to version control and DevOps. This track also includes sessions focused on security—because security starts on day one and never ends.

The Future of APEX:

What will APEX development look like in the years to come? No one can know for sure, but by using new and innovative features of the Oracle database coupled with the power of APEX, the future looks bright! Show us your new and innovative ways to use APEX, whether through combining APEX with new 21c features, the MLE, JavaScript in the database, ML, AI, or something only you can think of. This track will give you a look at exciting things to come!

Server Infrastructure:

Today there are so many options for how you can configure your APEX infrastructure. How does your APEX environment's server infrastructure affect how you develop? Do you have advice, tips, or tricks for others on using the Oracle APEX Service, APEX on AWS or Azure, or on-premises? This track aims to shed light on the ever-changing world of APEX server infrastructures.


Don't see a category where your session fits? That's perfectly fine—tag it as 'Other’, and we'll have a look.

Back to Top

Database Engineering & Development

Database Engineering & Development at ODTUG Kscope23:

At the core of applications is the layer that handles, stores, and manipulates the data needed by the application. The back-end functionality (core business rules) are developed in this layer as well. It can involve RDBMS or other database types, in autonomous or manually managed setups, developed in SQL and PL/SQL or other languages – the possibilities are many and you want to learn about them to make sound choices for your app.

In the end, it’s all about making the data available to those that need to use it, no matter where the data resides – single or multiple clouds, hybrid, or on-premises datastores. Database engineers and database developers fit all the pieces together, converging data or seamlessly joining multiple sources or moving data to where it’s needed. In all cases, both old and tried skills as well as new and fresh skills are needed. You can learn of both sets of skills at ODTUG Kscope23.

All about Performance:

High Performance setups, Optimization, Tuning – if it’s about the performance of the application, this is the subcategory for it.


Applications these days can run in cloud (both single and multi-cloud), on-premises or hybrid setups. For sure you’ll need to know about all permutations.


In Oracle Cloud there are several Autonomous offerings, where you let Oracle do most of the database management. This is the subcategory for Autonomous Data Warehouse, Autonomous Transaction Processing and Autonomous JSON Database.

Code in Core:

Central pieces of the application code are often best placed in the core. You can be very efficient using SQL or build data APIs in PL/SQL; but you can also utilize the Multilingual Engine (MLE) to use other languages. Whether SQL, PL/SQL, JavaScript, Python, JET, Java, etc. This is the subcategory for programming languages.

Converged Database:

In the Converged Database you do not need to maintain a lot of different data sources with integration between them. One database can handle Spatial, Graph, JSON, Blockchain, and more.


Rolling out changes from development to QA to production environments for code, applications, database changes, and infrastructure can be a challenge. Developers, DBAs, and sysadmins alike need good deployment tools and workflows for different situations. Automation and infrastructure-as-code can be helpful.

Integration and Moving Data:

With data in many locations (even multiple clouds) you need to integrate, let your applications use the data from multiple sources or converging them to one, or move the data to where the application needs it.


We see stories about computer hacking in the media almost every day. An application really needs to be secure right from the start. Anything pertaining to security belongs in this subcategory.


Tools for developing and/or managing the core are plentiful. From classic SQL*Plus to Oracle SQL Developer and other tools, both from Oracle and third parties. Tools can be installed programs or browser-based in the cloud. In both cases you might need to work with databases in cloud or on-premises.

Back to Top

Emerging Technologies 

Emerging Technologies at ODTUG Kscope23:

Technology constantly evolves, which has even helped us to adapt to a “new normal” in the COVID era. Business leaders, IT infrastructure specialists, and application developers like you have had a pivotal role in identifying and implementing solutions that are crucial in supporting the community. Join us and our amazing panel of visionaries as they share their thoughts about the roads ahead. Take home valuable insights on the future of technology, and help those who depend on us to plan and build for tomorrow.
Advanced Topics on AI and Machine Learning: 
Block Chain Applied: 

Data Sharing - Approaches and Technologies: 

Hyperautomation: While many organizations have successfully digitized many of their operations, several others remain that continually face challenges in digitally transforming their processes and workflows. In this subcategory, we discuss how technologies such as AI/ML and robotic process automation can help companies to evolve.


Next-Generation Security: As more and more organizations move IT operations into the cloud and support a globally distributed workforce, the role of digital security is increasingly important, but challenging. Discussions in this subcategory could include concepts such as Zero Trust Security and Cybersecurity Mesh.

Quantum Computing: Quantum computing can be described as one of the most disruptive technologies that will impact the IT industry in areas such as high-performance computing, machine learning, and cryptography. While the quantum computer has yet to enter mainstream, there are several bridging technologies and computing frameworks that will help developers start on this technology now.

Sustainability and Social Good: The world continues to face many challenges in our societies and our climate. In this subcategory, discussed will not only be how technology can be used for good, but how we can improve practices in our industry to lessen our impact on the climate.

Back to Top

  Enterprise Planning 

Enterprise Planning at ODTUG Kscope23:
In prior ODTUG Kscope conferences, there has been confusion about where to find information about the Enterprise Planning processes that an organization undertakes. Were these in the Planning track or were they in the Essbase track? We have reimagined these two tracks. You can learn more about the Essbase track below.

The Enterprise Planning track is intended to provide insight into how Hyperion Planning and Oracle EPM Cloud Enterprise Planning (formerly known as PBCS/EPBC) can be used to support the various business processes that encompass enterprise planning. These include financial planning, strategic modeling, revenue/sales planning, workforce planning, capital planning, project financial planning.

Technologies supported in the Enterprise Planning track include Hyperion Planning and PBCS/EPBCS, which includes the use of the prebuilt frameworks. It is important to note, FreeForm Apps supporting Enterprise Planning initiatives are represented in the Enterprise Planning track. FreeForm Apps supporting operational reporting or “beyond finance” processes are represented in the Essbase track.

  • Business Process Based Planning – Workforce, Capital, Financials, Projects, Strategic Modeling
  • Intelligent Performance Management, etc.
  • Enterprise-based FreeForm Apps
  • Planning-related functionality and business rules

Back to Top

  EPM Foundations & Reporting 

EPM Foundations & Reporting at ODTUG Kscope23:

This track merges the EPM Integration & Automation, EPM Reporting, and EPM Infrastructure tracks from prior years. We developed this track in recognition of how each of the disciplines covered by these legacy tracks is foundational to an Enterprise EPM solution. This track includes sessions covering data integration, master data management, data governance, process automation, cross-product reporting, and cloud infrastructure.  

  • Cloud Data Management, FDMEE, ODI (cloud & on-premises), EPM Integration Agent, Data Maps, Smart Push 
  • EPMAutomate, REST API, Groovy 
  • Smart View, Management Reporting, and Narrative Reporting
  • Cloud instance management
  • Third-party applications may also be represented within this track.


Essbase at ODTUG Kscope22:

Essbase is the cornerstone of Oracle EPM. While Essbase is the data engine of many of the Oracle EPM Cloud offerings, this track is intended to elevate one’s understanding of the standalone OLAP engine. Last year we enhanced the content of the Essbase track to include not only the technical deep dives but also how Essbase can, is, and should be used to provide actionable insight to the organization. It is important to note, free-form planning to support an Enterprise Planning initiative is also represented in the Enterprise Planning track. Free-form planning to support operational reporting is represented in the Essbase track.

Business Innovation:

Out-of-the-box solutions utilizing Essbase technology and tools. This applies to domains beyond finance such as HR, sales, or operations.

Design & Optimization:

Techniques and leading practices to build and optimize Essbase applications as well as how to optimize for performance.

Care & Feeding:

The initial stand-up of an Essbase application as well as the ongoing maintenance to ensure optimal performance is critical. Tips & tricks on how to design the infrastructure needed to support an optimal Essbase environment, as well as backups & disaster recovery are discussed.

Calculations & API:

Innovation in the technical discipline of calculations. Leading practices for calc design and API development. An exploration of Groovy and how it can enable the Essbase platform to do even more.

Essbase Infrastructure:

With Essbase converging to a single code line for both on-premises and cloud deployments, we explore how to design the infrastructure needed to support the collection of Essbase applications that will be deployed. Sessions will address on-premises (, 11.2) as well as cloud (21c) Essbase deployments.

Other Essbase:

Learn more about Essbase and the unique ways that organizations are extracting value from their investments.

Back to Top

Extending Oracle Cloud Applications

Extending Oracle Cloud Applications at ODTUG Kscope23:

The development tools used to extend Oracle Cloud Applications (Fusion) is a growing area as Oracle makes this easier with rich APIs and a range of development and integration platforms. With each new technology this is as much about use cases as how to do it, and ODTUG is the obvious home for this emerging community. As Oracle ME gathers momentum this adds even more opportunities to extend Oracle Cloud Applications.

Fusion APIs:

Oracle Fusion Cloud Applications come with a set of APIs that can be leveraged to extend the functionality.

Visual Builder:

Oracle Visual Builder is a cloud-based software development Platform as a Service and a hosted environment for your application development infrastructure. Apps can be visually designed and enhanced with JET Web Components and/or customized with JavaScript.

Oracle Applications Platform:

The Oracle Applications Platform helps you create modern, sophisticated, consumer-grade applications—whether extending Oracle Fusion Applications or building your own. It does this by combining sophisticated search, powerful business objects, built-in telemetry, low-code tools, and the new Redwood design system.

APEX with Fusion:

Extending Fusion applications using APEX low-code platform.

OCI with Fusion:

Extending Fusion applications on Oracle Cloud Infrastructure – UI, Integration, Security, CI/CD, Network Design, Best Practices.

ODA with Fusion:

Extending Fusion applications with Oracle Digital Assistant.

Process Cloud with Fusion:

Extending Fusion applications with Oracle Process Cloud Service to enable human workflow capabilities.

Back to Top

Financial Close 

Financial Close at ODTUG Kscope23:

Financial close is so much more than HFM and FCC. In the Financial Close track, we explore how Oracle EPM enables the critical tasks, which are foundational to an efficient, accurate, and reliable record to report process. Whether it is account reconciliation that includes transaction matching, financial consolidation, tax provisioning, last-mile reporting, or close-process management, the financial close track provides the information needed to streamline your organization’s financial close.

  • Financial Management (HFM) and Financial Close & Consolidation (FCC)
  • Account Reconciliation (ARM/ARCS)
  • Tax Provisioning (HTP/TRCS)
  • Third-party applications may also be represented in this track when integrated into an overall record-to-report process.

Back to Top


Profitability at ODTUG Kscope23:

Oracle Profitability and Cost Management supports the financial close process as an allocation subledger in the implementation of shared service costing, intercompany billing and fully allocated P&Ls, ultimately allowing for unsurpassed flexibility, accuracy, speed and transparency in the allocation process without overburdening the general ledger and associated budgeting solutions.

This track will focus on how organizations have successfully implemented and utilized PCM and Enterprise PCM, their benefits and learnings, and how it has helped them to succeed in their organizational goals. In addition, with the 2022 release of Enterprise PCM, implementers over the past year have had the unique experience of being the trailblazers for EPCM and will share their unique learnings and bring to light their tips and tricks on leading practices, optimization, automation and trouble shooting.

  • Allocation Tracing and Reporting
  • Financial Close Allocations
  • Shared Services Allocations
  • Operational and Channel Profitability
  • Transfer Pricing

Back to Top

Strategic EPM 

Strategic EPM at ODTUG Kscope23:

The Strategic EPM track was formerly known as Real World EPM. The sessions in this track are designed to educate decision-makers about how Oracle EPM can be part of the strategic vision of your organization through programs such as finance transformation, undertaking a journey to the cloud, improving application return on investment, or establishing and managing a center of excellence. The goal of this track is to provide actionable intelligence that leaders can use to realize their EPM strategy.

Back to Top

Submit an Abstract