Is there a topic you would like covered but do not see here? We are happy to take webinar suggestions. Email us at kgately@odtug.com.

Did you miss a webinar? As a full ODTUG member, you can view all of our past webinars at any time. Just log in and you will see the link for the recorded list under the Resources tab. Not a member? Join now for $99!

NASBA_CPERegistry_logo_color_transparent.png  ODTUG is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry  of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.NASBARegistry.org.

How to qualify for CPE Credits:

  • Register for the webinar, indicate that you are a Full (paid) ODTUG member, and check the box on your registration form to indicate you'll be earning credits.
  • Attend the session and fill out an evaluation form; make sure to include your name. The evaluation form will be sent to you once the webinar is completed.
  • You must respond to all poll questions that will show up on the screen at random during the presentation.
  • After the webinar, you will receive a certificate via email for the session you attended.
  • Submit the certificate to your State Board of Accountancy.

Webinars are free to all. No cancellation is required. If you do not attend, your registration will automatically be cancelled.

Webinars that are eligible for CPE credit will be noted as such in their description.
Our webinar calendar is constantly evolving! Check back frequently, as more webinars will be added to the schedule.

Suggest a Topic   Past ODTUG Webinar


communities_0003_Layer-3.png Wednesday, September 18, 2019 12:00 PM - 1:00 PM EDT
  From Our ODTUG Kscope19 Partners at Alithya - Keys to the Kingdom: Key Concepts to Account Reconciliation Cloud Application Design
 ACEAss-01.pngNick Boronski, 

With Account Reconciliation  now included in both the Standard and Enterprise baskets of EPM cloud goodies, the temptation is to tear the packaging and start building. However, even Close & Consolidation experts can have trouble bridging the knowledge gap between more familiar applications (e.g., HFM, Financial Consolidation and Close, etc.) and Oracle’s “one-stop shop” reconciliation tool. Incorrect assumptions made early on in the application design can be troublesome later as the project rolls on. Instead, provide your company with a strong foundation by having a firm grasp on functionality, best practice recommendations, and setups for scalability.

In this webinar, we will discuss how to elicit actionable requirements, review overlooked out-of-the-box functionality, and account for key design concepts in order to establish a strategic enterprise solution for both today and “tomorrow”—giving you the keys to the kingdom!

Register Here

Analytics square with padding-01.png Thursday, September 19, 2019 12:00 PM - 1:00 PM EDT
 Oracle Analytics Cloud (OAC) or Oracle BIEE? – Replacement for Discoverer
Andrew Preston, 

CPE Web Icon.png  This webinar is eligible for one (1) CPE credit. To receive the credit attendees must be a Full (paid) ODTUG member, attend the entire webinar and answer all poll questions that will pop up on-screen during the webinar, and fill out the evaluation form (with your name) that will be on-screen immediately after the webinar.

With the Oracle Discoverer 11g end of life statement of direction from Oracle, we are faced to look at alternatives. With Oracle Analytics Cloud (OAC) Service from Oracle, it is important to understand whether OAC is the replacement for Discoverer, or is it Oracle BIEE? This presentation unfolds OAC and Oracle BIEE’s fit to migrate off Discoverer, explores challenges, and includes a discussion on solutions to consider. Other options for Discoverer within the Oracle family of products are also discussed as well as how well they integrate with each other. Attendees will learn:

Objective 1: Learn about Oracle Discoverer replacements in OAC and Oracle BIEE.

Objective 2: Understand challenges and what to prepare for when taking on a Discoverer roll-off project.

Objective 3: Learn about a possible roadmap as a baseline for a successful migration.

Instructional Delivery System:
Group Internet Based

Program Level:

Field of Study:
Computer Software and Applications

Prerequisites and Advance Preparation Required:

Cost: Free

Register Here

communities_0003_Layer-3.png Tuesday, September 24, 2019 12:00 PM - 1:00 PM EDT
  Impact on Data Extraction Strategy with New Releases in HFM and FCCS
Megha Chopra
 and Mohit Jain, Genpact

CPE Web Icon.png This webinar is eligible for one (1) CPE credit. To receive the credit attendees must be a Full (paid) ODTUG member, attend the entire webinar and   answer all poll   questions that will pop up on-screen during the webinar, and fill out the evaluation form (with your name) that will be on-screen   immediately after the webinar.

What will be the impact on data extraction strategy once Extended Analytic (EA) is discontinued from HFM in the next release and in the FCCS 19.06 release? The new feature in Data Management is “Data Export to File.”

In this webinar, we will talk about data extraction strategy from HFM/FCCS using FDMEE/ Data Management, as HFM is the book of record and this data is to be loaded in different outbound systems.

Learning Objectives:

  • How “Custom Application” can be used to extract data from HFM/FCCS
  • What is "Data Export to File" option from FCCS 19.06
  • Migration of existing "custom target" application approach to "Data Export to File" option in FCCS

Join us to explore the journey of data from consolidation tool to external systems!

Register Here

communities_0003_Layer-3.png Thursday, September 26, 2019 12:00 PM - 1:00 PM EDT
  Critical Pre-Flight Checks for Business Systems
Chuck Czajkowski, 

The environment which houses your business critical EPM applications is complex. Maybe as complex as the cockpit of an aircraft. Just as a pilot might not be able to build or fix everything on their plane, you might be using applications but not know how to build or fix everything that’s being used. This shouldn’t stop you from doing a pre-flight check to ensure that all your Hyperion systems are running properly and set for you and your end users. Let’s talk about some different strategies to achieve this and give you the confidence in your systems so that you can know when things are running well—or more importantly, when they need attention before takeoff.

