ODTUG Oracle OpenWorld 2018 Sessions                                  APEX.pngBI.pngDatabase.pngEPM.pngEmerging-01.png


What Every DBA Needs to Know About Oracle Application Express (APEX)
ACE Director
Francis Mignault, Insum Solutions

Once an enterprise starts using Oracle APEX, many applications are rapidly created to help manage the business. DBAs start asking questions about managing APEX and installing it in Oracle databases: How can I properly backup and recover our APEX applications? How do I integrate an APEX installation with EBS? What are the different components required and supported for the middle tier? Those questions and much more will be answered in this session.

Back to Top

Business Intelligence

BI Developer to Data Engineer with Oracle Analytics Cloud Data Lake Edition
ACE Director
Mark Rittman, MJR Analytics

In this session we'll look at the role of a data engineer in designing, provisioning, and enabling an Oracle Cloud data lake using Oracle Analytics Cloud Data Lake Edition; using data flow and data pipeline authoring tools and applying machine learning and AI to this task; connecting to database and SaaS sources along with sources of external data via Oracle Data-as-a-Service; and how traditional Oracle Analytics developers can transition their skills into this role and start working as a data engineer on Oracle Public Cloud data lake projects.

Active Directory Integration and Single Sign On for OAC - A Walkthrough
Becky Wagner, US-Analytics Solutions Group

Setting up Active Directory Integration and Single Sign On for OAC are not small tasks. Learn about our journey, lessons learned, and tips from setting up AD and SSO for our client. We will dig into the fine details and explain what worked, pitfalls to avoid, and ongoing maintenance suggestions. The learning objective for attendees of this session will be to take away lessons learned from a real-life implementation of OAC using IDCS, Active Directory bridge, and Active Directory Federation Services for Single Sign On.

Drinking Our Own Champagne: Oracle Analytics Cloud at ODTUG
Oracle ACE
Tim German, Qubix

ODTUG is an independent, not-for-profit, global user group and the host of ODTUG Kscope, one of the world's largest annual Oracle user conferences. In 2017 we decided to implement an Oracle Analytics Cloud (OAC) system to provide our conference team with advanced analytics. In this session you will learn about:

- How ODTUG has used OAC to support our conference planning activities such as providing analytics on session attendance/ratings, and content review team alignment with attendee objectives.
- Our ongoing effort to expand the reach of our analyses to cover areas such as footfall, marketing, and membership and attendee demographics.
- Our practical experience configuring, maintaining, and developing on the OAC platform.

Back to Top


3D - Docker for Database Developers
ACE DirectorRoel Hartman, APEX Consulting

This session will briefly cover the Docker basics, but then we will dive in to the more intermediate use of Docker. This session is aimed at database developers that would like to set up a development and/or test environment using a microservices architecture, consisting of multiple containers. For example, one for the Oracle database, one - or more - to support the Oracle Rest Data Services (ORDS) and one - or more - other containers that will execute specific NodeJS applications.

Setting this up in the Oracle Container Cloud Service will also be discussed.

How a Mobile Payment Company Profits from the Autonomous Data Warehouse Cloud
Oracle ACEHolger Friedrich, sumIT AG and Simon Uhde, TWINT AG

Oracle's Autonomous Data Warehouse Cloud (ADWC) enables many industries to run elastic Data Warehousing installations with little to no organizational overhead. TWINT is the leading national Swiss mobile payment provider. In a highly competitive market, the company has to adapt to the growing business and amounts of data. ADWC is a mean to stay ahead of the curve regarding data management and data warehousing for TWINT.

It's All About the Bots: How Chatbots Will Revive Your DeskTop Applications
ACE DirectorMia Urman, AuraPlayer

The world of mobility is moving faster than we can imagine it. Millennials today don't talk, they chat; they don't have addresses, they have locations; they don't have email, they message. In this session, you will hear about Oracle's Intelligent Bot Service and how it can help transform your desktop applications from an outdated liability to a transformative part of your business. We will learn how to develop our very first BOT and what are the pieces we need to make our conversational applications work. Learn how intents, flows, entities, and conversational applications come together to bring desktop applications into the next generation. We will also show a live demo and  customer case study.

Back to Top


How to Apply Blockchain, AI, IoT with Oracle Cloud - User Conversation
Hans Kolbe, Celantra Systems 

