Analytics | Oracle APEX  |  Core and Database  | 

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

Financial Close  |  Modern App Development  |  ProfitabilityStrategic EPM


Analytics at ODTUG Kscope22:

In today's data-driven culture, Analytics is big business that is necessary for companies to grow, innovate, and succeed in the current marketplace. The ODTUG Kscope22 conference is the premier Analytics conference for developers. If you can’t measure it, why bother? Analytics professionals converge at the ODTUG Kscope22 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, 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. 

AI/Machine Learning:

Understanding and use of data can be substantially enhanced by the complementary capabilities provided by 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 ML and AI to understand how it can be integrated into processes at your organization. Gain knowledge of how to build systems that leverage ML and AI. 

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 on 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


APEX at ODTUG Kscope22:

ODTUG Kscope22 will continue to lead the pack by providing the best educational experience for Oracle APEX developers. This year, we’re going to make sure content is available for all skill levels—from the beginner to the advanced APEX developer—so there is something for everyone.
We’re also going to explore the more challenging issues that APEX developers face—such as integration, extensions, lifecycle management, and security. We’ll also continue to have a track dedicated to the core components of APEX, as they are some of the most powerful features of the tool 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. We also 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!

APEX 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 by utilizing non-APEX technologies.

Lifecycle Management & Security:

Application development is not a discrete process anymore—whether with APEX or any other technology. With more and more emphasis being put 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 Express:

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 it be through combining APEX with new 21c features, the MLE, JavaScript in the database, ML, AI, or through something only you can think of.  This track will give  (you, not us?) a look at exciting things to come!

APEX Server Infrastructure:
Today there are so many options for how your APEX infrastructure can be configured. How does the server infrastructure of your APEX environment affect the way you develop? Do you have advice or tips and 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.

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

Back to Top

Core & Database

Core & Database at ODTUG Kscope22:

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.

This track is for all who work with the central pieces needed for successful application development. Architects deciding on cloud or on-premises setup, database designers thinking about whether to use diverse or unified (converged) datastores, back-end developers creating business APIs for frontend APEX or PaaS to call, operations people deploying the core app pieces, performance tuners, testers and more.


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, 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 Multi Lingual 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 sys-admins alike need good deployment tools and workflows for different situations. Automation and infrastructure-as-code can be helpful.


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 

Track Sponsored by
Emerging Technologies at ODTUG Kscope22:

The ODTUG Kscope Emerging Technologies track is getting an overhaul in 2022. These past two years have been challenging with COVID-19 severely impacting businesses and our daily lives. Yet, despite those challenges, technology has continued to evolve, and has even helped us to adapt to this “new normal.” 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. 
AI Engineering: AI/ML technologies are increasingly an integral part of IT solutions. These intelligent features need to be managed like every other software component. AI engineering (DataOps, ModelOps, and DevOps) attempts to address these challenges.
AIOps: AI/ML technologies are not only involved in software applications and data analysis. They are also very relevant in managing today’s complex IT infrastructure. A great example of AIOps is the Oracle Autonomous Database.

Digital Twins: As real-world systems become increasingly complex, many organizations have sought to build digital twins to simulate, plan, and optimize these systems. Abstracts should contain either case studies, or supporting technologies.

Distributed Cloud: While many organizations have embraced cloud technologies during the last decade, issues such as data sovereignty, privacy, sustainability, and network latency continue to be a hot-button issue. In this subcategory, we will discuss these issues and the impact of newer technologies that facilitate edge computing, such as more capable but specialized edge computing devices, 5G mobile networks, and hybrid computing solutions.

General Advancements in Technology: This subcategory includes abstracts that otherwise do not fit in any of the others in this track. These abstracts demonstrate advanced topics such as new AI algorithms, blockchain types, Cloud Native frameworks and architectures.

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.

Internet of Behaviors: The Internet of Behaviors (IoB) combines the use of IoT and Big Data to drive user behaviors. While controversial, it is an important area for discussion as smart technologies continue to exert huge influences in our daily lives.

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.

Total Experience: Today, there are many mediums of interfaces that users use to interact digitally with organizations. This subcategory discusses progress in unifying traditionally siloed disciplines to provide a total experience.

Back to Top

  Enterprise Planning 

