ODTUG Sessions at Oracle OpenWorld 2012

ODTUG is proud to offer twenty-five sessions and five Symposiums on Sunday, September 30, 2012 at Oracle OpenWorld in San Francisco, CA. ODTUG Symposium topic areas are: Database Development, Business Intelligence, Fusion Middleware, Hyperion/EPM, and Application Express.

See below for sessions held throughout the week.

CON5265 

Empowering Emdeon's Finance Team with Financial Data Quality Management’s ERPI 

Greg Faulhaber, Emdeon Business Services

ACE John Booth, Emerging Solutions

 Monday, October 1

10:45 - 11:45 AM     

InterContinental - InterContinental Ballroom C

In April 2011, Emdeon kicked off a project to enhance its financial systems and processes, which rely on Oracle Essbase. This project transitioned data feeds from an IT-centric batch process to a finance-centric Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications process. Before the implementation, a batch process managed by IT was used to feed data from Oracle E-Business Suite. In less than a month, Emdeon finished the heavy-lifting implementation of Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications and Oracle Hyperion Financial Data Quality Management to automate its Oracle E-Business Suite 11 actual data feeds into Oracle Essbase, empowering the finance team to perform its own data loads.


CON3419

Build Oracle APEX Multilingual Applications 

ACE Francis Mignault, Insum Solutions

Monday, October 1 

10:45 - 11:45 AM     

Marriott Marquis - Foothill F

During this session, the participant will learn how to create and maintain multilingual applications. The presenter will demonstrate how to run the APEX builder in multiple languages and explain the translation process. The session will also demonstrate how to export and import the translated applications and how to add the ability to switch from one language to another during the execution of an application.

The translation process is explained in detail including how to use the APEX views, how APEX derives the language of the application, and how to test and make sure that your translated applications are synchronized with the primary application.

This session contains technical information as well as some live demonstrations.


CON4378

New Features of Oracle BI 11.1.1.6 We Didn't Get to Put in the OBIEE 11g Book

ACE Christian Screen, Capgemini NA

Adrian Ward, Addidici

Monday, October 1 

10:45 - 11:45 AM     

Moscone West - 3020

The first book on Oracle BI 11g published this year by authors Christian Screen, Adrian Ward, and Haroun Kahn by Packt Publishing contains a first-class instruction to the OBIEE 11g platform, repository building, report development, and many ancillary items in between. However, there are many new features of Oracle BI 11.1.1.6 that the authors wanted to put in the book but couldn't forgo the manageable 600 page book size. This session takes a candid real-world look at the new features that make Oracle BI 11.1.1.6 a true achievement and worthy of Gartner Research's latest ranking for Oracle BI in the Magic Quadrant for Business Intelligence and a must upgrade to version from its prior versions.


 

CON4832

Effective Fault Handling in Oracle SOA Suite 11g

ACED Ronald van Luttikhuizen, Vennster

ACED Guido Schmutz, Trivadis

Monday, October 1 

1:45 - 2:45 PM         

Moscone South - 308

It is one thing to architect, design, and code the "happy flow" of your automated business processes and services. It is another thing to know how to deal with situations you do not want or do not expect to occur in your processes and services. This session will dive into fault handling in Oracle Service Bus 11g and Oracle SOA Suite 11g based on an Order-to-Cash business process. Faults can be differentiated between business faults, technical faults, and faulty user input. Each type needs a different approach to prevent them from occurring or to deal with them. This session shows and demos what patterns and techniques can be used in Oracle Service and Oracle SOA Suite to prevent and handle technical faults as well as business faults.


 

CON3733

How Oracle Essbase ASO Works and How to Design For Performance

Dan Pressman, nTuple

Monday, October 1 

1:45 - 2:45 PM         

InterContinental - InterContinental Ballroom B

In short, this presentation moves from the most generic “How ASO Works” information to the most practical “Design for Performance.” Previously unpublished information based on the statistics page, documentation, and gleaned from related patent filings is all distilled into 12+1 Rules to guide your ASO Designs. These rules will ensure that your cubes perform maximally, require less Aggregation, and have a minimal memory footprint.

There will be an emphasis on using “Stored Hierarchies” real world examples to design around their limitations. Compression and the impacts of using Attribute dimensions are also discussed.

This info is found nowhere else except the new book Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals.


 

CON4110

Slay Bad Data in Essbase with Oracle Data Integrator  

ACED Cameron Lackpour, CL Solve

Monday, October 1 

1:45 - 2:45 PM         

InterContinental - Sutter