The Emerging Technologies special interest group brings together users and technology experts to assess and discuss emerging technologies, such as distributed ledger, i.e. Blockchain, artificial intelligence (AI), and internet of things (IoT). We will showcase the latest Oracle Blockchain, IoT, and AI offerings. Oracle Cloud opens up a new universe for integrations with the latest market-driven data and technologies. Questions we are asking are: What are the technologies? How do they apply? What are the use cases? How do I use the Oracle Cloud to get the top benefits? 

Back to Top


Enterprise Data Management Cloud Service (EDMCS): The Master Data Solution
ACE DirectorTracy McMullen, interRel Consulting

It’s inevitable that your business strategy, models, growth, people, financials, etc. are consistently changing.  It’s hard to stay on top of these changes and realign your business as it happens. Enterprise Data Management Cloud Service has arrived (a new tool modeled after its on-premises version, Data Relationship Management) to help standardize dimensions, hierarchies, attributes, and mapping maintenance across the enterprise.  Adventist Health is one of the first adopters of this tool.  Come hear their story and why they chose Enterprise Data Management Cloud Service for data governance, collaboration, and master data management across their applications.

EPM Cloud in Real Life: Four Real-World Cloud Migration Case Studies
Bobby Ellis, Datavail

Everyone is talking about cloud right now and, for financial professionals, Oracle EPM Cloud is on the list of considerations. But there are lots of questions about EPM Cloud as well: How does it perform? Is it as robust as Hyperion on-premises? How easy is it to implement? Can all of a company’s data be moved over? In this presentation, we’ll answer these questions and more by presenting four different successful real-world EPM Cloud migration and implementation case studies for EPBCS, FCCS, and ARCS. Attendees will get a birds-eye view into the practicalities of moving to cloud, and the tools they need to make the business case for their own company.

Vitamix - A Blend of Many EPM Cloud Applications and More to Come!
Mike Portale, Vitamix , Vatsal Gaonkar and Wayne Paffhausen, Edgewater Ranzal

Vitamix Corporation implemented Oracle ARCS in late 2017 and Oracle FCCS application in early 2018. Later in 2018, the FP&A team embarked on an Oracle EPBCS implementation. In the EPBCS implementation, Vitamix uses out of the box content in order to plan Margin by Product Categories. Oracle EBS loads a set of drivers that can be used for Trend based modeling across Budget, Forecast and Rolling Forecast scenarios. The loading of these drivers is made possible via a seamless integration built in Cloud Data Management (CDM). CDM is also used to sync Actuals data from FCCS to EPBCS and to sync Budget data from EPBCS to FCCS.  The case study will focus on the EPBCS implementation and the seamless data integrations between the cloud applications.

PBCS Revenue Forecasting with On-Prem FDMEE at Weight Watchers
Cindy Eichner, Finit Solutions

Learn how Weight Watchers implemented PBCS to forecast revenue by membership cohorts and libraries of retention schemes and promotion schemes. With an atypical planning and forecasting application, Weight Watchers chose to move their Excel forecasting models to PBCS while data integration was accomplished using on-prem FDMEE. Leave this session knowing about a different type of solution that can be built with PBCS.


Happily, Ever After: ODTUG and Oracle EPBCS
Oracle ACEGary Crisci, General Electric

ODTUG has gone live with EPBCS to manage its reporting and budgeting needs. We have wanted to utilize Oracle’s solutions, but the investment in computing assets made it unfeasible. Oracle’s Cloud provides a way for smaller organizations to adopt enterprise-class software without incurring the overhead typically associated with these advanced applications.

In this session, ODTUG Director and Oracle ACE Gary Crisci will demo the ease of deploying an EPBCS app for ODTUG. Gary will go through the process of creating an app, importing metadata and financial data from ODTUG’s GL, and building feature-rich dashboards and reports. He will also demo some of the novel features in EPBCS such as managing metadata via the Smart View Excel add-in.


Then and Now: Two Years in to First-Ever FCCS Implementation
Kevin Hebbel, SC&H Consulting and  Michael Zink, Brookfield Property Group

Thayer Lodging, the first organization to go live with FCCS and implement an ERP Cloud and EPM Cloud solution together, made the full-scale shift to the cloud to revamp their end-to-end financial close and reporting process from subsidiary ledgers and data collection all the way through financial reporting.

The rapidly growing global hospitality and investment company’s financial overhaul knocked 50% off of its average time to close; achieved complete visibility into the entire close process including consolidation, data collection and reporting processes; and enabled the accounting and finance teams to have complete control over the entire financial close process without any reliance or burden on the company's IT department.

Back to Top

 *All sessions subject to change