| Application Express  | Database | Emerging Technologies  | EPM Infrastructure

 EPM Integration and Automation | EPM Reporting  | Essbase  | Financial Close  | Modern App Development 

 Planning  | Real World EPM


Oracle Analytics:

Dive into all things Oracle Analytics and learn about the 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 Spark, ODI, GoldenGate, and more.

Data Platforms:

Explore the newer phenomenon of elastic cloud data warehouse platforms that scale with ease and require minimal administration to gain high performance across analytic query profiles. Compare and contrast these offerings from Oracle and other vendors with more traditional and open-source platforms to determine the best fit for your organization. See how to integrate a Cloud Data Warehouse platform into the rest of your analytics ecosystem. Platforms include Kafka, Hadoop, Object Storage, and more.

AI/Machine Learning:

Learn about the latest and greatest technologies making their mark on the world. The common themes across all of these new technologies? Humans are interacting with and relying on artificial intelligence now more than ever through machine learning, deep learning, chatbots, personal assistants, and more. Devices connected to the internet are creating new user experiences and new data sets to analyze in the world of IoT. 

Application Express

Track Sponsored by


APEX at the ODTUG Kscope20 Conference:

ODTUG Kscope20 will continue to lead the pack by providing the best educational experience for Oracle APEX developers. This year, we’re going to make sure that there is content available for all skill levels—from the beginner to the advanced APEX developer.  

In addition to the beginner track, we’re going to also include the more challenging issues that APEX developers face—such as integration, extensions, and lifecycle management & 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 overlooked.


New to APEX? Or perhaps you’re a DBA or Java/JavaScript-focused developer and want want to learn more about it?  Then this track is for you. Sessions in the beginner track should target developers who are APEX newbies or those with minimal APEX experience. Sessions will be focused mostly on the core components of APEX and blend lecture and demonstration, since seeing really is believing—especially with APEX.

APEX Core Components:

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

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 (e.g., REST), other platforms (e.g., AWS, Azure), or even other languages and tools (e.g., Java, SQLcl, JavaScript). This track will highlight 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—with APEX or any other technology. With more and more emphasis being put on things like CI/CD & DevOps in general, can APEX play in that world? Of course it can. This track should highlight anything that has to do with the overall management of applications over their lifetimes—from configuration management to version control and DevOps. This track will also incorporate sessions focused on security, since security starts on day one and never ends.

Other Application Express:

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


Database at the ODTUG Kscope20 Conference:

The Oracle Database RDBMS is the backbone for the vast majority of applications, solutions, and products for working with data, including the Oracle product suite itself. For everyone working with Oracle Database in one role or the other, the database track is the core of the ODTUG Kscope conference, bringing you the best and latest of tools, tips, tricks, hacks, and techniques from practical field experience.

Presenters at ODTUG Kscope20 will include the world’s best Oracle ACE Directors, ACEs, ACE Associates, Groundbreaker Ambassadors, Product Managers, and generally experienced people, all who have knowledge to relate and demonstrate within their fields, whether it be database administration, development, design, DevOps, or anything related to the Oracle RDBMS.

The track covers a number of sub-categories:

For the Modern DBA:

The role of a database administrator has always been a changing role, as database versions over time have taken over a lot of the mundane and boring tasks—the Autonomous Database more so than ever. The DBA needs not only the traditional skills, but must also add a variety of new skills for the new roles of DevOpsDBA, architect, or whatever task a skillful DBA can be given in the changing IT landscape.

At ODTUG Kscope20, we’ll tackle all the latest features and techniques in the newest versions of both database, Oracle Enterprise Manager, and Oracle Cloud interfaces relevant for the modern DBA. Topics can cover backup and recovery, security, hardware, software administration, identity management, high availability, performance tuning, upgrades, consolidation, storage, cloud, virtualization, scripting, multitenant, in-memory, database as a service, auditing, mixing on-premises and cloud, etc.

Database Development:

Development in, with, and around an evolving RDBMS such as the Oracle Database covers more and more varied ground as each version brings new capabilities inside the database. We’ve seen the database adapt new technologies, enabling the most modern development using built-in features. Applications access the database not just with SQL, but also REST and other APIs. Whether in the cloud or on-premises, a modern database developer needs knowledge of a broad variety of topics and concepts to create the performant applications the users of today desire.

ODTUG Kscope20 database development, among other topics, covers essential database development concepts and techniques, including application architecture and design, SQL, PL/SQL, REST API strategies, testing, debugging, logging, ETL, new features through the versions, version control, application performance, open source APIs, cloud-based development, programming languages, and frameworks to interface with database environments.

Database Design:

A good application using data starts with a good data model, leading to a good database design. To build a robust model based on business requirements, a developer must know how different model choices can impact how well the model can or cannot be expanded to match future requirements. DBAs as well as developers need knowledge on how different design strategies influence performance and scalability of the application.