Track Sponsored by
Enterprise Planning at ODTUG Kscope22:
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/EPBCS) can be used to support the various business processes that encompass enterprise planning. These include financial planning, long-range planning, revenue/sales planning, workforce planning, capital planning, and project financial planning.  Technologies supported in the Enterprise Planning track include Hyperion Planning and PBCS/EPBCS, which includes the use of the prebuilt frameworks. 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.

Back to Top

  EPM Foundations & Reporting 

Track Sponsored by
EPM Foundations & Reporting at ODTUG Kscope22

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.  Products & technologies encompassed in this track include Cloud Data Management, FDMEE, ODI (cloud & on-premises), Data Maps, Smart Push, EDMCS, DRM, DRG, EPM, EPM Automate, REST API, Groovy, SmartView, and Narrative Reporting, as well as cloud instance management. Third-party applications may also be represented within this track.


Track Sponsored by

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 (19c/21c) Essbase deployments.

Other Essbase:

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

Back to Top

Financial Close 

Track Sponsored by

Financial Close at ODTUG Kscope22:

Financial close is so much more than just HFM. 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.

Technologies in the financial close track include Account Reconciliation (ARM/ARCS);, Financial Management (HFM);, and Financial Close & Consolidation, including Supplemental Data (FCCS), Tax Provisioning (HTP/TRCS), Financial Close Management (FCM), and Narrative Reporting.  

Third-party applications may also be represented in this track when integrated into an overall record-to-report process.

Back to Top

Modern App Development (PaaS)

Modern App Development (PaaS) at ODTUG Kscope22:

Platform-as-a-Service (PaaS) covers all of Oracle’s Cloud based technology tools. Kscope has awesome communities for those technologies that existed pre cloud such as EPM and APEX but we want to explore and encourage some of the born-in-the-cloud technologies now available.
Modern App Development will target front-end and back-end developers who are interested in learning about other development areas we see out there, including but not restricted to:

  • Platform-as-a-Service (PaaS) such as Oracle Digital Assistant and Visual Builder
  • APIs and Integration
  • Traditional Development Modernization
  • Developer sessions around governance and learning are also encouraged


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.

Visual Builder Studio:

In Visual Builder Studio you can create and extend applications using a visual development environment with integrated agile and collaborative development, version control, and continuous delivery automation. Great tool for DevOps.

Digital Assistant:

Oracle Digital Assistant is an AI service that offers prebuilt skills and templates to create conversational experiences for your business applications and customers through text, chat, and voice interfaces. Application owners can easily get started with prebuilt skills to provide chatbot functionality to business users. Developers can build on the library of templates and create their own custom skills to automate the customer experiences.

OCI Integration:

Oracle Integration is a fully managed service that allows you to integrate your applications, gain insight into your business processes, automate processes, and create visual applications.

PaaS Best Practice:

The PaaS platforms offer many choices - which is the best for you? Hear about best practices and real-life use cases to help you make informed decisions.

PaaS Roadmap:

Like anything else, PaaS evolves. Here, you’ll find glimpses of the future and roadmaps to help decide which ways to go forward.

Other App Development:

Development and app modernization topics in the PaaS context that are not mentioned in the above subcategories.

Back to Top


Track Sponsored by

Profitability at ODTUG Kscope22:

Profitability and Cost Management are native to both Financial Close and Enterprise Planning processes. In this track we will explore how profitability and cost management solutions (HPCM and PCMCS) support management reporting, financial close allocations, shared services allocations, and operational profitability. We will also explore general profitability and cost management technical considerations such as optimization, application tips and tricks, automation, troubleshooting, new or lesser-known features and integration with other Oracle EPM product processes.

Management Reporting:

Make better business decisions with managerial level reporting insight through fully allocated P&Ls; product/channel/fund profitability, and activity-based costing.

Financial Close Allocations:

Explore solutions directly impacting financial close cycles such as expense allocations for regulated industries such as health care, utilities, and insurance, as well as operational transfer pricing models.

Shared Services Allocations:

Understand how profitability provides transparency and traceability focus for allocation processes such as standard costing rates, IT financial management, HR allocations, and indirect rates.

Operational Profitability:

Gain insight at the right level of detail to identify the profit winners and profit losers. Common-use cases include channel/segment/market allocations and customer/product profitability.

Back to Top

Strategic EPM 

Track Sponsored by

Strategic EPM at ODTUG Kscope22:

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