Everyone knows that bad data kills Essbase applications, but did you know that bad data can also kill careers, consulting engagements, and company-wide labor agreements? Why is the rule of high-quality data in Essbase honored more in the breach than the observance? This session explains the real-world consequences of bad data, categories of data quality, and tools and strategies for ensuring that your Essbase database has the right data. A complete solution in Oracle Data Integrator will show one path to salvation in the never-ending quest for quality data. This presentation is an expansion of the data quality chapter in the book Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals.


 

CON2672

Error? What Error?

ACED Martin D'Souza, ClariFit

Monday, October 1 

4:45 - 5:45 PM         

Marriott Marquis - Golden Gate C1

A common situation that all developers have faced is integrating a new feature in an (APEX) application, launching it into production, and then getting the dreaded “it doesn’t work” phone call. How could this happen? You covered all the angles. Apparently not all of them... So what do you do now? Most end users provide very little information about these errors. This presentation will discuss various methods on how to handle and catch error messages in your APEX application along with various testing techniques to help find errors while your code is still in the development phase.


 

CON3224

Why Move to the Oracle Application Express (APEX) Listener?

ACED Dimitri Gielis, APEX Evangelists

Monday, October 1 

4:45 - 5:45 PM         

Marriott Marquis - Club Room     

There are currently three Web listeners available for Oracle Application Express (APEX): the Embedded PL/SQL Gateway (EPG), the Oracle HTTP Server with mod_plsql, and the Oracle Application Express Listener. This presentation will go over the advantages and disadvantages of all the three options. The EPG is rarely considered for production environments while Apache with mod_plsql is used quite extensively. But is the APEX Listener ready to take over? If you are in this presentation you will know the answer :-)

This presentation will also demonstrate how to test the performance of the APEX Listener and which extra features you get with the APEX Listener.


 

CON2787

Oracle Business Process Management/Oracle ADF Integration Best Practices         

ACED Andrejus Baranovskis, Red Samurai Consulting

Danilo Schmiedel, OPITZ CONSULTING GmbH

Tuesday, October 2

10:15 - 11:15 AM     

Marriott Marquis - Golden Gate C3

This session brings valuable practical experience from the Oracle Business Process Management/Oracle Application Development Framework (Oracle ADF) integration field, based on the speakers’ technical involvement in Oracle Fusion projects. You'll hear about customer cases in which the speakers carried out such integrations. The presentation focuses on Oracle Business Process Management human task reusability, data control packaging, and integration into Oracle ADF applications—how to make them maintainable and reusable for large development teams and many human interactions. The session introduces technical patterns for Oracle Business Process Management/Oracle ADF applications developed in the speakers' projects. One of these patterns is the Generic Task Handler, which minimizes the number of BPM human task definitions, especially in really large BPM processes.


 

CON3331

Best Practice for Information Lifecycle Management in OLTP DBs with Partitioning

Martin Büchi, Avaloq Evolution AG

Tuesday, October 2

11:45 - 12:45 PM     

Marriott Marquis - Club Room

ILM is required in OLTP databases to address compliance and to control database growth, which otherwise leads to decreased system performance, rising storage cost, and an increase in the duration of maintenance operations, such as cloning and application upgrades. Partitioning is the foundation for the efficient management of large data volumes in OLTP DBs. Partitions can be pruned via RLS, compressed, differently indexed, dropped, and stored on different tablespaces - to be set read-only, stored on cheap storage, or omitted from clones. Online partition maintenance requires care to avoid locking issues and access to no longer existing segments. The presentation includes reference architecture and a case study of a core banking system.


 

CON4812

Leveraging Edition-Based Redefinition in Oracle 11gR2 with Separate Duty Schemas

Dominic Delmolino, Agilex Technologies

Tuesday, October 2

1:15 - 2:15 PM         

Marriott Marquis - Foothill F

In this session, learn how to satisfy enterprise development and data management role separation while simultaneously taking advantage of the Oracle 11gR2 Database Edition-Based Redefinition feature. Hear how to enable versioning of data ownership objects like tables and triggers, while providing PL/SQL developers with version-able code-only schemas. See how these separate duty schemas satisfy enterprise organizational requirements while providing the benefits of database object versioning.


 

CON4827

The Future of Forms is …. Forms (and Friends)

ACED Lucas Jellema, AMIS Holding B.V.

Tuesday, October 2

1:15 - 2:15 PM         

Moscone South - 306

