Analytics
  | Application Express  | Database | Emerging Technologies  | Enterprise Planning

 EPM Foundations & Reporting  | Essbase  | Financial Close  | Modern App Development 

 Profitability  |  Strategic EPM

Analytics

Analytics at the ODTUG Kscope21 Conference:

In today's data-driven culture, Analytics is big business for companies that take their work seriously. ODTUG Kscope21 is the premier Analytics conference for developers. If you can’t measure it, why bother? Analytics professionals converge at ODTUG Kscope21 to bring you the best presentations, new insights, knowledge, and information.

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 Oracle Integration products, Spark, GoldenGate, and more.

Data Platforms:

Explore the newer phenomenon of elastic cloud data warehouse platforms which 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/Spatial:

The analytical experience can be substantially enhanced by the complementary capabilities provided by machine learning and Spatial. Machine learning can help to process huge quantities of data and offer focused insights, such as the relative importance of certain attributes to an event occurring. Spatial is hugely useful when location or proximity are important and can help to provide an enhanced map-view. These types of technologies have a synergy with analytics and the sessions in this stream cover technical considerations through to the use-cases of these powerful integrated platforms. 

Application Express

APEX at the ODTUG Kscope21 Conference:

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

In addition to the beginner track, we’re going to explore 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 the most overlooked.

Beginner:

New to APEX? Or perhaps you’re a DBA or Java/JavaScript-focused developer and want to learn more about APEX? Then this track is for you! Sessions in the beginner track will target developers who are APEX newbies or those with minimal APEX experience. Sessions are 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 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.

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 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—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 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 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.

Database

Database at the ODTUG Kscope21 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 another, the Database track is the core of the ODTUG Kscope conference, bringing you the best and latest tools, tips, tricks, hacks, and techniques from practical field experience.

Presenters at ODTUG Kscope21 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 DevOps DBA, architect, or whatever task a skillful DBA can be given in the changing IT landscape.

At ODTUG Kscope21, 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 Kscope21 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/Agile:

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 Kscope21 Conference:

ODTUG Kscope’s Emerging Technologies track offers attendees 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 on the cutting edge at ODTUG Kscope21.

Enterprise Planning

Enterprise Planning at the ODTUG Kscope21 Conference:

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.

EPM Foundations & Reporting

EPM Foundations & Reporting at the ODTUG Kscope21 Conference:

Sometimes called the kitchen sink track, EPM Foundations & Reporting has been reenvisioned for ODTUG Kscope21. This track merges the EPM Integration & Automation, EPM Reporting, and EPM Infrastructure tracks from prior years. We developed this new track in recognition of how each of the disciplines covered by these legacy tracks is foundational to an Enterprise EPM solution. In this track you can expect to find 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.

Essbase

Essbase at the ODTUG Kscope21 Conference:

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. This year is different though and we’ve enhanced the vision 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 for 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.1.2.4, 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 investment

Financial Close

Financial Close at the ODTUG Kscope21 Conference:

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.

Modern App Development

Modern App Development at the ODTUG Kscope21 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 and 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?

Governance:

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.

Profitability

Profitability at the ODTUG Kscope21 Conference:

The Profitability track is new to ODTUG Kscope21. We have added this track because we recognize the importance of this activity as well as the cross-domain nature of it. 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.

Strategic EPM

Strategic EPM at the ODTUG Kscope21 Conference:

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.