Both theory and practice are covered on a range of topics in the field of data modelling and database design.

Database Tools:

Whether administering, developing or designing databases, tools of all sorts are necessary to make life easier and more productive, both for the daily business and the once-in-a-while tasks of deploying, migrating, upgrading, and so on.

We’ll cover all the latest and best database tools used for interfacing with database environments, showing new features, usage methods and tips for improving productivity. Both Oracle products as well as third-party tools are on the list of tools we cover, including SQL Developer, SQL Developer Data Modeler, SQLcl, DBArtisan, OraOpenSource (OOS), Oracle ORDS, TOAD, and more.


DevOps is a philosophy or approach that enforces the collaboration and communication between software developers and IT operations by automating the process of software delivery and infrastructure changes. DevOps influences the life of both DBA and developer in a world that demands agility.

Learn about topics such as operational strategy and development, review code merging, integration, testing, change management release approvals, infrastructure as code, application performance monitoring, and releasing automation configuration.

Other Database: 

As a core track, the Oracle Database RDBMS covers a very broad variety of topics. Any topic that is not covered by the five sub-categories above is covered in the Other Database category.

Emerging Technologies

Emerging Technologies at the ODTUG Kscope20 Conference:

ODTUG Kscope’s Emerging Technologies track offers the attendee the opportunity to learn about some of the latest and greatest technologies making their mark on the current landscape. The common themes across all of these new technologies? Humans are interacting with and relying on artificial intelligence now more than ever through machine learning, deep learning, personal assistants, and more. Devices connected to the internet are creating new user experiences and new data sets to analyze in the world of IoT. It’s a great time to be a technologist, and ODTUG will keep you educated on the cutting edge at ODTUG Kscope20.

EPM Infrastructure

Track Sponsored by

EPM Infrastructure at the ODTUG Kscope20 Conference:

Maintaining a strong Enterprise Performance Management (EPM) infrastructure will ensure that EPM programs and applications remain operationally functional, secure, and can handle the growing needs of any business to ensure that all moving parts are running smoothly. At ODTUG Kscope20, you’ll learn what you need to ensure the health of your EPM infrastructure.

Cloud, Hybrid, or Hosted Infrastructure:

Our experts will discuss managing cloud products and the challenges of combined cloud/on-premises system architectures. We’ll review all the planning considerations such as native cloud vs. hybrid, security implications, how to approach and mitigate risk, considerations for how to approach backup and DR, and integration considerations with on-premises systems and other cloud systems. Topics will include Oracle SaaS, IaaS, and PaaS offerings and their impact on Hyperion.

Installs and Upgrades:

Learn how to plan for a successful installation, including architecture-leading practices, high availability, and managing disaster recovery. We will also cover Hyperion patching and automation best practices, as well as the latest methodologies in planning and executing upgrades.

Maintenance, Optimization, Security, and Troubleshooting:

Post-implementation is a crucial time, and it requires a strategy dedicated to providing operational support. Learn how to plan and implement scalable and sustainable support models, whether done in-house, outsourced, or through a COE. We’ll teach you how to provide maintenance and support, administer health checks, monitor, problem solve, optimize, and troubleshoot the entire EPM infrastructure to ensure maximum performance and stability. In addition, many organizations and industries have strict security guidelines, especially at the enterprise level. You’ll learn everything about managing security for the EPM suite from the best. This includes external provider integration and tuning, single sign-on, Kerberos and Smart Card integration, SSL, access controls monitoring, auditing, and reporting.

Other EPM Infrastructure:

Sessions in this subtopic will cover any great EPM infrastructure topics and technologies not covered by the other subtopics.

EPM Integration and Automation

Track Sponsored by

EPM Integration and Automation at the ODTUG Kscope20 Conference:

Data and master data are the foundational elements of all business applications, and EPM is no exception. Well designed EPM data and metadata integration can help save time and development costs while reducing process execution times. You’ll learn how to design integrations that perform well, address common business needs, and most importantly, ensure data integrity. We also explore how automation across the EPM suite (not just integration) can be accomplished using a variety of technologies.

Master Data Integration:

We’ll show you best practices for designing, building, and maintaining a metadata management and governance process that supports cloud and on-premises EPM products. We primarily focus on Enterprise Data Management (EDMCS), DRM, and DRG, but explore and other master data management tools that can complement an Oracle EPM deployment.

Data Integration:

Data integration is a core activity for any EPM deployment—cloud or on-premises. We explore the challenges and solutions available to enable better data integration.  Oracle tools that we explore are Cloud Data Management, Data Maps, Smart Push, FDMEE, and ODI (on-premises and cloud). Like master data integration, we also will explore other applications and technology that can enrich the data integration process for your EPM deployment.

Process Automation:

