Sponsored by

peloton.jpg




The Hands-On Training Labs are back – with fresh new content for ODTUG Kscope18. These labs are BYOL – Bring Your Own Laptop (and Ethernet Adapter if your computer requires one) – and are included free of charge with your conference registration. Classes are limited to 45 people and will be filled on a first-come, first-served basis; there is no advance sign-up required.

 See below for class descriptions:

Application Express

Database

EPM Data Integration

Essbase

Financial Close

Planning


Application Express:

Building a Basic Demo Application Using Oracle Application
Monday, June 11, 2018 | 3:15 - 5:15 p.m. | Europe 6, Lobby/Third Level
Hilary Farrell, Oracle Corporation and David Peake, Oracle Corporation

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.


Creating REST Enabled SQL References and Web Services
Tuesday, June 12, 2018 | 11:30 a.m. - 12:30 p.m. | Europe 6, Lobby/Third Level
Carsten Czarski, Oracle Corporation and David Peake, Oracle Corporation

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.


Do You Know PL/SQL? Then JavaScript Is Easy! (Day 2 of 3)

Tuesday, June 12, 2018 | 2:15 - 4:15 p.m. | Europe 6, Lobby/Third Level
Juergen Schuster, IT-Beratung and Dan McGhan, Oracle Corporation

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.

Do You Know PL/SQL? Then JavaScript Is Easy! (Day 3 of 3)
Wednesday, June 13, 2018 | 2:15 - 4:15 p.m. | Europe 6, Lobby/Third Level
Dan McGhan, Oracle Corporation and Juergen Schuster, IT-Beratung

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.

 


Database:

Build and Secure a RESTful Service with Oracle REST Data Services
Monday, June 11, 2018 | 10:45 - 11:45 a.m. | Europe 6, Lobby/Third Level
Ashley Chen, Oracle Corporation

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 should have our Developer Days VirtualBox appliance downloaded before arriving at the conference.

Do You Know PL/SQL? Then JavaScript Is Easy! (Day 1 of 3)
Monday, June 11, 2018 | 1:15 - 3:15 p.m. | Europe 6, Lobby/Third Level
Dan McGhan, Oracle Corporation and Juergen Schuster, IT-Beratung

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.

How to Write Better Technical Reports
Wednesday, June 13, 2018 | 9:00 - 11:00 a.m. | Europe 6, Lobby/Third Level
ACE_Director.jpgCary Millsap, Cintra Software and Services

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.


EPM Data Integration:

Hands-On Lab with FDMEE (on-Prem)
Monday, June 11, 2018 - 1:15 - 3:30 p.m. | Europe 11, Lobby/Third Level

Bernard Ash, 123Olap

This session will dive in the functionality and uses of FDMEE on-prem. Using a live environment, learn and execute tasks related to FDMEE, on-prem!

Data Management Hacks to Turn You into an FDMEE Cloud Ninja!

Wednesday, June 13, 2018 | 9:00 - 11:15 a.m. | Europe 11, Lobby/Third Level
Doug Correa, Peloton Group

You don’t need to be an expert to go beyond standard file-based data loading, but chances are, if you’re loading data to EPM Cloud apps such as EPBCS or FCCS, you are using Data Management in the form of FDMEE Cloud. Attend Peloton’s hands-on training session to learn about some of our favorite time-saving integration options, utilizing often-overlooked features within FDMEE Cloud.

During this session, Peloton’s team of experts will cover:

• All data type integrations for loading non-numeric data, such as text, dates, and Smart List values

• Multi-column integrations to load data for multiple dimension members in a single row of data

• Driver-dimension data loads to specify target values by dimension

• Loading periods as a column to support multi-period single row files

• Data Sync to synchronize data between EPM target applications

Hands-On Lab: Enterprise Data Management Cloud Service (EDMCS)
Wednesday, June 13, 2018 | 2:15 - 4:30 p.m. | Europe 11, Lobby/Third Level

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.

Julia Radovani, Peloton Group 




Essbase:

Hands-On Lab: Essbase Cloud
Tuesday, June 12, 2018 | 2:15 - 4:30 p.m. | Europe 10, Lobby/Third Level

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.
Karen Zubetz, Oracle Corporation 


Financial Close:

Hands-On Lab: FCCS
Tuesday, June 12, 2018 | 2:15 - 4:30 p.m. | Europe 11, Lobby/Third Level

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.
Oracle ACEEric Erikson, 123Olap


Planning:

PBCS and EPBCS Beyond the Basics—New Features, Tips, & Advanced Functionality
Monday, June 11, 2018 | 1:15 - 3:15 p.m. | Europe 10, Lobby/Third Level
Suzy Gallivan, Peloton Group

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.

Hands-On Lab: PBCS 
Wednesday, June 13, 2018 | 9:00 - 11:15 a.m. | Europe 10, Lobby/Third Level

Attend this session to get your hands on PBCS and explore the product under the guidance of a skilled instructor.

Matt Ward, Peloton Group