Register Here

communities_0006_Layer-6.png Thursday, September 26, 2019 3:00 PM - 4:00 PM EDT
  Powerful: Practical Machine Learning In The Hands Of The DBA

 ACE Director.jpg Craig Shallahamer, 

Powerful Machine Learning (ML) is upon us. As Oracle DBAs, it is now our turn to leverage ML, enabling us to do things never before possible. But it's not that simple. There is a lot to learn. Everything from methodology to math to tools. And then the nagging question of, as a DBA, is there a real application in my work?

The good news is, classic ML applications match our analysis use cases, and we have access to a ton of performance data; powerful number-crunching machines sit on our desktops and ML software is 100% free. It's the perfect setup!

So, in this presentation I'm going to introduce you to the world of ML from a DBA perspective. This includes understanding what ML is, why you should use it, and why now. I will lead you through two use cases, each using a different ML algorithm. The first at a high level and the second at a detailed level.

Our future is not AWR or even ASH analysis! Now is the time for Oracle DBAs to step into the world of ML because it is powerful, practical, and enables us to do things we have never been able to do before.

Analytics square with padding-01.png Thursday, October 10, 2019 12:00 PM - 1:00 PM EDT
 Oracle Spatial Studio: Fast and Easy Spatial Analytics and Maps
Carol Palmer
and David Lapp, Oracle Corporation

In this session, we'll share a new tool, Spatial Studio, which lets you quickly and easily do spatial analytics and create maps, even if you don't have GIS or spatial knowledge. Now business users and non-GIS developers have a simple user interface to access the spatial features in Oracle Database.

We’ll show you through step-by-step demos how to prepare your data for spatial analysis, perform spatial analysis operations, publish, and share the results. You will also learn how to access spatial analyses results via REST and incorporate them in applications and workflows.

Carol Palmer, senior principal product manager, and David Lapp, senior principal product manager, will present. This will be an interactive session where you can share questions and comments with the presenters.

Register Here

Emerging square-01.png Tuesday, October 15, 2019 12:00 PM - 1:00 PM EDT
 The Bots Are Coming! How Emerging Technology Is Changing Our Businessesand Our Lives
Andrew Jorgensen, 
MindStream Analytics

In just five years, Uber upended both the taxi and rental car business. Could your business be next? We’ll take a look at how automation, AI, machine learning and decisioning engines, and blockchain are poised to disrupt a host of industries and the everyday technologies we use. We’ll explore how your business can adopt these changesand create a competitive advantage for yourself.

Register Here

communities_0006_Layer-6.png Thursday, October 17, 2019 12:00 PM - 1:00 PM EDT
  SQL Tuning: Undocumented Secrets for Getting Accurate Cardinalities
  Kaley Crum,
ABC Financial

One of the most common SQL Tuning problems is when the Oracle cost-based optimizer mis-estimates the expected number of rows that will be returned from an execution plan row source operation. This presentation delves into uncharted waters to help attendees understand strategies for dealing with cardinality mis-estimates.

Register Here

communities_0003_Layer-3.png Tuesday, October 22, 2019 12:00 PM - 1:00 PM EDT
  What Happens When the Data Scientist and the Financial Analyst Meet for Lunch?
Jim Webb, 
CSS International, Inc.

Enterprise Performance Management has long been ubiquitous with financial analysis and reporting throughout every successful organization worldwide. This fact leads us to ask, "What's next for EPM?" In this presentation, we will talk about how operational analytics combines with existing Oracle EPM planning applications to bring an integrated view of performance to your organization. We will also talk about Oracle's vision for "Integrated Performance Management" and how you can best prepare yourself to create more confidence in your predictions.

communities_0006_Layer-6.png Thursday, October 24, 2019 12:00 PM - 1:00 PM EDT
  SQL Through the Ages
  Chris Saxon,
Oracle Corporation

In the past fifty years data storage has transformed from punched cards that could barely hold 80 characters to cloud-based servers that count storage units in terabytes. This session will chart the history of data storage, from the birth of the relational model in the '70s to the rise of NoSQL solutions in the 2000s and the subsequent return to SQL in the 2010s. Throughout this time, relational databases have continued to evolve. A key enhancement is adding support for NoSQL style JSON storage. This session will finish with a demo of "SQL magic," showing how you can combine the best of flexible JSON storage with SQL's query capabilities, giving guidelines to help developers work effectively with data in the modern era.

communities_0001_Layer-1.png Tuesday, October 29, 2019 12:00 PM - 1:00 PM EDT
  Universal Theme - Basic Principles to Modern Applications
Lino Schildenfeld and David Anderson, 

How difficult can it be to create a modern and responsive app using Oracle APEX 18.x/19.x?

In this demo session, we will build a public-facing app following a few basic principles to demonstrate the power of UT.

Simple but powerful CSS techniques can be daunting for back-end developers so this session is structured for audiences of all levels, encouraging you to explore and take on any CSS challenges ahead.

We will explore some of the underutilized secrets of Universal Theme and learn about its gem CSS classes which can simplify your design asks.

Register Here

communities_0001_Layer-1.png Tuesday, November 19, 2019 12:00 PM - 1:00 PM EDT
  The Genius of Classic Reports
Tyson Jouglet and David Anderson, 

Did you mean to say Interactive Reports?
   ● No!
   ● Reports do not need to look like reports
When to use Classic reports
   ● Very simple or very complex reports
   ● To create a custom-tailored experience
Data Binding Magic
   ● Column vs. row templates
   ● How to use templates successfully
Some Gotchas with Row Templates
   ● Sorting changes
   ● Getting clever with HTML expressions