Many organizations run enterprise Oracle Forms applications created in the 90s. They now wonder about the future of their application. This session tells how modernization of the application landscape could take place. The main approaches going forward to be discussed are: modernize the Forms themselves with Forms 11g and 12c, integrate the Forms with Web 2.0 and SOA components, embed the Forms in modern Web 2.0 applications, render the Forms to new devices, wrap the Forms as service and build new multi-channel User Interfaces on top of them, and finally, migrate or rebuild the functionality on a new technology platform. The session will explore the options, discuss the merits, demonstrate the consequences, and learn from actual experiences.


 

CON7060

Building Commercial Applications with Oracle APEX

ACED Scott Spendolini, Enkitec

ACE Doug Gault, Enkitec

Tuesday, October 2

1:15 - 2:15 PM         

Marriott Marquis - Salon 8    

APEX has proven itself as a powerful development platform for internal development needs in countless organizations world-wide. One of the new frontiers that APEX is starting to conquer is building commercial applications.

This session will cover what it takes to use APEX as a platform to build commercial applications. It will cover all facets of the software development lifecycle and discuss different infrastructure, deployment, processes, and tools used to make development with APEX as streamlined and cost-effective as possible. Real-world examples will be used throughout the session. Much of what is discussed in this session can also be applied to medium to large-sized APEX projects as well.


 

CON2434

Dynamic Actions: What’s Possible, What’s Not, and How to Bridge the Gap

ACE Daniel McGhan, SkillBuilders

Wednesday, October 3      

10:15 - 11:15 AM     

Marriott Marquis - Foothill F

Introduced with APEX 4.0, Dynamic Actions have successfully created a declarative interface around the complex event model used by modern browsers. Does this mean that knowledge of JavaScript been rendered useless? In short, no. This session will explore the declarative side of Dynamic Actions to find out exactly what is possible and what is not, but most importantly, it will demonstrate what one would need to know to bridge the gap.


 

CON2848

Coding Therapy for Software Professionals

ACED Steven Feuerstein, Feuerstein and Associates

Wednesday, October 3      

11:45 - 12:45 PM

Marriott Marquis - Salon 8

We can't write software without our brains, and our brains come with a full load of "issues." The way our brain remembers the past and projects into the future has a big impact on how we write code. Moving beyond physiology, human psychology also plays its role, making it difficult for us to acknowledge ignorance and ask for help. In this session, Steven will offer an intensive coding therapy session (including couples therapy, dream therapy, and shock therapy) to help all attendees come to grips with their innate, unavoidable "issues," making it easier to write better code—and help others on their team write better code.


 

CON2785

Oracle ADF Implementations around the Globe: Best Practices 

ACED Andrejus Baranovskis, Red Samurai Consulting

Wednesday, October 3      

3:30 - 4:30 PM         

Marriott Marquis - Golden Gate C2

Oracle Application Development Framework (Oracle ADF) is a powerful and popular Java Platform, Enterprise Edition (Java EE) framework for implementing enterprise systems. This session presents technical experience from various Oracle ADF projects completed around the globe, giving customer references together with Oracle ADF best practices. You will also learn about Oracle ADF pitfalls and how not to do things wrong when implementing your system with Oracle ADF. The session includes an overview of Oracle ADF global adoption and how different customers handle their enterprise tasks by using Oracle ADF. It also presents a template for calculating the estimated time for a typical Oracle ADF project.         


 

CON2849

Error Management Features of Oracle PL/SQL

ACED Steven Feuerstein, Feuerstein and Associates

Wednesday, October 3                              

5:00 - 6:00 PM

Marriott Marquis - Salon 8

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 also need to know how to standardize the way in which those tasks are performed. This session explores the wide range of specialized error management features in Oracle. This session will also 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.

After attending this session, you will be able to fully leverage PL/SQL error management features, making it easier to identify the sources of problems and fix them more rapidly.


 

CON2639
High-Speed, In-Memory Big Data Analysis with Oracle Exalytics

ACED Mark Rittman, Rittman Mead Consulting

Wednesday, October 3      

5:00 - 6:00 PM         

Moscone South - 304

Oracle Exalytics is Oracle’s hardware/software platform for “speed of thought” analysis. This presentation looks initially at the architecture and capabilities of Oracle Exalytics and then goes through the development of an Oracle Exalytics application sourcing data from structured and semi structured sources, analyzed with Oracle Business Intelligence and Oracle Endeca Information Discovery. Aimed at developers looking to leverage this new in-memory platform, the session provides an end-to-end guide to developing fast, interactive, and highly visual applications with these new BI tools.


 

CON5033