Process automation enriches an overall solution. It improves efficiency and frees up the administrators and system users to do more with the applications rather than performing repetitive, non-value add tasks. We explore a number of technologies—EPM Automate, REST API, and Groovy to name just a few—that enrich your EPM deployment and return valuable time to you.

EPM Reporting

Track Sponsored by

Oracle EPM Reporting at the ODTUG Kscope20 Conference:

In today’s data-driven culture, reporting, BI analytics, and visualizations are huge drivers of big business decisions. ODTUG Kscope20 is the premier conference for reporting, BI analytics, and visualization developers. The ODTUG Kscope20 conference brings together the best and brightest experts to help you package and visualize mission-critical information.

Smart View:

Look under the hood and learn all about the pivotal ad hoc reporting tool, Smart View, which uses Microsoft Office to access data and produce ad hoc reports. Sharpen your skill set and gain the most comprehensive view of your business under one single technology. Integrate and leverage data directly from Planning, Financial Close, Essbase applications, and more using Oracle’s common add-in for Microsoft Word, Excel, PowerPoint, or Outlook.

Financial Reporting:

You’ll learn about the latest in Hyperion Financial Reporting and Enterprise Performance Reporting Cloud (EPRCS) to produce period-end financial and regulatory reports. Industry experts will show you all the latest features of these tools. You will learn how to build, use, narrate, and deploy efficiently; distribute with ease; and improve security, memory, and query performance.

Other EPM Reporting:

Sessions in this subtopic will cover any awesome EPM reporting topics and technologies not covered by the other subtopics.


Track Sponsored by

The ODTUG Kscope20 Conference Is the Place for Oracle Essbase!

ODTUG Kscope20 brings together the most intelligent Essbase designers, developers, and administrator experts for both on-premises and in the cloud! Our experts will show you design patterns for hybrid and ASO models, demonstrate how to manage backup processes, and cover security and automation. New to Essbase in the cloud? You’ll be able to learn the ins and outs of the Essbase Cloud Service (EssCS), along with all the tools needed to build better structures for data collection as an administrator, designer, and optimizer. Want to take a deep dive into Oracle Corporation’s engineered hardware system for BI, Analytics, and Exalytics? We’ve got you covered.


We’ll teach you how to properly administer, manage, and maintain Essbase from backups and security to automation.

API and Related Tools:

APIs have transformed how we connect to data. You’ll get a bird’s-eye view on how to use the Java API/Groovy and how to use associated tools such as non-Oracle and free community utilities.


In these sessions, calculation scripts, MDX, and CDFs are the names, and best practices are the games.

Design and Optimization:

You’ll learn all you need to know about cube design, hybrid, and ASO. Design, optimize, and tune your work for maximum performance.

Essbase Cloud:

Learn all about the new Essbase Cloud Service (EssCS) within Oracle Analytics Cloud (OAC/OAAC): what it is and the real-world applications of this new technology.

Other Essbase:

Sessions in this subtopic will cover any cool Essbase topics and technologies (like Exalytics) that are not covered by the other subtopics.

Financial Close

Track Sponsored by

Financial Close at the ODTUG Kscope20 Conference:

The Financial Close presentations at the ODTUG Kscope20 conference will be the best way to learn the ins and outs of cloud and on-premises Financial Close solutions. These sessions will give you what you need to make your Financial Close solutions the best they can be.

Financial Consolidation and Close Cloud:

Learn from the best when it comes to Financial Close in the cloud. You’ll hear implementation experiences, practical feature highlights, and tips and tricks related to Financial Consolidation and Close. A centerpiece in Oracle’s cloud EPM suite, the solution has an ever-growing set of built-in features for you to learn about.


From the provision process to workpapers to reporting, there is much to learn about Oracle’s Tax solutions, whether in the cloud or on-premises. You’ll hear from experts who have implemented Oracle’s Tax solutions and learn the current leading practices.

Hyperion Financial Management:

Hyperion Financial Management (HFM) is a worldwide classic when it comes to financial consolidation and reporting systems. We’ll share implementation stories, application design ideas, rule tips and tricks, application tuning, and we’ll feature highlights and strategies for getting the most out of HFM.

Account Reconciliation:

No Financial close cycle is complete without a robust account reconciliation system.  These sessions are for those who are looking to move from an Excel-centric process and want to learn the basics of Account Reconciliation, and for folks who have already implemented these systems and are looking to leverage more functionality.

Task and Close Management:

Still tracking your financial close tasks in Excel, on a whiteboard, or in your head? Come and learn what experts can share on the best practices for implementing Task and Close Management to manage the monthly, quarterly, or annual process.

Supplemental Data:

Are you using a sophisticated financial consolidation system but still collecting supplemental information in Excel? Oracle’s Supplemental Data solution offers the ability to gather and manage additional detail that falls outside of traditional reporting applications, whether for financial reporting or tax purposes.

