ODTUG Webinars

    Is there a topic you would like covered but do not see here? We are happy to take Webinar suggestions. E-mail us at

    Did you miss a Webinar? As an ODTUG Member you can hear all of our past Webinars at any time. Just log in and you will see the link for the recorded list. Not a Member? Join now for $99!

    Our Webinar Calendar is constantly evolving! Check back frequently as more Webinars will be added to the schedule.

    Suggest a Topic Archived Webinars

    Tuesday, September 2, 2014 3:00 PM - 4:00 PM EDT
    APEX Applications for Smartphones: Dealing with Limitations
    Dick Dral, Detora

    When designing (web) applications for smartphones, the designer is confronted with a number of limitations. The screen is small, the keyboard is not easy to use, and the available bandwidth is often limited. The use of JQuery Mobile and the mobile theme in APEX 4.2 only partly addresses these limitations. This presentation will touch on a number of possibilities to deal with the limitations mentioned previously in order to create a useable smartphone application with APEX.

    The subjects of the presentation are:
    •    Designing a smartphone application
    •    Using a special smartphone template for APEX
    •    Using HTML5 itemtypes
    •    Using special itemtypes for touch input, including an entirely new type for time input
    •    Using repetition and prediction
    •    Using alternative input methods such as location, voice, and image
    •    Creating a single page application using APEX

    All subjects will accompanied by demonstrations.

    Register Here


    Tuesday, September 9, 2014 3:00 PM - 4:00 PM EDT
     Create Fancy Applications with Version 3 of the Bootstrap Theme for APEX
    Sergei Martens, SMART4apex

    A group of APEX developers have joined hands to develop a free Twitter Bootstrap APEX theme and made it available for everyone who wants to use it. This theme was presented to the APEX community during Kscope14 in Seattle. After Kscope14, the developers have been working on a version 3 of the Bootstrap theme.This new version of the Bootstrap theme includes not only new Bootstrap elements but also a rich “admin dashboard” and several plugins and additional features to enhance the usability for end users.

    During this webinar, you’ll learn about the new Bootstrap theme and how to use the theme in your own APEX application. In addition, you will learn some Bootstrap tips and tricks.

    Register Here

    Wednesday, September 17, 2014 11:00 AM - 12:00 PM EDT
    Bulletproof Your PL/SQL Program Units
    Steven Feuerstein, Oracle Corporation
    *hosted by Oracle Corporation

    Consistent, robust error management is a critical feature of any successful application. Developers need to know all that is possible in PL/SQL regarding the raising, handling, and logging of errors, and that standardize the way in which those tasks are performed. This webinar goes beyond the basics of exception handling in PL/SQL to explore the wide range of specialized error management features in Oracle. We will cover FORALL's SAVE EXCEPTIONS, DML error logging with the DBMS_ERRLOG package, the AFTERSERVERERROR trigger, the DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function, and more. In addition to covering error-related functionality, we'll also take a look at using assertion procedures to validate assumptions and execution tracing to better understand what is happening in your code. After attending this webinar, you will be able to take advantage of PL/SQL error management features, making it easier to identify the sources of problems and fix them more rapidly.

    Register Here

    Thursday, September 18, 2014 12:00 PM - 1:00 PM EDT
    Using FDMEE-Open Interface Adapter for MS Dynamics Navision Integration
    Francisco Amores Torres, Infratects

    Like its predecessor (FDM Classic), FDMEE provides the functionality of performing data integration with relational databases. With Open Interface Adapter (OIA), we can integrate any source with our EPM applications. In this webinar, we will show how to configure OIA to load GL data from Microsoft Dynamics Navision into Hyperion Planning and perform drill-through to see our source data details.

    Register Here

    Tuesday, October 7, 2014 12:00 PM - 1:00 PM EDT
    Calc Manager Rules with an ASO Cube: Yes, It Works!
    Ludovic De Paz and Paul Hoch, TopDown Consulting   

    You might have noticed that ASO applications are listed in Calc Manager, and this begs a number of questions:

    1. What can Calc Manager do for your ASO application?
    2. What can't Calc Manager do for your ASO application?
    3. What are the benefits of Calc Manager for an ASO database?
    4. What are the best practices for using Calc Manager with an Essbase cube?

    In this webinar, Paul Hoch, principal architect for TopDown Consulting, and Ludovic De Paz, senior consultant for TopDown Consulting, will answer these questions and more. The session will include real-life examples and case studies of successful implementations, as well as limits, gotchas, and workarounds.

    Register Here

    Thursday, October 16, 2014 11:00 AM - 12:00 PM EDT
    All About the Function Result Cache
    Steven Feuerstein, Oracle Corporation 

    The function result cache, added in Oracle Database 11g, offers developers a way to dramatically reduce the amount of time it takes to retrieve data requested repeatedly by database sessions (specifically, when the same rows of a table are fetched much more frequently than they are changed). This cache is stored in the SGA, shared across all sessions in the instance, and automatically purged of "dirty data" by the Oracle Database. Every application running on 11.1 or higher should be taking advantage of this feature. Best of all, there is minimal impact on your code to start using this feature.

    Register Here

    Tuesday, October 28, 2014 3:00 PM - 4:00 PM EDT
    Drillbridge: The Easy (and Free) Way to Implement Hyperion Drill-Through
    Jason Jones, Key Performance Ideas

    Oracle Essbase has long been recognized for its power to slice and dice data. The data that is loaded to Essbase is often summarized somehow – consolidated by time period, business unit, product, or more. Drill-through enables users to drill from the consolidated data in Essbase back to the detailed records in a relational database.

    This is where Drillbridge comes in. Drillbridge is a free component that finally makes it easy to implement drill-through from an Essbase cube to any relational data – even if that relational database isn’t directly used to load the cube in the first place. Drillbridge’s incremental and evolutionary approach to implementing drill-through lets users enhance the capabilities of their existing cubes and infrastructure without having to migrate, redevelop, or upgrade any of their existing software and infrastructure.

    Register Here

    Thursday, November 13, 2014 11:00 AM - 12:00 PM EST
    Turbocharge Your PL/SQL Code with Bulk Processing
    Steven Feuerstein, Oracle Corporation

    This session focuses on how to turbocharge the performance of multi-row SQL statements executed from within a PL/SQL using FORALL and BULK COLLECT. These features have been around since Oracle 8i, but many developers still don't use them or only scratch the surface of what is possible.
    The bulk processing webinar will focus on why these features were needed and how they work. Steven will start with simple examples and syntax and drill down into all nuances, including the LIMIT clause for BULK COLLECT and the SAVE EXCEPTIONS, INDICES OF, and VALUES OF clauses for FORALL.
    After attending this webinar, you will be able to both create new programs built around these features and also redesign existing programs safely to improve performance.

    Register Here

    Tuesday, December 9, 2014 12:00 PM - 1:00 PM EST
    Applications Design: The Dashboard of the Company
    Marcelo Burgos, Architects Express

    Why is the control board of the company the ideal mobile application?

    1. Significant user intervention is not required.
    2. The application must show us what we are looking for, regardless of our location or time.
    3. Ideally, the dashboard works on the basis of Business Intelligence data, independent of transactional systems.
    4. It requires special security conditions.

    More than any other application, the dashboard is a beautiful piece of software that displays the state of the indicators requested by the end user. Don’t miss this webinar, where you will discover the tips for what to do in the time that elapses until the indicators are ready to show the application data in a fashionable way. As we work with APEX, we will focus on improving the interface through subtle changes in the templates, and especially in the design and use of the images. In the midst of the transition between APEX 4 and APEX 5, we will analyze the graphic possibilities and alternatives available.

    Register Here

    Thursday, December 11, 2014 11:00 AM - 12:00 PM EST
    Ten (Other) Top Tips for Improving PL/SQL Performance
    Steven Feuerstein, Oracle Corporation

    Bulk processing (FORALL and BULK COLLECT), along with the function result cache, are the "big ticket" items when it comes to performance optimization with PL/SQL. But there's still more we can do to tweak our code for even better response times for our users. This third webast in the series starts with the automatic compiler optimization, showcases the extraordinary speediness of PGA data manipulation (a.k.a., package variables), and demonstrates the effect of the simple NOCOPY hint. We finish up with an introduction to pipelined table functions and some thoughts on optimizing your algorithms.

    Register Here



    2520 Independence Blvd., Suite 201 | Wilmington, NC 28412 | Phone (855) 853-0491 | | Copyright © 2014