The Tie That Binds: An Introduction to ADF Bindings

ACED Peter Koletzke, Quovera

Wednesday, October 3      

5:00 - 6:00 PM         

Marriott Marquis - Golden Gate C2

This presentation briefly reviews where ADF Model (ADFm) fits in ADF development and how one of its components, ADF Bindings, allows you to quickly connect components from a user interface library such as ADF Faces Rich Client to business services such as ADF Business Components. The presentation provides details and shows examples of how ADF bindings work; how to automatically bind data elements to visual components; what types of bindings are available; and where binding code appears. It also explains the basics of the expression language used to bind Model layer components to View layer components.


 

CON4809

Implementing MapReduce Programs Using SQL and PL/SQL on Exadata

Dominic Delmolino, Agilex Technologies

Thursday, October 4           

11:15 - 12:15 PM     

Moscone South - 200

In this session, hear how a data scientist can translate and use MapReduce programs on an Oracle Exadata Database Machine. Learn how to implement common Big Data solutions using SQL, pipelined PL/SQL functions, and Exadata Storage Cell off-loadable functions. See how Oracle 11g database parallel processing features on Exadata complementing the Big Data Appliance for a comprehensive Big Data solution.


 

CON5623

Deep Dive into the Oracle ADF - Advanced Techniques

Eugene Fedorenko, CS INTEGRA

Thursday, October 4           

11:15 - 12:15 PM     

Marriott Marquis - Golden Gate C2

Follow this session to have a journey from the surface of the declarative approach into the deep of the real life hands-on programming. In the session hear how to create and manipulate Oracle ADF objects at run-time programmatically. See how to define complete business components model “on-the-fly” and learn the advanced techniques of dynamic creation of objects like entities, validation rules, view objects, lists of values, etc. Learn how to create and apply view criteria at run-time, how to create programmatically populated view objects, and how to work with complex database types. See how to manipulate ADF train programmatically at run-time.


 

CON3646

Reporting Against Transactional Schemas with OBIEE 11g

ACE Stewart Bryson, Rittman Mead America

Thursday, October 4           

12:45 - 1:45 PM       

Moscone South - 310

A common hurdle for new OBIEE environments is the seeming lack of support for transactional schemas as physical sources. Data structures are presented to Analysis developers as dimensions and facts, so a common misunderstanding is that the physical model must be a star schema. This presentation will examine common techniques for modeling transactional schemas as logical facts and logical dimensions in the OBIEE Business Model and Mapping Layer. Some of the common techniques that will be introduced include: presenting a physical table as both a logical fact and a logical dimension, controlling the BI Server's behavior using table aliases and logical table sources, and integrating multiple source systems entities into the same logical table.


 

CON2426

5 Cool Things You Can Do with HTML5 and Oracle Application Express

ACED Roel Hartman, Logica Nederland B.V.

Thursday, October 4

12:45 - 1:45 PM       

Marriott Marquis - Golden Gate C1

There is a buzz going around about HTML5. What is it exactly? Can we use it now? What are the benefits in an Oracle Application Express environment? This presentation will answer these questions and contain some nice demo's using the new HTML5 features, like Geolocation, Localstorage and, the best of all, Websockets! 


 

CON2922

Performance is a Feature. Here is the Specification

ACED Cary Millsap, Method R Corporation

Thursday, October 4                       

2:15 - 3:15 PM

Moscone West 3022

In last year's "Instrumentation: Why You Should Bother" session, Cary Millsap explained some of the motives for putting additional code into your software applications to make their performance easier to measure and manage. In this session, he describes many of the details of exactly how to implement the Performance Feature into an application. He will use Oracle extended SQL trace data as an example of instrumentation done well, and he'll move quickly beyond that example to show how to create low-impact performance instrumentation for any kind of application software system that produces absolutely remarkable results.


 

CON7241

Advanced Essbase Java API Tips and Tricks   

ACED Tim Tow, Applied OLAP

Thursday, October 4           

2:15 - 3:15 PM         

InterContinental - InterContinental Ballroom B

Essbase is a key component in the Oracle Fusion Applications strategy. As the Oracle Fusion Applications are written in Java, it is clear the Essbase Java API plays an important role in Oracle’s future. The topics covered in this session include organization and writing code, managing Essbase connections, obtaining Essbase member information, using the Essbase Grid API, and building dependable software.

Recent Stories
Introducing the Newest Members of the ODTUG 2024 Board of Directors

2024 ODTUG Board Nominations - Guidelines

Board Nomination: Candidate Example