Narrative and External Reporting:

If you are looking to fully automate and manage the reporting process for SEC filings, board packages, and internal reports, then Oracle’s Narrative Reporting solution is for you. Learn how others have seamlessly integrated financial information with the accompanying narrative while keeping strict controls on information access and version control within the familiar Microsoft Office environment.

Other Financial Close:

Sessions in this subtopic will cover any nifty financial close topics and technologies not covered by the other subtopics. ODTUG Kscope20 presentations here may cover Oracle products that connect the financial close components together such as Shared Services and Smart View. This subtopic will also cover starter kits and customer experiences with non-Oracle products used to extend the Financial Close functionality and aid in managing applications.

Modern App Development

Modern App Development at the ODTUG Kscope20 Conference:

In the DevOps World of Application Development we see more and more tools being used with Oracle. While ODTUG has a vibrant and successful APEX community developing modern applications, there are other tools and platforms we want to encourage at ODTUG Kscope. This Modern Apps Development Track will be in addition to the APEX track and will target front-end and back-end developers who are interested in learning about, but not restricted to:

  • PaaS such as Oracle Digital Assistant, Visual Builder Cloud Service:
  • APIs
  • Open Source
  • Traditional Development Modernization
  • Java, JavaScript, Python, JET, etc.
  • Developer sessions around governance and learning are also encouraged

Oracle PaaS:

Development tools as part of the cloud platform tools, such as Oracle Digital Assistant the modern chatbot, VBCS and JDev, and mobile.

Traditional Apps Development Modernization:

How do we update existing apps? What can be done and what tools are available?


APIs, interfaces, approach to the building of modern apps—here we will include tips, trips, and approaches to this emerging area.

Modern Apps Tools:

In our heterogeneous world we use many tools in our Oracle World, Java, JavaScript, Python, JET, and Open Source Examples of how these are being used and the skills required.


Track Sponsored by

Oracle Planning at the ODTUG Kscope20 Conference:

Making a plan, working on a budget, or forecasting a target? Attending Planning presentations at the ODTUG Kscope20 conference is the best bet to soak up knowledge from experts in Oracle Hyperion Planning who have real-world experience with the tool. Whether it’s Oracle Cloud or on-premises, you’ll learn from the gurus about the budgeting and forecasting essentials necessary to achieve organizational success.


ODTUG Kscope19 presenters will cover management and security administration of on-premises and/or cloud Planning solutions to set access permissions, create users and groups within applications, and prevent unauthorized users from viewing or changing data.


Dive into leading practice design with Planning applications including Hybrid, ASO, and BSO technologies; calculation methodologies; and expert guidance for satisfying specific business requirements.


Optimization is often what can set your application apart from the pack. You’ll hear tips and tricks in performance tuning and how to design for performance using on-premises and/or cloud Planning products.

Planning Cloud:

We’ll walk you through planning and budgeting with the flexibility of the cloud across the enterprise and all the newest features, tips, tricks, and best practices with Planning and Budgeting Cloud (PBCS), Enterprise Planning and Budgeting Cloud (EPBCS), and Profitability and Cost Management Cloud (PCMCS).

Planning Modules and Frameworks:

Are you in the buy vs. build decision-making process? Maybe you want to take advantage of pre-built models. We can show you the ins and outs of specific on-premises modules: Workforce, Capex, Project Planning, and Public Sector Planning and Budgeting. The EPBCS Cloud frameworks (Financials, Strategic Modeling, Workforce, Strategic Workforce, Capital, and Project Planning) will also be covered here.

Other Planning:

Sessions in this subtopic will cover any interesting Planning topics and technologies not covered by the other subtopics, like Hyperion Profitability and Cost Management (HPCM) and Hyperion Strategic Finance (HSF).

Real World EPM

Track Sponsored by

Real World EPM at the ODTUG Kscope20 Conference:

EPM is an integrated suite of products and tools. How does it work in the real world? This track is looking for content on how EPM as a whole is actually practiced.

EPM Industry Topics:

Get your hot industry topics here! Always a balancing act, this subtopic covers the relationship between finance and IT. Learn how others are making it work, along with other key industry topics that even the best EPM professionals tackle daily.

EPM Processes and Management:

Looking for tips on how to fine tune business processes related to EPM or managing the staffing and training for your EPM team and environment? How has project management evolved with cloud application? Look no further! We have you covered with a variety of topics on leading practice processes and management.

Multi-Product Implementations:

We want to hear about EPM implementation projects that span multiple products (e.g., Essbase, Planning, EPM Reporting, and Financial Close) where no one of these products represents a dominant part of the story.

Other Real World EPM:

This subcategory is for you to share product features that are not product specific such as Task Manager, Approvals or Navigation Flows, and other topics that may be relevant to the broader EPM community.