Introduction to Hyperledger
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Oceanic 7, Lobby/Third Level
Topic:
Breakout with Blockchain - Subtopic:
Hyperledger is an open source collaborative effort created to advance cross-industry blockchain technologies. It is a global collaboration hosted by the Linux Foundation, and it includes leaders in finance, banking, the Internet of Things, supply chains, manufacturing, and technology. This session will examine various distributed ledger projects with a focus on Hyperledger Fabric.
Introduction to Hyperledger
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Oceanic 7, Lobby/Third Level
Topic:
Breakout with Blockchain - Subtopic:
Hyperledger is an open source collaborative effort created to advance cross-industry blockchain technologies. It is a global collaboration hosted by the Linux Foundation, and it includes leaders in finance, banking, the Internet of Things, supply chains, manufacturing, and technology. This session will examine various distributed ledger projects with a focus on Hyperledger Fabric.
Introduction to Oracle Autonomous Blockchain Cloud
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Oceanic 7, Lobby/Third Level
Topic:
Breakout with Blockchain - Subtopic:
Oracle Autonomous Blockchain Cloud enables enterprise customers to expand the boundaries of their existing applications. Oracle’s eagerly awaited Blockchain Cloud Service is built upon the Linux Foundation’s Hyperledger Fabric platform. This session will provide attendees a tour of Oracle’s Blockchain Cloud Service and an introduction to the development and deployment of autonomous networks and contracts.
Introduction to Oracle Autonomous Blockchain Cloud
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Breakout with Blockchain - Subtopic:
Oracle Autonomous Blockchain Cloud enables enterprise customers to expand the boundaries of their existing applications. Oracle’s eagerly awaited Blockchain Cloud Service is built upon the Linux Foundation’s Hyperledger Fabric platform. This session will provide attendees a tour of Oracle’s Blockchain Cloud Service and an introduction to the development and deployment of autonomous networks and contracts.
The Hyperion Close Suite Gets the Job Done for Calumet Specialty Products
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Oceanic 4, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
EPM Case Studies
Do you want to hear first-hand from a client about their implementation of the Hyperion Financial Management (HFM), Data Management (FDMEE), Account Reconciliation Manager (ARM) and Financial Close Manager (FCM) products, including how data was fed to these applications directly from SAP? This presentation will guide you through the implementation of the Hyperion Close Suite of applications at Calumet Specialty Products. We will share the real world benefits Calumet gained from using multiple products to streamline their monthly close process. Additionally, we will discuss the solutions used to address the challenges faced during implementation.
Inside Out OAC Essbase & DV
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere A1, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
Join Oracle ACE Gary Adashek from General Electric GE Digital as he goes Inside Out (Disney/Pixar) of Oracle Analytics Cloud (OAC), OAC DV, and BI.
Learn step by step how to build an Essbase cube from scratch via Cube Designer (DBX), an Excel Wizard driven workbook model.
Then, connect your cube to analysis plus visualizations, create a beautiful story about your dataset, and determine insights.
Also take a look into additional ad-hoc analysis or object inserts via Smart View.
This presentation will take a detailed look at the steps required to successfully design, build, and deploy an Essbase cube in the cloud via Excel. You can connect that cube as a source for beautiful visualizations online with OAC DV and ingest OAC BI content into MS Office via Smart View.
We’ll provide a step-by-step guide, tools, tips and tricks.
The benefits for users include:
• Essbase cube build via Cube Designer Extension Wizard
• Setup & connect OAC—DV/BI to OAC—Essbase as a datasource
• Create data visualizations and use custom Data Viz plug-ins
• Create OBI content
• Consume OBI data objects via Smart View for Office
Save “The Beverage Company!": How to Impress People with Smart View in PowerPoint
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Northern Hemisphere A2, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Ad Hoc Reporting
Gary and Gary are on a quest to save the beloved TBC (aka The Beverage Company). This darling fictitious corporation, immortalized in the Essbase Sample Basic application, has fallen on hard times; it’s going to take a substantial cash infusion from an investor to get the company back on its feet.
Leveraging their mastery of EPM, the Garys will walk potential investors through a dynamic pitch, demonstrating why TBC is worth saving.
REST API for Data Management and FDMEE
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
EPM Data Integration - Subtopic:
Other EPM Data Integration
Does REST say something to you?
Join this session to discover how Data Management and FDMEE can now be automated and integrated with other systems using the new REST API.
Building from the Ground Up: Report & Dashboard Storyboarding
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere A3, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Data Visualizations
“That is not what I was thinking at all!” Have you ever had someone say that to you after you took the time to gather what you believed were solid requirements and then build an entire dashboard or report? Attend this session to learn a proven method of building your reports and dashboards from the ground up. We’ll shine the proper light into the requirements-gathering tunnel.
#19sverificado: How Data Analytics Helped Put Order to the Chaos During Mexico's Earthquake
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Database - Subtopic:
DBA
On September 19, 2017, at 1:15 PM CT, Mexico was hit by one of the deadliest earthquakes since 1985. This resulted in 366 people dead, 44 buildings destroyed, and over 3,000 structures rendered unusable. In the moments after the earthquake, Twitter and social media became the tools survivors used to provide help with everything they could. Soon after, even the help became chaotic—supplies arriving where they were not needed, a flood of people where there were already enough helping hands, and no help in places where people needed it most. This talk will go into how a group of IT and data scientists helped put order to the chaos of the aid effort during the disaster. They inadvertently assisted in saving lives, helping to give hope for the future.
Sherwin-Williams EPM On-Prem to the Cloud Journey
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Oceanic 4, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
EPM Case Studies
Hate the idea of the cloud? Love your On-Prem solution? So did we! Navigating the slow performance of our webforms forced us to reevaluate the cloud.
Hands-On Lab: FDMEE (On-Prem)
When:
June 11, 2018,
Hands-On Lab,
1:15 PM -
3:30 PM
Room:
Europe 11, Lobby/Third Level
Topic:
EPM Data Integration - Subtopic:
Other EPM Data Integration
This session will dive into the functionality and uses of FDMEE on-prem. Using a live environment, you will learn and execute tasks related to FDMEE on-prem!
A Critical Comparison of the Oracle EPM On-Premises vs. Cloud Solutions
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Asia 3, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
EPM Case Studies
Oracle EPM has been around for over 25 years in various incarnations. Some of those older products lead their respective spaces; the top consolidation product in the world is still HFM, the top budgeting solution is Hyperion Planning, and the top cube technology is Oracle Essbase. Is there a rush to throw out the tried and true Oracle EPM solutions? We'll compare the traditional on-premises products to their new Cloud replacements. What are the benefits and drawbacks of each, and what should we be implementing today?
Oracle ORDS 101: Jumpstart Your Development, Revisited
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Asia 2, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX Integration
Being able to provide RESTful interfaces to our data has become a common requirement, and as APEX developers, we certainly have to deal with it too.
This presentation is designed to give beginning ORDS/REST developers an overview of the most important use cases in order to be productive immediately.
We will cover simple to more advanced use cases typically used in modern web applications. The examples and use cases will be practical and relevant. We will cover the definition, management, and features of ORDS-based RESTful services. Some very important features of Oracle ORDS are not well known (e.g. the support of optimistic locking—out of the box)!
We will cover security and how to protect your RESTful services. Being able to provide a script-based deployment of your services becomes even more important when dealing with devops and agile development practices.
The Open API Initiative (OAI) provides an open specification, originally know as the Swagger specification, for describing and documenting REST APIs. From version 17.4 onward, Oracle REST Data Services (ORDS) exposes the metadata of specific web services in Open API 2.0 format.
We will have a first look at the generation and automatic documentation of your API by using Swagger.io.
Oracle APEX 18.1: The Golden Nuggets
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Asia 2, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX New Release
Every new APEX release contains a few major features that everybody talks about. For example, in APEX 18.1 these features include Remote SQL Data Access, REST service consumption, the new REST workshop, and improvements in the interactive grid.
In addition to these, there will certainly be almost 100 other smaller features and improvements delivered by the APEX team. The wizards will be improved, the PL/SQL and Javascript APIs will be enhanced, and the plugin infrastructure will be extended.
Many of these features are certainly not discussed enough even though they continually increase our productivity or make things easier. However, they only work if and only if you are aware that they exist and know how to use them.
In this presentation we will take a close look at the most noteworthy of the smaller new features. Certainly we will see hands-on demonstrations, and the full demo application will be provided as a download.
Deep Dive: #LetsWreckThisTogether APEX Talks
When:
June 14, 2018,
Thursday Deep Dive,
9:30 AM -
11:00 AM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Application Express - Subtopic:
Other Application Express
The #LetsWreckThisTogether APEX Talks are back! Just in case you have not received enough inspiring content by the end of the week, the Thursday session will focus on Javascript and APEX. Some of the best, well-known speakers and luminaries in the APEX world will give you insights and guidance on how to leverage Javascript in APEX—the right way.
The format will be short bursts (10–12 minutes each) to keep you engaged and make it fun to listen.
Get ready for an awesome lineup:
• The Ground Rules, ACE Director Peter Raganitsch, FOEX GmbH
• Organizing Your Code and Tools to Use, Oracle ACE Vincent Morneau, Insum
• Understanding the Widget Architecture, Menno Hoogendijk, Qualogy
• Performance, ACE Director John Scott, APEX Evangelists
• Debugging, Kai Donato, MT AG
• Your Roadmap to Success, How to Get Started, ACE Alumni Dan McGhan, Oracle Corporation
Imagine That! Explore HFM Design Concepts
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Northern Hemisphere A4, Fifth Level
Topic:
Financial Close - Subtopic:
Hyperion Financial Management
Come to this session to expand your imagination and explore a variety of HFM application design concepts. We will cover strategies of translating every entity into one or more reporting currencies regardless of the entity hierarchy. We will explore different ways to handle flow dimensions, data sources, and currency translation adjustments. Do you want to make Parent Currency adjustments without the drawbacks of the value dimension? What about loading local currency and USD? Examine inventive ways to use custom dimensions and find out why more is sometimes better. Oracle ACE Chris Barbieri will share knowledge from his nearly two decades of experience with HFM application design, helping you find practical ways to reduce your maintenance, improve performance, and make better use of HFM.
HFM Rules for Absolute Beginners
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Northern Hemisphere A4, Fifth Level
Topic:
Financial Close - Subtopic:
Hyperion Financial Management
Have you ever wondered what happens behind the scene when you click “calculate,” “translate,” or “consolidate?” Does the script in a rules file fill you with anxiety? In this session, Oracle ACE Chris Barbieri will explain the basics of HFM’s rules. No experience needed!
Increase Your Programming Confidence by Using Unit Tests
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Database - Subtopic:
DB Dev
Everyone knows how important testing is, but hardly any developer writes repeatable tests. Sure, we create and run some ad-hoc tests to make sure our code works, but this is hardly repeatable. This session will show you how unit testing can help your developers become more productive and more confident about their results.
DV and Essbase Use Cases
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Essbase - Subtopic:
Essbase Cloud
We invested heavily to ensure that DV desktop and the DVCS experience on top of Essbase are the best among their peers. We also introduced many new use cases and will discuss them as part of this session.
• We automatically created Essbase as target for data flow, and we use that cube for acceleration for DV queries against federated sources.
• DV is enhanced to support not only read values from Essbase, but also write back to Essbase
• DV on top of Essbase is enhanced to support hierarchy.
We will also discuss roadmap items, bringing in the calculation script, aliases, alternative hierarchy, as well as many other rich experiences to DV.
Management and Release of Large-Scale APEX Applications and Development Teams
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Asia 1, Lobby/Third Level
Topic:
Application Express - Subtopic:
Other Application Express
No matter how many developers you have working on APEX applications, the logistics of large-scale APEX development in an Agile SDLC environment are never trivial. Sometimes cutting off development, exporting the entire application, and tagging it for release just don’t cut it. Properly rolling out new releases of your APEX applications requires additional considerations. In this session, I will highlight lessons learned during our journey rolling out frequent, hassle-free changes to multiple APEX applications.
Introduction to Financial Close in the Cloud
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Northern Hemisphere A4, Fifth Level
Topic:
Financial Close - Subtopic:
Financial Close Cloud
Everyone talks about the new cloud products, but what are they and what do they mean to you? This session will provide an introductory deep dive into and demonstration of the Oracle Close Solutions in the cloud.
Auditors and How to Suffice Their Hyperion Requests to Pass an Audit
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Oceanic 4, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
EPM Case Studies
Auditing your Hyperion environment for SOX or any other compliance requirement is never easy. This session will explain some tips and techniques on how you can manage requests from various internal/external auditors in order to pass your Hyperion audit.
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere A2, Fifth Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
Would you like to move your Oracle EPM environment to the Cloud? Are you still using spreadsheets for financial planning and forecasting? The Cloud is attractive for any organization - no initial upfront cost for hardware or software, less IT involvement, and no annual maintenance costs. Attend this presentation and hear how others have moved and learn how migration is not as difficult as you may think!
Migrating on premise processes to Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) or Planning and Budgeting Cloud Service (PBCS) provides a great opportunity for you to clean your current environment and data structures and streamline your processes. This session features key case studies! Hear how:
• AAR Corporation moved from a legacy budgeting and reporting solution to the Cloud and reduced calculations from 20 minutes to15 seconds, improved visibility into their entire GL and reduced integration complexity
• IDT, a leading solutions provider in RF, high performance timing, and memory interface, used a “move and improve” process to migrate from an on-premise Hyperion Planning solution to Oracle EPBCS and implement Workforce Planning
• ReachLocal, an online marketing and advertising solution provider, combined applications and databases into one cloud app
• A metals recycling company combined applications and databases into one cloud app
• A leading builder of new homes migrated from HFM to EPBCS
• A utility company migrated from on premise Planning to PBCS
• A major consumer goods company migrated from Essbase/VBA to PBCS for marketing spend forecasting
Hyperion's Down! What to Do! What to Do!
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Asia 3, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
Other Real World EPM
This session reviews real world issues relating to installation and operation of Oracle's real world platform. We focus on the core components of financial management, planning, essbase, FDMEE, and financial reports.
-Problem avoidance
-Monitoring basics
-System patching
-Troubleshooting: If A then B
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere E3, Fifth Level
Topic:
EPM Data Integration - Subtopic:
Other EPM Data Integration
In this session, we will work through the alphabet soup of EPM systems to illustrate cloud and on-premise integration patterns and paradigms. We will take you step-by-step through the decisions of selecting the best tool for the job, providing answers to common EPM integration questions.
Topics include:
EPM Systems: OACS (Essbase Cloud), PBCS (Planning Cloud), and FCCS (Consolidations)
Integration Tools: FDMEE (Data Management), EssCS (OACS), EPMAutomate (PBCS/FCCS), and Outline Load Utility (Planning)
Languages: PowerShell and Jython
Building a Foundation of S&OP with EPBCS at O-AT-KA Milk
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Planning - Subtopic:
Planning Modules and Frameworks
O-AT-KA Milk is a dairy cooperative, which was founded in Batavia, NY in 1959 and is focused on creating innovative dairy-based products. O-AT-KA’s planning process was supported by offline spreadsheets and enabling technologies that were difficult to manage and lacked the analytical capabilities desired to provide detailed insights into the business. Integrations with source systems were manual and required significant effort. The existing tools limited O-AT-KA’s ability to effectively gain insights and provide the level of analysis needed to support organizational growth.
O-AT-KA selected Oracle Enterprise Planning & Budgeting Cloud Service (EPBCS) Financials as the strategic solution to provide a more repeatable process for planning, reporting, and analyzing, while requiring less effort to maintain and supporting future growth. Out-of-the-box Financials functionality for department expense planning was supplemented with more detailed custom Revenue, COGS, and operational planning to provide a unified solution across key budget areas and the entire production process.
EPM Sunday Symposium: Opening Remarks and State of EPM Business & Strategy Review
When:
June 10, 2018,
EPM Sunday Symposium Session 1,
1:00 PM -
2:00 PM
Room:
Southern Hemisphere I/II, Fifth Level
Topic:
Real World EPM - Subtopic:
Other Real World EPM
Opening Remarks
Al Marciante, Oracle Corporation
State of EPM Business & Strategy Review
Matt Bradley, Oracle Corporation
The State of EPM Business and Strategy Review will set up themes for the EPM sessions to follow and introduce the agenda for the rest of the day. We’ll highlight EPM Cloud portfolio growth, market momentum, and customer adoption, and include a discussion of product to process shift leveraging.
Angular, Vue, React, JET: JavaScript on the Client, How Do I Choose What's Best?
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
DB Dev
With the constant changes in the JavaScript ecosystem, it's often difficult to decide what is the best approach for building an application that meets the needs at the enterprise level. This session will present multiple concepts and ideas related to how JavaScript can be used on the client in a client-server architecture.
What does it mean to move from a server-side language to a pure client-side language like JavaScript running in the browser? Is it just the language that changes or does the complete application architecture have to change as well? These questions will be answered as we discuss what pitfalls to avoid and what techniques can be used to find that needle in the haystack.
Four Seasons Hotels, a Hybrid Cloud Story—Best of Both Worlds
Co-Presenter: Tjien Lie, Four Seasons Hotels & Resorts
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Asia 5, Lobby/Third Level
Topic:
EPM Infrastructure - Subtopic:
Cloud and Hybrid Infrastructure
In this session, we will review the technologies and techniques that inlumi uses to securely deploy Oracle EPM Planning for Four Seasons Hotels' properties across the globe using both on-premises Hyperion Planning and cloud technologies.
Contain Your Test Environment: Using Docker and Oracle DB 12c
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Oceanic 5, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
Have you ever been faced with the need to quickly and constantly deploy an Oracle DB for testing, but you want to avoid the hassle of repeatedly installing the database? Use Docker to deploy an Oracle DB for your test environment.
The True Value of Blockchain . . . and It Ain't Bitcoins
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Oceanic 3, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
Many people think of Bitcoin when they hear blockchain, but that's not where the real value of the technology lies. This session will take a look at the concepts being applied to blockchain technology by walking through the process of rolling your own blockchain. We’ll also examine how organizations are taking advantage of this technology.
Careers and the Changing Landscape Panel for DBA/Developers
When:
June 13, 2018,
Careers and the Changing Landscape Panel for DBA/Developers ,
10:45 AM -
12:15 PM
Room:
Oceanic 7, Lobby/Third Level
Topic:
Bonus Sessions - Subtopic:
In these panel discussions, industry and consulting experts will explore product and employment trends, automation and other factors affecting the future of technology and resource demands.
Danny Bryant, Snowflake Computing (Moderator)
Jeff Smith, Oracle Corporation
Stewart Bryson, Red Pill Analytics
Anton Nielson, Insum
Dan McGhan, Oracle Corporation
Kent Graziano, Snowflake Computing
DevOps for the Analytics Cloud Using the Developer Cloud Service
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Northern Hemisphere A2, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
BI Analytics
The Oracle Analytics Cloud (OAC) has changed the way we build and deliver analytics. It has also changed our approach to managing our analytics investments, including the development lifecycle and the automation of processes ranging from testing to deployments. It’s all in the Cloud now; that should make things easier, right?
With the Oracle Developer Cloud Service (DCS), it can be! DCS is a free cloud service that features issue tracking, code versioning, team collaboration, Agile project management, and continuous integration and delivery. In this presentation, we’ll explore how DCS can manage the entire lifecycle for OAC development. Attendees will see a live demonstration showing how to use DCS to automate testing and deployment for OAC.
What We Learned Building Analytics for Google
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Oceanic 2, Lobby/Third Level
Topic:
Big Data & Data Warehousing - Subtopic:
Other Big Data and Data Warehousing
How should we approach analytics when the serverless cloud is the only option? Cloud-native data platforms enable developers to build applications quickly. In this keynote, learn how Red Pill Analytics stitched together data from across the internet using the Google Cloud Platform to tell a social media story for our client Google. Hear how we used BigQuery, App Engine, PubSub, Cloud Functions, and Data Studio to build a complete marketing analytics platform measuring user engagement from sources including Twitter, LinkedIn, YouTube, Google Analytics, Google+, and AdWords.
What challenges did we face? What decisions did we make? And how did the Google Cloud Platform enable us to deliver all of this in less than three months? We can only show you the door—you must choose to walk through it.
The Hackett Group: Maximize the Return on Your Oracle Cloud Investment
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
Companies are struggling with how to articulate the value of cloud solutions and link them to business improvements and value creation. The Hackett Group’s Digital Transformation Platform (DTP) aligns Oracle Cloud functionality with Hackett-certified best practices, benchmark metrics, and configuration guidance to maximize return on investment. First, it helps organizations build their benefits case and know where to focus by quantifying performance gaps against world class. Once the business benefits have been identified, organizations prioritize which best practices to focus on that will lead to improved business outcomes. Next, it helps accelerate Oracle Cloud implementations through a best practice execution plan with Oracle Cloud configuration considerations. Finally, the platform provides access to Hackett strategic advice through the life of the Oracle contract. Learn how your organization can accelerate your Oracle Cloud implementation, improve business outcomes, and maximize your return on your software investment.
Driving Value Through Collaborative Narrative
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Oceanic 2, Lobby/Third Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
Are you tired of manually compiling narrative reporting? Would you rather spend your time on value-added analysis? If so, you won’t want to miss this session, where we will guide you through how to deliver actionable insight in order to improve financial accuracy and reduce cycle time.
“It’s Like Magic”: How Windstream Used Hybrid Mode to Make Their Aggregations Disappear
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Asia 4, Lobby/Third Level
Topic:
Essbase - Subtopic:
Design and Optimization
Windstream will walk you through the challenges facing their planners while explaining how issues were resolved using Hybrid Aggregation Mode.
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere A1, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Advanced Analytics
KaVo Kerr is a cohesive organization comprised of two global leaders united to provide dental excellence and serve as a single premier partner for the dental community. Due to attributes of our General Ledger, KaVo Kerr could not previously complete revenue reporting on a country-by-country basis. This session will showcase how we chose Profitability and Cost Management Cloud Service (PCMCS) over realigning our chart of accounts (a major overhaul). Attendees will learn how the solution provides insight into allocation-based business processes, combining data from our GL and other systems, including Hyperion Financial Management (HFM), in order to match actuals and complete the necessary reporting and analysis of business performance.
How To > Deriving a Roadmap for Migrating Your Hyperion Applications to the Cloud
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Asia 5, Lobby/Third Level
Topic:
EPM Infrastructure - Subtopic:
Cloud and Hybrid Infrastructure
There have been inhibiting factors from moving all of your Hyperion applications to the Cloud . . . until now. In this session, we’ll talk about the Planning options, but also about Financial Consolidation and Close as the ‘next gen’ HFM, “Essbase-as-a-Service” via Oracle Analytics, new reporting and integration methods, the other Oracle EPM Cloud solutions, and offer roadmap advice.
AST: Embracing Oracle’s EPM Cloud—Making the Right Choices for Implementation or Migration
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere A1, Fifth Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
Oracle EPM Cloud has undoubtedly been one of Oracle’s most successful cloud solution sets. The full Cloud EPM Suite delivers broad capabilities at a reduced price and with less technical pain compared to on-premise. Now customers can have planning, budgeting, and forecasting; financial management and reporting; cost allocations; account reconciliation with matching; collaborative and regulatory reporting; and even supporting Essbase cubes offered as a service, all with no infrastructure costs. Oracle has done a great job porting its on-premise EPM solutions and technology into a consistent Cloud platform while including many new bells and whistles.
In this session, AST’s experts will highlight their insights and experiences with the Cloud EPM Suite in both standalone EPM implementations and those that include Oracle ERP and/or HCM deployments. AST experts will also discuss roadmap/assessment considerations for those still undecided about the Cloud. In doing so, we will share our best practices, advice, and the lessons learned from our earliest Cloud PBCS implementation successes (circa 2015) to the many current ones across the entire Cloud EPM Suite.
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Oceanic 5, Lobby/Third Level
Topic:
Database - Subtopic:
DBA
This presentation is about SQL statement parsing—what it is, how it affects database performance, and how to detect and correct parsing problems. We'll start by defining in detail what exactly parsing is, including information about parent and child cursors and what causes Oracle to create multiple child cursors for the same statement. We break down hard, soft, and "softer" parsing, showing how these can impact performance. We'll explain multiple ways to detect parsing problems, as well as the existing options for fixing them.
Peloton: Best Practices for Moving HFM to FCCS
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Oceanic 3, Lobby/Third Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
The legacy of HFM as the leading close, consolidation, and reporting tool set a very high bar for measuring the success of Oracle's cloud offering—Financial Close and Consolidation Cloud Service (FCCS). Oracle has invested significantly in FCCS to incorporate customer feedback as well as the recommendations of leading implementers to provide a world-class cloud solution. Peloton was among the first partners to deploy FCCS and has continued to be a leader in successful FCCS implementations. This session will share knowledge and best practices derived from our portfolio of client successes.
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Oceanic 3, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
Join us to review real-life examples and solutions for tuning application queries. We will dive into examples and case studies of seemingly simple and complex queries suffering from poor performance. We’ll provide insight into why they perform poorly and review solutions and concepts for overcoming these issues.
Analytic Views for Mortals: Worth It? When and Where
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Oceanic 3, Lobby/Third Level
Topic:
Database - Subtopic:
Other Database
Oracle 12.2 Analytic Views are not just for BI or DW experts; mere mortal developers can leverage this new, no-cost feature of the Oracle 12.2 database. Analytic Views enable simpler SQL statements and improved performance for aggregate and calculation queries—a big advantage for any developer building BI-like reports for data warehouse, business intelligence, or other data analysis purposes. Even if you’ve never used Oracle OLAP and/or do not have OBIEE, if you create BI-like queries, Analytic Views deserve a look.
This introductory session, geared for a non-data warehouse audience, covers:
- The basic components of Oracle Analytic Views: dimensions, hierarchies, and Analytic Views
- How to create and implement Analytic Views atop existing relational tables
- How to use Analytic Views in an APEX BI-like reporting application, including the effort involved and performance before and after
Are the promised performance gains of Analytic Views worth the investment of learning and implementing this new 12.2 feature? Attend the session to learn if, when, and where Analytic Views make a difference in your projects.
Editable Grid Essentials
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Application Express - Subtopic:
APEX New Release
Are you upgrading tabular forms to editable grids? This session is for you. Gain practical guidance on when, why, and how to effectively upgrade both simple and customized tabular forms to Editable Interactive Grids. No tabular forms? Learn how to master the Editable Interactive Grid.
Many of us have creatively tailored legacy tabular forms with PL/SQL collection loops and custom JavaScript in order to meet requirements. Or we’ve used custom solutions for tabular editing. Now, how can we turn these into editable interactive grids? This session focuses on Editable Interactive Grid features and essential upgrade tactics:
-Tabular Form vs. Editable Grid features
-How to implement checklists, cascading LOVs, and dynamic actions
-Using JavaScript APIs to access/change data as well as in-row and multi-row validations
-Strategy for typical upgrade scenarios
This session is essential for those who need advice on if, when, and how to replicate the tabular form functionality of their existing tabular form or custom solutions, plain or highly customized (with PL/SQL and/or JavaScript), in an Editable Interactive Grid.
Learn how to wow your end users with the Editable Interactive Grid.
Let Your EPM Cloud Users Embrace the Virtue of Laziness Through Analytics
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Essbase - Subtopic:
Essbase Cloud
Laziness generally carries a negative connotation. However, when applied to removing repetitive actions in order to enable your employees to pursue value-added activities, laziness is a virtue. In this presentation, we will incorporate analytics techniques such as:
o Machine learning exceptions
o Data Visualization Dashboards
o Predictive analytics
o Descriptive analytics
o Data governance
Utilizing these techniques within your Oracle Cloud EPM applications will help you refine your financial analytics process, allowing your team to focus on growing your business.
Wow! You Can Be a Financial Reporting Pro, Too!
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere A3, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
Financial reports are meant to deliver the most efficient and accurate financial data to the users. Have you ever wondered why your FR reports take so long to render? We will take a look at the overall design of the FR. There are many factors in a client-based or a web-based FR; we will briefly go over the difference between web and client versions.
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Northern Hemisphere A3, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
In this session, we will have you singing “Hakuna Matata” as you follow our “problem-free philosophy” for building narrative reports with Enterprise Performance Reporting Cloud Service. We will examine various tips and techniques for creating reports using both EPM Cloud data sources and the Enterprise Performance Reporting Cloud Application. As we know, financial reporting allows better decision-making and increased accountability; this session will equip attendees with practical tools to create reliable and process-driven reports.
Hands-On Lab: Build and Secure a RESTful Service with Oracle REST Data Services
When:
June 11, 2018,
Hands-On Lab,
10:45 AM -
11:45 AM
Room:
Europe 6, Lobby/Third Level
Topic:
Database - Subtopic:
DB Tools
In this hands-on session, you’ll learn how to:
+ Install and configure ORDS
+ AUTO REST enable a table
+ Develop and deploy a RESTful service
+ SECURE it
+ Generate Swagger/OpenAPI doc for your consumers
Participants must bring their own PCs and should have our Developer Days VirtualBox appliance downloaded before arriving at the conference.
Orchestra Networks: Beyond DRM: Lessons Learned in Large Enterprise Migrations
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Oceanic 4, Lobby/Third Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
Thinking about DRM or EDMCS to support the governance of your Hyperion EPM metadata, hierarchies, and other related data? Or looking for alternatives to your current DRM implementation? This session will feature a panel discussion describing the experiences, lessons learned, and benefits achieved from multiple implementations of Orchestra Networks’ EBX software to support governance of key Finance metadata, master/reference data, and hierarchies. The panel will feature, Andrew Helwig, Associate Director, Finance Systems, United Technologies Corporation (UTC); Esther Jesurum, Principal Solutions Architect - Finance, Orchestra Networks; and Conrad Chuang, Director of Industry Solutions, Orchestra Networks. This session will be of interest both to current DRM users looking for alternatives and to organizations looking to adopt a data governance solution.
Preview of Oracle Autonomous Database
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
Other Database
With the introduction of the first ever Autonomous Database Cloud, we are entering a new era of database. To support this new era, Oracle Database is also switching to a new annual release model, Oracle Database 18c being the first release of this new model. But what does this mean to you, and how will it change your interactions with the Oracle Database? This session will provide a clear understanding of how our unique Autonomous Database Cloud works, illustrating how it will impact both DBAs and developers. It will also provide a unique opportunity to get ahead of the curve and learn directly from the Oracle Database development team what's new in Oracle Database 18c .
Finally Execution Plan Stability with SQL Plan Management
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
DBA
The performance of any database application relies heavily on consistent query execution. While the Oracle Optimizer is perfectly suited to evaluate the best possible plan without any user intervention, a SQL statement’s execution plan can change unexpectedly for a variety of reasons. This potential for change makes even the most experienced DBAs and developers nervous. SQL Plan Management (SPM) offers an ideal solution to this conundrum by preserving the current execution plans amidst environment changes, only allowing plans to change if it results in improved performance. This presentation will provide a detailed explanation of how SPM works, along with step-by-step instructions of how to capture your existing execution plans. It will also cover how to test and verify any newly found plans, as well as explaining in detail how SPM interacts with other plan stability features such as SQL profiles, SQL patches, and adaptive cursor sharing.
Vertical Edge: Enabling Customer Success in a Self-Service BI World
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Asia 1, Lobby/Third Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
Energize the shifting self-service delivery model with the freedom to tackle some of the biggest hurdles in BI. With worrying about integration a thing of the past, you can finally concentrate on delivering a solution that focuses more on function than form; more on decisions than data. Journey with John Conlee and John Booth of Vertical Edge Consulting Group to understand how self-service delivery can be the key to solving one of the longest running challenges in Business Intelligence.
Smart View API: The Excel Force Awakens
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Essbase - Subtopic:
API and Related Tools
At a prior KScope, we presented the lessons learned and difficulties encountered during a major conversion to Smart View at Gap Inc. The good news is that since then, Oracle has made many enhancements to the API, which has made it significantly easier and more reliable to use. This presentation will cover the new features, lessons learned since that initial conversion, and how we used the improved functionality to simplify and stabilize our tools. Topics will include “bulletproofing” your connections and retrievals, using variable substitution when executing calcs, simplifying and optimizing retrieval logic, addressing challenges in Office 2016, using MDX to query outline structures, and much more. This presentation is for intermediate or advanced developers who have some knowledge of Excel VBA.
Project Planning: Leverage NASA’s Rocket Science to Automatically Populate Project Costs
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Planning - Subtopic:
Design
Join Bill Reddy and George Cooper to learn how to utilize Planning to accurately spread costs over the life of a project by leveraging the sophisticated cost curve methodologies used by NASA. If you know specifically which month(s) certain projects will occur, budgeting is easy. But many types of costs have a life of their own. Some, such as land purchases and preparation, are up-front and tail off quickly. Others peak near a specified date or near the end of a project. In this session, you’ll learn how to apply different cost curve algorithms to help your budget more closely match the actual cost stream.
Hands-On Lab: Data Management Hacks to Turn You into an FDMEE Cloud Ninja!
When:
June 13, 2018,
Hands-On Lab,
9:00 AM -
11:15 AM
Room:
Europe 11, Lobby/Third Level
Topic:
EPM Data Integration - Subtopic:
Other EPM Data Integration
If you’re loading data to EPM Cloud apps, such as EPBCS or FCCS, chances are you’re using Data Management (aka FDMEE Cloud). You don’t need to be an expert to go beyond standard file-based data loads.
Data Management (DM) makes it easy go beyond the basics and integrate all kinds of data from virtually any source, in any format.
Join Peloton's team of experts to get hands-on experience with features to help you get the most out of your EPM data management solution.
Ask the Experts—Financial Close Panel
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Asia 3, Lobby/Third Level
Topic:
Financial Close - Subtopic:
Other Financial Close
Please join us to have an open discussion with experts in the Financial Close community. Bring your outstanding questions about Financial Close.
Deep Dive: HFM vs. FCCS: Feature by Feature
When:
June 14, 2018,
Thursday Deep Dive,
9:30 AM -
11:00 AM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Financial Close - Subtopic:
Other Financial Close
Are you still unsure about the differences between on-premise and cloud Financial Close solutions? Join us for this deep dive session, in which we will explain, feature by feature, the differences between HFM and FCCS. How do consolidations work? How are the workflows different? How differently should you approach metadata management? Where and how is the logic written? How is security different? How do you migrate from HFM to FCCS? If you are seeking answers to these kinds of practical questions, you’ll be happy you stayed for this last sip of ODTUG Kscope content!
Katherine Price, Key Performance Ideas
Geordan Drummond, Finit Solutions
Oracle Ace, Eric Erikson, PQR Company
Louis Litrenta, GBI
Terrance Walker, interRel Consulting
Minie Parikh, EPMI
Make HFM Talk to You: Different Ways to Log What Your Rules Are Doing
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Asia 3, Lobby/Third Level
Topic:
Financial Close - Subtopic:
Hyperion Financial Management
Have you ever spent hours trying to read HFM's mind to understand why your rules were not doing what you thought they were supposed to? If so, you probably wished HFM could talk to you and explain what it is doing.
It can! This session will explore the different ways HFM rules can talk to you and log what they are doing—from writing to a log file to using cell texts or writing to the database. We will discuss the benefits and drawbacks of each option.
Added bonus: The same concepts apply to track the performance of your rules!
FCCS Rules 101: Essbase Calculation Concepts for HFM Professionals
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Northern Hemisphere A4, Fifth Level
Topic:
Financial Close - Subtopic:
Financial Close Cloud
Are you going to the cloud? You’ve spent your career building your VB Script skills and mastering everything that starts with HS. Now you need to adapt to the world of Essbase. This session will introduce the key concepts of Essbase calculation logic that apply to FCCS, helping to pave the way for your transition. (Hint: HS.Exp does not translate to @EXP)
The Heart of an Airline’s Business is a Living and Breathing OAC Essbase Cube!
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Asia 4, Lobby/Third Level
Topic:
Essbase - Subtopic:
Essbase Cloud
Join us in this session to learn how a major airline carrier put Essbase Cloud at the heart of its business. Everyone knows about Oracle Analytics Cloud and Essbase Cloud, but perhaps there are capabilities you have not explored or are not yet aware of. We will reveal the power of the platform, showing you how we are refreshing, maintaining, and optimizing the cube, along with some of the provided dashboarding functionality. We will also share some use cases in order to highlight the value that our customers gain in their move to Oracle Analytics Cloud.
Happily Ever After: ODTUG and Oracle Enterprise Planning and Budgeting Cloud Solution (EPBCS)
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere E3, Fifth Level
Topic:
Planning - Subtopic:
Other Planning
Have you heard the news that ODTUG has gone live with Oracle’s Enterprise Planning and Budgeting Cloud Service? ODTUG recently announced that it has adopted Oracle’s EPBCS to manage its financial reporting and budgeting needs. ODTUG has long wanted to utilize Oracle’s innovative finance solutions, but the large investment required in computing assets made it unfeasible. Today, with the availability of Oracle’s cloud solutions, the paradigm has shifted. These solutions provide 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 demonstrate the ease of deploying an EPBCS application for ODTUG. Gary will walk through the process of creating an application in PBCS, importing metadata and financial data from ODTUG’s GL, and building feature-rich dashboards and financial reports. He will also lead a demonstration of some of the novel features in EPBCS such as the ability to manage metadata via the Smart View Excel add-in.
Oracle Developer Community Lunch and Learn: Essbase Panel
When:
June 12, 2018,
Oracle Developer Community Lunch and Learn: Essbase,
1:00 PM -
2:00 PM
Room:
Asia 5, Lobby/Third Level
Topic:
Essbase - Subtopic:
Other Essbase
ODTUG Kscope18 will feature an Essbase Lunch and Learn panel with Oracle ACE Directors and Oracle ACEs, who are designated by Oracle Corporation as Oracle community enthusiasts and advocates. Many of these professionals are attending and speaking at ODTUG Kscope18. Eat a quick lunch from 12:45 - 1:00 p.m. in Pacific Hall B/C and at 1:00 p.m. join one of the information-packed sessions led by a panel of Oracle ACE Directors and ACEs. Bring your questions; these are the people who have the answers!
Gary Crisci, General Electric (Moderator)
Tim German, Qubix
Ricardo Giampaoli, TeraCorp
Jason Jones, Applied OLAP
Glenn Schwartzberg, interRel Consulting
APEX Sunday Symposium: APEX 18 and the REST of the World
When:
June 10, 2018,
APEX Sunday Symposium Session 3,
1:00 PM -
2:00 PM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Application Express - Subtopic:
Other Application Express
One of the marquee features of Application Express 18.1 is the improved support to consume external REST services and REST-enabled SQL. In this session, you will learn how to reference external REST services as Web Source Modules and how to create reports, charts, calendars, or other components using these. Remote Oracle database can be accessed as REST Enabled SQL services: Create an APEX component driven by an SQL query as before—but have it executed on a remote Oracle database over a REST interface using HTTPS and JSON. This session will also cover how to work with external data sources in custom PL/SQL code or as a plug-in developer. Tips and tricks will round up the session.
Hands-On Lab: Creating REST Enabled SQL References and Web Services
When:
June 12, 2018,
Hands-On Lab,
11:30 AM -
12:30 PM
Room:
Europe 6, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX New Release
One of the marquee features of Application Express 18.1 is the improved support to consume external REST services and REST enabled SQL. In this session, you will learn how to reference external REST services as Web Source Modules and how to create reports, charts, calendars, or other components using these. Remote Oracle database can be accessed as REST Enabled SQL services; you can create an APEX component driven by an SQL query as before, but have it executed on a remote Oracle database over a REST interface using HTTPS and JSON. The session will also cover how to work with external data sources in custom PL/SQL code or as a plug-in developer. Some tips and tricks will round out the session.
DATE, TIMESTAMP . . . and the APEX Calendar
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Asia 1, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX Core
As APEX developers, we're all working with DATE and TIMESTAMP data types - all the time. But we have four data types for date and time data - can you tell the exact difference ...? This session will shed some light into this and when to use which DATE or TIMESTAMP data type in PL/SQL or APEX applications.
For visualization, one typically thinks about the Calendar component. Did you know, that you can use a comprehensive Javascript API for the Calendar and that there are configuration options way beyond the standard region attributes? In this session you'll learn about these and also how to integrate the Calendar with other components using Dynamic Actions.
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Oceanic 1, Lobby/Third Level
Topic:
Database - Subtopic:
DBA
Oracle Database 12.2.0.1 (12cR2) significantly improves the performance of Database In-Memory (DBIM) features, offering potentially massive improvements in real-time analytic processing and queries. This session takes a deeper look at what the Oracle 12cR2 optimizer is actually doing “under the covers” when it makes its decisions to process a query against IMCS-resident and non-resident tables, including improved In-Memory Joins, leveraging Join Groups, taking advantage of In-Memory Expressions, and utilizing In-Memory filtering effectively. We’ll look at some real-world performance improvement metrics obtained against an Exadata Express OPC environment, which shows how best to approach using these newest DBIM features.
Leveraging Partitioned External Tables: Primer and Practical Examples
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Oceanic 2, Lobby/Third Level
Topic:
Big Data & Data Warehousing - Subtopic:
Other Big Data and Data Warehousing
Oracle Database 12c is the first release to offer the capability of accessing a file in HDFS or Hive format as an external table. Through live and recorded demonstrations, this session will explain how an Oracle DBA can leverage these new features in order to gather data in tabular form from these file formats, while utilizing the best tool ever designed to filter, sort, aggregate, and report information—Structured Query Language.
Oracle Developer Community Lunch and Learn: Database, Data Warehousing, and Big Data Panel
When:
June 12, 2018,
Oracle Developer Community Lunch and Learn: Database, Data Warehousing, and Big Data,
1:00 PM -
2:00 PM
Room:
Asia 3, Lobby/Third Level
Topic:
Database - Subtopic:
Other Database
ODTUG Kscope18 will feature a Database, Data Warehousing, and Big Data Lunch and Learn panel with Oracle ACE Directors and Oracle ACEs, who are designated by Oracle Corporation as Oracle community enthusiasts and advocates. Many of these professionals are attending and speaking at ODTUG Kscope18. Eat a quick lunch from 12:45 - 1:00 p.m. in Pacific Hall B/C and at 1:00 p.m., join one of the information-packed sessions led by a panel of Oracle ACE Directors and ACEs. Bring your questions; these are the people who have the answers!
Jim Czuprynski, ViON Corporation (Moderator)
Heli Helskyaho, Miracle Finland Oy
Craig Shallahamer, OraPub
Julian Dontcheff, Accenture Enkitec Group
Zohar Elkayam, Brillix-DBAces
Gustavo René Antúnez, Pythian
Introducing Domain Specific Language (DSL) for Enterprise Planning Models
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Oceanic 4, Lobby/Third Level
Topic:
Planning - Subtopic:
Planning Modules and Frameworks
This session will introduce Domain Specific Language (DSL), a new paradigm for writing business logic for multidimensional planning models. DSL is a user-friendly mechanism for writing business logic and can be leveraged to extend the capabilities of Enterprise Planning Models.
Using Hybrid BSO in EPBCS: Best Practices, Tips, and Tricks
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Northern Hemisphere E3, Fifth Level
Topic:
Planning - Subtopic:
Planning Cloud
Hybrid BSO supports the best of both BSO & ASO (all BSO calcs with instantaneous aggregations like ASO). In this session, we will discuss when Hybrid BSO can be used, as well as the benefits of using Hybrid BSO over BSO in EPBCS. We will also go over best practices and tips & tricks to get the most out of Hybrid BSO.
Hybrid Cloud Integration: Putting It All Together
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
EPM Data Integration - Subtopic:
Cloud Hybrid Integration
Oracle EPM on-premise, cloud, and the hybrid approach are all supported by a number of tools and technologies that can help navigate and resolve data migration and integration issues. These tools include Oracle Data Integrator (ODI), Financial Data Management Enterprise Edition (FDMEE), and Data Management. With so many options for integration, finance teams are asking, “Which one is best for our business needs?”
In this session, Steve will provide examples of the essential questions that help determine the best integration approach. He will review each option while focusing on tasks, benefits, and drawbacks. He’ll compare the integration options and the advantages of each offer, providing real-world examples of each approach. Attendees will come away with a solid understanding of the best integration method for their business needs.
EDMCS or DRM: Which One Should I Use?
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
EPM Data Integration - Subtopic:
Metadata Management/Integration
When it comes to master data management, the question you need to ask is: Where does master data management fit into our cloud strategy? Your organization’s current and future master data management needs will determine if you can work with the limited options Oracle Enterprise Data Management Cloud Service (EDMCS) currently offers. As you wait for the planned improvements, you’ll have to decide whether you want the robustness of a mature tool like Oracle Data Relationship Management (DRM). Currently, we are in a transition period between applications. This session will provide the information needed to decide which application best fits a company’s master data management needs.
The Session will include:
•A review of EDMCS
•A side-by-side comparison of DRM and EDMCS
--Single version of the truth or “as is” source data from individual applications
•Real world examples showing
--When DRM is the best choice
--When EDMCS is the best choice
--When using both is the best choice
•How to fit master Data Management into your Cloud Strategy and Roadmap
--Do you need DRM, EDMCS, or should you wait until EDMCS is mature?
•And more…
Do the Mashup: How to Get BI Self-Service Data Connections Right
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Asia 4, Lobby/Third Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
BI Analytics
With data as king, IT and business struggle between one version of the truth and the need to add data into the system quickly for analytic purposes. While you may need validated data that resides in a data warehouse, it is also necessary for users to supplement this data on the fly. Successful analytics applications require the ability to mash up external data with data from a warehouse. In this session, we’ll cover joins, transforms, connections to cloud applications and other databases. Come to learn how to use the new data flow, machine learning, and mashup capabilities of OAC, DVD, and OBIEE 12c for today’s analytics.
Advanced Visualizations for Data Discovery and Exploration in Oracle DV
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Northern Hemisphere A1, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Advanced Analytics
The process of scientifically uncovering insights in complex data sets is one of the most exciting and compelling areas of visual analytics. Sankey graphs, parallel coordinates, radar graphs, and trellis charts all have the potential to reveal important patterns, relationships, and trends in highly dimensional data.
Knowing how to properly prepare, extend, and revise data sets during the exploration process, while also visualizing and highlighting key artifacts and findings, is as much an art as a skill. Join the experts from Vlamis as we walk you through a series of narrated demonstrations, which will reveal the yet untapped potential of Oracle Data Visualization 4.0.
API Economy for Dummies (and APEX Developers)
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Asia 2, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX Integration
Thanks to RESTfull web services, the number of APIs is currently exploding. New services are built on top of existing services, creating whole new business cases. APEX 18.1 addresses this topic by both supplying and consuming RESTfull web services in a declarative way, but it also raises some questions in the areas of versioning, scalability, performance, security, monitoring, transformation, and orchestration. At a certain point, a third party tool like MuleSoft can provide the necessary functionality for API management. In this presentation, I will explain what API Economy is and how APEX fits in. A demonstration with APEX & MuleSoft will be included.
APEX 18.1 & Beyond
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Asia 2, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX Integration
We all know that APEX 18.1 offers a lot of features right out of the box, but what if you get a requirement that goes beyond APEX 18.1's standard functionality? Let's go through some of these and learn what you can do to address:
- XLSX import
- PDF/XLSX reporting
- Drilldown reporting
- Continuous integration
- Automated testing
- Tree with enhanced functionalities
- Workflow support
- Offline capability
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
EPM Data Integration - Subtopic:
Other EPM Data Integration
ODI is an incredible and flexible development tool that goes beyond simple data integration. However, most of its development power comes from out-of-the-box ideas.
--Have you ever wanted to dynamically run any number of "OS" commands using a single ODI component?
--Have you ever wanted to have only one data store to loop multiple sources without requiring different ODI contexts?
--Have you ever wanted to have only one interface to loop any number of ODI objects with effective control?
--Have you ever needed a "third command tab" in your procedures or KMs to improve ODI powers?
--Do you still use an old version of ODI and miss having a way to know the values of the variables in a scenario execution?
--Do you know that ODI has four "substitution tags" that can be incredibly useful?
--Do you know how powerful "dynamic variables" can be?
--Do you know how to control your ODI priority jobs automatically? (i.e. stop, start, and restart scenarios)
If you want to know the answers of all this questions, please join this session to learn the special ODI secrets that will take your development skills to the next level.
Implementation of Integrated Cloud Consolidation Solution at Mid-Size Company
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Asia 3, Lobby/Third Level
Topic:
Financial Close - Subtopic:
Financial Close Cloud
This session will cover a case study of an FCCS/EPBCS implementation at a mid-size company. In a joint presentation between client and implementation partner, we will discuss the implementation path and the lessons learned. We will also explore the FCCS from both a practical and pragmatic perspective, making suggestions about how to set up a successful implementation project.
Asurion’s Quest to "Insure" Profitability with Oracle PCMCS
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Oceanic 4, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
EPM Case Studies
Do you remember the last time you shattered your phone screen? Asurion sure does! Although they are the superheroes of smart devices for many people, even they can use a little help sometimes.
Oracle Profitability and Cost Management Cloud Services (PCMCS) provides a robust, enterprise-grade allocation solution that is significantly more cost effective and easier to manage than previous on-premise solutions. Asurion implemented PCMCS to establish clear connections between the consumption of resources within the business and how those resources are used to drive customer and product profitability. Asurion started their journey to the cloud by migrating allocations from an existing on-premise custom Oracle Planning solution to PCMCS. The end result is a high-performing allocation solution, which provides improved result transparency and costs less.
In this session, we will review how Asurion’s hybrid EPM deployment (existing on-prem DRM, Planning, HFM, etc.) accelerated their ability to take advantage of the PCMCS benefits and established a foundation for their cloud presence. We will also share best practices that the team developed, the superhero-like features, performance optimization, and reporting benefits, which contributed to the success of the Asurion PCMCS implementation.
Emerging Tech Unconference Session
When:
June 13, 2018,
Emerging Tech Unconference Session ,
9:00 AM -
10:30 AM
Room:
Oceanic 7, Lobby/Third Level
Topic:
Bonus Sessions - Subtopic:
This unconference session is all about you! We’re looking for attendees to give short 10-minute demos or focused discussions on some emerging technology that you’re researching or using in your organizations. Examples include chatbots, AI, AR/VR, Blockchain, etc. If you’re interested in giving a short demo or focused talk on Emerging Tech please come prepared to the unconference session and sign up at the beginning. We’ll try our best to fit everyone in.
Careers and the Changing Landscape Panel for EPM/BI
When:
June 13, 2018,
Careers and the Changing Landscape Panel for EPM/BI ,
2:15 PM -
3:45 PM
Room:
Oceanic 7, Lobby/Third Level
Topic:
Bonus Sessions - Subtopic:
In these panel discussions, industry and consulting experts will explore product and employment trends, automation and other factors affecting the future of technology and resource demands.
Natalie Delemar, EY (Moderator)
Kevin McGinley, Snowflake Computing (Co-Moderator)
Mark Rittman, MJR Analytics
Becky Wagner, US-Analytics
John Conlee, Vertical Edge
Bill Nall, GE Digital
Four Seasons Hotels and Resorts: Solving the Dynamic Content and Calculation Quandary
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Oceanic 2, Lobby/Third Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
Eventually it became apparent that the complexity of Four Seasons’ revenue calculation and reporting process had outpaced their homegrown Excel-based solution. It was becoming increasingly cumbersome, as it was unable to quickly react to change and ensure the delivery of timely and accurate reporting to management.
Learn how Four Seasons leveraged Essbase and Dodeca’s sophisticated development capabilities to simplify and streamline the ongoing evolution of their revenue calculation and reporting workflow, providing each hotel the ability to customize the content and calculations required to address their specific needs.
Building a Cloud Adapter in FDMEE and Data Management
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
EPM Data Integration - Subtopic:
Data Management/Integration
We all know that FDMEE supports Hybrid integration. This functionality allows us to connect the on-premises and Oracle EPM Cloud worlds.
But what if our source or target is a cloud service other than the Oracle EPM Cloud? Can we bypass file-based loads? And what if I have Data Management instead of FDMEE; can we have a Cloud Adapter?
Don’t miss this session if you want to see how FDMEE and Data Management can be used to interact with cloud-based solutions in order to provide seamless integrations.
JavaScript and Offline First
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Asia 1, Lobby/Third Level
Topic:
Application Express - Subtopic:
JavaScript
Everyone’s familiar with the situation of being on a train or a plane and having a very limited or no internet connection at all. In many companies there is a steady transition to cloud services. For emails, text editing or storage services you need an internet connection. In this presentation, I will explain how to create web applications with offline capabilities. There will be a live-demo in which I will show you how to create an Oracle APEX application with offline capabilities.
APEX and Additional Templating Engines
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Asia 2, Lobby/Third Level
Topic:
Application Express - Subtopic:
JavaScript
Whether Mustache.js or Handlebar.js, there are a lot of possibilities to extend the standard functionality of the Oracle APEX templating engine. With a little bit of JavaScript and the respective template markup, you are able to create reusable templates or implement already existing ones. In this presentation I will show an exemplary implementation of an additional templating engine into Oracle APEX, and I will weigh the advantages and disadvantages of this approach. In addition, I will ensure that developers know where to expect potential difficulties.
Going Mobile with Universal Theme
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Application Express - Subtopic:
APEX New Release
In APEX 18.1, JQuery Mobile is deprecated as the solution for mobile applications. It will be replaced by a solution based on Universal Theme.
This presentation will show you how to create mobile applications with APEX 5.0 and 5.1 using Universal Theme. Although the responsiveness of the Universal Theme is a good starting point for mobile development, you will need to do more. The normal reports are not suitable for mobile applications. They can be replaced by a List View using a Named Column Report Template styled with CSS. The standard forms do not use the screen space very effectively, but this can be tweaked by applying a few lines of CSS.
The presentation will also cover ways to reduce the keyboard input. Some alternative methods of input such as touch and speech will be demonstrated along with a number of other tweaks to help create a usable and great looking mobile application.
All software used will be available so you can start building your own mobile app immediately after the presentation.
Supplementing Your Financial Reporting Diet
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Northern Hemisphere A4, Fifth Level
Topic:
Financial Close - Subtopic:
Financial Close Cloud
In this session, you will learn how you can use the supplemental data elements of FCCS to enhance the reporting process and collect additional information you might need for footnotes or other reporting requirements. The discussion will cover the full range of input and reporting options, as well as workflow.
Lego My Cash Flow!
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere A4, Fifth Level
Topic:
Financial Close - Subtopic:
Financial Close Cloud
In this session, you will learn how to leverage the out-of-the-box building blocks in FCCS to build a cash flow statement that seamlessly brings together data from the balance sheet, income statement, and manual data sources. This will include a review of dimensionality, calculations, and data impacts. You will also learn some tips and tricks for handling the reporting of business transactions such as acquisitions and divestitures.
APEX 18.1 New APIs
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Application Express - Subtopic:
APEX New Release
APEX comes with a set of APIs that help simplify both your APEX and PL/SQL development. Most developers aren't aware of the many features in the set of APIs. This presentation will introduce the APEX APIs while highlighting some of the best APIs released as part of APEX 18.1.
Logger: Everyone's Using It, Why Aren't You?
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Oceanic 5, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
Code Instrumentation (i.e. logging) can be a huge time saver in your code. Most organizations don't instrument their code, do a hack job (using dbms_output and then removing it before release), create their own logging platform, or use Logger (github.com/oraopensource/logger).
For those not using Logger, this talk is for you. It'll cover the basics of Logger, an open source PL/SQL logging tool. If you're already using Logger, this talk will cover new features and future plans.
This talk is suitable for both managers and developers as proper code instrumentation can significantly reduce development/debugging time and aid in production issues.
Oracle Developer Community Lunch and Learn: APEX Panel
When:
June 12, 2018,
Oracle Developer Community Lunch and Learn: APEX,
1:00 PM -
2:00 PM
Room:
Asia 1, Lobby/Third Level
Topic:
Application Express - Subtopic:
Other Application Express
ODTUG Kscope18 will feature an APEX Lunch and Learn panel with Oracle ACE Directors and Oracle ACEs, who are designated by Oracle Corporation as Oracle community enthusiasts and advocates. Many of these professionals are attending and speaking at ODTUG Kscope18. Eat a quick lunch from 12:45 - 1:00 p.m. in Pacific Hall B/C and at 1:00 p.m. join one of the information-packed sessions led by a panel of Oracle ACE Directors and ACEs. Bring your questions; these are the people who have the answers!
Martin D'Souza, Insum (Moderator)
John Scott, APEX Evangelists
Peter Raganitsch, FOEX GmbH
Karen Cannell, TH Technology
Vincent Morneau, Insum
The Many Ways to Get Your Data into Oracle Analytics Cloud
Co-Presenter: Tim Vlamis, Vlamis Software Solutions
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere A3, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
BI Analytics
Oracle Analytics Cloud (OAC) provides a powerful tool to get insight from your data, wherever it is. This session will describe the many ways to get your data into OAC, from enterprise data sources all the way to the humble, but mighty CSV file. What if your data is still on premises? No problem, OAC has a way to get your data securely into the cloud, or it can keep your data on premises and visualize it in the cloud. In addition, learn about the effective self-service data preparation capabilities of OAC. With real world context provided by Tim Vlamis from Vlamis Software Solutions, this session will cover everything you need to know.
Become an Analytics Lifecycle Superhero: Dramatically Reduce Your Time to Patch/Upgrade/Move to the Cloud!
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere E3, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
In this session, you will learn how to dramatically reduce your system testing costs by using a regression testing utility called the baseline validation tool (BVT). This tool enables you to plan your upgrades and execute patching and developer lifecycle more effectively across on-premises systems and the cloud. Attend this session for an overview of the BVT, including its testing capabilities, new features, and some real world application examples.
EPBCS/PBCS/Hyperion Planning 101: The Freshman-Level Intro Class
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere E3, Fifth Level
Topic:
Planning - Subtopic:
Other Planning
Are you considering PBCS or EPBCS for your budgeting and forecasting solution? Do you need to make a case to management to get away from all the spreadsheets? Do you want to avoid the sales hype and focus on real-life examples? This session will show some solutions; learn what works well and what might need some tweaks in the product. For example, learn about features that can be used to guide the user through the planning cycle or how the product can be used to implement rolling forecasts. Beyond the technical, learn about the project phases necessary to implement both the planning processes and the product to ensure the end state goal. Questions encouraged! Leave this session with a beginner’s knowledge of the product and how it could be used for your planning cycles.
Consolidating Large Critical Medical Databases with Minimum Downtime: A Story from Norway
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Oceanic 1, Lobby/Third Level
Topic:
Database - Subtopic:
DBA
This is the story of Norway’s largest health region consolidating nine critical electronic medical record databases, with a size of 100-150 TB and more than 15,000 users, into one database.
We will cover the methods and techniques applied to achieve the goal of a four-hour downtime window per consolidation round; existing techniques require more than 24 hours.
During the process, more than 700 tables had to be copied, while ID’s were replaced to avoid conflicts. The process must be executed in the correct order, with parallellity and speed.
We'll see how a 32-way join of 100 million rows replaced potentially 3.2 billion ID’s, and was done in less than five minutes, including transfer to the target.
This presentation goes through the challenges of the project, while also presenting solutions and explaining how Oracle Scheduler became a key component in handling several thousand PL/SQL procedures in order to simplify the process.
Introduction to Docker for Oracle DBAs — Containers? What Is It All About?
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
DevOps/Agile
Whether or not you've heard of Docker, if you are a DBA or DevOps still working with virtual machines, this seminar is a must for you. It will teach you how to empower yourself with Docker concepts for Oracle, MySQL DBAs, and DevOps.
The adoption of containers has been steadily increasing for many applications, and it is considered to be the next generation of virtualization technology as well as an ideal solution specifically for database environments.
Oracle Database Meets Docker: How to Get Started
Presenter: Anton Els, Dbvisit Software Limited
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Oceanic 5, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
Some might think Docker is only for developers, but that’s not really true. As with most things in the technology space, there are many use cases. In this session, let’s explore the world of Docker. Docker is here to stay, and we will see more and more of it in the future. In this session, we’ll start with some basics—what Docker is and how it works. Then, we’ll move to running a few examples of creating a database environment —perfect for testing, development, and possibly even production systems in the future.
RMAN, Oracle Database, and Multitenant
Presenter: Anton Els, Dbvisit Software Limited
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Oceanic 3, Lobby/Third Level
Topic:
Database - Subtopic:
Other Database
RMAN, as most know it, is one of the most important utilities in a DBA’s arsenal. It’s fair to say that in earlier releases it occasionally created havoc, and some DBAs were afraid to use it. Is it too complex? “Backup database” does not look too complex, does it? In Oracle Database 12c, Multitenant was introduced and RMAN’s exciting new options received a lot of attention. Whether you’re working with full to partial backups, cumulative or differential incremental backups, or image copies or backup sets, this session is for you. We will demonstrate how you can use RMAN to help protect your data and manage backup and recovery of your Oracle Database 12c Multitenant environment—including backups in cloud-based solutions.
Public Sector Financial Reporting is a Breeze with PBCS and EPRCS
Co-Presenter: Vince Tran, Vertical Edge Consulting Group
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Real World EPM - Subtopic:
EPM Case Studies
By now we know all about the wonders of EPRCS and PBCS. But have you seen how they are both utilized in the public sector? Join this session to learn how Bell County went from disparate Excel spreadsheets to a singular reporting platform, which provided one version of the truth. This allowed the county to successfully create their comprehensive annual financial report (like CAFR) by using Oracle Planning and Budgeting Cloud Services (PBCS) and Enterprise Performance Reporting Cloud Services (EPRCS)! Along with the case study, this session will include best practices for integrating EPRCS and a review of the latest features from the most recent update.
HFM and FCCS: Make the Future a Little More Known
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Asia 3, Lobby/Third Level
Topic:
Financial Close - Subtopic:
Hyperion Financial Management
Oracle has announced their roadmap for on-premise products and revealed a clear direction for cloud products. Many HFM (and a few Enterprise) customers might be wondering what they need to do now to plan for the future—whether that future includes working with HFM or an eventual move to FCCS. This session will cover various areas, helping attendees understand what should be done now and what to think about for the future.
Hands-On Lab: FCCS
When:
June 12, 2018,
Hands-On Lab,
2:15 PM -
4:30 PM
Room:
Europe 11, Lobby/Third Level
Topic:
Financial Close - Subtopic:
Other Financial Close
Attend this lab to get deeper, hands-on experience with FCCS, Financial Consolidations Cloud Service. Learn the ins and out of this product with live experience in the tool. Please note that your device needs to have one of the browsers supported by Oracle installed to attend this session.
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Oceanic 3, Lobby/Third Level
Topic:
Database - Subtopic:
DevOps/Agile
This session will delve into using an “infrastructure as code” approach to deploy and manage a Kubernetes cluster in the Oracle Cloud Infrastructure (OCI) with Terraform.
Kubernetes has become the go-to platform to manage and deliver solutions in the cloud. With all the power Kubernetes provides, it comes with a steep learning curve. With all the concepts to cover, it can be difficult to determine which parts are relevant and require attention when deciding to deploy a cluster into a cloud environment. In this session, I will explore the use of Terraform, a tool for building, changing, and versioning infrastructure safely and efficiently. I will also cover an Oracle project called Terraform-Kubernetes-installer
We will explore HA recommendations as well as tasks such as deploying and scaling up and down a Kubernetes cluster—all this with the ability to keep track of infrastructure changes though versioning.
New APEX 18.1 REST Enabled SQL Support: A Step Forward to Microservices Architecture for APEX Applications
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Application Express - Subtopic:
APEX New Release
A backing service is any service an app consumes over the network as part of its normal operation. Examples include datastores, messaging/queuing systems, and SMTP services for outbound email.
A microservices architecture is one that structures the application as a set of loosely coupled, collaborating services. Each service implements a set of narrowly related functions. For example, an application might consist of services such as the order management service and the customer management service.
I believe the introduction of components that support native declarative-like consumption of data and interaction with functionality over HTTP protocols in the APEX framework in version 18.1 benefits the adoption of distributed systems implementing the microservices approach.
In this session, we will review what is available in the new release of APEX in regards to microservices along with REST Enabled SQL Support. We will showcase the feasibility of having a completely distributed APEX utilizing microservices.
To showcase this case study, the audience will be guided through the process of building an APEX application that relies completely on external resources to provide functionality in a declarative way and deploying said application to a distributed infrastructure, having more than one instance of the UI service (the APEX application).
Chart Your Way to Success with Oracle JET Charts in APEX 18.1
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Asia 1, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX New Release
In this session, we will explore the extensive charting capabilities available in APEX 18.1, based on the Data Visualization components of Oracle JavaScript Extension Toolkit (Oracle JET). This JavaScript charting solution is highly customizable, accessible, and interactive, and incorporates automatic responsive design support. We’ll explore how you can take full advantage of the built-in declarative capabilities, and how you can utilize the JET JavaScript APIs to further customize your charts and make them fly with APEX 18.1.
Hands-On Lab: Building a Basic Demo Application Using Oracle Application
When:
June 11, 2018,
Hands-On Lab,
3:15 PM -
5:15 PM
Room:
Europe 6, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX Core
This one “double” session (over two hours) is designed to take you through building a comprehensive application using Application Express. The session is designed for people with no prior knowledge or very little experience developing with Application Express. You will learn how to develop a large number of different application components, and you’ll leave with a clear understanding and the confidence to start building your own applications using Oracle Application Express.
Oracle Jet vs. Oracle ADF or Oracle Jet with Oracle ADF
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Database - Subtopic:
ADF and MAF
Today the Oracle ADF community is concerned about the future of their beloved framework. It seems we hear more about JavaScript frameworks and toolkits, such as Oracle Jet, and less about Java EE tools like Oracle ADF. Should we learn Oracle JET and dive into the JavaScript world? This session is focused on these completely different approaches, clarifying whether Oracle Jet and Oracle ADF really do compete with each other. Come finally understand if you should switch from Oracle ADF to Oracle JET. We’ll explore situations in which Oracle Jet provides awesome features and when we should stick with Oracle ADF. You’ll also learn architecture patterns combining Oracle Jet and Oracle ADF for building modern enterprise applications.
When:
June 14, 2018,
Thursday Deep Dive,
9:30 AM -
11:00 AM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Database - Subtopic:
DB Dev
Today's agile applications have to deal with ever-increasing data volumes; rich varieties of data types with their associated intricate/flexibility requirements; and complex hybrid cloud-based environments, where critical high-volume transactional-based applications have to function in combination with equally important real-time advanced data analytics reporting solutions. As such, having an innovative data indexing strategy in combination with appropriate data-aware deployments is vital to ensure today's complex applications are high-performing, scalable, and robust. Many of today's applications struggle to perform or scale because they lack the necessary flexible indexing and data management strategies at the database layer. This session will demonstrate numerous innovative indexing-based tricks and tactics that will ensure applications run as efficiently as possible, regardless of the size or complexity of the underlying data management layer.
New Indexing Features Introduced in Oracle Database 12c Release 2
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Oceanic 5, Lobby/Third Level
Topic:
Database - Subtopic:
DBA
The recent Oracle Database 12.2 release has introduced a number of extremely useful new indexing features and enhancements. These include capabilities such as automatically tracking index usage, advanced index compression enhancements, deferred invalidation of cursors during index creation/rebuild, automatic index maintenance during new online operations (such as online table moves and conversion to partitioned objects), and JSON indexing enhancements.
In this session, these will all be discussed in detail with practical examples of how they can be usefully deployed to improve overall database performance.
Advanced Topics in EPM Cloud Infra and Security
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Asia 5, Lobby/Third Level
Topic:
EPM Infrastructure - Subtopic:
Cloud and Hybrid Infrastructure
Are you interested in the detailed operations of EPM Cloud infrastructure and security? This session will offer tips and tricks as we discuss various approaches to manage your EPM Cloud service. This is the place to learn about service automation, security insights, and best practices. The session is intended to further your understanding of EPM Cloud service administrators.
Fast Data Using Oracle Data Integrator with Spark Streaming and Kafka
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Oceanic 2, Lobby/Third Level
Topic:
Big Data & Data Warehousing - Subtopic:
Data Integration
Data—what is it good for? To discover actionable insights in your day-to-day business! But finding these insights can be quite a challenge in today's world, where both the quantity and the speed at which data is generated is higher than ever. Streaming and messaging provide the answer to these big and fast data challenges. Based on the success story of a large online payment company, you will learn how to leverage Spark Streaming and Kafka in Oracle Data Integrator 12c, which allow data to be transformed and streamed to multiple target consumers in real-time. We will explore how they made their transition as well as the lessons to be learned from their journey.
Adapting Data Vault 2.0 to Real-World Requirements
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Oceanic 3, Lobby/Third Level
Topic:
Database - Subtopic:
Database Design
A large community for data vault modeling exists. Many members of this community use and defend the method with almost religious vigor. Data Vault is a well-established method, especially since Data Vault supports standardized modeling, efficient data loading, and automation of loading process implementation.
But every project has individual requirements that don’t always fit a chosen design paradigm perfectly. This is also the case with Data Vault. Therefore, project teams often have discussions on whether one should adapt to requirements or implement the standard 100%.
This talk will present features of the current Data Vault 2.0 modeling standard guidelines (e.g. Hash-Keys); assess their suitability with respect to different DWH project requirements; and discuss how contradictions could be solved, which adaptations could be useful, and when they'd be justified.
Examples and experiences from real-life projects will be used to illustrate these points. A lively discussion is expected.
Assessment of the Autonomous Data Warehouse Cloud by an Early Adopter
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere A3, Fifth Level
Topic:
Big Data & Data Warehousing - Subtopic:
Other Big Data and Data Warehousing
Since the beginning of 2018, Oracle, Amazon, and Snowflake have been providing a fully managed data warehouse service in the cloud. While Amazon Red Shift and Snowflake are examples of new contenders in the marketplace, Oracle is a well-established vendor. While the newest players have built fresh engines expressly for the purpose, Oracle did it differently—by adapting its flagship database engine to do the trick. The service itself is running on Exadata hardware in the Oracle Cloud.
During this presentation we will assess Oracle's service based on experience with the preview program in 2017 and early projects completed using the final product in the winter/spring of 2018. We will discuss lessons learned, the services sweet spot, and limitations. Moreover, we will compare AWDC to other managed DWH cloud services. This will illustrate the advantages for AWDC customers, but will also help identify opportunities for improvement in subsequent AWDC versions.
Increasing Controls, Validations, and Data Integrity for HFM
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere A4, Fifth Level
Topic:
Financial Close - Subtopic:
Hyperion Financial Management
Come see how General Electric has leveraged the EPM suite of products to provide a self-governing dataset for seamless, accurate, and reduced financial close. We start with an extensive DRM set of definitions; add FDMee integration; build expanded HFM metadata, business rules, and financial reports; and wrap it all together with a lights-out automation & notifications solution. You too can increase your peace of mind during the financial closing cycle.
DRM defines the parameters for which these edits execute, while FDMee and HFM deliver the business rules. FDMee drives data integrity checks, HFM delivers control and process governance, and Automic automates and provides notifications. Financial Reports offer dynamic drill-through capabilities for business users to navigate to the level of detail that the edits require.
We will explore each component of the solution, review DRM property definitions, look into a sample of FDMee scripting, and walk through the end result analysis and reporting capabilities, which are offered to the functional team.
Predictive Analytics for HFM
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Oceanic 4, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
EPM Industry Topics
Come see how General Electric delivers predictive analytics to support their financial close. An interactive dashboard combines information gathered from all aspects of the HFM financial close, delivering insights on how the applications are performing in the present state and how they will perform in the future. It is built on an Oracle database with intelligent SQL-based algorithms and delivered through an OBIee dashboard. A powerful set of interpretive rules marries demographic intelligence from the application’s metadata and data layers with event-driven messaging and operational performance in order to deliver an application assessment that addresses the current and future health state of the application.
This presentation might also fit into the "Real World EPM" track.
10 Things You Can Do Today to Improve Your Planning Application
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere E3, Fifth Level
Topic:
Planning - Subtopic:
Design
Do you ever ask yourself if there are some simple things that you as a functional admin can do to improve your application? Are any of them simple to implement? Will they fit your application? The answer is yes. In this session, I will show you 10 things I do to improve the user and admin experience in most of the applications I build.
Hands-On Lab: PBCS and EPBCS Beyond the Basics—New Features, Tips, & Advanced Functionality
When:
June 11, 2018,
Hands-On Lab,
1:15 PM -
3:15 PM
Room:
Europe 10, Lobby/Third Level
Topic:
Planning - Subtopic:
Other Planning
Oracle's Planning solutions in the cloud are continuously innovative, constantly providing new capabilities. This session will offer insights into the latest and greatest features. Join Peloton as we explore the lesser-known corners and advanced functionality available in these tools. From infolets to navigation flows, job scheduling, and more—Peloton cloud experts will show you how to get the most from your PBCS and EPBCS investments.
Upgrading to the Cloud: Tales from the Battlefield
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Oceanic 3, Lobby/Third Level
Topic:
Database - Subtopic:
DBA
Every Cloud migration project has its share of unique challenges. Since businesses demand as little downtime as possible, the strain of a migration can be minimized if the team is informed about existing mechanisms and tools before a project begins. This project had tight timeframes, large databases, database upgrades, and the CLOUD. The session is a real use case scenario, demonstrating the challenges and successes of migrating numerous large (>10TB) databases from on-prem to the cloud. This session will discuss the tips, tricks, and solutions that enable a team to overcome challenges when failure is not an option. It will help any implementer or project to navigate the Cloud Migration river, while avoiding the rapids.
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Oceanic 2, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
EPM Processes and Management
This session will provide insights, tips, and techniques on using the Oracle EPM Automate tool to automate movement of metadata and data for Hybrid Environments and between Cloud Pods (e.g. Enterprise Planning and Budgeting Cloud Service (EPBCS) and Profitability and Cost Management Cloud Service (PCMCS) applications).
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Northern Hemisphere E3, Fifth Level
Topic:
Planning - Subtopic:
Planning Cloud
This session will discuss how Sims Metal Management, a world leader in metal, electronics, and curbside recycling, implemented the Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) application to satisfy their forecasting and budgeting needs. The solution uses a Hybrid architecture, in which on-premises Financial Data Management Enterprise Edition (FDMEE) is used for data integration, for loading from source systems to EPBCS, and to integrate post forecast data with on-premises Hyperion Financial Management (HFM).
Drinking Our Own Champagne: Oracle Analytics Cloud at ODTUG
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Asia 4, Lobby/Third Level
Topic:
Essbase - Subtopic:
Essbase Cloud
Tim German and Opal Alapat
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 as well as content review team alignment with attendee objectives
--Our ongoing effort to expand the reach of our analyses in order to cover areas such as footfall, marketing, and membership and attendee demographics
--Our practical experience configuring, maintaining, and developing on the OAC platform
Oracle Analytics Cloud for the Finance Analyst
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Essbase - Subtopic:
Essbase Cloud
Tim German and Kevin McGinley
Finance analysts have long depended on Essbase and Excel as their primary analytical tools. With the arrival of Oracle Analytics Cloud (OAC), analysts have gained both an easier means of spinning up and developing “personal” Essbase models from Excel and the capability to add sophisticated visualizations via Data Visualization (DV)—bundled with all versions of OAC. In this session, we’ll take a real-world look at how users can begin to build and refine their own cubes from Excel and how they can share them with others. We’ll then explore using DV to present data from these and “enterprise” applications in more intuitive ways.
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Essbase - Subtopic:
Administration
Metadata management is a challenge in complex environments, as there are constant changes. If the metadata process is not built in a robust and dynamic way, you will end up having a lot of extra work every time the business changes.
One of the best ways to maintain metadata on ASO cubes is using ODI, which allows great flexibility in order to create real complex enterprise ETL processes. But if you use ODI in its standard way, you will end up having multiple similar ODI objects because each ASO application/dimension is tied to a particular ODI data store. In other words, the higher the number of ASO applications, the more ODI objects, increasing the possible failure points and code reworking if something changes. This would cause us to lose a lot of time, money, and trust in those systems.
This case study describes how to implement a smart EPM environment that uses Oracle Data Integrator with Oracle Essbase, so that you can take full advantage of its potential. This session will show how to create dynamic processes that change automatically for any number of Essbase applications, allowing metadata maintenance to meet the business needs with low development costs.
How to Use Your Existing ODI On-Premise to Seamlessly Integrate PBCS
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
EPM Data Integration - Subtopic:
Other EPM Data Integration
Oracle Cloud services products, including Planning and Budget Cloud Service (PBCS), enables companies to focus on their own business instead of spending money and resources on maintaining big IT infrastructures. It also gives them the possibility to be connected 24x7 from any place in the world.
But what happens if this company already has an ODI on-premise infrastructure and they want to integrate the new PBCS with it? Can we use our existing ODI on-premise? How hard is to accomplish this?
This session will show how to use your ODI on-premise to integrate and orchestrate your PBCS seamlessly.
Lifting the Hood on OAC
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Essbase - Subtopic:
Administration
How does this Oracle Analytics Cloud work anyway? Since OAC is a platform as a service offering, unlike the EPM cloud applications, it requires some infrastructure administration. This session has the information you need to know about backups, patching, and managing your OAC service. Essbase in OAC is also a little different than the on-premises versions. Come to this session to hear a technical perspective on the changes to Essbase, and learn how to administer it on the cloud.
Developing APEX Apps in 2018
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Application Express - Subtopic:
APEX New Release
How we develop with Oracle Application Express has evolved over time. We now need to focus on the mobile aspect and optimize our workflow as much as possible, as we are in the low code decennia.
In 2017 I did a series of blog posts about building the mtable.online game in Oracle Application Express (APEX). In this presentation, I will review those posts as I take you on the journey of how you can develop APEX apps today. We will cover quickSql, Blueprint, APIs, and other tips and tricks that can help you build modern applications.
Bringing Virtual Reality (VR) and Augmented Reality (AR) to APEX
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Application Express - Subtopic:
APEX Integration
This is the first ever 3D APEX presentation. You will receive a Google Cardboard to follow along as I introduce the concepts of the WebVR, WebAR API, and the newer WebXR API. I will also showcase the first Mixed Reality Oracle APEX app.
Mixed Reality (WebXR) is designed to allow web developers to easily create web applications that adapt to the capabilities of each platform. These examples run in WebVR- and AR-enabled browsers.
Maybe you don't use Mixed Reality just yet in your apps, but I'm sure in the future you will. Either way, this presentation will be fun!
DevOps with Oracle Database, APEX, BI, JET, and Oracle Cloud—Game Changers!
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Database - Subtopic:
DevOps/Agile
Demand for innovation and faster software delivery drove Schreiber Foods to extend their Oracle implementation with new processes such as DevOps and Continuous Delivery. Schreiber applied these processes across a broad technology base including Oracle DB, APEX, JavaScript Extension Toolkit (JET), Oracle REST Data Services (ORDS), BI, E=Business Suite, and Cloud. The session will provide a before-and-after overview, which will highlight the improvements in productivity, quality, and speed of software development and operations.
Deep Dive: Last Minute ODTUG Kscope18 Planning Souvenirs You Will ACTUALLY Use!
When:
June 14, 2018,
Thursday Deep Dive,
9:30 AM -
11:00 AM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Planning - Subtopic:
Other Planning
As we say goodbye to Disney World, wrapping up another amazing ODTUG Kscope conference loaded with the best content around, I’m sure we’ll all be going home with quite a few souvenirs (probably plenty of T-shirts and Mickey Mouse ears).
But before you zip up your bags and head to the airport, come join our Planning track deep dive session as some of the best Planning experts in the EPM world share tips and tricks you can immediately implement in your systems back home! A variety of speakers will share a wide range of “quick and dirty” tips, tricks, solutions, and inventions that any system administrator could implement in their own systems. These “souvenirs” are the ones that you can take back to your office and put to good use, so don’t forget to stop by and check them out. You don’t want to leave Orlando without them!
Andy Tauro, Performance Architects
Jon Harvey, eCapital Advisors
Kyle Goodfriend, Huron Consulting Group
Ask the Experts - Planning Panel
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Planning - Subtopic:
Other Planning
Please join us to have an open discussion with experts in the Planning community. Bring your outstanding questions about Planning, on-prem or on the cloud.
Shankar Viswanathan, Oracle Corporation
Mark Rinaldi, Oracle Corporation
Oracle ACE Associate, Jon Harvey, eCapital Advisors
Kyle Goodfriend, Huron Consulting Group
Top-Down and Bottom-Up Planning at Breakthru Beverage Group
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere E3, Fifth Level
Topic:
Planning - Subtopic:
Planning Cloud
Planners are always looking for real-time reporting and quick feedback. They are looking to make the forecasting and planning process faster by using historical trends, entering data at any level, entering growth factors, and driving the results down to the lowest level of the business. They want instant feedback on consolidated results.
This session will highlight a customer success story about using PBCS. This session will walk through the strategic benefits of building a driver-based budget and forecasting application with the ability to seed SKU level data and apply growth rates at any level of a product or organization in order to effectively build a bottom-up plan. The session will also discuss the work force planning application, which includes the ability to allocate people over multiple cost centers and companies. We will also cover the technical architecture and strategy necessary, which allow integration with the higher-level P$L in real time. The presentation will feature live demonstrations.
Attendees will leave this session with a grasp of the business solutions and strategic benefits of building a plan from historic trends. They will also gain a complete understanding of the technical architecture, the benefits of Groovy calculations, and how to implement a similar solution.
Why Groovy is Game Changing
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Northern Hemisphere E3, Fifth Level
Topic:
Planning - Subtopic:
Planning Cloud
Groovy is a game changer. It improves performance, allows for proactive user validation, and can interact with the user in ways we haven't been able to since the introduction of SmartView.
This session will provide an overview of Groovy functionality, including topics such as mind-blowing performance improvements, how to interact with the planners, pre form save validation, and changing the form visuals. The session will cover the basics of Groovy from start to finish with interactive code reviews and live demos.
Attendees will leave this session with the knowledge and examples that will enable them to implement Groovy calculations in their own environments, allowing them to take advantage of groundbreaking advancements in the technology. These scripts improved calculations, data pushes, and consolidations by 98% in a real client applications.
Demystifying Data Warehousing as a Service
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Oceanic 2, Lobby/Third Level
Topic:
Big Data & Data Warehousing - Subtopic:
Other Big Data and Data Warehousing
Kent Graziano, Presenter
We’re all aware that as data warehouses are rapidly changing so to are the best practices associated with them. As organizations build new data warehouses and modernize established ones, they are turning to Data Warehousing as a Service (DWaaS) with hopes of taking advantage of the performance, concurrency, simplicity, and lower cost of a SaaS solution. This can also allow them to reduce their data center footprint, in turn cutting maintenance costs as well.
But what is a DWaaS really? How is it different from traditional on-premise data warehousing?
Everything You Need to Know About Oracle 12c Indexes
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Oceanic 1, Lobby/Third Level
Topic:
Database - Subtopic:
DBA
Indexes are an important consideration for optimal performance in every Oracle database. However, with each new release there is an incredible amount of new features and/or changes, which can impact how Oracle indexes function and are maintained. This often results in many applications running inefficiently. In this presentation, Janis Griffin, a database performance evangelist at SolarWinds, will review current Oracle index structures/options and discuss how they work, when they should be used, and how they should be maintained. Examples will explore using new index features such as multiple indexes on same column, partial indexes for partitioned tables, and advanced/prefix index compression.
This presentation is a must see for DBAs, developers, application architects, and anyone else interested in maintaining high performance Oracle-based applications.
Oracle 12.2—My Favorite Top Five New or Improved Features
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Database - Subtopic:
DBA
Oracle 12c (12.1) has been out for quite a while now, but it wasn’t until March of 2017 that Oracle 12.2 became available to the public for download. In this presentation, Janis Griffin, a database performance evangelist at SolarWinds, will deep dive into several of the new features she considers some of her favorites. Attendees will learn about enhancements to the In-Memory option, Multitentant (PDB) improvements, new partitioning capabilities, the new sharding feature, and more. Along the way, Janis will demonstrate the many uses and best practices of utilizing these features. This presentation is a must-see, especially for those planning to upgrade soon to 12.2.
Enginatics: Take Yourself Out of the Stone Age: Meet Blitz Report - The Ultrafast SQL to Excel Export for the EBS
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Oceanic 2, Lobby/Third Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
Did you ever want to get quick, efficient MS Excel reporting from the EBS Applications? Without massive MS Excel/XML files that take forever to open? Without eons of IT development/formatting time to create? That fits seamlessly inside your Oracle menus using native Oracle Forms? And does not cost an arm and a leg? Come and learn about Blitz Report from Enginatics, the easiest and quickest way to export Oracle EBS information into MS Excel.
At the end of the session you will:
• Know how to create reports from scratch, and how to maintain, improve, and even transform existing reports using Blitz Report.
• Experience how to use Blitz Report as a powerful toolbox for performance tuning and system administration/IT support
• Observe first-hand Blitz Report’s ultrafast export performance for big datasets.
• Understand how Blitz Report will drastically improve your business operations.
The presentation is suitable for Business Analytical consultants, DBAs, and non-DBAs alike.
Incorta: How Shutterfly Optimized Its Supply Chain with Real-Time Oracle EBS Data
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere E3, Fifth Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
Learn how Shutterfly, Inc. is bypassing traditional ETL and data warehousing methods by leveraging Incorta’s innovative Direct Data Mapping engine to enable real-time reporting on its complex business data.
In this session you’ll learn:
- How to spend less time manually running and combining reports for Oracle EBS, so that you can spend more time understanding key data insights.
- Why Shutterfly’s Vice President of supply chain Josh Miller calls Incorta’s no-data-warehouse analytics “the greatest thing since sliced bread.”
Getting Started with Groovy and EPBCS
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Planning - Subtopic:
Planning Cloud
So you’ve heard about Groovy, and you know about some of the cool things you can do with it in EPBCS. But how do you get started? Is it only for programmers? This session will explore writing Groovy business rules, making the process approachable for anyone who is new to it or hasn’t written code before.
Maybe you haven’t heard about Groovy. Did you know that you can add a member on the fly, execute a rule only for dirty cells on a data form, or perform enhanced data validation? You can do all of these and more with Groovy business rules, solving for use cases that standard business rules just aren’t sophisticated enough to handle. Lots of code samples will be provided to help get you started on your own Groovy journey.
Mastering MDX for Analytics and Reporting
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Asia 4, Lobby/Third Level
Topic:
Essbase - Subtopic:
Other Essbase
MDX is often used in ASO cube member formulas, but did you know that it can also be used to write reports and Smart View queries? Did you know that these reports and queries can be written against both BSO and ASO cubes? MDX can seem daunting, but once you have a basic understanding of syntax and functions, MDX is not particularly difficult. This session will provide what you need to get started writing the MDX reports and queries that can supplement your reporting, adding a new tool to your reporting tool set.
ASO Plan Type: ASO Allocations & Calculations at Warp Speed
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Asia 4, Lobby/Third Level
Topic:
Essbase - Subtopic:
Calculations
In this session, satisfy the Vulcan in yourself as we explore the syntax and concepts of the methodologies that improved the calculation efficiency of the Leidos ASO Planning Application by 30x–60x in 2017! These methods enhance the genius Joe Watkins idea of using ASO allocations to write results of member formulas by applying refinements for optimization. The methodologies and syntaxes covered will include P.A.M. (Point-of-View Adaptive Method), N.E.O. (NonEmpty Subset Optimization), Z.A.C. (Zero Allocation Clears), and P.A.S. (Planning Allocations Synchronously). Learn the syntax that can also take your Enterprise ASO calculations to warp speed!
External Tables—Not *Just* Loading a CSV File
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Oceanic 5, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
External tables are a way to map data from files in the OS to columns in a RowSource—in effect allowing you to select directly from a file. This can be useful in many ways, allowing you to, for example, join the external data to look up tables in the database. It also lets you use the complete range of SQL syntax and functions to transform the external data if needed.
From version to version, Oracle database has added functionality to the external table, so it is now capable of so much more than simply loading a CSV file. You can load data from flat text files, from binary DataPump dump files, from HDFS (Hadoop Distributed File System), or from Apache HIVE. You can even do a limited unloading to a DataPump dump file. You can have the loading process perform an OS preprocess call; for example, unzipping will allow you to load from a compressed file.
Oracle 12.2 also provides the ability to add certain metadata to the external table, which is useful for the optimizer. You can define constraints (primary key, referential, unique, not null) for the optimizer to trust and rely on, and you can define partitions to allow partition pruning to read only the necessary files of a multi-file external table.
This presentation will discuss the various possibilities and will show examples of syntax and use cases for the various access drivers: ORACLE_LOADER, ORACLE_DATAPUMP, ORACLE_HDFS, and ORACLE_HIVE.
When 7-bit ASCII Ain't Enough: About NLS, Collation, Charsets, Unicode, and Such
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Oceanic 5, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
Life as a DB developer would be much easier if the entire world was happy with A-Z in upper and lower case. However, the globalized world is a very diverse place with myriads of special characters, modifiers, different alphabets, writing directions, sorting and comparison rules, and many ways to encode these characters. Your database and application absolutely need to know about these things in order to handle them correctly. Otherwise you'll find your app displaying garbage or worse, storing it.
Oracle database offers many NLS (National Language Support) settings to handle such globalization on the database, instance, and session/client level. NLS functions are available in the SQL language; they handle specific cases with code when the session settings aren't granular enough. Oracle 12.2 added collation support, which allows you to specify right down to the column level how columns should sort and compare values. You can choose whether to store everything with database character set UTF8 or stick to a single-byte character set. In either case, be aware of how conversion occurs if the client is not using the database character set.
This presentation will discuss many of the potential issues and how to use NLS and collation to avoid them. We’ll show pitfalls in which you can get mangled (or even invalid) data stored if you are not careful.
3D: Docker for Database Developers
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Application Express - Subtopic:
Other Application Express
This session will briefly cover Docker basics, after which we will dive in into the more intermediate use of Docker.
We will walk through the following subjects:
- What is Docker
- Images, containers, and basic concepts
- Creating and/or modify images
- Using Docker Compose to define multiple dependent containers
- Running multiple ORDS instances and a load balancer
- Using Docker Swarm
- Putting it all in the cloud
Benefits of Developing APEX Applications on the Exadata Express Cloud Service
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Application Express - Subtopic:
Other Application Express
"When you develop an APEX application, it doesn't matter if the database is in the cloud or on premises." This statement is heard often, but it is not entirely true.
When your database is in the Oracle Cloud, there are some things that you should consider. Part of the Oracle Database Cloud is the Oracle Developer Cloud Service. Since it has a lot of baked-in goodies, such a Build server, Code repository, and even SQLCl for your own scripts, why not take full advantage of it?
In this session we will show you how to set up your development environment with Oracle Database Exadata Express Cloud Service, Oracle Developer Cloud Service, Oracle SQL Developer, GIT, and all other bits and trinkets that we used for a recent project.
Hybrid Hacks: Tips and Tricks for Common Hybrid Issues
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Essbase - Subtopic:
Design and Optimization
Hybrid Essbase is the greatest thing to happen to on-premise EPM in the last decade; perhaps it’s even the greatest thing since sliced bread. However, this doesn't mean it's not without challenges.
In this session, we'll talk about common issues encountered in Hybrid implementations. We’ll discuss potential workarounds and the benefits and drawbacks of each approach. Using real-life Hybrid projects—one at a communications company and one at a medical device manufacturer—we'll explore the issues encountered, the innovative strategies employed to address these issues, and the results, with some caveats.
Can You Have Your Cake and Eat It, Too? Yes! A Client Success Story on a Complete Organizational Transformation Using ERP Cloud and FCCS
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Oceanic 4, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
EPM Case Studies
Using the state of the art ERP Cloud, FCCS technology, and proven methodologies, SC&H empowered one of its clients to shift from a high-risk manual close process to a transparent and accurate cloud-based close process within four months. In this presentation, we will walk through the entire success story, demonstrating how an organization can rapidly transform all of its accounting and finance functions by implementing ERP Cloud and FCCS. We will also cover additional details, including the key challenges and lessons learned throughout the process.
Automate SQL with Method5 Open Source Remote Execution
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Oceanic 1, Lobby/Third Level
Topic:
Database - Subtopic:
DBA
Learn how to easily run SQL, PL/SQL, and shell scripts on a large number of databases and hosts with the open source program Method5. Remote execution is not just faster, it's a process that lets you find, fix, and prevent many problems that you would never solve addressing one database at a time. It starts as simply as SELECT * FROM TABLE(M5(p_code => 'SELECT * FROM DUAL', p_targets => 'DEV')); and can grow to solve many complex tasks.
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Oceanic 4, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
EPM Industry Topics
Should you stay or should you go? Let’s get to the guts! Oracle EPM customers have many options when considering the cloud. Whether you are looking to fully jump into a complete subscription-based platform or simply want to dip your toes into a hybrid model, many serious factors can influence your decision. Join us as we walk through a complete decision-making process for evaluating which cloud model is right for you. We will get to the guts of what is actually offered and the realities of software-as-a-service, public infrastructure-as-a-service, and private managed cloud vendors by looking at services, security, flexibility/control, data integration, and overall costs.
Design Your Databases Straight to the Cloud
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
Database Design
Everybody is talking about the cloud. How does the cloud change your work as a database designer? What should you know and what new things should you learn? In this session, learn about these concerns and design a small database to the cloud using Oracle SQL Developer Data Modeler and Oracle SQL Developer.
Database/APEX Sunday Symposium: Make AppDev Fun Again, with the Oracle RAD Stack
When:
June 10, 2018,
APEX/Database Sunday Symposium Session 1,
9:00 AM -
10:15 AM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Application Express - Subtopic:
Other Application Express
The RAD Stack approach incorporates everything you need for a successful business application. This includes REST, today’s dominant architectural style and agreed-upon method for tying applications together; Oracle Database, the fastest and most versatile database in the world, available for free or for Enterprise installations, on-prem, or in the Oracle Cloud; and Application Express—the fastest way to build responsive, flexible, and durable web applications for the Oracle Database.
Let’s Take a Look at Essbase in the Cloud
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Oceanic 2, Lobby/Third Level
Topic:
Essbase - Subtopic:
Essbase Cloud
Essbase in the Cloud was released almost a year ago. It’s time to take explore how it can replace, enhance, or serve the same role as your current on-premise Essbase environment. In this session, we’ll take a thorough look at Essbase in the Cloud. We’ll cover the differences between on-premise Essbase and the Cloud offering; what you’re getting; what you’re giving up; best practices for working with Essbase in the Cloud, particularly if you are running a Hybrid EPM Solution; plus tips and tricks for how to make the most of Essbase in the Cloud. This session will also include a review of features such as calculations, currency conversions, sandboxes, and other important things to know in order to get started. It will also include some real-world examples. You will leave with a clear understanding of how to work with Essbase in the Cloud, ready to take advantage of all it has to offer.
Daily Revenue Reporting in a Flash with Essbase ASO: A Case Study with TopDown Consulting & Quantcast
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Essbase - Subtopic:
Design and Optimization
Join TopDown Consulting principal architect, Paul Hoch, and Quantcast senior financial systems administrator, Anthony Leonardini, in this dynamic session. You'll learn how building a large ASO reporting cube eliminated manual processes and provided separate reporting results that included the ability to refresh the data any time in order to capture different analytics, depending on reporting requirements.
This session will cover:
• How we built analytic dimensions and reporting metrics
•How we used ASO persistent calc scripts to plug/tie revenue between reported financial results and data warehouse raw revenue data
•How we automated the cube with both dimension building and data loading
•Additional dimensions for more granular data and advanced analytics (e.g. multiple years of data; the ability to compare data for one day on a weekly, monthly, yearly, or multiple year basis; the ability to compare different days, weeks, and months; and more)
•How we used SQL load rules against their Data Warehouse to quickly refresh and reload large volumes of data at a moment’s notice
Attendees will leave with a concrete understanding of how to make ASO cubes work in any reporting situation.
Five Habits to Increase Your Oracle EPM IQ
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Oceanic 2, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
EPM Processes and Management
“I just don’t know what I don’t know about my EPM product!” Maybe you’ve felt the same when asking yourself, “Can my product do this?” The key is you just don’t know—YET! During this session, I may not tell you exactly what you “don’t know,” but I can definitely provide five key habits that will increase your Oracle EPM product IQ by leveraging readily available resources, documentation, free content libraries, blogs, newsletters, events, webcasts, people, training, subscriptions, social media, and so much more. Through some of the tips I provide, you will become aware of those things you “don’t know” yet, allowing you to stay current on your EPM product knowledge and maximize the benefit of your product investment. Come check out some great ways to stay “in the know” about your Oracle EPM products.
SC&H Group: From FTE to ROI: Building a Custom Oracle PBCS Application to Go Beyond Finance
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
As a healthcare analytics organization that thrives on data-driven decisions, our client had a gap in their forecasting and planning outside of finance and accounting—operational staffing. Their ultimate goal was to plan full-time
employee (FTE) staffing, and use this data to drive timely, geographical hiring decisions.
With EPBCS and Workforce Planning in place, we rolled out a custom PBCS application acting as a weekly workforce capacity and demand model for their Workforce Management team. This model empowered the
organization to extend forecasting into operations—using it to identify and resolve gaps in staffing and strengthen their ability to connect the dots between workforce demand, capacity, FTEs and revenue targets. Some of the more technical details include:
● Able to model and forecast FTE requirements based on volume on a weekly basis
● Workforce capacity calculations
● Model the variance between FTEs required and FTEs available in given regions
● Able to update key assumptions for what-if scenarios of staffing changes
● Consolidate 100s of Excel sheets into a centralized data source
This non-traditional PBCS implementation brought data-driven decision making beyond finance, and empowered operations to make more informed decisions and take control of their resources and revenue.
Exploring the Details of APEX Sessions
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Application Express - Subtopic:
APEX Core
A session is one of the main features of APEX. It establishes a stateful behavior across pages for each user. Usually, we take a session for granted, but knowing how sessions work in detail can be useful when debugging errors. How does APEX secure and validate a session and its items? We will examine what happens between the creation and destruction of a session and how you can interact with it.
There are some important differences to consider when assigning a value to an item via Automatic Row Fetch, Computation, Source, or Default value. We all struggle with these things from time to time. Also, what happens exactly when you submit a page for page processing?
Have you ever heard about a 32k limitation in APEX? We’ll go into detail on clearing out the exact problem and how to deal with CLOBs.
The latest APEX releases have introduced additional features like asynchronous page submits, rejoin session, and session cloning. We’ll take a look at how these things work and the possible consequences for our applications.
This presentation will be of value for both beginners and experienced APEX developers.
Customizing the Interactive Grid with Plugins
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Asia 2, Lobby/Third Level
Topic:
Application Express - Subtopic:
Other Application Express
Do you have requirements for your APEX applications that cannot be fulfilled using the declarative options of the Interactive Grid? Join this session to explore the issue and view solutions in live demonstrations.
The interactive grid has quickly become the number one component in most APEX applications. Although APEX 18.1 continues to extend its capabilities, JavaScript customizations will always be necessary.
After exploring API, you will better understand the underlying architecture and you’ll be able to build superior applications and speed up development. You might even start to think like an Interactive Grid!
Learn how can you turn hundreds of lines of JavaScript Initialization Code into plugins. You will see a collection of plugins, which will make doing your advanced customizations a piece of cake.
Public Sector Automated Narrative and Financial Reporting
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Northern Hemisphere A1, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
This session will include an in-depth overview of financial reporting best practices and a discussion of fully automated EPM and reporting solutions. This will enable public sector organizations to more effectively and efficiently print annual consolidated financial reports alongside narrative.
Deep Dive: From Zero to Bot (and Much More) in Less Than 90 Minutes
When:
June 14, 2018,
Thursday Deep Dive,
9:30 AM -
11:00 AM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Database - Subtopic:
DB Dev
As one of the hottest technology fields in 2018, chatbots enable enterprises to engage users in the easiest user interface available—a natural language conversational user interface. Rather than having to access/download/learn to use apps, end users simply start chatting with chatbots, as chatbots act as a digital assistant that can perform a variety of tasks.
In this (almost) zero-slide session, we will walk through developing a chatbot with Oracle Intelligent Bots from start to end. And we will help you access temporary accounts so you can even follow along with us. This session provides valuable insights to chatbot development and is well suited for developers of all backgrounds!
A Cautionary Tutorial: Learn the Basics of SQLMAP to Show How a Single SQL Injection Vulnerability Can Lead to a Major Data Breach
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Asia 2, Lobby/Third Level
Topic:
Application Express - Subtopic:
Other Application Express
Apply basic hacking techniques to show your clients how a single SQL Injection vulnerability can be very dangerous. There's nothing like a simple SQLMAP attack to convince even the most skeptical clients to take these "small" security flaws seriously.
Use Docker to Localize Your Dev Environment and Eliminate Version Control Headaches!
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Application Express - Subtopic:
Other Application Express
Are you tired of co-workers accidentally overwriting your code? What about faulty VPN connections, restrictive wifis, and unreliable remote servers? Docker, in combination with git, solves these problems by empowering you to clone your dev APEX/DB environment locally. We'll do a demo, sharing best practices within an Oracle db 12c, NGINX, and APEX 5.1.4 environment. You'll wonder how you ever survived without Docker.
AMC Theatres: Expanding DRM and DRG to 12 Foreign GLs
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
EPM Data Integration - Subtopic:
Metadata Management/Integration
After two international acquisitions, AMC Theatres has recently become the largest movie theater chain in the world. Join us to learn how, in a matter of months, AMC integrated their domestic DRM and DRG application with 12 foreign GLs, many of which are cloud-based or hosted solutions. This solution allows all foreign DRG users to maintain their local COAs while mapping to the domestic reporting structure. We will also discuss the definition of new governance processes; hurdles of integration with multiple diverse systems; and challenges of foreign encoding, language, and culture.
Advanced Automated Browser Tests with APEX
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Application Express - Subtopic:
Other Application Express
This session will look more closely at how APEX developers can use Test Driven Development and Data Driven Testing to improve the quality of their APEX applications. The session will also cover how to call the automation scripts programmatically and run them on a load-testing environment or as part of an automated build process (aka continuous integration). For maximum benefit, attendees should have prior experience with automated browser testing or have previously attended an APEX Test Automation Framework presentation.
10 More Ways to Secure Your APEX Application
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Asia 2, Lobby/Third Level
Topic:
Application Express - Subtopic:
Other Application Express
So...you’ve hardened your environment, locked down your application, and installed the latest Oracle security products; but is there more you should be doing? See ten more ways to secure your APEX application you may not have considered.
Planning Ad Hoc vs. Essbase Ad Hoc: How They Differ and Why You Should Care
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere A2, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Ad Hoc Reporting
If you are planning to upgrade from on-premises Hyperion Planning to EPBCS, you should know that users who built Smart View reports with an Essbase ad hoc connection will be required to rebuild nearly all of those reports using the Planning ad hoc connection. The differences between Planning ad hoc and Essbase ad hoc may seem small, but they are significant enough to frustrate users who have not been sufficiently trained. The good news is that Planning ad hoc includes features which users will enjoy. In this session, you will learn the key differences between the two and how to adequately prepare your users for the transition.
Docker & Essbase: Bring the Cloud to You
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Asia 4, Lobby/Third Level
Topic:
Essbase - Subtopic:
API and Related Tools
Docker is a modern technology for rapidly deploying and containerizing servers both on-premise and on the cloud. This presentation will introduce the Docker technology in a practical way, exploring interesting Essbase/EPM use cases in which Docker can be used to open up and enhance infrastructure, development, and testing in EPM organizations of any size.
Up & Running with the OAC Essbase REST API
Co-Presenter: Tim Tow, Applied OLAP, Inc.
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Essbase - Subtopic:
Essbase Cloud
The Oracle's Essbase Cloud offering introduces a new and modern REST API in addition to its traditional Java API. The new REST API opens up many development, integration, and automation capabilities and differs greatly from the traditional API. This session will introduce the REST API, exploring how it's similar to and different from traditional APIs. We’ll also cover some real world examples and how to get started with development.
Universal Theme: Understanding Core Technology and Lesser-Known Features
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Asia 1, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX Core
The Universal Theme provides a plethora of tools to quickly build sleek and responsive applications. For more complex applications, you may want to either manipulate the page to perform certain actions or adjust the display. In this session we will explore custom responsive breakpoints, the underlying CSS principles of UT known as BEM, and the theme42 module for custom JavaScript components.
Event-Driven Applications Using Custom JS Events
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Asia 2, Lobby/Third Level
Topic:
Application Express - Subtopic:
JavaScript
Have you ever wanted to have the same dynamic action fire for different events if the user clicks a button or presses enter? Out of the box, it appears that APEX cannot handle this situation. However, there is a very simple solution using custom events and event emitters in JavaScript.
APEX Sunday Symposium: State of the Union
When:
June 10, 2018,
APEX Sunday Symposium Session 6,
4:30 PM -
5:30 PM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Application Express - Subtopic:
Other Application Express
One of Joel Kallman's favorite quotes is, "When our customers and partners are successful, we're successful!" One of his passions in life is serving Oracle customers, helping them to be successful with the Oracle Database, Oracle REST Data Services, and Oracle APEX. He also enjoys celebrating their success. In this State of the Union address, Joel will present the successes and challenges from the past year, and what to expect from Oracle and the APEX community in the exciting year ahead.
Real World Blockchain Demos
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Oceanic 7, Lobby/Third Level
Topic:
Breakout with Blockchain - Subtopic:
Arun Kanchi, Presenter
This session includes the following:
A live demonstration of supply chain Trade Finance on OABCS. Banks, buyers, sellers, carriers, insurance providers, and government agencies can process Trade Finance requests, issue and operate financial instruments, endorse transactions and documentary evidences, track shipments, trigger payment transfers, etc.
• Our perspective on and experience of OABCS.
• A closer look at supply chain trade finance workflow across organizations through distributed ledgers on a permitted blockchain network. Limit the time and costs associated with intermediary processing, eliminate cumbersome offline reconciliation, and reduce fraud risks.
• How to consume and convert agreement Ts & Cs between parties into smart contracts that are automatically triggered to execute actions such as sending compliance reports and making payments.
Real World Blockchain Demos
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Oceanic 7, Lobby/Third Level
Topic:
Breakout with Blockchain - Subtopic:
Arun Kanchi, Presenter
This session includes the following:
A live demonstration of supply chain Trade Finance on OABCS. Banks, buyers, sellers, carriers, insurance providers, and government agencies can process Trade Finance requests, issue and operate financial instruments, endorse transactions and documentary evidences, track shipments, trigger payment transfers, etc.
• Our perspective on and experience of OABCS.
• A closer look at supply chain trade finance workflow across organizations through distributed ledgers on a permitted blockchain network. Limit the time and costs associated with intermediary processing, eliminate cumbersome offline reconciliation, and reduce fraud risks.
• How to consume and convert agreement Ts & Cs between parties into smart contracts that are automatically triggered to execute actions such as sending compliance reports and making payments.
Set the DRG Genie Free! It Will Ask, "Ever Had a Governance Friend Like Me?!"
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
EPM Data Integration - Subtopic:
Metadata Management/Integration
If Oracle DRM is the lamp, DRG is the genie that grants you unlimited data wishes. Don’t let Jafar’s horrific manual governance processes hold you back. Be like our data lovers, Aladdin and Jasmine. Hop on the magic carpet to learn how General Electric explores this whole new data governance world. Be part of an original Enterprise MDM production!
Oracle DRM enables organizations to achieve standardized and centralized management of their metadata for various entities and attributes (accounts, cost centers, company codes, products, etc.). However, technology is just an enabler; it alone will not satisfy the master data governance needs of an enterprise. The people and the process are also essential pieces of the puzzle.
That’s where the DRG workflow functionality of Oracle DRM comes into play. Without proper data governance, oversight, and efficient processes, data quality issues will arise, trust in the data will decrease, the usage of the system will decline, and subsequently the enterprise investment in the master data management initiatives will suffer.
Edgewater Ranzal: Winning Strategies for Oracle Cloud Adoption: Should You Test Drive, Lease, or Buy?
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
Have you seen your future in Oracle EPM & Analytics Cloud? And do you know if it’s sunny or not? Over the last several years, many of our customers have asked that same question—should I move? If so, when? And if when, how? Edgewater Ranzal Sr VP & Oracle Ace Mike Killeen, and BI Principal Solutions Architect Andy Rocha present a series of case studies to highlight the different approaches customers have taken to assess and deliver to their internal business partners the features and benefits of Oracle Cloud. Whether taking an “assessment-only view,” “bring your own Cloud,” “dip your toe in the water,” or “big-bang” approach, gain insight into the pros and cons of different implementation approaches, business benefits, and product features—specifically focused on the EPM and Oracle Analytics Cloud product suite. The presentation concludes with a demo of the visualization capabilities of Oracle Cloud—one of the top features requested by customers—and walk away with a better understanding of the strategies customers apply to drive innovation within the Oracle stack.
PDB Me, ASAP! Deep Dive into Oracle Database 12cR2 Multitenancy
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Oceanic 3, Lobby/Third Level
Topic:
Database - Subtopic:
DBA
Oracle Database 12cR2 has dramatically revamped the range of Multitenant features, including faster PDB cloning with virtually no downtime, tighter resource control at the PDB level, ILM Automatic Data Optimization (ADO) policies for PDBs using Heat Maps, and even FLASHBACK recovery for individual PDBs. This session explores the latest features of 12cR2 Multitenant as well as numerous code examples, which anyone can immediately leverage when deploying, upgrading, and migrating to CDBs and PDBs.
Get Ready for Brain OverLoad with Oracle Database 12.2/18c Features
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Oceanic 1, Lobby/Third Level
Topic:
Database - Subtopic:
DBA
Oracle Database 12, Release 2, 18c is packed with enhancements for DBAs and developers. Come listen to all the pertinent new features of Oracle 12.2 and 18c, which will change how you perform maintenance and tune the database. This session is not the traditional Oracle review of new database features. Be prepared to have your mind overloaded with the following focused areas:
Database Upgrade Options
Online Improvements
Partitioning Option
Multi-Tenancy (PDB) Option
Data Guard
RMAN
General Database
RAC
ASM/ACFS
In-Memory
Oracle DBAs/developers can take immediate advantage of these new features. I will give the audience a rapid-fire list of all the new features.
Storing and Generating JSON with Oracle 18
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Oceanic 5, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
Oracle 12c added formal support for JSON data with the 12.1.0.2 update in July of 2014. Oracle 12.2 and 18.1 added new functionality including the ability to generate JSON. Oracle stores JSON using standard Oracle character data types VARCHAR2, CLOB, and BLOB. A JSON-specific “IS JSON” test may be applied in CHECK constraints and WHERE clauses, as can two other JSON-specific conditionals: JSON_EXISTS and JSON_TEXTCONTAINS. Three JSON-specific functions are also provided: JSON_VALUE, JSON_QUERY, and JSON_TABLE. Attendees will learn how to create tables using JSON columns, INSERT data into JSON columns, query JSON data, use JSON_TABLE to represent JSON data as “normal” relational data, and generate JSON from SQL using Oracle functions (JSON_OBJECT, JSON_ARRAY, JSON_OBJECTAGG, JSON_ARRAYAGG).
Blockchain? What is Blockchain? Why Do I Care?
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Oceanic 7, Lobby/Third Level
Topic:
Breakout with Blockchain - Subtopic:
As digital transformation continues, current methods for handling transactions, contracts, records, and other data are not keeping up. Blockchain may be the key to modernizing and protecting transactions. Blockchain provides an open, distributed ledger updateable only by a consensus of involved parties. Efficiently storing transactions in a way that can be verified makes Blockchain attractive anywhere that data and value are in motion. Blockchain is most commonly thought of as the mechanism enabling digital currencies, but its most useful deployment may be in securing IoT input, supply chain, medical records, contracts, transactions, and data transmissions. Attendees will learn the basics of Blockchain, including its current uses and security features.
Blockchain? What is Blockchain? Why Do I Care?
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Oceanic 7, Lobby/Third Level
Topic:
Breakout with Blockchain - Subtopic:
As digital transformation continues, current methods for handling transactions, contracts, records, and other data are not keeping up. Blockchain may be the key to modernizing and protecting transactions. Blockchain provides an open, distributed ledger updateable only by a consensus of involved parties. Efficiently storing transactions in a way that can be verified makes Blockchain attractive anywhere that data and value are in motion. Blockchain is most commonly thought of as the mechanism enabling digital currencies, but its most useful deployment may be in securing IoT input, supply chain, medical records, contracts, transactions, and data transmissions. Attendees will learn the basics of Blockchain, including its current uses and security features.
Pimp My iGrid
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Asia 2, Lobby/Third Level
Topic:
Application Express - Subtopic:
Other Application Express
Are you already using the Interactive Grid, but missing some item types such as "Simple Checkbox"? Are you trying to create your own iGrid item plugin?
Come to this session to learn how to create item plugins for use with the iGrid.
Javascript in the Database—Heaven or Hell
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Oceanic 5, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
Javascript directly in the Oracle Database as stored procedures—is it Heaven or hell?
Come to this session to learn how to deploy Javascript code in the database using the Oracle Database Multilingual Engine.
Join us for a comparison between PL/SQL and Javascript, and you can decide whether it’s heaven or hell.
Simplify Any User Interface Development by Using Oracle SQL and PL/SQL with the Thick Database Approach
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Database - Subtopic:
Database Design
Whether you develop applications for an Oracle database in APEX, ADF, MAF, JET, MAX, VBCS, Java, JavaScript, or any other development framework or programming language, the development approach known as "Thick Database" can provide many benefits in terms of productivity, code reusability, and ease of maintenance for your applications. This approach uses the power of Oracle PL/SQL and SQL to make applications lighter and more efficient.
The Thick Database approach consists of principles for centralizing as much application logic in database code as possible. This greatly simplifies the development work needed for the user interface.
This session will explain the benefits, principles, and guidelines for using this approach. It will discuss how business rule logic can be centralized and standardized so that application updates due to business changes are much easier. It will also describe different levels at which you can apply these principles and how to decide which level to use. The session will walks you through sample code for the main SQL and PL/SQL code components you might use to implement Thick Database principles: table APIs, complex views with INSTEAD OF triggers, and business rule procedures.
Design Modernization Case Study: Applying Mobile App Design Principles to the UTOUG Website
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Database - Subtopic:
ADF and MAF
Cellphone app design has raised the bar for the design of modern business applications. Modern computer application users are accustomed to the fast and intuitive user interfaces offered by the apps available on mobile devices.
This presentation will explain the principles of modern user interface design and the standards for those principles available as Oracle Alta UI. These principles and standards can be applied to applications created with any popular development tool, such as APEX, JET, MAF, MAX, VBCS, JavaScript, Java, ADF, or even Oracle Forms. The session will show examples of these principles in the context of pages available on the UTOUG website as well as other websites, and will demonstrate the benefits of a modernized design that can accommodate mobile devices. In addition, it makes suggestions for how device features can play a role in many business applications. The session will close by outlining the resources available for next steps and further study of user interface design.
An Alternate Approach to ASO Calcs—MDX Scripts
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Essbase - Subtopic:
Calculations
This will be detailed technical session on MDX, discussing all the possibilities and uses of MDX. The majority of this session will be dedicated to MDX export/import process and new MDX insert functionality in Cloud.
Attendees will learn:
-How to write an MDX script
-The overview of calculation options in ASO
-The overview of MDX queries and ways of executing queries
-How to automate MDX queries
-How to organize the MDX script as a template for faster and easier execution of queries
-How to utilize MDX scripts to generate calculated values and feed them back into an Essbase cube
-How to use MDX insert to feed the data to Essbase cube in the cloud
We will cover all the possibilities of how MDX can be a very powerful tool—from basic to advanced.
Intro to Machine Learning with Oracle Data Viz
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Northern Hemisphere A2, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Advanced Analytics
This session will be a comprehensive introduction to Machine Learning using Oracle DVD. I will discuss the fundamentals of ML and give a live demonstration showing how to implement a ML model in Oracle DVD without writing a single line of code; there will definitely be code involved on the backend, as the implementation wouldn't have been possible without it. There is no “one model fits all” approach. After exploring the complete process for building a model, we will predict from it. I will also cover a few advanced topics on the various options available for building a model. We’ll examine the metrics and statistics and discuss how to read, interpret, and think about different approaches to tuning your model.
If you are a data science enthusiast and want to know about Machine Learning, this is a must attend session.
Attendees will learn:
- What Machine Learning is and how it fits into AI space
- The different ecosystems available for implementing ML (including Oracle and non-Oracle tools)
- An overview of ML capabilities in Oracle DVD
- How to build a Machine Learning model on training data in Oracle DVD (this will be a live demo, and we will be building a ML model without writing a single line of code in an hour)
- How to predict the outcome
- To understand the ML process flow
- The different approaches to tune and improve your model
- About additional references to get you started
This will be a very technical and process-driven session, and I will provide all the sample data files and the Oracle DVD project.
Predictive Analytics and Essbase: A High-Level Technical Overview
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Oceanic 7, Lobby/Third Level
Topic:
Essbase - Subtopic:
Other Essbase
As Niels Bohr said, “It is difficult to make predictions, especially about the future.” We try anyways. However, our predictions, plans, and forecasts are often based on gut feelings or outdated and oversimplified models. In this session, we will show you how to make the forecasting process more intelligent, accurate, and automated. We will demonstrate how the process can be improved with the power of statistical software R and Oracle Data Miner. We’ll contrast different integration options with Essbase, including the custom integration of open source R and Oracle R Enterprise. We’ll also compare the accuracy and performance of different models.
ODI and Jython Work Together to Better Control Your Environment
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
EPM Data Integration - Subtopic:
Data Management/Integration
If your environment is sufficiently complex, many of the administrative/monitoring tasks require dynamic parsing and script generation. The scripts can be dynamic MAXL, batch, SQLLoader, HTML, or any other, the content of which depends on environmental variables, the existence of files on the file system, variables passed as runtime prompts by the user, exact timing, etc. Using Jython in reusable ODI procedures provides a way to generate those scripts in multiple integration jobs and different contexts.
Best Practices to Roll Out PBCS and EPBCS Applications
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Planning - Subtopic:
Planning Cloud
This session focuses on guiding customers and implementation consultants to use the tools and capabilities that Oracle provides as well as the best practices that Oracle recommends to ensure a successful Cloud implementation. The session also emphasizes strategies to ensure long-term success of the product once it goes live.
A Layman’s Guide to the Essbase Cloud REST API
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Asia 4, Lobby/Third Level
Topic:
Essbase - Subtopic:
Essbase Cloud
Perhaps one of the most consequential enhancements Oracle has made to Essbase Cloud is the REST API (Representational State Transfer). This API provides users with a number of integration capabilities—from simple updates of substitution variables to execution of data loads and calculation scripts. Though this API is still early in its development cycle, this beginner-level session will demonstrate examples, showing you how to get the most out of your EssCS applications.
Reaching for the Clouds: Data Governance for Cloud Applications
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
EPM Data Integration - Subtopic:
Metadata Management/Integration
Data Governance is critically important to organizations today, even more so in a world where diverse data sources, on-premises, and cloud applications need to co-exist. Learn how Oracle’s Data Relationship Management (DRM) can become the foundation for cloud applications such as Essbase Cloud, PBCS, and Anaplan, among others. In this session, we will learn how to effectively integrate with these cloud applications and DRM.
Make the Most of All the Latest Features of Oracle Data Visualization
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere A2, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Data Visualizations
Are you interested in using DV features more effectively? This session will help you rapidly make the most of Oracle Data Visualization capabilities. We will demonstrate how to make the most of the latest capabilities, reviewing the numerous new features of Oracle Data Visualization v5 and highlighting why and how they are important for end users. We will showcase Oracle DV tips and tricks for end users, which will help easily get to stunning visual insights. This session is open to business users and technical users, with no pre requisite knowledge of Oracle DV.
MindStream Analytics: The Path from Break-Fix to Application Value Management
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
MindStream and Windstream walk you through the value of having a team of Hyperion experts to help bring value and dependability to their Hyperion solutions.
No matter the size of your organization or whether it’s on-premise or in the cloud, you depend on your Oracle Hyperion and BI solutions to deliver mission-critical functionality – to be at its best always, right? From driving your forecasting and analytic processes to close, consolidation and reporting to the street. Running complex solutions such as Oracle Hyperion, Essbase, DRM, OBIEE requires skilled technical resources and to bring true value to the business functional expertise. Most organizations have a Hyperion Administrator, but face the situation of limited expertise, limited time or the ole resource revolving door – therefore often faced with the high cost of sub-contracting engagements. Sound familiar?
MindStream and Windstream have worked together for years now in implementing and supporting their Hyperion applications to:
– Maximize system uptime with proactive monitoring
– Stabilize applications and enabled expanded functionality to enhance application ROI
– Bring focus to problem-solving - determine the root cause of issues or service interruptions
– Coordination and communication with Oracle for issues and updates
– Help institute a change control process and documentation of your Oracle footprint
Insum Solutions: An Hour with Mike Hichwa and the Oracle APEX Development Team
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
This year we’ve decided to “yield the balance of our time” back to the APEX community and back to the individuals that have been so instrumental to the success of many of us in the APEX community. We’re incredibly honored to host Mike Hichwa, Joel Kallman, and the APEX development team. While a good number of APEX developers recognize Mike Hichwa as the father of APEX, there’s an entire population out there that does not know Mike, and are not aware of the origins of APEX. In this Q&A session, we’re going to go back all the way back to the beginning, and up through to the latest version 18.1. You'll leave knowing a bit more about the tool and the people responsible for it.
Low Code, Low Cost BI with Oracle APEX and Analytic Views
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere A1, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
Oracle introduced Analytic Views as part of Oracle DB 12c Release 2. Now we can very easily write complex hierarchical and dimensional queries against existing database tables and views using very simple, straightforward SQL. All complexity is captured in the view definition. Aggregations, joins, computations, etc. are all defined in the Analytic View.
When coupled with Oracle Application Express (APEX), Analytic Views provide serious BI report capabilities that can be quickly tailored by the end user as requirements change. Your IT resources no longer need to be the bottleneck.
Best of all, both Analytic Views and Oracle APEX are available for free with the Oracle Database license, which compares rather favorably to OBIEE.
In this session we will:
- Generate the DDL using SQL Developer—Quick Analytic View
- Create an Analytic View
- Query the Analytic View using simple SQL statements
- Create stunning visualizations using Oracle APEX
Why Lefties Are the Essbase Champions: They Can Overcome Sparse Dimensions
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Essbase - Subtopic:
Calculations
Dense and sparse configuration is a straightforward and efficient way of optimizing OLAP storage and calculations, but it can become problematic as you have only one choice for your database, and changing it regularly is not an option.
By attending this presentation you will learn:
* How FIX really works; it is not only a way of selecting your calculation perimeter.
* How to use cross-dimensional operator (->) on the left side of calculation.
* How attribute dimensions can be used to create dynamic formulas in calc scripts.
* How LOOP command works; it is usable, even though it can be tricky.
Mixing those four elements, you will learn how to deliver light-speed, easy to maintain calculations scripts in order to:
*create blocks in bottom-up calc mode even with complex formulas
*transfer data from a dimension to another using attributes
*create dynamic calculation scripts that rely on outline members
*aggregate data without calculating intermediate levels
*make several allocations across sparse dimensions in bottom-up calc mode.
Oracle Analytics: How to Get to the Cloud and the Future of On-Premises
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Asia 5, Lobby/Third Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
BI Analytics
Unfold the mysteries of the cloud by learning how to get your own Oracle Analytics Cloud environment for visualization, Essbase, or both. In this session, you’ll gain new insights about whether you should keep your data where it is or bring it to the cloud, including information about how to achieve that. Lastly, we’ll discuss the future of Oracle BI for on-premises deployments and how they might be migrated.
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Asia 5, Lobby/Third Level
Topic:
Planning - Subtopic:
Planning Cloud
Are your planning processes efficient? Can you instantly update drivers and get results or do you find yourself waiting long hours to see results in your Oracle EPM Planning application? Do you know how your end-users are utilizing drivers, web forms, smart lists, and other critical tools? If any of these questions concern you, don’t worry, there is a new hope! In this session, you will learn how designing a new PBCS application or enhancing your existing application can take your organization’s planning process to new heights. Over this hour-long demonstration, I will show you better ways to utilize business rules, smart lists, and web forms to create an elite planning process.
Jenkins Meets APEX
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Application Express - Subtopic:
APEX Integration
Developing fast but deploying slow? You might know Jenkins, but you might not be familiar with the functionality of this tool. In this presentation, there will be a short introduction into Jenkins itself with some easy examples of how to utilize Jenkins in APEX projects.
Jenkins can do all the work you do every day. By using Jenkins, an installation, test or even a complete dump of your APEX application and the database objects can be done with either one click or automatically. Using Jenkins means taking the time to write a script with parameters. However, this will allow you to complete future tasks without thinking about them.
I will demonstrate how to maintain global variables and secure passwords. Even connecting to LDAP or using Slack/Email for notification is not very difficult. I will also explore some useful plugins and how to split the different steps of your deployment process into several Jenkins jobs.
After this presentation, you will understand the basics and you’ll be able to set up your own Jenkins while making the deployment as fast as it should be. This information can be helpful for APEX Developers, database engineers, or even DBA’s.
Guarding Your Data Behind a Hard Shell PL/SQL API—the Detail
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
Database Design
I’ve taken my “Why Use PL/SQL?” talk around the conference circuit and published the companion whitepaper on the PL/SQL blog. It was a high-level account that appealed to common sense and abstract principles of computer science. This session takes the opposite approach. It tells you in practical detail how to ensure that the hard shell of the database’s PL/SQL API is impenetrable by addressing code organization and security. It advocates a four-schema model (data, code implementation, API, and connect) using only invoker’s rights units together with code-based access control to honor the principle of least privilege. The approach is refined by explicit control of “inherit privileges,” the “accessible by” whitelist, and secure error handling. Scrupulous care is taken to ensure that the privileges needed for installation and patching are not available at run-time.
Automate Your Way Out of a Job or at Least Get Back Some Free Time: A Story of Powershell, MAXL, and MDX Scripts
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Oceanic 2, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
Other Real World EPM
This is the story of how Emerson created a process to enable functional users to run processes on servers that they would not normally have access to. Imagine being able to run a full group of processes (export, import, calculation scripts, defrag, etc.) with minimum effort. This process can and has been expanded beyond its initial Essbase requirements to include other almost random technical and functional maintenance processes (long-running consolidations checks, calculation statistics, smart view deletion, etc.).
“Adequate” Planning Doesn’t Cut It at San Francisco State University: An Oracle PBCS Case Study
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Planning - Subtopic:
Planning Cloud
Though doing “fine” using Microsoft Excel spreadsheets to budget, plan, and report, SFSU wanted to move toward a more efficient, robust, and comprehensive planning and budgeting solution. Join us to learn how SFSU’s “start small, but think big” approach to implementing Oracle’s Planning and Budgeting Cloud Service (PBCS) solution is kicking “adequate” to the curb!
How to Build a Business Analytics Business Case When the Future Is Cloudy
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Northern Hemisphere A1, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
We all know that IT spend has recently become cloudier and cloudier as software, infrastructure, and platform costs move to the cloud. However, we all face situations in which we need to make the best use of our organization's investment in existing applications and infrastructure! In this session, we will discuss practical advice on when and how to make the business case for moving to the cloud for BI and business analytics as well as related software, infrastructure, and platform solutions. We will also examine the circumstances in which moving to the cloud makes sense financially and when it doesn't. Using real-life case studies, we’ll discuss companies that moved to the cloud, companies that chose (near-to-mid-term) to stay fully on-premise, and companies that made the business case for a hybrid environment for the foreseeable future. Learn how to evaluate what makes sense for you and your organization!
Walmart International: The Case for Essbase
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Asia 4, Lobby/Third Level
Topic:
Essbase - Subtopic:
Other Essbase
Walmart International is the one segment of the Walmart business that generates more than $100 billion dollars in revenue from 28 countries with 55 different banners. Essbase is an integral tool used by the finance team to consolidate and manage this diverse portfolio. Over the course of this presentation, we will share some of the ways Essbase and related Oracle products are used to provide management insight, including:
- Consolidated variance analysis—actual vs. plan vs. forecast (Essbase and HFM & DRM)
- Easier access to better data in SAP BW—ledger data enhanced with consolidation entries and adjustments to prior year for more accurate year-over-year comparisons
- KPI data aggregation, analysis, and reporting
- The future of Essbase at WMT International—the cloud? Lessons learned from piloting OCS
Blue Cross Blue Shield of Michigan Uses EPBCS to Make a Risky Business Less Risky
Co-Presenter: James Martin, Blue Cross Blue Shield of Michigan
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Oceanic 4, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
EPM Case Studies
This session will demonstrate how EPBCS facilitates integrated enterprise planning. With the release of Strategic Modeling as part of EPBCS, companies can build their short- and long-term plans on a single platform. An integrated environment improves the efficiency of the process, increases the accuracy of the plans, and simplifies administration.
Workforce Planning Integrated with HRMS: An E*TRADE Case Study
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Planning - Subtopic:
Planning Modules and Frameworks
Say goodbye to TBH’s and hello to forecasting new positions and headcount throughout the requisition lifecycle. Join TopDown Principal Architect John L. Maloney and E*TRADE Vice President FP&A Evan Thayer to discover how they used Hyperion Planning to solve the reconciliation and headcount challenges. This allowed them to develop a new position-based headcount forecasting and reporting model, which integrates data from multiple HR systems and the applicant tracking system.
The session will cover:
• A review of the pain points we needed to solve (e.g. timely integration of metadata and data, and the elimination of timely reconciliation efforts).
• The initial solution, including a demonstration of the features and capabilities of the current solution, in production since mid-2017.
• How the Finance organization is realizing additional value from the implementation.
• Lessons learned from a complex implementation with numerous integrations.
• A review of how to implement this solution on-premise or in the cloud.
Attendees will leave with a solid understanding of how to apply the information and lessons learned to their own real-world reconciliation and HR scenarios, salary expense, and their capacity planning by employee and position where applicable in the solution.
Migrating from DRM On-Premise to EDMCS Cloud
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
EPM Data Integration - Subtopic:
Metadata Management/Integration
Unlike the other applications in Oracle's EPM Cloud offerings, EDMCS is not a straight replacement for the on-premise application. One must take into account application design considerations, while also planning the approach to migrate application capabilities and developing a logical roadmap. This session will discuss the implementation of EDMCS in the real world based on the design and implementation of a hybrid on-premise/cloud solution for an early adopter of the EDM cloud offering.
Make Your ASO Reporting Cube Speedy Fast!
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Essbase - Subtopic:
Design and Optimization
The dynamic nature of business models pushes us to perform analytics on large data sets (2.5TB). Developers are often asked for reporting solutions on huge data sets to provide analytical capability to end users with metadata changes. Designers have to look beyond tool capability to find strategies that support user expectations and design processes that allow for continuously changing financial reporting requirements. In this session, Jaymin Manger, senior developer at Ingersoll Rand Company, will demonstrate a case study. The session will also provide a macro to micro level vision on designing techniques for Global Financial reporting solutions, including performance tuning, partitions, and quick data fetching.
What's Cooking with Oracle Smart View for Office?
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere A3, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
Over 15 years ago, the challenge of combining the various Hyperion add-ins for Microsoft Excel into a single common add-in was first showcased at the Hyperion Solutions R&D area. This concept was the beginning of Oracle Smart View for Office, which has since expanded to integrate across the Office Suite to become the single add-in for our cloud and on-premise EPM, OBIEE/BICS, and financials cloud. With each update of Smart View, we deliver powerful new features and functionality to our users. Despite continued innovations in our browser-based interfaces, it remains one of the most used interfaces with our apps. Come to this session to see what new developments are in process. You’ll learn new tips and tricks, and you’ll have the chance to network with others during this interactive session.
Oracle Smart View Unbound: Desktop, Mobile, Web
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Northern Hemisphere A2, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
Oracle Smart View is one of the most widely used analysis and reporting tools for Microsoft Office, but it has historically required Windows client-installed versions of Office. That is about to change! Come to this session to see Smart View integration with MS Office on MacOS, iOS, and in the cloud.
Teaching On-Premise Planning Some PBCS Tricks
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Planning - Subtopic:
Other Planning
Who says you can’t teach an old dog new tricks? Since its initial release, PBCS has continued to add features at a swift pace. Unfortunately, that’s not the case for on-premise Hyperion Planning, as little more than basic patches have become available. PBCS is well over three years ahead of its on-premise sibling. If you are stuck with on-premise Hyperion Planning and would like to add some of the cool new features from PBCS to your application, this session is for you. Learn how to harness the power of Smart Push—on-premise. Learn how to create and use Smart Lists dynamically connected to dimensions—on-premise. This session will come complete with various demos and the sample code needed to get your shiny new PBCS tricks up and running on your old-school on-premise application.
ASO and BSO and Hybrid! Oh My!
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Essbase - Subtopic:
Other Essbase
Essbase started off with BSO, and everyone loved it. Although BSO is still loved by many in the Essbase community, many applications work much better in ASO. Now Oracle has given us Hybrid mode, which is also great. But which technology is the best? The answer is, as many consultants like to tell clients, it depends. Each choice has some unexpected strengths and weaknesses. We’ll discuss tuning Hybrid applications using non-traditional block sizes, as well as why ASO can’t always be replaced by Hybrid applications. We’ll even talk about Smart Push and why Hybrid may not matter for many applications. If you are considering which storage option to use for your application, this session will help you make a decision. We’ll even conduct a live demo to showcase the significant differences between the many storage technologies.
Automatically Deploy Schema Changes with Ansible and Liquibase
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Oceanic 1, Lobby/Third Level
Topic:
Database - Subtopic:
DevOps/Agile
Database schemas and application code are tightly coupled together, but they’re often maintained and deployed separately.
The open-source project Liquibase helps you manage your schema changes by writing simple JSON or YAML documents. Liquibase makes it easy to deploy to different flavors of databases, rolling changes backward and forward as necessary.
Ansible is an open-source automation tool that enables you to define and run tasks on a set of remote targets. Like Liquibase changelogs, Ansible playbooks are JSON or YAML documents.
Utilizing the two tools together enables you to effectively version control your database schema changes and deploy them to multiple hosts simultaneously.
Agile and DevOps work hand in hand.
This talk introduces Liquibase and Ansible while demonstrating how to use them together.
All sources and examples will be available for download.
This presentation includes live demos.
JSON and PL/SQL: A Match Made in Database
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
DB Dev
Javascript has taken over the world of apps. It is the language for internet and mobile app development, and Javascript developers want to work with JSON as their primary data structure of choice. Relational database developers can moan about a lack of concern for data integrity, consistency, etc., but that won't stop anyone. Maybe we should give them the best of both worlds—work with JSON, but store and manipulate that JSON data in a powerful, fast, secure relational database, Oracle Database. This session introduces attendees to the Oracle Database 12c features that make it easy to work with JSON in the database, through PL/SQL, and to publish REST APIs to those PL/SQL calls.
Hands-On Lab: Do You Know PL/SQL? Then JavaScript Is Easy! (Day 3 of 3)
When:
June 13, 2018,
Hands-On Lab,
2:15 PM -
4:15 PM
Room:
Europe 6, Lobby/Third Level
Topic:
Application Express - Subtopic:
JavaScript
This is day three of a three-day lab, which will introduce JavaScript to PL/SQL developers. We'll ensure that you leave this session feeling comfortable with JavaScript, ready to use the language in the real world. Attendees are strongly encouraged to be present for all three days of this progressive lab (two hours each day). Day one is listed in the Database track.
Hands-On Lab: Do You Know PL/SQL? Then JavaScript Is Easy! (Day 1 of 3)
When:
June 11, 2018,
Hands-On Lab,
1:15 PM -
3:15 PM
Room:
Europe 6, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
This is day one of a three-day lab, which will introduce JavaScript to PL/SQL developers. We'll ensure that you leave this session feeling comfortable with JavaScript, ready to use the language in the real world. Attendees are strongly encouraged to be present for all three days of this progressive lab (two hours each day). Days two and three are listed in the Application Express track.
Oracle Developer Community Lunch and Learn: Business Intelligence, Data Visualization, and Advanced Analytics Panel
When:
June 12, 2018,
Oracle Developer Community Lunch and Learn: Business Intelligence, Data Visualization, and Advanced ,
1:00 PM -
2:00 PM
Room:
Asia 2, Lobby/Third Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
ODTUG Kscope18 will feature a Business Intelligence, Data Visualization, and Advanced Analytics Lunch and Learn panel with Oracle ACE Directors and Oracle ACEs, who are designated by Oracle Corporation as Oracle community enthusiasts and advocates. Many of these professionals are attending and speaking at ODTUG Kscope18. Eat a quick lunch from 12:45 - 1:00 p.m. in Pacific Hall B/C and at 1:00 p.m. join one of the information-packed sessions led by a panel of Oracle ACE Directors and ACEs. Bring your questions; these are the people who have the answers!
Wayne Van Sluys, interRel Consulting
Tim Vlamis, Vlamis Software Solutions
Dive into Dynamic Actions
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Application Express - Subtopic:
APEX Core
Are you new to APEX? Do you want to be able to take your applications to the next level with very little knowledge of JavaScript? If so, learning the basics of dynamic actions is a must! Dynamic actions are a powerful tool that allow you to quickly and easily define client-side behavior declaratively with little or no knowledge of JavaScript. However, dynamic actions can still be daunting to a novice APEX developer.
In this session, I’ll introduce and explain the concept of dynamic actions as I progress through a number of common, real-world requirements that a developer may face. I will explain how to use dynamic actions to easily solve these problems. An application with examples ranging from basic to advanced will be available for download in order to facilitate further learning after the session.
EPRCS vs. Other Oracle EPM Reporting Solutions
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Northern Hemisphere A1, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
In just two short years Enterprise Performance Reporting Cloud (EPRCS) has gone from being a collaborative, narrative reporting tool to being the strategic reporting choice for Oracle. Compatible with many sources, as well as almost every Oracle EPM/BI Cloud solution, EPRCS is quickly becoming a one-stop shop for all types of reporting solutions. Come to this session to get an in-depth look at the reporting capabilities of EPRCS; we’ll also compare and contrast the features and functionality of EPRCS against other EPM Reporting options. Along with that, we'll review and demonstrate the Management Reporting feature delivered within EPRCS (the "new FR").
What's New in Hyperion Planning? Yes, Hyperion Planning!
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Planning - Subtopic:
Design
Yes, you read the title correctly! There are actually new features in Hyperion Planning. Don’t miss this session, where you’ll learn about all of the new features and enhancements in Hyperion Planning. We’ll demo new Planning enhancements such as smart push, valid intersections, smart forms with Excel formulas, sandboxing, and hybrid support. We’ll also review tips and tricks for incorporating these new features into your application. If you are on an on-premise Hyperion Planning admin, this is the session for you!
Oracle Developer Community Lunch and Learn: EPM Applications Panel
When:
June 12, 2018,
Oracle Developer Community Lunch and Learn: EPM Applications,
1:00 PM -
2:00 PM
Room:
Asia 4, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
None
ODTUG Kscope18 will feature an EPM Applications Lunch and Learn panel with Oracle ACE Directors and Oracle ACEs, who are designated by Oracle Corporation as Oracle community enthusiasts and advocates. A substantial number of these professionals are attending and speaking at ODTUG Kscope18. Eat a quick lunch from 12:45 - 1:00 PM in Pacific Hall B/C and at 1:00 PM join one of the information-packed sessions led by a panel of Oracle ACE Directors and ACEs. Bring your questions; these are the people who have the answers!
Tracy McMullen, interRel Consulting (Moderator)
Gary Adashek, General Electric
Francisco Amores, Inlumi
Deanna Sunde, Key Performance Ideas
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Oceanic 1, Lobby/Third Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
In this session, you will hear how KPMG used their Powered Finance solution to deliver a cloud-based ERP and EPM transformation for Avis Rent A Car System, a global $10 billion company.
Has your company growth led to a highly fragmented organization with difficulty integrating and harmonizing your global accounting and finance function? Learn how KPMG used a suite of Oracle Cloud Financials, Planning, and Consolidation products including PBCS, FCCS, DRM, ARCS, FRCS and Fusion Financials to enable the efficiency and effectiveness objectives at Avis. The transformation program included multi-layer transformation of business processes, technology, service delivery model, organization structure and capability, governance and controls, underlying data and reporting, and supported the customer’s change and program management for the program. Relevant process areas include: Master Data Management; Planning, Consolidation & Reporting; Record-to-Report; Acquire-to-Retire; Quote-to-Cash; and Procure-to-Pay.
We will walk you through the evolution of the transformation from initial target operating model and roadmap, through global process, technology and delivery model design, technology configuration, testing, training and business case realization.
What Every DBA Needs to Know about Oracle Application Express (APEX)
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Database - Subtopic:
DBA
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 manage APEX in the Cloud? What are the different components required and supported for the middle-tier?" In this session, we’ll answer those questions along with many others.
Lift and Shift Oracle Application Express in the Cloud
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Application Express - Subtopic:
APEX Core
In the past, you had to buy servers and/or hosting services in order to manage your technology stack. Now there are numerous options which allow you to quickly and easily deploy your applications on the cloud. The tough part is deciding which cloud offering or tools to use.
This session will cover the different cloud options available to lift and shift your Oracle Application Express (APEX) applications on both Oracle Cloud and non-Oracle cloud providers. We will also discuss some of the cloud options that use APEX as an add-on, such as BI Cloud Service (BICS).
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
DevOps/Agile
Cary Millsap, Presenter
Imagine a car with no speedometer. There are speed limit signs and policemen with radar guns waiting to catch you speeding, but you have no way to know how fast you're going. Of course, this car does not have a hood (a bonnet), so to change the air filter you would have to hire a specialist who could saw into the body of your car. A car like this would be preposterous, yet people write software like this all the time.
The Oracle Database has some of the best performance logging features of any software in the world built into it. You can use it with any application—even applications that were built without logging and monitoring in mind. But you can go so much further if you make the effort to include some performance logging features in your application. In this session, I'll explain Oracle's extended SQL tracing feature and describe how to enable and disable it. Then I'll show some innovative ideas that will help you design and build database applications that are easier to monitor, manage, and maintain throughout the software development life cycle.
Hands-On Lab: How to Write Better Technical Reports
When:
June 13, 2018,
Hands-On Lab,
9:00 AM -
11:00 AM
Room:
Europe 6, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
Cary Millsap, Presenter
Writing technical reports isn’t considered to be fun by most people, but it’s worth remembering that the person who records history controls how history will be remembered. My career has been distinguished more by writing than anything else.
A good technical document needs to be strong, relevant, crisp, informative, and interesting. If you try to write one up at the end of a project, you'll learn two horrible things. First, you will find yourself unable to remember enough details to write the truth. And second, you'll find yourself wanting to write such strong declarative sentences you would have to do a little more research to support them. However, because your project has concluded, you don't have the chance. In this way, the writing of the report profoundly influences the project itself.
In this informal session, I'll cover a number of tips that will help you write stronger, more relevant, and more interesting reports. The goal will be to help you better showcase your hard work, and in turn improve the quality of the work you're writing about.
Putting Predictive Planning to Work
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Asia 5, Lobby/Third Level
Topic:
Planning - Subtopic:
Planning Cloud
Predictive Planning is an element of Oracle EPM's focus on Intelligent Performance Management, which is automating as much as possible in order to free up humans to do the real thinking. Predictive Planning is advanced statistical forecasting made easy and tightly integrated into EPBCS. It includes methods such as linear regression, exponential smoothing, and seasonality. For each forecast, it tests many different techniques and creates a forecast using the best one. You might use the results as your primary forecast, you might use them as your forecast seed, or you might use them to compare to and validate human-made forecasts. You don’t need a PhD in statistics. In fact, it’s a good way to learn more about statistical forecasting techniques (aka data science).
So how exactly does it work, and how can you use it to improve your forecasts? In this session, we will do a quick overview of the statistical techniques and error measures. Then, we will identify some potential use cases from finance, sales, and HR. Finally, we will dig into some examples of how to set up and implement the cube. This session is intended for EPBCS admins and developers, as well as Finance, Sales, and HR planners who want to improve their forecasting and analytics.
Visual Approach to Essbase Calcs: 2018
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Essbase - Subtopic:
Calculations
Essbase’s “Best in Class” calculation engine enables Essbase and Planning to satisfy a vast array of planning and analysis needs. Whether it’s on-premise, in PBCS custom databases, or in the EPBCS business processes, creating custom logic that meets any analytical need will generate enormous value for your organization. But to take advantage of that power and avoid costly mistakes, you must thoroughly understand what you’re working with.
The Visual Approach to Essbase calculations was developed and refined over 20 years of Essbase and Planning projects with thousands of hours of training. Now, it’s been updated for the cloud and Hybrid Aggregation. The Visual Approach uses many diagrams and visualizations to walk through exactly how Essbase thinks, starting with a thorough explanation of dimensionality, the Essbase calc cycle, global calculation, and controlling calculation scope. It demystifies sparse and dense, showing how to make the block your friend in order to make your calculations (and other Essbase/Planning operations) quickly. Finally, it explains a handful of the most important commands and functions.
This session is for power users, admins, and developers who are either new to Essbase and Planning calculations or need to improve their calculation skills. We will provide a thorough understanding of the concepts governing Essbase calculations and the core set of commands and functions that are used in virtually every calc script and business rule. This session will give you the confidence to tackle new calculation challenges and write better, faster, and more powerful business rules.
Topics will include:
• Dimensionality and global calculations
• Demystifying sparse and dense
• Calculation order and two-pass calc
• Stored and dynamic calcs
• Calc All, Calc Dim, and Agg
• FIX and IF
• @Prior, @ParentVal, @AncestVal, @MDParentVal, @MDAncestVal
APEX Nitro, From Zero to Hero
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Application Express - Subtopic:
JavaScript
APEX developers of all skill levels inevitably have to write JavaScript and CSS. Do you think the learning curve is too steep? That is 100% normal. Within APEX, barely any guidelines exist to learn the fundamentals of these languages. Let’s fix that.
A new tool is rising in popularity among the APEX community; APEX Nitro takes your front-end development to the next level by reducing mundane tasks, boosting performance, modularizing code, enhancing teamwork, and more.
Come to this session and become an APEX Nitro hero!
Turning APEX into a Progressive Web App (PWA)
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Application Express - Subtopic:
Other Application Express
Imagine if your phone could come with every app in the world. It sounds pretty revolutionary—until you realize that it’s the definition of a web browser.
Modern web browsers have become so sophisticated that they can make a web app feel like a native app, meaning that is it installable, able to push notifications to your phone, has offline capabilities, and much more.
APEX, meet the world of Progressive Web Apps.
Leveraging More EPBCS Features for Forecasting and Opportunity Insights at Children's Hospital Colorado
Presenter: Bill Mowle, Children's Hospital Colorado
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Oceanic 4, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
EPM Industry Topics
Learn how Children's Hospital Colorado has been leveraging more of the features in EPBCS to support beyond budgeting initiatives at our organization. We have been using EPBCS for two years and have been phasing in new functionality. Join this session to see how we have been implementing predictive planning, workforce planning, Strategic Modeling, and much more in order to discover new financial opportunities.
The EPM Force Awakens @ GE into a Fully Functional Shared Service
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Real World EPM - Subtopic:
EPM Processes and Management
Not so long ago, in a galaxy not so far away, GE built one of the largest EPM Shared Service teams. Seismic shifts in the Industrial Internet of Things have captured GE’s EPM team, forcing them to transform. After building the world’s largest Exalytics/Exadata PaaS and supporting more than 500 applications, our team still had much to do.
In the battle between on-premise and cloud, GE businesses are caught in the middle, unsure which path to take. How should an organization align to address the EPM options? How do we evaluate and bring balance to the many facets of change (emerging technology, cloud adoption, organizational challenges, etc.)? How does an organization align with a company that is changing at a rapid pace?
Join me, Paul Husak, director of EPM product management, to walk through a real-life transformation of an EPM organization. We’ll cover the processes of transforming into a digital organization (IT to DT), moving from project to product management, and absorbing business application teams into our shared service.
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Asia 5, Lobby/Third Level
Topic:
EPM Infrastructure - Subtopic:
Maintenance, Optimization, Security and Troubleshooting
Over the last two years, GE has built out a large shared services team to handle all aspects of Oracle EPM Hyperion. This session will focus on the PaaS organization within the shared services, which was built to handle the day-to-day operations and new architecture of the Exalytics and Exadata environments.
In this session, senior EPM infrastructure architect, Joseph Nasal, will discuss how, as a service team, GE built a state of the art platform to handle the day-to-day management of a world class EPM platform. Joseph will focus on the team organizational structure, automation tools, how to size out your team, and how to keep the environments humming through patch releases and performance testing and tuning.
Creative Solutions for FX Analysis in HFM
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere A4, Fifth Level
Topic:
Financial Close - Subtopic:
Hyperion Financial Management
For companies that have functional currencies different from the reporting currency, FX impact analysis or Constant Rate Analysis may be a simple translation. What if your entities submit financial data in the company’s reporting currency, but operate in local currency? How do you perform FX impact analysis easily in HFM? Yum Brands has done it in various ways, from the mundane manual calculation in Excel to two different automated creative ways in HFM. In this session, Yum Brands will share their creative solutions to automate the translation in HFM. The discussion will include the business requirements, design considerations, setup in HFM metadata and rules, as well as the execution and users’ experience and benefits.
As a bonus, they will also reveal their ingenious methodologies of handling historical override in HFM. Whether you are a business user or a developer, you do not want to miss this content-packed session.
Case Study: Implementing a One-of-a-Kind Driver-Based Rolling Forecast Model at MD Anderson Cancer Center Using Hyperion Planning with ASO Integration
Co-Presenter: Janet Kloves, University of Texas MD Anderson Cancer Center
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Asia 5, Lobby/Third Level
Topic:
Planning - Subtopic:
Design
In this session, you will learn how the University of Texas MD Anderson Cancer Center transformed a traditional annual operating budget process into a more forward-looking driver-based rolling forecast process. In this session, we will review details of the MDACC solution design that supports rolling forecast, target setting at higher levels, and bottoms-up annual operating budgets. Attendees will gain a greater understanding of best practices and dimension design (Entities, Measures, and Attributes) to enable flexible user input and efficient calculations.
How to Do Peer Code Reviews in APEX Development Teams
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Application Express - Subtopic:
APEX Core
When peer code reviews are done well, they result in better code, fewer bugs, more informed and productive developers, and money saved. Done poorly, they are still worthwhile, but have far fewer advantages. Luckily, it takes no extra time to do peer code reviews well.
How Teams Can Develop in APEX Without Stepping on Each Other
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Application Express - Subtopic:
APEX Core
APEX is a highly productive, low-code development environment, great for small and large teams. End users, testers, and developers all love the ability to see the progress immediately in a shared, hosted environment. However, with large development teams, accurately determining whether to develop within the shared system or in a private environment is key to keeping team members happy. This presentation provides specific guidance on how to develop within the shared development environment and when to go private.
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Northern Hemisphere E3, Fifth Level
Topic:
Planning - Subtopic:
Planning Cloud
PBCS has been a game changer in the Hyperion landscape. It’s quick and easy to license, and you can be up and running in days. As a focal point for Oracle’s Planning Development team, PBCS has all the new bells and whistles. Join Peter Nitschke (aka EssbaseDownUnder) as he walks through the impacts of some of these new features, discussing limitations and defining new “best practices” for PBCS design.
Whether you’re an experienced Planning implementer or just about to start your first project, this session will contain a buffet of real world tips, code, and design principles to take home with you.
In this session you’ll see:
- Dimensional design: how to best set and use your ASO and BSO cubes
- Moving data around: Smartpushes vs. Xrefs\XWrites vs. Data Management
- One app or more: How to integrate multiple PBCS pods together
- Nav Flows: Designing a 21st century UI
- Groovy: What’s the fuss?
That’s Not What the Tech Ref Says! Weird and Wonderful Code and What It Means
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Essbase - Subtopic:
Calculations
Peter Nitschke and Tim German
Essbase’s flexibility is also its biggest curse—when it’s possible to write something 100 different ways, occasionally someone actually will! Join Peter Nitschke and Tim German as they delve into the underbelly of Essbase code, exposing both the hilarious and the obscure, while breaking down complicated code into its component parts.
In this session we’ll cover:
- Dynamic calc block creation!
- When strings go bad—what about missing members?
- So you want a parent?
- ISVALID—sorting the wheat from the chaff
Join us as we explain the method behind the madness, picking apart (and on) friends' and colleagues' (and our own!) old code lines and discussing the code that works, but definitely won’t be found in the documentation.
Deploying Hybrid Data Guard on Oracle Cloud
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Oceanic 3, Lobby/Third Level
Topic:
Database - Subtopic:
DBA
Moving your data center to cloud is done in phases, as some of the enterprise would like to partially move to the cloud. This session will describe ways to use hybrid Data Guard to connect your on-premise database to a standby in Oracle Cloud.
Working in any hybrid cloud requires some networking definitions prior to using any host or database. The next consideration would be the Data Guard setup between our data center and the cloud, which is based on the company’s needs.
Come see Data Guard and Far Sync best practices in action. The session will concentrate on:
• The setup of the network (site to site) between our data center and the cloud
• Building the physical standby
• Building the Far Sync
• Configuring Data Guard Broker
• Setting RMAN Archive Retention
Learning Objective #1: Learn the basics of site-to-site networking over the cloud.
Learning Objective #2: Learn how to build the physical standby.
Learning Objective #3: Learn how to build the Far Sync instance.
Learning Objective #4: Learn how to set up the Data Guard Broker with the most important configuration.
Deep Dive: Essbase and OAC Experts Panel
When:
June 14, 2018,
Thursday Deep Dive,
9:30 AM -
11:00 AM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Essbase - Subtopic:
Other Essbase
Has it been an intense week? Do you have a lot of information still to process? How about some questions left unanswered? Come join us on a deep dive and ask the questions you’ve always wanted to ask a panel of experts. Oracle Analytics Cloud has been launched (to the sky) for quite some time, and more people are jumping into this technology every day, alongside those still on Essbase OnPrem. This session will provide an open forum with expert panelists who are there to share detailed information with you. This is the spot to wrap up a great week with top-notch Oracle and community people!
Questions and thoughts can be submitted in advance via email to OACDeepDive@gmail.com or by tweeting with hashtag #OACDeepDive.
Everything OAC and/or Essbase is welcome! #LiveDemonstrations #NewTricksAndFeatures.
ACE Director, Glenn Schwartzberg, interRel Consulting
Kumar Ramaiyer, Oracle Corporation
Victor Belyaev, Oracle Corporation
Karen Zubetz, Oracle Corporation
Ask the Experts—Essbase Panel
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Oceanic 4, Lobby/Third Level
Topic:
Essbase - Subtopic:
Other Essbase
Please join us to have an open discussion with experts in the Essbase community. Bring your outstanding questions about Essbase, on-prem or on the cloud.
Peter Nitschke, M-power Solutions
Paul Hoch, TopDown Consulting
Oracle Ace Alumni, Tim Tow, Applied OLAP
Belén Ortiz - Mindstream Analytics
Christopher Bolind, FedEx Ground
Oracle Ace, Robert Gideon, interRel Consulting
EPMI: "One Oracle" . . . Fact or Fiction? Explore Oracle's New Integrated Business Process Features
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Asia 2, Lobby/Third Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
Are you tired of applications that claim to be “integrated,” and yet still feel like a patchwork of systems that are being held on by complex mappings . . . and a glimmer of hope?
Even with the emergence of new enterprise technology, the user experience continues to suffer from a disjointed journey for daily activities. We notice this pain across accounting, finance, human capital, reporting, and many more functions! And it’s not a surprise . . . these applications were not necessarily designed to work together.
But finally, Oracle’s Integrated Business Process offering allows you to have a single access point with one user interface for a truly unified experience. This capability can lower the total cost of ownership by eliminating costly integrations and needless reconciliations, which most of the industry still experiences.
Join us in this session to learn about the benefits of the unified EPM offerings, which include planning/budgeting, financial close, tax, account reconciliations, profitability & cost management, and enterprise reporting. Learn how to get the most ROI from your cloud investment by integrating user navigation flows in a single access point.
Answer questions such as:
• How can I forecast variances in PBCS/EPBCS using pre-elimination and post-elimination Actuals from FCCS?
• How can I reduce time to close by integrating consolidations, reconciliations, and tax activities?
• How can I access Disclosure Management reports, without leaving my Consolidations dashboard?
• How can I use the cost analysis from Profitability and Cost Management (PCMCS) to feed the IT Planning application in EPBCS?
We are excited to showcase the new 360 degree capabilities of the Oracle Integrated Business Process features during this session!
Oracle Account Reconciliations Cloud Service vs. BlackLine: A Tactical Feature-Based Review
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Asia 3, Lobby/Third Level
Topic:
Financial Close - Subtopic:
Financial Close Cloud
Are you tired of slick product demos that blur the lines between differentiating features for account reconciliation tools? While functionality across the leading tools in the market is indeed very similar, this session will cover the feature differences that may impact your business processes and the ability to scale usage. Using real implementation use cases for both products, we’ll compare reconciliation compliance, transaction matching, reconciliation formats, rules, automation, and analytics between Oracle ARCS and BlackLine, which will help you make the best decision for your company’s business requirements.
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Asia 1, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX Core
Oracle Forms is still being developed and for those whose requirements are being fully met, and are up on a supported release, there is no reason to move off Forms. However, if you are on an older release of Oracle Forms, or need to deliver modern, intuitive, self-service or mobile applications, then Application Express is an excellent option.
Learn what is involved in building out using Application Express, the dos and don’ts, how to use the APEX Migration Project, and more.
Why Citizen Developers Should Be Your New Best Friend
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Asia 1, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX Core
You keep hearing how “low code” tools are the next big thing in app development, and how “citizen developers” are building their own apps using no Code and low code tools. Well Oracle APEX is very much a low code tool, and even more so with APEX 18.1.
Learn how and why you, as an IT professional, should engage with these citizen developers to greatly improve productivity and engagement, and for the good of your organization. See how with APEX 18.1 you can readily guide these citizen developers to become development stars.
Introduction to Oracle APEX
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Asia 1, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX Core
Learn for yourself just why Oracle Application Express (Oracle APEX) is such a powerful, easy-to-use development tool. You already have an Oracle Database license, which means you can use Oracle APEX to develop any number of apps, for any number of end users, without any additional licensing fees.
This session is designed to give you an overview of the tool complete with demonstrations and is aimed squarely at those who have only ever heard of Oracle APEX. Learn how you can maximize the value of the data stored in your database by building beautiful, responsive, secure apps exceedingly fast and with minimal coding.
MythBusters: Migrating to Oracle EPBCS
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Planning - Subtopic:
Planning Modules and Frameworks
If you are currently an Oracle Hyperion Planning or Oracle PBCS (Planning & Budgeting Cloud) customer, you might be wondering if you should migrate to one or many of the Oracle EPBCS (Enterprise Planning & Budgeting Cloud) frameworks such as Financials, Workforce, Capital, and/or Projects. For new customers, whether or not to implement EPBCS may be an easy decision. However, for those who are already mature Hyperion/PBCS customers, there are many relevant items to explore, including functionality, methodology, security, data integration, and the process of moving your current solution to the "E" framework(s). This session will provide an understanding of the frameworks, exploring the potential migration path and associated steps in the comfort of a “myth-buster” format. This session is geared to not only answer migration questions, but also to help determine what those questions are. If you want to learn more about migrating to EPBCS from your current PBCS/Hyperion model, this session is for you!
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Asia 4, Lobby/Third Level
Topic:
Essbase - Subtopic:
Essbase Cloud
Join this session with Vlad Plotnikoff and William Olsovsky to discover how Essbase applications can now be more affordably and quickly implemented, allowing both casual and power users to leverage the feature-rich OAC platform.
Blockchain Applied: Finding a Use Case for APEX
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Asia 2, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX Integration
Blockchain is a disruptive technology set to revolutionize how we trade, manage assets, and exchange information. Blockchain can be described as a distributed database, which on the surface appears to compete with traditional database technologies. So how does this technology apply to or impact an APEX developer? Attend this session to grasp some of the interesting principles of Blockchain, and through the use of concept applications learn to appreciate how APEX fits into this groundbreaking paradigm.
Quest Software: Future Proof Your Databases—Extend DevOps Across Your Database Infrastructure
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere A3, Fifth Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
With businesses continuing to drive the adoption of DevOps methodologies such as Continuous Integration and Continuous Deployment, the need to include databases in those processes has become even more important. In many companies, the database development lifecycle has become the bottleneck in an otherwise agile delivery process. As such, database professionals are under increasing pressure to shorten delivery timelines even more, increasing the stakes within an already high-stress, risk-averse environment.
With little room for error, in an environment where downtime can cost millions of dollars, the need to extend DevOps processes across the entire database infrastructure in order to reduce risk and deliver consistently reliable results is more important than ever.
Utilizing a real-world scenario/use case involving both on-premise and cloud databases, John Pocknell will show attendees how to implement an end-to-end agile approach to database management.
From monitoring to root-cause diagnostics, problem resolution and data replication, John will show the entire agile database management workflow, including DevOps integration. This enables organizations to deploy changes to production safely and quickly when end users are jumping down the DBAs throat and money is on the line.
Bare Necessities: Fundamentals of HFM
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere A4, Fifth Level
Topic:
Financial Close - Subtopic:
Hyperion Financial Management
In this introductory-level session, you will learn high-level concepts and features of HFM, including why it’s used and how it can address your business reporting challenges. We will cover who uses HFM, considerations for successful implementation of an HFM solution, and how it fits into a typical financial system architecture. This is a great session for new users, administrators of other Hyperion or Oracle products, or anyone considering implementing an HFM solution in their organization. Forget about your worries and rest easy with this intro to the fundamentals of HFM.
Financial Reporting Made Easy
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Northern Hemisphere A2, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Static Reporting
This session will include tips and techniques to save time on your report development and reduce the associated maintenance effort. There will be information on covering report structure/design, useful functions, formatting, related content, advanced member selection, ranking/sorting of report items, and more. Attend this session to save yourself from the pain of learning things the hard way.
Hands-On Lab: Enterprise Data Management Cloud Service (EDMCS)
When:
June 13, 2018,
Hands-On Lab,
2:15 PM -
4:30 PM
Room:
Europe 11, Lobby/Third Level
Topic:
EPM Data Integration - Subtopic:
Other EPM Data Integration
Join this session to get hands-on experience using Oracle’s new and highly anticipated EDMCS. This session will train you on:
• The Information Model, which will demonstrate why EDMCS goes beyond just “DRM in the Cloud.”
• How to register target applications for maintenance through application adapters in EDMCS.
• How to import metadata and create application views.
• How to manage metadata with a request.
• How to export data to a target application.
• How to manage security, automate tasks, and perform migrations.
You Don't Need Any Javascript, CSS, or HTML Knowledge for APEX
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Application Express - Subtopic:
APEX Core
Maybe you just started with Oracle APEX and now you've heard all the experts at this conference talking about Javascript, CSS, and HTML. Don't be afraid; you don't need any of those to be a successful APEX Developer.
Oracle APEX is still a low code RAD tool with plenty of declarative settings. All your business logic is implemented in SQL and PL/SQL, so you should be fine.
This presentation will help you understand the potential maintenance issues that can arise from copying JS code from the internet. Let me show you how far you can get with standard APEX know-how, and how to avoid sprinkling JS/HTML/CSS code everywhere.
Building Big Things for Small Screens
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Asia 1, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX New Release
The Universal Theme in APEX 18.1 will see a number of enhancements targeted at developers building responsive apps that are well suited for mobile and small-screen devices. In this tactical session, we’ll demonstrate how to transition from jQuery Mobile APEX apps, and how to apply mobile UI patterns with the Universal Theme to build great small-screen experiences.
APEX Sunday Symposium: The Most Amazing Universal Theme Yet
When:
June 10, 2018,
APEX Sunday Symposium Session 4,
2:00 PM -
3:00 PM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Application Express - Subtopic:
Other Application Express
The Universal Theme aims to empower developers with the tools they need to build beautiful, responsive, accessible apps without becoming experts in HTML, CSS, or JavaScript. This session will introduce you to some of the improvements and updates to Universal Theme in the latest version of APEX, and how to take full advantage of all that it has to offer. Attend this session to learn how the latest release of APEX contains the most amazing version of the Universal Theme yet.
Going Serverless: An Introduction to AWS Glue
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Oceanic 2, Lobby/Third Level
Topic:
Big Data & Data Warehousing - Subtopic:
Data Integration
Going "serverless" is the latest technology trend for enterprises moving their processing—including data integration and extract, transform, and load (ETL) tools—to the cloud. But what does that mean and when should you use serverless ETL? In this session, we'll dive into the world of Amazon's fully managed data processing service called AWS Glue. With an easy-to-populate metadata catalog and no server to provision or resources to allocate, AWS Glue allows the data engineer to focus on his or her craft—building data transformations and pipelines. We will compare and contrast traditional ETL tools, such as Oracle Data Integrator and Glue, which will prepare attendees for the new world of data integration.
New Features of Essbase in Cloud and Roadmap
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Essbase - Subtopic:
Essbase Cloud
By Kscope 2018, Essbase will have been in the cloud for 15 months. In this session, we will update the community about all the features we introduced over the last year; we’ll also discuss the roadmap going forward.
Taking Control of the Client Side – Leveraging New JavaScript APIs
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Asia 1, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX New Release
Whilst APEX is primarily a low-code tool for building web applications, it is also highly extensible, allowing JavaScript developers to explore beyond the declarative capabilities of the framework and customize the user experience of their apps. In this session, the development team will take you through some of the new, or newly documented, APIs now available in APEX 18.1
APEX Sunday Symposium: Building APEX Apps for Everybody!
When:
June 10, 2018,
APEX Sunday Symposium Session 5,
3:30 PM -
4:30 PM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Application Express - Subtopic:
Other Application Express
A hearing aid allowing someone to hear music for the first time; smart glasses displaying captions enabling a deaf person to enjoy the theater; a remotely assisted blind person walking an unknown busy street; glasses allowing people to perceive colors for the first time. Technology smashes through perceived barriers to participation and enjoyment, and truly enables all. This is equally true in the digital world, where, with the right approach, technology can again break through these barriers.
In this session, you will learn what the “right approach” is on the web, and how APEX can help you work toward this. We will also talk about what “disability” really means; how it’s not just about those with obvious disabilities, but either through circumstance or injury, how anyone can face certain limitations or restrictions at some point in their lives, and therefore how thinking inclusively about your design and development can truly benefit everyone. Starting today, let’s all build APEX apps that anyone can use and love!
Demystify the Oracle Analytics Cloud
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Northern Hemisphere A1, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
The Oracle Analytics Cloud can be a powerful platform, but:
• How do you size it?
• Which editions are right for you?
• What are the capabilities?
• Can it scale?
• Can it be your system of record for reporting?
• What are universal credits?
• What is the difference between standard, enterprise, and data lake editions?
• What is pay-as-you-go?
• What is monthly flex?
• Which bundle is right for my organization?
• How is connectivity established?
• How do I integrate it with my source systems?
• Can I create self-service reporting for my users?
• Can I create monthly books?
• Can I mash up data?
• What is day-by-day reporting?
In this session, you will learn everything you wanted to know about Oracle Analytics Cloud but were afraid to ask!
Developing Secure Application
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Oceanic 5, Lobby/Third Level
Topic:
Database - Subtopic:
DB Tools
Securely developing application is more than a checkbox on a release list. This session will go over everything from classic SQL Injection to second order injection, and many other secure patterns that should be followed regardless of the application language. We’ll look at using the OWASP top 10 list and how it applies to database-backed application development.
Oracle DB REST API
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
DB Dev
The Oracle Database now has REST APIs for everything from creation of a database to SQL execution. We’ll start with a quick overview of REST, why it's taken off, and what it’s not. The new REST API is being used for everything from monitoring long running SQL to more lifecycle operations such as a DataGuard failover, as well as Oracle's own Managed Cloud service integration. This session will go over all aspects of the API and its usage.
Database Sunday Symposium Session 1
When:
June 10, 2018,
Database Sunday Symposium Session 1,
11:00 AM -
12:00 PM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
Other Database
Five Tips to Get the Most out of Your Indexes
Maria Colgan, Oracle Corporation
Why REST won the API Wars
Kris Rice, Oracle Corporation
SQL Magic: The Magically Changing Data Type
Chris Saxon, Oracle Corporation
Database Sunday Symposium Session 2
When:
June 10, 2018,
Database Sunday Symposium Session 2,
1:00 PM -
2:00 PM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
Other Database
Quick SQL
Mike Hichwa, Oracle Corporation
Let's Go Shopping
ACE Alumni Jeff Smith, Oracle Corporation
JSON and the Oracle Database
Maria Colgan, Oracle Corporation
Database Sunday Symposium Session 3
When:
June 10, 2018,
Database Sunday Symposium Session 3,
2:00 PM -
3:00 PM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
Other Database
JavaScript is Weird
ACE Alumni Dan McGhan, Oracle Corporation
Social Network Reach Why
ACE Alumni Jeff Smith, Oracle Corporation
How to Hack-Proof Your App from SQL Injection
Chris Saxon, Oracle Corporation
Database Sunday Symposium Session 4
When:
June 10, 2018,
Database Sunday Symposium Session 4,
3:30 PM -
4:00 PM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
Other Database
Useful Supplied PL/SQL Packages
Maria Colgan, Oracle Corporation
ORDS Tips and Tricks
Kris Rice, Oracle Corporation
Database Sunday Symposium Session 5
When:
June 10, 2018,
Database Sunday Symposium Session 5,
4:00 PM -
5:00 PM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
Other Database
How to Load CSV Into and Export It From Oracle Database
Chris Saxon, Oracle Corporation
Sqldev WEB, ON PREM – What Does That Mean for IT Orgs?
ACE Alumni Jeff Smith, Oracle Corporation
We Do It All for You, A Review of the AppDev Team’s Community Sites (AskTOM, Dev Gym, LiveSQL)
Chris Saxon, Oracle Corporation
All Things SQL Developer
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
DB Dev
In this he said/he said talk, Kris and Jeff will go over how SQL Developer has gone from just your desktop tool to now being available in your browser, and at the command line. This isn’t just a history lesson. Kris and Jeff will go head-to-head on tips and tricks between two environments and how both are expected to grow in the next year.
You will learn new techniques that you can start using today to save you time and be more productive with Oracle Database. This will be a lively session, and is your chance to interact directly with the product team.
Of Course You Can Do That with APEX! Report Templates, the Definitive Guide
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Application Express - Subtopic:
APEX Core
Out of the box, Oracle Application Express has a powerful templating engine. When it comes to beautiful and compelling layouts, the Classic Report is still the most effective tool in your toolbox. Let me show you some easy techniques that will simplify your life. Learn why the “HTML Expression” column attribute can often be your best friend. We’ll also learn about the mighty Custom Named Templates, which will serve you well when you need more advanced layouts.
We’ll talk about custom layouts for Interactive Reports. Did you know that the Interactive Grid also allows for some degree of customization? All of the information contained in this session is on out-of-the-box native APEX functionality.
After this presentation, it won't take long before you see how to apply these techniques everywhere.
How To Make Workforce Work for You: Plus Enhancements Have Arrived
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Planning - Subtopic:
Planning Modules and Frameworks
This session will cover the common modifications to out-of-box (OOB) rules, which make them meet exacting customer requirements. We will also cover additional new features and/or enhancements based on your feedback.
BI Developer to Data Engineer with Oracle Analytics Cloud Data Lake Edition
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Oceanic 2, Lobby/Third Level
Topic:
Big Data & Data Warehousing - Subtopic:
Data Integration
In this session, we'll look at the role of the data engineer in designing, provisioning, and enabling an Oracle Cloud data lake using Oracle Analytics Cloud Data Lake Edition. We’ll also examine the use of data flow and data pipeline authoring tools and how machine learning and AI can be applied to this task. Furthermore, we’ll explore connecting to database and SaaS sources along with sources of external data via Oracle Data-as-a-Service. Finally we’ll delve into how traditional Oracle Analytics developers can transition their skills into this role and start working as data engineers on Oracle Public Cloud data lake projects.
Deep Dive: Drill to Detail, Live!
When:
June 14, 2018,
Thursday Deep Dive,
9:30 AM -
11:00 AM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Big Data & Data Warehousing - Subtopic:
Other Big Data and Data Warehousing
Be a part of the studio audience during a live recording of the Drill to Detail podcast! Mark Rittman, an independent analyst and Oracle ACE Director, began the podcast over a year ago, focusing on the business and strategy of analytics, big data, and distributed processing in the cloud. Throughout the session, Mark will be joined by several esteemed guests, including his first ever podcast guest, Oracle ACE Director Stewart Bryson. Join us for what is sure to be a lively discussion on everything big data and data warehousing.
Why Should I Care About DVD? Blu-Ray Is the New Thing, Right?
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere A1, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Data Visualizations
You like Tableau and PowerBI, but you've been hearing about this thing called DVD. No, not the disc. We're talking about Data Visualization Desktop, Oracle's data visualization tool, which is part of the Oracle Analytics Cloud (OAC) suite. In this session, we will be taking a quick look at OAC's suite of tools. We’ll explore how Oracle Data Visualization stacks up against its main competitors, including a grudge match style live demo, during which you will get to take part in rating each tool! We will focus on the most important and interesting features, so that after attending this session, you will be able to make your own assessment.
How Sharing the Wealth Helped Make Managing the Close Easier
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Asia 3, Lobby/Third Level
Topic:
Financial Close - Subtopic:
Financial Close Management
For many years, finance/accounting organizations have been hard-pressed to maintain an adequate grasp of the finance/accounting general ledger close process. CFOs have professed their desire to compress the close process, but they don't clearly understand why certain G/L close processes take so long. We will delve into Financial Close Manager functionality (cloud-based & on-premise) to provide insights into the G/L close process. We’ll shine a light onto the G/L close sub-tasks that have historically been bottlenecks in streamlining the G/L close.
Everything a PBCS or FCCS Developer Needs to Know About Essbase Calc Scripts
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Essbase - Subtopic:
Essbase Cloud
Just when we thought writing calc scripts was a dying art, PBCS and FCCS pulled us back in. That's right, both PBCS and FCCS now allow us to write calc scripts for things like copying data, allocations, goal seeking, aggregations, clearing, and more. Now those of us who are Cloud administrators have to learn Essbase calculation languages. In one hour, self-proclaimed calc script expert, Edward Roske will teach you the basics of writing calc scripts so that you can get started writing procedural calculations in your Cloud applications.
Seven Essbase Calc Scripts Secrets
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Essbase - Subtopic:
Calculations
What's old is new again. Essbase on the Cloud, PBCS, and FCCS all let us write Essbase calc scripts, so it's time to dust off your old calc skills and learn a few new tricks. Roske and Schwartzberg will cover some things you might not know about how calc scripts function, how to improve performance, troubleshooting, and more. They'll also cover secrets that even the greatest Essbase experts might not be aware of. If you want to learn the 7+ secrets of the Calc Script experts, this is a session you don’t want to miss.
interRel: The Future of Reporting & Analysis: The Emergence of Artificial Intelligence and Machine Learning (AKA Skynet)
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Southern Hemisphere I, Fifth Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
On Tuesday, June 12 at 10:15 a.m., the best-attended session at ODTUG Kscope18 will be "The Future of Reporting and Analysis: The Emergence of AI and Machine Learning (AKA Skynet)." Business analytics experts Edward Roske and Glenn Schwartzberg will show you how you can enter the world of advanced analytics without fancy data scientists or advanced programming. Using only the power of OAC, they'll show you how pattern matching, driver determination, data mining, and even natural language generation are available today . . . and how computer-driven analytics will change your world.
Using Oracle Data Visualization? STOP!
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Northern Hemisphere A3, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Data Visualizations
If you think that the session title is suggesting we go back to the days of tables and pie charts, think again. In this session, we will cover four categories of visualizations that fit the acronym STOP: S=Segmentation, T=Trends, O=Outliers, and P=Patterns. Using Oracle's Data Visualization Desktop software, we will demonstrate the best visualizations for each category, along with tips on how to create visualizations that drive effective business decisions. This session will also include advanced visualization plugins from the Oracle Analytics Store, which extend the DV Desktop environment in order to enhance the capabilities of the product. We’ll present a compelling data story, revealing the insights that can be developed when you "STOP" using visualizations.
Using Apache Kafka to Add Streaming Analytics to Your Application
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Asia 5, Lobby/Third Level
Topic:
Big Data & Data Warehousing - Subtopic:
Other Big Data and Data Warehousing
While relational databases are still the kings of transaction processing systems, they have a hard time keeping up with the increasing demand for real-time analytics. In this session, we will build and demonstrate an end-to-end data processing pipeline. We will discuss how to turn changes from database state into events and stream them into Apache Kafka. We will also explain the basic concepts of streaming transformations using windows and KSQL before ingesting the transformed stream in a dashboard application. Lastly, we will explore the possibilities of adding microservices as subscribers. Live demos will be performed using Apache Kafka and Cloud infrastructure, as well as analytics and visualization services.
Tackling Time Troubles: How Oracle Datetime Datatypes Work
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Oceanic 3, Lobby/Third Level
Topic:
Database - Subtopic:
Database Design
Dealing with time-related data can be more complicated than one might expect. Leap years, time zones, and daylight saving time shifts can cause confusion and lead to runtime errors or poorly performing SQL code. We will look at some major pitfalls to avoid, and we’ll discuss best practices when dealing with time data.
Oracle Analytics Cloud Strategy and Roadmap
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Northern Hemisphere A3, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
What’s new, where are we, where are we going, and why? Join Oracle Development for this presentation/discussion to see the latest and upcoming innovation in Oracle Analytics, with a focus on Data Visualization, Machine Learning, Natural Language, Big Data, Essbase integration, and many more unrelated buzz words such as Virtual Reality, Blockchain, Quantum Computing, and Dark Web.
Oracle Analytics (BI and Essbase) Sunday Symposium: Development Panel Q&A
When:
June 10, 2018,
Oracle Analytics (BI and Essbase) Sunday Symposium Session 3,
11:45 AM -
12:00 PM
Room:
Southern Hemisphere I/II, Fifth Level
Topic:
Essbase - Subtopic:
Other Essbase
Interactive Q&A with Oracle Analytics Product Management and Development
Kumar Ramaiyer, Matt Milella, Gabby Rubin, Oracle Corporation
Oracle Analytics (BI and Essbase) Sunday Symposium: Opening Remarks and Oracle Analytics Product Strategy, Roadmap, and Demos
When:
June 10, 2018,
Oracle Analytics (BI and Essbase) Sunday Symposium Session 1,
9:00 AM -
10:30 AM
Room:
Southern Hemisphere I/II, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
Opening remarks
Oracle Analytics Product Strategy, Roadmap, and Demos
This session sets up themes for sessions to follow and introduce the agenda for the rest of the day. We will highlight Oracle Analytics and how it relates to existing, on-premise products such as Business Intelligence, Essbase, Publisher, and others. We’ll also review innovation roadmap and on-premise strategy.
Oracle Analytics (BI and Essbase) Sunday Symposium: Essbase Product Update and Demos
When:
June 10, 2018,
Oracle Analytics (BI and Essbase) Sunday Symposium Session 2,
11:00 AM -
11:45 AM
Room:
Southern Hemisphere I/II, Fifth Level
Topic:
Essbase - Subtopic:
Other Essbase
Essbase Product Update and Demos
This session will give an overview of new Essbase capabilities; discuss Essbase big (and small) data strategy, enhanced integration with data visualizations, new Smart view capabilities; and offer experimental lab demos.
Jump into Jenkins
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Oceanic 5, Lobby/Third Level
Topic:
Database - Subtopic:
DB Tools
Have you heard of Jenkins but don't know what it is? You are not alone. This presentation will take a look at what this mysterious application is and what it can do for you in the Oracle Database world.
When storing your code in a version control system, Jenkins can detect code changes and orchestrate deployment and testing tasks to help with continuous integration.
Learn the Jenkins basics and see if it can help you streamline your database application deployments.
Soup to Nuts: Configuring APEX in the Oracle Cloud
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Application Express - Subtopic:
APEX Integration
Configuring APEX to run in the Oracle Public Cloud can be a daunting task. In this session, we'll go through the full process of installing and configuring APEX to run securely in the Oracle Cloud. First, we will install APEX on a cloud database instance. Then we’ll configure a compute instance to run ORDS and a web server running HTTPS, including software installation, configuration, and firewall rules.
Thirdware: Bringing RPA to EPM
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
There’s tremendous excitement amongst finance and IT professionals in robotic process automation (RPA) technology and what it’s bringing to finance departments. A lot of the focus is on the ROI of automating processes, RPA’s impact on accelerating the close, and how it can enable organizations to better allocate limited resources.
During the financial close, balances need to be validated, records must be consolidated, journal entries need to be adjusted, financial data has to be gathered for disclosure, and financial statements must be prepared. There’s a lot of risk for error in these activities, and RPA can add a lot of value by drastically reducing the time, effort, and risk in closing the books.
However, there’s an even bigger ROI opportunity that is often overlooked. Beyond increasing processing speed, RPA’s ability to automate the manual, error-prone procedures in the last mile of finance has a substantial impact, particularly with validation and reporting. This last mile of finance tends to be an often-overlooked area for finance departments, which means there are still many opportunities for improvement.
Attend our presentation to learn how you can leverage RPA to process vast volumes of data in a fraction of the time and with greater accuracy to reduce or eliminate negative financial impacts.
EPM Sunday Symposium: EPM Cloud Adoption Customer Panel
When:
June 10, 2018,
EPM Sunday Symposium Session 4,
4:00 PM -
5:00 PM
Room:
Southern Hemisphere I/II, Fifth Level
Topic:
Real World EPM - Subtopic:
Other Real World EPM
EPM Cloud Adoption Customer Panel
Hari Sankar, Moderator, Oracle Corporation
The focus of this panel will be on how customers are adopting EPM Cloud for driving business value and transforming their business processes. We'll have panelists representing multiple patterns: on-prem migration, addition of EPM Cloud alongside on-prem, net-new adoption, etc.
Open Q&A
EPM Development and Product Management, Oracle Corporation
Interactive Q&A session with EPM Development.
How to Find Patterns in Your Data with SQL
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
DB Dev
SQL is a powerful language for accessing data. Using analytic functions, you can gain an abundance of insights from your data. However, there are many problems that are hard or outright impossible to solve using these functions.
Introduced in 12c, the row pattern-matching clause, match_recognize, fills this gap. With this, it's easy to write efficient SQL to answer many previously tricky questions.
This session introduces the match_recognize clause, using worked examples to show how it functions and the ways it's easier to write and understand than traditional SQL solutions.
This is useful for developers and data analysts who need to search for patterns in their data.
Fixing the Worst Database in the World
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Database - Subtopic:
Database Design
Tables are the foundation of your database. Mistakes in their design put your whole application on shaky footing, so it's worth spending some time to ensure you construct them well.
But what if you inherit a schema riddled with bad practices? How do you go about fixing it? In this interactive session, Chris and Heli will show you how to use Oracle Data Modeler to iteratively fix a broken data model.
If you're a developer or DBA who creates database tables, this session is a must for you!
Baha Mar's All in Bet on Red: The Story of Integrating Data and Master Data with PBCS, FCCS, and ARCS
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
EPM Data Integration - Subtopic:
Cloud Hybrid Integration
Baha Mar is the Bahamas' newest luxury resort, featuring world class hotels, restaurants, shopping, spas, a golf course, and a casino. Baha Mar has gone all in, betting big on red by adopting a Planning and Budget Cloud Service (PBCS), a Financial Close and Consolidation Cloud Service (FCCS), and an Account Reconciliation Cloud Service (ARCS). Within PBCS, Baha Mar has implemented daily operational reporting (DOR), which captures daily activity across the entire property.
In this session, we will explore how, and more importantly, why FDMEE (on-premises) was used in favor of cloud data management. We will cover the myriad of disparate and highly specialized data sources needed to support loading detailed operational data on a daily basis. We will study the various methodologies used to streamline data integration and enrich the data load cycle.
Additionally, we will discuss how EDMCS and cloud data management were leveraged to reduce duplicate master data maintenance while sharing key findings about this exciting new cloud service.
Did Baha Mar win big? Come to this session to find out!
FDMEE vs. Cloud Data Management: The Real Story
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
EPM Data Integration - Subtopic:
Cloud Hybrid Integration
Are you considering or have you recently purchased an Oracle EPM Cloud Service? If so, you've likely heard about Cloud Data Management and how it can satisfy all of your data and master data needs. Sounds like Nirvana, right? Not so fast.
In this session we will explore the capabilities of Cloud Data Management and its supporting technologies as well as its on-premises counterpart, FDMEE. We will weigh the pros and cons of each option, including software and hardware costs, functionality, and sustainability.
After attending this session, you will be able to make an informed decision about which integration toolset is right for you.
SQL Developer Data Modeler: Just What You Need
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Oceanic 3, Lobby/Third Level
Topic:
Database - Subtopic:
DB Tools
Oracle SQL Developer Data Modeler is a remarkably useful tool designed to support the entire systems development lifecycle. While it encourages capturing the big picture, Data Modeler can also be used in a snapshot fashion to get a specific task done efficiently. Unfortunately, the struggle to figure out how to do even a simple task can prevent the user from ever opening this "Swiss-army-knife" software.
This presentation is an overview of some of the most useful features of Data Modeler. We’ll explore how to get just what you need out of it without getting lost along the way. So, whether you have a job for an analyst or a developer, you owe it to yourself to take advantage of this remarkable tool. I believe that you will find it’s just what you need.
Pitfalls and Surprises with DBMS_STATS: How to Solve Them
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Oceanic 1, Lobby/Third Level
Topic:
Database - Subtopic:
DBA
Gathering optimizer statistics with DBMS_STATS becomes more convenient with every version of Oracle. The functionality of the statistics package has been extended several times as more and more is automated with every database version. The predefined default values, which are available for most parameters, are suitable for the majority of applications. Nevertheless, there are still situations in which we are surprised by the behavior of the statistics package.
In this session, through live demos and practical examples, I will show some pitfalls of DBMS_STATS as well as surprising situations from customer projects. I will also explain why these happen and how the pitfalls and surprises can be eliminated. It is essential to understand the influence of the different settings and parameters. Knowing the behavior of DBMS_STATS and the limitations of this package will help you avoid wrong statistics and bad performance.
Hands-On Lab: Do You Know PL/SQL? Then JavaScript Is Easy! (Day 2 of 3)
When:
June 12, 2018,
Hands-On Lab,
2:15 PM -
4:30 PM
Room:
Europe 6, Lobby/Third Level
Topic:
Application Express - Subtopic:
JavaScript
This is day two of a three-day lab, which will introduce JavaScript to PL/SQL developers. We'll ensure that you leave this session feeling comfortable with JavaScript, ready to use the language in the real world. Attendees are strongly encouraged to be present for all three days of this progressive lab (two hours each day). Day one is listed in the Database track.
OAC/EssCS — A Year Later: How Has It Changed?
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Essbase - Subtopic:
Other Essbase
OAC/EssCS has been out for more than a year now. Considering the limitations of the V1 release, how has it changed and improved? Is it ready for prime time now? Come and find out as Edward Roske and I fight over the best and worst features. This session will include demos of some of the newer elements.
Continuous Integration and Testing with APEX
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Application Express - Subtopic:
APEX Core
Continuous Integration and Testing is a hot topic right now. In this session, I will show how you can configure your development environment to reap the benefits of a Continuous Integration and Testing methodology.
Why would you want to do this? It’s simple—to make our lives as developers less stressful. We will gain confidence in our releases and streamline the deployment process.
Maximum APEX
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Application Express - Subtopic:
APEX Core
Ever wondered how many users your APEX application can support or what you can do to speed up your APEX application? In this session we’ll cover what tweaks, tips, and changes you can make to tune your application to the maximum.
What’s New and What’s Coming with Tax Reporting Cloud Service?
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere A4, Fifth Level
Topic:
Financial Close - Subtopic:
Other Financial Close
What’s New and What’s Coming with Tax Reporting Cloud Service?
What’s New and What’s Coming with Profitability and Cost Cloud Service?
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere E3, Fifth Level
Topic:
Planning - Subtopic:
Other Planning
Does your team spend too much time on allocation-based business processes such as corporate management allocations, shared services allocations, IT costing, or allocations that support transfer pricing? Does your current process provide complete transparency between pre-allocated and post-allocated results? Can you easily change assumptions and run what-if analysis on your calculations? If these questions resonate with you, this breakout may be helpful. This session will cover current and future capabilities, as well as customer success stories.
When:
June 10, 2018,
EPM Sunday Symposium Session 2,
2:00 PM -
2:45 PM
Room:
Southern Hemisphere I/II, Fifth Level
Topic:
Planning - Subtopic:
Other Planning
This session will consist of a presentation and interactive demo.
Part 1: Connected Planning will showcase a unified experience and flow across strategic modeling, financial planning and budgeting, LOB planning, profitability, and reporting capabilities.
APEX Sunday Symposium: Oracle APEX 18.1 New Features
When:
June 10, 2018,
APEX Sunday Symposium Session 2,
11:00 AM -
12:00 PM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Application Express - Subtopic:
Other Application Express
Oracle Application Express 18.1 focuses on declaratively integrating data sources from remote databases and extending applications running on the cloud via REST. A new Create Application Wizard enables you to add components and features to new and existing applications. Upgrading to the latest Oracle JET and jQuery JavaScript libraries will further allow APEX to take advantage of new and improved data visualizations and widgets. In this session, we will show those new capabilities and show some of the numerous enhancements to JET Charts and the Interactive Grid.
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Asia 1, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX Core
Many cities offer comprehensive Open Data portals with APIs that provide information on various types of government activities. Making this data publicly available makes governments more accessible and accountable to the communities they serve. Given the right tools to mine and analyze this data, businesses and citizens just might develop new and innovative apps that take full advantage of the data provided. In this session, we’ll take a look at a few of the over 750 public data sets provided by the City of New York and show how anyone can use cloud-based low code tools, like Oracle Application Express, to easily build powerful data analysis tools that tap into data-like expenditures, 311 service requests, and demographic and education data.
Garden Tour: Walk Through a Mature Business Intelligence Ecosystem
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere A3, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
BI Analytics
Let me give you a tour through our mature Oracle Business Intelligence ecosystem, which has been developed and retooled over the past decade in order to maximize our investment in a full Oracle stack from database to OBIEE, with integrated APEX applications, Google Charts, HTML, JavaScript, and beautiful D3 visualizations. Learn how you can extend OBIEE beyond BI to deliver more with your data.
Deep Dive: TED Talks from the Experts: Leave Inspired
When:
June 14, 2018,
Thursday Deep Dive,
9:30 AM -
11:00 AM
Room:
Southern Hemisphere IV, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
End your epic conference experience with a round of TED talks by community experts whose tricks will leave you inspired. Just sit back, relax, and enjoy a content-packed session as diverse as our track, with topics ranging across SmartView, calculation options in Advanced Analytics, Data Visualization, and more! After a week of intense learning and connecting, these concise final presentations will be exactly what you need.
ACE Director, Tracy McMullen, interRel Consulting
Oracle ACE, Gary Adashek, General Electric
Oracle ACE, Wayne Van Sluys, interRel Consulting
ACE Alumni, Sarah Zumbrum, Oracle Corporation
Kirby Lunger, Performance Architects
Ask the Experts—EPM Reporting, BI Analytics Panel
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere A2, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
Please join us to have an open discussion with varied experts in the EPM Reporting and BI community. Bring your outstanding questions or share your expertise, or both!
Understanding and Optimizing Oracle Memory Serialization Access (Latches and Mutexes)
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Oceanic 3, Lobby/Third Level
Topic:
Database - Subtopic:
DBA
Oracle memory serialization control is core to Oracle database operations. One of the most fascinating topics in Oracle internals and performance optimization is memory serialization. We will look at the circumstances in which serialization is used, how it works, how to influence its operation, and how to diagnose problems. It's a complex situation; in order to get the upper hand on serialization control, this presentation will explore the lock (a little), the latch (a lot), and the mutex (a whole lot). Topics will include: performance diagnosis, how Oracle implements latches and mutexes, and related internal algorithms. Special attention will be given to the library cache mutex operations. This is a practical, yet deep internals presentation filled with amazing discoveries about how Oracle works.
Taking ASH Analysis to the Next Level: Plan Change and Parsing Detection/Analysis
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Oceanic 1, Lobby/Third Level
Topic:
Database - Subtopic:
DBA
Sometimes snapshot time-based (AWR) performance data does not provide the level of detail we need to diagnose performance issues. Usually Oracle Active Session History (ASH) data bypasses this limitation by providing session level sample data. However, we can go further by creatively using ASH data to do things that are not possible using standard ASH and time-based analysis. In this presentation, I will show you how to use ASH data to pinpoint SQL plan changes. Also, I will show you how to detect parsing issues before they show up in the wait interface. The presentation will include demonstrations and instructions on where to get the free SQL, so you can take your ASH analysis to the next level!
IT Wars: Developer vs. DBA or How to Get What You Want and Need
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
DB Dev
For decades, developers and DBAs have battled over who controls the world. With each new development paradigm, the battle flares up again as developers push DBAs to adopt and support new data structures (JSON), new APIs (REST services), new technologies (In-Memory), and new platforms (Cloud).
In this session, Jeff takes on the role of lead developer on a project to deploy a RESTful web-based application, while Maria takes on the role of the DBA. Through the use of live demos, they learn to work together to find a solution that will allow them to embrace a more agile development approach and utilize the latest technology trend without exposing the business to painful availability or security vulnerabilities.
Can developers and DBAs peacefully coexist? Join us in this session and find out!
P.S. Are you excited to learn new dev tech at conferences only to be bummed out your DBA won't let you implement it back 'home?' This session will also give practical tips to put your DBA's fears to rest.
Developing RESTful Services with Oracle SQL Developer
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Southern Hemisphere V, Fifth Level
Topic:
Database - Subtopic:
DB Dev
Do you need to provide a REST interface for running workloads against your Oracle Database?
This session will take you through the process of an install/configuration of Oracle REST Data Services and the building of several RESTful services that demonstrate various techniques (working with BLOBs, passing binds, executing stored procedures, etc.) with Oracle SQL Developer.
SQL Developer has a REST development environment that's very similar to the SQL Worksheet. If you know SQL, PL/SQL, and HTTP fundamentals, you can build your REST services and have them running within a few minutes. See how to organize your services via modules; how to supply the DB workload code (SQL, PL/SQL) for each handler; how to generate the SQL scripts to be source controlled, deployed, shared; and more.
This session will not sell REST in general; it will demonstrate building REST for Oracle Database.
Account Reconciliations, a Required Control but a Huge Burden. If Only There Was a Way to Improve the Process . . . There is ARM!!
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere A4, Fifth Level
Topic:
Financial Close - Subtopic:
Financial Close Management
If you find yourself spending tremendous amounts of time on manual balance sheet reconciliations with no segregation of duties or controls, no management visibility into status of the reconciliations, or material misstatements/risks, you are not alone. We were there just over a year ago. This session is a case study detailing the ongoing progression to transform the account reconciliation process at Archer Daniels Midland (NYSE: ADM), a Fortune 50 company. Join us as we share lessons learned, opportunities for improvement, and expected/achieved benefits of the Oracle Account Reconciliation Manager (ARM) implementation journey.
Texas Racing Commission: Lessons Learned from Migrating to Oracle Cloud
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Oceanic 3, Lobby/Third Level
Topic:
Database - Subtopic:
Other Database
Over the past few years, the Texas Racing Commission has made a concentrated effort to migrate Oracle operations to the Oracle Cloud. We'll discuss lessons learned, difficulties encountered, and accomplishments achieved with Oracle Database, Oracle Enterprise Manager, Oracle IDCS, and Oracle Content & Experience Cloud.
Finit Solutions: Advanced Topics in Cash Flow – How to Make HFM do the Dirty Work
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Asia 3, Lobby/Third Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
Cash flow in HFM by itself is complicated – and adding in the topics of CTA and non-cash items can begin to make even the most seasoned HFM veterans heads spin. Come see some different approaches to tackling these complex issues, and find out how to make HFM do the dirty work for you!
Hacking Oracle APEX
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Application Express - Subtopic:
APEX Core
There have been many conference presentations, books, and webinars on how to secure APEX applications. But most, if not all, never explore what an actual attack would look like or the damage it might cause.
This session will demonstrate just that—actual Cross Site Scripting and SQL Injection attacks against APEX applications which do a whole lot more than print “hello, world.” Along with the demonstration, the session will cover how you can mitigate and prevent these types of attacks.
Secure RESTful Services
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Asia 2, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX Core
Web services are everywhere these days. You may find yourself needing to both produce and consume them, depending on the requirement. Because the data transmitted from web services is just as sensitive as data within your own database, you must pay close attention to ensure that it’s being transmitted in the most secure fashion possible.
This session will cover how to create and secure a RESTful web service via ORDS using OAuth 2.0. We will also explore how to consume a web service that requires OAuth 2.0 based authentication via PL/SQL APIs.
Essbase: What Is It, Technically?
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere A1, Fifth Level
Topic:
Essbase - Subtopic:
Design and Optimization
Imagine you’ve just been assigned the role of business SME or IT analyst in an Essbase implementation project. Or maybe you’ve been designated to be administrator for an Essbase solution that your colleagues rely on for business-critical analysis and reporting. As a user, you generally know what Essbase is, but now you have to learn about how it works “under the hood.” You need to know what’s really behind the magic of the Essbase cube.
This session is for anyone who’s new (or newish) to Essbase. We’ll help you understand the main components of Essbase and how they come together in a complete production solution. We’ll cover the key features and functions—Outlines, Load Rules, Calc Scripts, write-back, process automation, and drill-through, among others. In addition, we’ll discuss how Essbase cloud (OAC) is different from on-premise Essbase, describing a few popular reporting tools. The main objective of this session is to provide a functionality overview, which can serve as a roadmap for learning the technical details of Essbase solution development.
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Oceanic 1, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
The methods used to track performance issues in SQL and PL/SQL vary based on the level of access within a system. A developer in cooperation with a DBA, or one who has already been granted DBA privileges can have a wide variety of tools and deep visibility. However, a user with nothing more than CREATE SESSION and SELECT privileges can still make considerable headway on deciphering performance issues and correcting them.
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Asia 5, Lobby/Third Level
Topic:
Planning - Subtopic:
Planning Modules and Frameworks
Would you like to move beyond tactical financial planning to long-range target setting? Can you quickly perform what-if scenario modeling? Are you still doing financial modeling and impact analysis in spreadsheets? Advanced financial models reveal the impacts of strategic decisions on an organization’s bottom line, balance sheet, cash flow, and shareholder value. However, these models cannot be easily developed or maintained in conventional enterprise planning solutions and spreadsheets. This session will feature the Strategic Modeling product embedded in Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS), a feature-rich financial forecasting and modeling solution that provides a complete integrated and closed loop solution to set targets, perform impact analysis, and present focused financial information.
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Asia 5, Lobby/Third Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
Abstract: Dentsply Sirona is a long-time Oracle Hyperion client, leveraging HFM, Essbase, and Planning to meet their critical financial reporting and analysis deadlines. With performance and availability for their end user community a top priority, having the best tools available to ensure their internal clients are receiving the most efficient, effective support possible isn’t a nice to have, it’s a requirement. Dentsply Sirona standardized on the Accelatis Application Performance Management Platform to get the results they needed. This presentation will dive into the details of how they’ve:
• Automated manual processes
• Improved coordination between finance and IT to collaborate more effectively
• Captured the details of their user community’s activities
• Opened up the “black box” across all of their environments and applications to have the information they need
• Reduced the time it takes to close their books by reducing their HFM consolidation times
• Moved from reactive management to proactive performance management
This presentation will explain the challenges that were being faced, and how the Dentsply Sirona team addressed them all with a single, unified platform that helped them gain the insight and control they were lacking and streamline their performance management processes for Oracle Hyperion.
Presenters: Scott Sweezey, Financial Systems Manager, Dentsply Sirona; Pontus Bergstrom, Hyperion Planning and Essbase Supervisor, Dentsply Sirona; Chuck Czajkowski, Solutions Architect, Datavail.
APEX AI: Communicating with Your Application Using Chatbots and Speech Recognition
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Application Express - Subtopic:
APEX Integration
In this session we will discuss how you can integrate Natural Language Processing and AI technologies with your APEX application. We will also cover how to configure Amazon Alexa and external text-based chatbots to interface with and gather data from your APEX applications and Oracle database.
Searching APEX Applications
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Application Express - Subtopic:
APEX Integration
Have your users ever asked you to make searching in your APEX applications 'just like Google?’ This session will explore the technologies for searching records that are available natively within APEX and from the Oracle database. We will then look at how to enhance searching in APEX—ranging from some tweaks of the native elements to a JSON interface with a dedicated Elastic Search index.
How to Build the Best Dashboards in PBCS & FCCS
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Asia 4, Lobby/Third Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
You don’t have to leave home to create dashboards these days! Oracle EPM Cloud solutions PBCS, EPBCS, FCCS, and PCMCS all allow you to create dashboards within their solution with no required integration to an external reporting solution. Join us for this session, where we'll walk you through the steps to create dashboards within the Oracle EPM Cloud. We’ll also share best practices for ensuring that your dashboards and visualizations provide just the right amount of accurate information, guaranteeing that they will be a hit with end users.
Planning Capex the Easy Way
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Asia 5, Lobby/Third Level
Topic:
Planning - Subtopic:
Planning Modules and Frameworks
The Enterprise Planning and Budgeting Cloud Service Capital framework delivers prebuilt functionality with which to plan capital expenses. In this session, we will explore how to plan Capex with out-of-the-box functionality, demonstrating how it can work as a standalone and how you can integrate it with the Projects framework. You’ll also learn the steps to implement EPBCS Capital from start to finish. We’ll review dependencies and integrations with Financials and Projects frameworks. Enablement and configuration are easy when you have the guide for each step and dependencies!
Rock Your EPBCS Financial Reports Using OAC
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere A3, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
BI Analytics
Are the dashboarding capabilities in Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) underwhelming your finance users? Do you wish you could connect the rich reporting tools of Oracle's Data Visualization Cloud Service (DVCS) and Business Intelligence Cloud Service (BICS) to your EPBCS application in order to have dashboards that will make your system the go-to destination for your finance users? Learn how to seamlessly integrate your EPBCS data to Essbase cubes in Oracle Analytics Cloud (OAC) so that you can connect them to the rich visualizations in BICS/DVCS.
Creative Solutions Using Oracle Data Pump
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Oceanic 1, Lobby/Third Level
Topic:
Database - Subtopic:
DB Tools
Oracle Data Pump is mainly used by DBAs for a straight copy of a table or schema or for a whole database for ages. Most are familiar with a few parameters such as content, include, and exclude. In Oracle Database 12.2, do you know expdp has 48 command line parameters and impdp has 55 command line parameters? Imagine the power of Data Pump with all of these parameters and their options. In this session, you will learn various scenarios of using Data Pump to copy metadata, data, or a subset of data. If you are a developer, you can also use Data Pump, even though the export dump file is saved on the database server! Oracle client tools or SQL Developer can be used to invoke Data Pump—no need to bother the DBA. Learn to use Data Pump to meet the unique data and metadata copy requirements you never thought possible.
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Oceanic 1, Lobby/Third Level
Topic:
Database - Subtopic:
DB Tools
Whether you are a DBA or a developer with an admin hat, you need to know about these essential tools. These tools will help you document the configuration and troubleshoot performance issues. How can you easily capture all the configuration components and performance characteristics of the database? Is there a GUI tool that can easily manage the database? Do you hate the SQL*Plus interface? Do you ever wish there was a more readable SQL explain plan that allowed you to see all related object details and statistics? Do you want to produce a more readable and understandable session trace output? Is your application security sound? Do these tools work if your database is in the cloud? Learn the tools that help you identify Grid Infrastructure, database, and operating system configuration and security issues. Be a proactive superhero!
Solving Business Financial Reporting Matrix Style with Custom HFM Consolidation Rules
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Asia 3, Lobby/Third Level
Topic:
Financial Close - Subtopic:
Hyperion Financial Management
This session will show how HFM can be extended to eliminate in two dimensions: by entities and by business units. The Matrix consists of the four dimensions of Entity, ICP, Custom1 (Business Unit), and Custom2 (Business Unit Counterpart), along with some tweaks to the consolidation rules of HFM.
The solution was to use a set of consolidation rules that had been developed by a consultant for another company with a similar challenge. The solution has been proven by several organizational changes since then, and it seems to be rock solid as long as some simple prerequisites are followed.
The presentation will cover topics such as:
*The Business case explained (it’s not that simple)
*How we solved the data entry with more than four dimensions, where one is ICP and another is behaving just like ICP
*Metadata structures supporting the Matrix explained
*How and where to eliminate—this is the key to making it work!
Visualizing Streams
When:
June 13, 2018,
Session 10,
10:15 AM -
11:15 AM
Room:
Northern Hemisphere A2, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
BI Analytics
Business Analytics is undergoing a significant change; the traditional approach of batch ETL populating a predefined model is being challenged by streamed data, distributed file systems, and ad hoc access. It is unlikely that any one of these on its own will fully support the business. Therefore, it’s vital to understand how these different approaches can be used together. This session will present a modern Business Analytics data flow. We’ll start with the data collection using Kafka, describing options for the transformation and enrichment, using Confluent's recently announced KSQL for example. We’ll end with surfacing using the latest release of Oracle's Data Visualization tool. The session will provide an excellent overview of the latest technology trends, exploring how they can be assembled to create a state-of-the-art analytical solution.
DevOps and OBIEE: Do It Before It's Too Late!
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Northern Hemisphere A1, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
One of the biggest challenges with OBIEE and, more generally, with the Gartner defined Mode 1 reporting is the time required for production; huge developments and reiterated test phases are usually pointed at as blockers for a faster process. The agile methodology changed some of those paradigms by cutting down the monolithic development phase into multiple pieces, which could be worked and tested separately. Still, the process required to test and move new pieces to production was manual, and therefore error prone. DevOps, one of the trending topics in IT, aims to solve the problem by extending the agile methodology to test and release phases via process automation.
In the session, we'll analyze various aspects and phases of DevOps lifecycle, including version control, environment provisioning, code merging, and automated testing. We'll also discuss how tools such as Git, Jenkins, and the Rittman Mead BI Developer Toolkit can help achieve the necessary automation.
Oracle PBCS: Crawling, Walking, and Now Running in the Cloud at VCU
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Northern Hemisphere E3, Fifth Level
Topic:
Planning - Subtopic:
Planning Cloud
Virginia Commonwealth University (VCU) implemented Oracle Planning & Budgeting Cloud Service (PBCS) with the intent of improving their planning and reporting process, previously executed utilizing linked Excel spreadsheets. The move to this platform provided processing efficiencies, greater analytical capabilities, and a renewed confidence in the data. VCU continued to implement enhancements which included reporting through the planning attribute functionality recently added, and the introduction of a RCM (Responsibility Center Management) allocation model. In this session, you will learn how VCU started their journey with PBCS, and increased functionality and in-house knowledge, continuously enhancing the model to continue to get the most out of their PBCS investment.
Converting Essbase Report Scripts to MDX
Presenter: Tim Tow, Applied OLAP, Inc.
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Essbase - Subtopic:
Other Essbase
Tim Tow and Tim German
Essbase report scripts have always been workhorses for Essbase administrators, but do not enjoy the same level of prevalence in the Oracle Analytics Cloud. In their place, customers must use MDX. Although MDX has been around for many years, report script users had no real reason to rewrite existing scripts until now. In this session, we will compare report scripts to MDX, using examples to show how to convert several popular report script techniques to MDX. We will also cover some of the techniques that are available in MDX, but are not available in report scripts. Alongside that, we’ll discuss the performance differences between the two technologies.
How Do You Do *That* in MDX?
Presenter: Tim Tow, Applied OLAP, Inc.
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Essbase - Subtopic:
Other Essbase
There are numerous ways to get data out of Essbase for reporting and other tasks, but nothing is as powerful or as flexible as MDX. MDX is designed around member sets, and it features several interesting functions for operating within those sets. Have you ever wondered how to get the non-shared members under a shared parent in a shared hierarchy? Have you ever wished you could take each member in a set and get only its children that have a certain user-defined attribute? Do you have requests for ad hoc alternate rollups? Can you export outline information other than member names via MDX? Attend this session to have all of your MDX questions answered.
Presenter: Tim Tow, Applied OLAP, Inc.
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
Many companies have sophisticated business models that do not fit with the simplification message offered by modern cloud-based systems. Attend this session and learn how Dodeca customers, in some of the world's best-known companies, have implemented tailored systems, designed to fit their exact requirements by using Oracle Essbase and other Oracle technologies combined with the Dodeca Spreadsheet Management System. Dodeca—not just for planning, reporting, and analysis. Participate in the Q&A session and ask questions directly to the panel. The Dodeca Edge.
Advanced CSS Techniques to Make Your Application Look Even Better
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Application Express - Subtopic:
Other Application Express
In this session, we will look at the more advanced CSS techniques that will make your application look and feel great. You have no idea how many problems can be solved with a little CSS.
How to Move HFM to EPM Cloud
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Asia 3, Lobby/Third Level
Topic:
Financial Close - Subtopic:
Financial Close Cloud
This session will highlight the best practices and methodologies that can guide customers and partners through the process of migrating an HFM application to EPM Cloud. We will present a case study, which will demonstrate a detailed mapping of metadata, data, and journals, as well as best practices for business rules migration.
CheckPoint Consulting: Learn How Summit Materials and CheckPoint Consulting Have Partnered Up Through EPM Managed Services to Support and Evolve the Company’s EPM Environment
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Asia 4, Lobby/Third Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
Oracle’s EPM software has become a mission critical system for the Finance team. CFOs and FP&A directors rely on EPM to close the books and provide accurate budgeting and forecasting , which allows them to make smart business decisions for their companies and shareholders. You might say the EPM process is the nervous system of a company’s financial strategy. That’s why it’s critical that your organization has dedicated expert resources to keep it running. Join CheckPoint as we describe how Summit Materials, a large industrials company, is using our expertise as a third-party specialist to support and manage their EPM infrastructure. Supplementing their in-house IT team with our team of EPM experts helps Summit keep their EPM systems running smoothly. Knowing their EPM systems are stable and performing as expected gives them more time to focus on the business.
In this presentation you will hear details on how Summit leverages CheckPoint Consulting to:
• Keep their systems humming and respond to incidents quickly and effectively.
• Resolve incidents quickly and confidently with root cause understanding.
• Keep systems updated with regular patching and Oracle incident management.
• Improve ROI with system confidence, allowing their business users to stick to business.
Taking Health Care Planning to the Cloud: A Migration Success Story from the University of Michigan Health System
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Asia 5, Lobby/Third Level
Topic:
Planning - Subtopic:
Planning Cloud
With a rapidly changing health care environment, agile budget processes are imperative. Learn how the University of Michigan Health System painlessly migrated their on-premise planning application to Planning and Budgeting Cloud Service (PBCS) in less than a month!
This presentation will describe the old budget process, highlighting pain points and the method used to develop a cloud-hosted strategy. We’ll explore why cloud was the right decision, while covering our approach to migration, testing and validation, communication, and training , as well as the overall experience
It’s All About Bots: How Chatbots Can Revive Your Legacy Applications
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Database - Subtopic:
DB Dev
The digital world is moving faster than we can imagine. Millennials today don’t talk, they chat; they don’t have addresses, they have locations; and they don’t email, they message. It’s a new world out there, and enterprises either keep innovating or find their fate alongside Blockbuster, Borders, and Sports Authority. In this session, you will hear about the newest kid on the block, Oracle’s Intelligent Bot Service, and how it can help transform your back office applications (EBS, JDE, Primavera, Forms) to a transformative part of your business. These digital agents will be able to support not only today’s business needs, but they’ll also be able to serve digital strategies into the future for what’s coming next. We will show a live demo and customer case study of the creation an EBS sales order by voice chat!
What Are Microservices and How Could They Improve Our Legacy?
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Oceanic 5, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
This session will be an in-depth customer story of a back-office modernization to mobile using a microservice architecture. The end result was a mobile app and a chatbot, which we’ll show in a live demo.
Today, agility is imperative for market competitiveness; unfortunately, most enterprises have not succeeded in implementing a microservices architecture because their business logic is “trapped” in their back-office Oracle Forms systems. Separating the way the screen looks from the function it performs is such a daunting task—even if it can be achieved, it may require years and millions of dollars. However, this “decoupling” of the business logic will allow organizations to “future proof” these applications and achieve the agility they need. In this session, we will present the story of how the largest transit system not only modernized their legacy applications, but launched them into the next generation by using chatbots and mobile applications.
The Good, the Bad, & the Ugly of Data Visualization
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Northern Hemisphere A3, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Data Visualizations
Data Visualization is the newest member of the Oracle BI family! Whether you are using OBIEE, are in the clouds with Oracle Analytic Cloud, or are on the Desktop, Data Viz allows you to rapidly dig into your data to create visualizations from many sources. This freedom of self-service frequently presents new challenges. People new to Data Visualization are often confused by all the possible visualization options; they do not know which to use for their data story, or they pick the wrong visualization altogether. We will discuss the various visualization types, showing where and how they are best used to help tell the data story while also driving deeper data discovery.
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Asia 2, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX Core
In this session you’ll learn how queries in LOV’s, classic reports, interactive reports, and interactive grids are executed under the hood. To understand the goal, we’ll start with the general optimization technique behind pagination queries. Then we’ll systematically explore whether and how this technique is used in the different types of APEX report queries. We’ll also cover your options to address poor performance that stems from not using the desired optimization technique for pagination queries.
Warning: this presentation will include lots of execution plans.
Cross Workspace Application Authentication Using JSON Web Tokens
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Asia 1, Lobby/Third Level
Topic:
Application Express - Subtopic:
Other Application Express
Have you ever tried implementing single sign-on (SSO) across different applications in different workspaces? Out of the box, APEX doesn’t support this. Using JSON web tokens (JWT) I’ve built a solution that makes this possible.
In this session, I’ll show you how I solved this problem from concept to implementation. Using several demonstrations, I’ll explain the advantages and disadvantages of the choices I made, while also examining some of the issues I encountered along the way.
What's New and Coming in Planning Cloud
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Northern Hemisphere E3, Fifth Level
Topic:
Planning - Subtopic:
Planning Cloud
This session will provide an overview of the strategic direction of Oracle Planning Cloud; it will be filled with content on the latest and greatest features in the Planning Cloud. The session typically includes a demo of new and upcoming features of the product, focusing on the product roadmap.
Essbase vs. Relational Data: The Pros and Cons of Each for BI Reporting in OAC
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere A1, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
BI Analytics
Oracle Analytics Cloud (OAC) offers cloud BI reporting options over relational data and directly hits Essbase Cloud and PBCS data. For many organizations, this brings together two distinct end user groups, particularly if there are long-time Essbase users. From a BI perspective, Essbase presents some powerful options—the ability to perform calculations in any dimension as well as more flexibility with alternate hierarchies. However, relational data provides more flexibility with unlimited dimensional attributes and better performance over large volumes of detail data. This session takes a deep dive into the pros and cons of OAC BI in conjunction with each data source. We’ll present live demonstrations to help show the audience the strength of each approach, and how both can be leveraged for a robust end user experience. We'll include direct integration, which allows drilling from a summary Essbase database to the supporting relational detail data.
Future-Proof Your Career: What Every Executive Needs to Know About Adaptive Intelligence
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Northern Hemisphere A3, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Advanced Analytics
What are the capabilities and limitations of machine learning? We’ll openly discuss the benefits and drawbacks of different options for building advanced analytics capabilities in your business. We’ll compare outsource vs. in-house, cloud vs. on-premises, and prepackaged analytics vs. open source custom code. You’ll learn what language you need to know, how to explain the common concepts of adaptive intelligence, and how to tie your experience to new techniques and tools. It’s likely that you already know enough but just need some guidance.
Three Steps Ahead: Making and Visualizing Predictions and Forecasts
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere A2, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Advanced Analytics
In this session, we’ll show you how to use the automated tools in Oracle Analytics Cloud in order to create and visualize forecasts including confidence ranges, discrete forecasts, and back casting. We’ll share the “gotchas” we’ve uncovered utilizing exponential smoothing, ARIMA, and other automated tools in real-world enterprise implementations. We’ll also explain how to build predictive models using the included capabilities of Oracle Analytics Cloud and Data Visualization Desktop. You’ll see what can be done with “out of the box” functionality and when it’s best extend your models using R and Python. Together, we’ll explore a practical business case approach for the preparation of data, the interpretation of results, and the visual presentation best suited for non-technical colleagues. Even if you’re not yet using the advanced analytics features in your reporting system, most likely your competitors are. As the tools become easier to use and as the business returns increase, there’s no reason not to start.
cubus: Essbase Unleashed – Reporting & Analyzing with a Twist
When:
June 12, 2018,
Vendor Sessions,
10:15 AM -
11:15 AM
Room:
Oceanic 5, Lobby/Third Level
Topic:
Vendor Presentation - Subtopic:
Vendor Presentation
Oracle Essbase is known to be one of the best OLAP databases in the world but every world-class database needs a world-class front end in order to generate meaningful information from your data.
cubus outperform has proven its worth in thousands of projects around the world. It is a very flexible and intuitive tool for reporting and analysis.
Whether on-premise, on OAC or in the cubus cloud, cubus outperform has a reputation for being one of the fastest OLAP front ends on the market, while being very flexible and easy to learn. That is why it has consistently been voted the No. 1 third-party tool running on top of Essbase, in the world’s largest annual survey of BI Users, BARC’s BI Survey.
Join us in this session to see us unleash the power of Essbase and see why numbers are not enough. We will show you how to generate meaningful information directly from Essbase and annotate your findings.
Are you missing the ad hoc analysis functionality of existing tools, such as OBIEE?
See how we can integrate into other tools such as OBIEE and CXO Cockpit to complement each other and create a seamless user experience.
Wouldn’t it be great if we could do all of the above, and also create planning applications? Come and see us to find out if we can.
cubus is a German software company implementing the first Essbase projects 25 years ago. Customer focus is a daily mission: We are big enough to solve your problems and small enough to care. cubus and its global partner network can help you to make the right decisions.
What's New in HFM? Yes, HFM!
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Asia 3, Lobby/Third Level
Topic:
Financial Close - Subtopic:
Hyperion Financial Management
Yes, you read the title correctly. There are actually new features in HFM. Don’t miss this session to learn about all of the new features in Financial Management and Financial Data Quality Management Enterprise Edition. We’ll cover new HFM enhancements like data insights, dashboard improvements, and new admin tools to help manage and tune performance. We’ll also highlight enhancements to ARM, Close Management, and FDMEE. If you are on an on-premise HFM admin, this is the session for you!
How to Succeed in FCCS Without Really Trying
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Asia 3, Lobby/Third Level
Topic:
Financial Close - Subtopic:
Financial Close Cloud
Are you ready, FCCS? No more servers, no more IT, and no more waiting for upgrades. As it is, closing the books is hard enough without having to worry about the technology under the covers. Join us for this informative session, in which we will take you step by step through how to implement Financial Close and Consolidation Cloud Service (FCCS). We’ll share lessons learned so that your move to the Cloud can be smooth sailing. While there won’t be a musical performance in this session, we are certain you will gain the critical knowledge that will help you have a successful FCCS implementation.
Oracle EPBCS: Are You In or Out of "The Box"?
When:
June 13, 2018,
Session 13,
3:30 PM -
4:30 PM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Planning - Subtopic:
Planning Cloud
Migration to the cloud is accelerating as organizations look to take advantage of the cost savings, quick implementation timelines, as well as the expansive planning and reporting capabilities available within Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS). One of the most critical elements of implementing EPBCS successfully is the ability to understand the standard capabilities and make informed decisions about when to supplement those with customized components.
In this session, we will share knowledge gathered from many EPBCS implementations across various industries and all the EPBCS modules. We’ll discuss features that organizations consistently enable, as well as the most common types of customizations. Attendees can expect to walk away with a deeper understanding of the real life experience of implementing EPBCS, including best practices and deployment challenges—plus valuable tips for staying “in the box.”
Session will be co-presented with Oracle’s Muthu Ranganathan, Director EPM Product Management
Scaling Up with Docker, Kubernetes, and APEX to Pattern Match the Genome
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Oceanic 2, Lobby/Third Level
Topic:
Big Data & Data Warehousing - Subtopic:
Other Big Data and Data Warehousing
Are you building a self-scaling and self-healing Dockerized microservices or fast data cluster for the life sciences or healthcare industry? Look no further than the blueprint for pattern matching at scale with the granularity, automation, redundancy, and real-time insights that only fast data orchestration can bring. This session looks at a real-life science case, searching the human genome for genetic patterns. You’ll see a comprehensive pattern matching application deployed in a Kubernetes cluster to illustrate the advantage of OCC for MSA and DevOps. We will then build an Application Express web app to visualize the matched genomic traits.
Timecards and Timekeeping in Five Acts: Microapps in APEX for Web, Desktop, Slack, SMS, and Voice
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Northern Hemisphere E1, Fifth Level
Topic:
Application Express - Subtopic:
APEX Integration
Accurate and timely reporting of time is the lifeblood of a services business. In this case study, we reimagine the classic time card as an APEX Microapp deployed in five different flavors: as a web app, as a native desktop app, in Slack (desktop & mobile), and as a chatbot on both SMS and Voice. This approach allows the application to utilize any channel to reach out and collect time from team members.
Hands-On Lab: PBCS
When:
June 13, 2018,
Hands-On Lab,
9:00 AM -
11:15 AM
Room:
Europe 10, Lobby/Third Level
Topic:
Planning - Subtopic:
Other Planning
Attend this session to get your hands on PBCS and explore the product under the guidance of a skilled instructor.
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Northern Hemisphere A3, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Other EPM Reporting, BI Analytics and Visualization
How often do you question what finance does with its time? Are people clinging to Excel reporting like a comfort blanket, resigned to endless manual activity while secretly craving the charts and graphs that can be produced in other areas of the business with the push of a button?
Come to this session to learn about M&G Finance's process of diagnosing the "why" of their reporting and in turn, you’ll understand the "what" of their quest for the right tool for the job.
In a cost challenge environment, throwing headcount at reports generation is no longer an option, particularly when you understand the costs; partnering properly with the business becomes imperative. But with a business base set in their ways, it’s essential to find a core interactive tool that could also adapt to deliver traditional style automated PDF reporting. That seemed impossible until…
Take a seat up front in the CXO Cockpit with M&G to experience our journey into an insightful future.
Why Your DBA Hates You (Basic Tips for Tuning Your SQL)
When:
June 11, 2018,
Session 3,
2:30 PM -
3:30 PM
Room:
Oceanic 1, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
Who tunes SQL—the developer or the DBA? There are some SQL constructs that are known to be inefficient and others that will confuse the heck out of the optimizer. Your DBA will (or should) be looking out for them, but it’s better to identify and avoid them in the first place.
The Quest for the Perfect PL/SQL Error Handler: Deep Dive into UTL_CALL_STACK
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Northern Hemisphere E2, Fifth Level
Topic:
Database - Subtopic:
DB Dev
The talk will cover best practices for PL/SQL developers.
To understand the optimal error handler, it is crucial to first understand the information that the database gives the developer. This covers an explanation of CALLSTACK, ERRORSTACK, and ERROR BACKTRACE. It is also explains why using SQLERRM is wrong.
During the session, we will demonstrate PL/SQL optimization levels and the effects they have on error handling.
Oracle 12c features the new package UTL_CALL_STACK. We’ll give an in-depth explanation of how to work with UTL_CALL_STACK. UTL_CALL_STACK gives more control to the developer. Unfortunately, it does not go far enough. This session will explain which modules are useful, how they can be used, and what is still missing in a way that allows easy adaption to the audience’s code.
With Logger, we’ll show you how to apply the results from those investigations into your own logging framework.
The talk will conclude with examples of the bad practices still largely in use. This gives the developer the chance to consider the perfect error handler in each situation. There is no one-size-fits-all solution, but with 12c/18c, we can write less while better handling errors.
The Expense Blender
When:
June 12, 2018,
Session 5,
9:00 AM -
10:00 AM
Room:
Asia 4, Lobby/Third Level
Topic:
Planning - Subtopic:
Other Planning
FORECASTING AND REPORTING EXPENSES IN A MATRIX ORGANIZATION
After a significant acquisition and reorganization, the Williams FP&A group was charged with developing a robust and dynamic expense forecasting and reporting system, which supported a matrixed organization. The demands for meaningful and actionable information, transparency of direct and allocated costs, and the ability to forecast and report expenses across multiple assets required an elegant expense reporting and forecasting solution. Learn how Williams leveraged its current investment in Hyperion Planning, Essbase ASO, Dodeca, and OBIEE to accomplish:
1. The merge of four varied planning applications into a single unified application, supporting multiple lines of business and allowing cost center owners to forecast expenses across the enterprise.
2. The automation of interfaces to push data from planning to Essbase ASO applications.
3. The utilization of the unique capabilities of Dodeca to dynamically build and burst reports to cost center owners.
4. The leveraging of OBIEE to deliver interactive graphical views of actionable expense data.
Powering Up Strategic Modeling with an EPBCS Implementation at ATCO Group
When:
June 11, 2018,
Session 4,
4:15 PM -
5:15 PM
Room:
Southern Hemisphere II, Fifth Level
Topic:
Planning - Subtopic:
Planning Cloud
This session will cover the implementation of the new Strategic Modeling EPBCS framework at ATCO. We will discuss the design and process considerations used to leverage Strategic Modeling, which vastly improved their long range planning. We will also share tips and tricks, and we’ll describe out-of-the-box features, explaining how we used Groovy scripts to integrate to the Financials framework.
Financial Close: Roadmap, Decisions (Cloud vs. On-Premises), and What’s Next?
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere A4, Fifth Level
Topic:
Financial Close - Subtopic:
Other Financial Close
Oracle continues to innovate in the cloud and the on-premises platform across the entire financial close suite. This innovation can benefit customers today, but understanding where we are going can also help you plan your own internal application strategy. This session will explain the roadmap for both platforms, while providing guidance for existing customers and answering any questions. Every attendee should leave the room with a clear understanding of the roadmap and trajectory for both the cloud and on-premises platform across the financial close domain.
Overview and Update: On-Premises EPM Applications & Roadmap
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Asia 4, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
Other Real World EPM
This session explores in detail the overall strategy and solution delivery roadmap for Oracle Enterprise Performance Management (EPM) on-premises applications. The discussion covers all areas of EPM functionality, including planning and budgeting, profitability and cost management, financial consolidation, financial close, external and internal reporting, and master data management. We’ll also discuss what you can expect from your continued investment in these solutions.
When:
June 10, 2018,
EPM Sunday Symposium Session 3,
3:15 PM -
4:00 PM
Room:
Southern Hemisphere I/II, Fifth Level
Topic:
Financial Close - Subtopic:
Other Financial Close
This session will consist of a presentation and interactive demo.
Part 2: Connected Financial Management will showcase a unified experience and flow across financial consolidation, account reconciliation, close process orchestration, tax, and external reporting.
Your Oracle Data Provider: C'mon, Work with Me Here!
When:
June 13, 2018,
Session 12,
2:15 PM -
3:15 PM
Room:
Oceanic 5, Lobby/Third Level
Topic:
Database - Subtopic:
DB Dev
Every client data provider (or access technology) for Oracle whether it be .NET, JDBC, OLE DB, PHP, etc. has features that can be used to enable better performance of client applications with Oracle Database. In this session Mark will review some of the common, yet sometimes overlooked, features that are available, why they make a difference, and provide recommendations on how to best use the features for Oracle Database application performance. In addition to a narrative discussion, real life (anonymous) examples may be used where appropriate to highlight appropriate usage.
Loading Data into FCCS
When:
June 11, 2018,
Session 2,
1:15 PM -
2:15 PM
Room:
Northern Hemisphere A4, Fifth Level
Topic:
Financial Close - Subtopic:
Financial Close Cloud
Are you migrating from HFM? To make sure you’re successful, it is crucial to have a firm understanding of the Movement, Data Source dimensions, and built-in calculations in FCCS.
This session will detail what you need to understand about loading data in order to do it successfully. Using real-world examples to show what can go right and what can go wrong when migrating from HFM to FCCS, we will look at:
• Movement and Data Source dimensions
• Opening balances
• Periodic vs. YTD data loading
• Dimension attributes
• Clearing data
• Intercompany eliminations
• Data load volumes
• Pitfalls, gotchas, and workarounds
• And more
Attendees will come away with a solid understanding of how to successfully load data and tie it out in FCCS.
Oracle APEX 18.1: An Update on Plug-In Development
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Asia 1, Lobby/Third Level
Topic:
Application Express - Subtopic:
APEX New Release
Since its introduction in APEX 4.0, many improvements have been made to the plug-in framework in Oracle APEX. This session will give you an update on all the new features in APEX 18.1, like enabling your plug-in for the new data locations and how to use the new APEX_EXEC api. In addition, it will also cover what you have to do to enable your plug-in to use it in an interactive grid. Take the opportunity to get firsthand information from the architect of the plug-in framework in Oracle APEX.
Let Me Share This Whole New World of Agile and DevOps with You
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Oceanic 4, Lobby/Third Level
Topic:
Real World EPM - Subtopic:
Other Real World EPM
When you hop on the Agile and DevOps magic carpet, there’s no challenge that you can’t overcome while flying over the Agrabah landscape of Oracle Finance applications!
General Electric is one of the biggest users of Oracle technology for Finance systems (HFM, Planning, Essbase, DRM, PBCS, OAC, CM, ARM, FDMEE, ODI, Automic, Accelatis, Exalytics, and Exadata), supporting more than 500 internal applications. In the past year, we have started a new journey to transform the way we manage our resources and projects using the Agile and DevOps practices.
Our goal is to accomplish the product vision and business objectives at a faster pace by better facilitating communication and collaboration between all product stakeholders, leveraging our resources efficiently throughout the planning, development, and operations phases of every product initiative.
As a scrum master of the GE Finance IT team, I will tell you an Arabian Nights Disney-worthy fairytale of how we put together the process, people, and technology pieces to accomplish our Agile & DevOps transformation journey.
Around the World in Less Than 80 Days! Implementing Country by Country Reporting with HFM/FCCS
When:
June 12, 2018,
Session 8,
3:45 PM -
4:45 PM
Room:
Asia 3, Lobby/Third Level
Topic:
Financial Close - Subtopic:
Hyperion Financial Management
International companies in the OECD are now required to provide country-by-country reporting of their key financial metrics. In this session, we will review the requirements of this country-by-country reporting, exploring how these can be fulfilled using HFM/FCCS. The presentation will also include a directory of some of the key digests and links to the relevant publications.
This session is based on a real life example and will cover the process of designing and implementing the solution. We will also explain the questions we received from our reviewers (financial and tax auditors) when walking them through the solution, as well as what we did to facilitate their requirements.
If you are already using HFM/FCCS as your consolidation solution, there are multiple benefits to using it to also deliver the country-by-country reporting. This presentation will give you the “How!”
We will also give a brief exposé on how you can go to the next level using Oracle EPRCS Country-by-Country solution.
Turning Rough Diamonds into Precious Gemstones: Sculpting EPM Logs into Sparkling Data
When:
June 13, 2018,
Session 11,
11:45 AM -
12:45 PM
Room:
Asia 5, Lobby/Third Level
Topic:
EPM Infrastructure - Subtopic:
Other EPM Infrastructure
The EPM suite has a treasure trove of monitoring information: HFM records server information and consolidation times, Planning records job execution, and Essbase MaxL can generate logs for calculation scripts execution.
In this session, we will explore where this information is stored, how it is structured, and how to transform and normalize it in order to turn it into insightful structured records.
These transformations are the foundation for deploying advanced data analytics and visualizations, giving you a clear picture of how your systems behave.
The techniques we will cover in this session include: reading and transforming EPM SQL information, transforming concatenated text fields into parsed and structured metrics, extracting metrics from xml information stored in a database, and capturing log information stored in text fields into a structured table.
We will conclude with an introduction to how this can be used in data visualization tools such as Oracle OAC/Data Visualization.
Smart View Custom Ribbon—Ingersoll Rand's Magic Carpet
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere A2, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Ad Hoc Reporting
How often does your user community need support to setup connections, set IE timeout settings, or build Ad Hoc reports? Do they ask for help on Function Builder formula syntax or to re-enable Smart View after an Excel crash? A Custom Ribbon solution can eliminate the burden of support while allowing the users to be more self-sufficient and productive.
Move and Improve Essbase Cubes from On-Premise to Cloud
When:
June 11, 2018,
Session 1,
10:45 AM -
11:45 AM
Room:
Southern Hemisphere III, Fifth Level
Topic:
Essbase - Subtopic:
Essbase Cloud
Essbase in cloud uses Hybrid query processor as default for BSO and ASO. However, Hybrid only takes effect if members and formulas are dynamic. If someone moves an on-premise cube to cloud, immediately expecting a performance improvement from Hybrid, they will be disappointed, as it won’t happen. The question then becomes how do we know we improved the system once we’ve move to the cloud? How do we know the changes are correct? How do we think about it, and what additional steps should be taken?
We now have a systematic approach to make even the most complex model perform well after a move to cloud.
Custom Analytics Made Easier with Essbase
When:
June 13, 2018,
Session 9,
9:00 AM -
10:00 AM
Room:
Northern Hemisphere E4, Fifth Level
Topic:
Essbase - Subtopic:
Essbase Cloud
With Essbase in cloud, we now have very powerful modeling tools and capabilities. We want to exhibit those capabilities by solving problems in different vertical domains and demonstrating that Essbase can model business hierarchies while supporting the specific calculations and workflow as needed in those use cases. We plan to ship starter kits for these various custom analytics with our service; we will discuss those kits in this session. We will also show slowly changing dimension capability and how to perform the analysis. In addition, we will cover other domain-specific analytics and we’ll share DBX workbook—spend, revenue tracking, cash flow, demand supply alignment in supply chain, capacity analysis, consensus forecast in S&OP, etc.
Hands-On Lab: Essbase Cloud
When:
June 12, 2018,
Hands-On Lab,
2:15 PM -
4:30 PM
Room:
Europe 10, Lobby/Third Level
Topic:
Essbase - Subtopic:
Other Essbase
Come to this hands-on training session to get first-hand experience with Essbase Cloud (part of the Oracle Analytic Cloud Service). The lab will provide a hands-on walk through to see what's changed, what new capabilities the cloud version offers, and how to get started with it. Microsoft Excel with Smart View is a prerequisite for some portions of this lab.
*** Attendees must come with a laptop for this session and will need to download SmartView. Please see the link below. SmartView will provide the latest version as soon as the license agreement is accepted. If you plan to attend this session and already have SmartView installed, you will need to uninstall it from control panel before installing this version.
http://www.oracle.com/technetwork/middleware/smart-view-for-office/overview/index.html
Reverse Engineering Data Visualization
When:
June 12, 2018,
Session 7,
2:15 PM -
3:15 PM
Room:
Northern Hemisphere A2, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Advanced Analytics
This session is for those curious about how Data Visualization works. How are the visualizations created? How do the various Advanced Analytics components, such as the "Explain" feature, work? What are the different scripts and script types that can be used in Data Visualization? How are maps generated? You won't be voiding any warranties, but you will learn how to more effectively interact with and problem solve in Data Visualization!
Oracle & R: Advanced Analytics on Steroids
When:
June 12, 2018,
Session 6,
11:45 AM -
12:45 PM
Room:
Northern Hemisphere A1, Fifth Level
Topic:
EPM Reporting, BI Analytics and Data Visualization - Subtopic:
Advanced Analytics
The value of Oracle R Enterprise cannot be understated, nor can the ability to use custom R scripts in various Oracle analytics tools. But how do you use R to maximize your organization’s analytics? This session will reveal the “secrets” about using R scripts in Oracle analytics tool—from the included standard to the custom scripts.
