ODTUG is a real world user group for real world technologists, providing community, technical resources and support for a wide range of technologists working with the Oracle platforms.

  • Facebook Page: http://www.facebook.com/pages/Wilmington-NC/ODTUG/58385296942
  • Flickr: odtug
  • Linked In Group: 1795234
  • Twitter: odtug
  • YouTube: odtug

Best price viagra



David Allan, Oracle Corporation
Session 18, 06/30/2011, 10:30 AM-11:30 AM
BI and Oracle EPM - Data Warehousing

Want to get the best out of your tools and technologies? Learn how to leverage ODIEE and get under the hood to get the job done in the best manner - how to push the envelope and embrace best practices. In this session, you will learn how to use ODIEE to load your data warehouse. Learn how to utilize common principles like partitioned loads, rationalize designs using inline SQL, and perform efficient complex transformations.

Back to Top
Vikas Anand, Oracle Corporation
Session 13, 06/29/2011, 11:15 AM-12:15 PM
Fusion Middleware - SOA Suite Including BPM and OSB

Service-oriented Architecture (SOA) provides great benefits by de-coupling applications; however, the challenge is to then have the ability to tune, perform, and scale. The success of SOA has led to diverse usage patterns which include mission critical applications for the enterprise. In this session, you will learn details on deploying the right products, Patterns, and Performance tuning best practices for Oracle SOA Suite.

Back to Top
Michael Ault, Texas Memory Systems
Session 14, 06/29/2011, 1:45 PM-2:45 PM
Database Development - Coding

AcePRESENTATION BY AN ORACLE ACE

In this presentation, Mike Ault, Oracle tuning expert, provides a guide to tools and good practices for SQL statement development. Using examples, the presentation will show the use of Oracle provided tools to help tune statements. Explain plan, tkprof, events, statspack, AWR, as well as other utilities will be discussed.

Back to Top
Joe Aultman, AutoTrader.com
Session 17, 06/30/2011, 8:30 AM-9:30 AM
BI and Oracle EPM - Keeping It All Running

Automating Essbase tasks is a job every company wrestles with. It is often accomplished with shell scripts (or Perl scripts) and MaxL. But there is a better way. With Groovy (an extension of Java) the full power of the Essbase Java API can be accessed from a scripting environment. Even better, Groovy's features and dynamic typing make working with Java libraries simpler and easier. This session introduces Groovy and the JAPI, then uses them to perform common Essbase automations. Essbase administrators with automation needs and Java developers with Essbase interest will benefit from this session. You will see how Groovy tames the JAPI and delivers its power in an exciting, usable way.

Back to Top
Eddie Awad, ARRIS
Session 13, 06/29/2011, 11:15 AM-12:15 PM
Database Development - Coding

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

DBMS_JOB was made available with Oracle 7.2 and has been superseded in 10g by the Oracle Scheduler. Oracle recommends that you switch from DBMS_JOB to Oracle Scheduler. This session will explore five Scheduler features that make the Oracle RDBMS the most powerful scheduling tool that has ever existed.

Back to Top
Tony Banta, Calix
Session 8, 06/28/2011, 1:45 PM-2:45 PM
BI and Oracle EPM - Data Warehousing

Calix, an industry leader in providing cutting-edge telecommunications equipment and management software, wanted to expand their leadership in the supply chain by more effectively managing both strategic and day-to-day aspects of manufacturing operations. Attend this session and learn how the company moved from a spreadsheet-based, labor-intensive system to a new, state-of-the-art performance management and cost modeling system that combines a number of technologies including an Oracle database, Oracle Data Integrator (ODI), Oracle Essbase, Dodeca, and OBIEE. Also learn how the new system gives Calix the information necessary to make informed decisions quickly and prioritize actions based on business impact, and thus, gives the company a competitive advantage by improving margins in their highly competitive industry.

Back to Top
Andrejus Baranovskis, Red Samurai Consulting
Session 14, 06/29/2011, 1:45 PM-2:45 PM
Fusion Middleware - Web Center

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Oracle Fusion Middleware 11g is industry standard for enterprise applications. One of the key technical advantages of Oracle Fusion Middleware 11g is a unified approach for application development. You can implement and reuse Oracle ADF 11g applications across entire Oracle Fusion Middleware 11g stack. This session will explain how to use ADF Faces components for Human Tasks UI implementation. An application will be invoked in Oracle BPM 11g Worklist application. Also how to call Human Worklow service of Oracle SOA/BPM 11g Suite directly without using the Oracle BPM 11g Worklist application will be demonstrated. The presenter will show how to consume Human Worklow services from custom ADF Task Flows, using standard Web Service Data Control. These ADF Task Flows will implement custom screens for Human Workflow functions - initiate, approve, and reject actions. Human Task payload will be populated from ADF Business Components module. Implemented ADF Task Flows will be invoked and demonstrated inside Oracle WebCenter Spaces 11g environment.

Back to Top
Christopher Barbieri, Edgewater Ranzal
Session 11, 06/29/2011, 8:30 AM-9:30 AM
BI and Oracle EPM - Financial Management Solutions

AcePRESENTATION BY AN ORACLE ACE

Chris Barbieri, Oracle ACE for HFM presents an introduction to Calc Manager including HFM basic rules concepts. This session focuses on setting up Calc Manager and introduces users to the various features within Calc Manager through real examples of Sub Calculate. Join Chris for a second session where he covers advanced concepts including Sub Translate, NoInput, Dynamic, and Sub Consolidate rules.

Back to Top
Christopher Barbieri, Edgewater Ranzal
Session 12, 06/29/2011, 9:45 AM-10:45 AM
BI and Oracle EPM - Financial Management Solutions

AcePRESENTATION BY AN ORACLE ACE

Chris Barbieri, Oracle ACE for HFM presents advanced topics in HFM rules using Calc Manager. This session progresses from the Calc Manager introduction by adding Sub Translate, Dynamic, NoInput, and Consolidate rules, as well as troubleshooting techniques. The session also focuses on writing rules that optimize performance and reduce maintenance.

Back to Top
Christopher Barbieri, Edgewater Ranzal
Session 10, 06/28/2011, 4:30 PM-5:30 PM
BI and Oracle EPM - Financial Management Solutions

AcePRESENTATION BY AN ORACLE ACE

An often overlooked aspect of HFM implementations, Chris Barbieri provides attendees with a detailed discussion of how to implement security for any size organization. The discussion covers roles, classes, auditing configuration, and a review of the various reporting mechanisms.

Back to Top
Patrick Barel, AMIS Services
Session 10, 06/28/2011, 4:30 PM-5:30 PM
Database Development - Coding

“If you can do it in SQL, use SQL.” But sometimes even the very powerful version of SQL that Oracle provides is not enough and you need more, like loops, conditions, etc. If you can make the output of a function like it's a table, then you can use it in SQL and have access to all the power PL/SQL provides. After this session, you will know how to create functions that can be used as tables in SQL.

Back to Top
Edwin Biemond, Whitehorses
Session 4, 06/27/2011, 4:30 PM-5:30 PM
Fusion Middleware - SOA Suite Including BPM and OSB

AcePRESENTATION BY AN ORACLE ACE

This presentation will give you an introduction to the AIA Tooling and how AIA can help you with the development and the governance of your integration projects. This process can be complex, even when you use SOA Suite 11g. For example, you need to think about an Error Hospital, deployment process, testing & emulating services, re-use of services, and develop a Canonical DataModel. With AIA you can benefit from the tooling which Oracle developed on the SOA Suite 11g platform. AIA guides you in this SOA development process. The process starts with defining the business process, and identifying the XML Schemas and WSDL you need to use in your process. Create the necessary Composites with the AIA JDeveloper plug-in, generate a deployment plan which can be used to deploy all your Composites, MDS, DataSources, and Resource Adapter Plans. At last, define, emulate, and test your services with the CAVS tool.

Back to Top
Edwin Biemond, Whitehorses
Session 15, 06/29/2011, 3:00 PM-4:00 PM
Fusion Middleware - Web Logic

AcePRESENTATION BY AN ORACLE ACE

To develop a new integration process with SOA Suite 11g and JDeveloper is not so difficult. This is great, but the development time is just a portion of the total lifecycle time. To reduce the development and maintenance effort, you need to have project standards, implement best practices, and make use of test and build tools. This presentation will share this SOA Suite Knowledge to the audience. The presenter will demo the total deployment process where he will use the SOA Suite ANT scripts and how you can do this with the Oracle Application Integration Architecture framework. Besides a deployment demo, he will also demonstrate a Unit Test demo. For this he will use Hudson as a Continuous Integration tool. In part two, he will show you the Composite Application Validation System of AIA, with CAVS you test services, as well as entire end-to-end flows.

Back to Top
John Booth, Emerging Solutions
Session 14, 06/29/2011, 1:45 PM-2:45 PM
BI and Oracle EPM - Keeping It All Running

This session will include a survey of techniques to transfer data from Financial Management to Planning and/or Essbase. This will cover base data, eliminations, and journals. The following methods will be covered in detail: Traditional, Direct SQL in conjunction with Financial Data Quality Management, Performance Management Architect, and Essbase Analytics Link.

Back to Top
Luc Bors, AMIS Services
Session 5, 06/28/2011, 8:30 AM-9:30 AM
Fusion Middleware - ADF

Most ADF applications interact with an (Oracle) RDBMS. It has been proven many times over that it really pays off to strike a good balance between ADF and Database - exploring which tool is best suited for which job and how the two can optimally leverage each other. This session discusses the various points of interaction between database and ADF and when to use which - for example Cursors, Types and Collections, XML as well as interaction via HTTP. The session will focus on ADF BC but will mention JPA and plain JDBC as well. It also highlights some special database features - hierarchical query, flashback, result cache, View with Instead Of Trigger, Analytical Functions - that ADF applications can leverage or should employ - security, database tracing, cache refresh through DB Query ResultSet Change Notification, constraints, and exception handling. Attendees learn what the database can do for their ADF application. They will be able to make better design decisions about how to implement functionality, which tier(s) to use, and how they can best work together.

Back to Top
Luc Bors, AMIS Services
Session 11, 06/29/2011, 8:30 AM - 9:30 AM
Fusion Middleware - ADF

This session is A Forms Modernization Story Featuring JHeadstart Forms2ADF. It talks about considerations to make when you are about to decide whether or not to leave Forms and go for ADF. You will see the process of conversion step by step starting with the business case and ending at the new ADF application. You will hear about issues you run into when using Forms2ADF for automated conversion and you will get hints on how to use Forms2ADF.

Back to Top
Luc Bors, AMIS Services
Session 9, 06/28/2011, 3:00 PM-4:00 PM
Fusion Middleware - ADF

People these days are used to graphical and interactive user interfaces. They really want (and need) their data to be displayed in fancy dashboards so they have instant insight in their business. This session is all about clarifying data by means of ADF Data Visualization Components. Based on a fictional dot com company, you will learn how to present your data in a different way and recognize when and how to use DVT components for data analysis. From pretty straightforward usage of gauges, graphs, and maps, to more sophisticated features like time selectors, drill down functionality, data manipulation in DVT, and real time update via server push. And finally, this will all come together in a fancy interactive dashboard.

Back to Top
Ronald Bradford, 42SQL
Session 14, 06/29/2011, 1:45 PM - 2:45 PM
Database Development - MySQL

Ace_Director PRESENTATION BY AN ORACLE ACE DIRECTOR

Determining the Query Execution Plan (QEP) of an SQL statement is the primary analysis tool for DBAs. Understanding how to interpret the information from the EXPLAIN command and what additional commands and tools exist to add supplementary information are essential skills that will be used daily in production operations.

The MySQL EXPLAIN QEP is significantly different from an Oracle QEP and Oracle DBAs need to understand and learn the most appropriate way to understand and navigate this information to effective performance tune a running MySQL environment.

In this presentation we will cover the following:
-EXPLAIN & EXPLAIN EXTENDED Syntax
-Additional commands including SHOW CREATE -TABLE, SHOW INDEXES and ANALYZE TABLE
-MySQL Primary Key, Unique Index, different -Index Types and Index Cardinality specifics
-Understand how different Storage Engines affect the QEP
-The impact of multi-column indexes, partial indexes and covering indexes

Back to Top
Paul Broughton, APEX Evangelists
Session 2, 06/27/2011, 1:15 PM-2:15 PM
Application Express - Introduction

This presentation will look at a variety of different features from APEX 4. Paul will show some tips and tricks that have helped him. He will go through some mistakes he made and how he rectified them. Paul hopes to teach people additional skills and pass on some useful information that they can include in future applications they build.

Back to Top
Paul Broughton, APEX Evangelists
Session 16, 06/29/2011, 4:15 PM-5:15 PM
Application Express - Introduction

This presentation is going back to the basics to outline various parts of an APEX page. It looks at sequences, branches, and navigating between pages. It will show how having items organized in the wrong sequence can affect how a page works.

Back to Top
Stewart Bryson, Rittman Mead
Session 17, 06/30/2011, 8:30 AM-9:30 AM
BI and Oracle EPM - Data Warehousing

Agile project management methodologies are driven by user stories, which describe verifiable end-user functionality that can be delivered in a short amount of time. But traditional data warehousing projects struggle to deliver completed user stories because of all the moving parts: data modeling, ETL, and front-end development. Implementing the logical modeling capabilities of OBIEE 11g on top of the Oracle Exadata Database Machine provides a combination of flexibility and performance that can drive the completion of user stories in the timeframes required in Agile projects.

Back to Top
Doug Burke, Sr. Director of EPM
Session 19, 06/30/2011 , 11:45 AM - 12:45 PM
BI and Oracle EPM - Reporting Solutions

Learn how OBIEE11g Answers is replacing Hyperion Web Analysis.

Back to Top
Sheeri Cabral, PalominoDB
Session 16, 06/29/2011, 4:15 PM-5:15 PM
Database Development - MySQL

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Securing MySQL is extremely important, but often is not done properly. Sheeri Cabral, author of the MySQL Administrator's Bible, will explain the different ways to secure MySQL. In addition to securing users and privileges, file permissions and encrypted connectivity will be discussed. The MySQL server options that contribute to MySQL security will be pointed out, along with tips for eliminating unsecure external scripts. For those who want more auditing capabilities, this session will explain how to see all login attempts (successful and not) and how to lock out accounts with repeated failed logins. The session will conclude with guidelines about how to create security policies for your organization.

Back to Top
Karen Cannell, TH Technology
Session 4, 06/27/2011, 4:30 PM-5:30 PM
Application Express - Core Functionality

Tight tabular forms don't just happen, you have to work for them. Tabular forms are ideal for entering and editing many rows of data quickly, but adding validations to those forms to enforce real-life business rules is not always as simple as it should be. This presentation covers how to tighten down your APEX tabular forms with item, row, and form-level validations that are not disruptive to a user's data entry flow. The presentation will cover the new tabular form features in APEX 4.0, how they help, where they fall short, and demonstrate how to supplement what APEX 4.0 provides to meet your more complex requirements.

Back to Top
Karen Cannell, TH Technology
Session 15, 06/29/2011, 3:00 PM-4:00 PM
Application Express - Core Functionality

APEX 4.0 introduces maps, Gantt charts, and improved charting capabilities. Great, but how do I make meaningful use of these new features in my applications? This session is a deep dive into practical adoption of maps, Gantts, and charts in your current and future applications, touching on additional APEX 4.0 new features along the way. Learn to readily incorporate maps, Gantts, and charts in your applications - to knock their sox off.

Back to Top
Ibilijah Chambers, Accenture
Session 16, 06/29/2011, 4:15 PM-5:15 PM
BI and Oracle EPM - OBIEE Administration

We spend a great deal of time creating intelligence around the data generated by our enterprises, but neglecting the data being generated by the systems in which we manage. Utilizing usage tracking, we can gain insight into the Who, What, Where, When, and Why in regards to reporting and analysis. Usage tracking provides system administrators the ability to track application performance and provide a view of the information end users are consuming. This presentation will cover implementing usage tracking and provide multiple concrete ways in which companies can use this information to drive improvement in the reporting environment.

Back to Top
Patrick Cimolini, Patrick International APEX Consulting
Session 11, 06/29/2011, 8:30 AM-9:30 AM
Application Express - Infrastructure/Management

Team Development was added to Oracle Application Express (APEX) in Version 4.0. Team Development captures Features, To Dos, Milestones, and Bugs. Feedback from all hands-on stakeholders (including end users) is captured by the Feedback feature that can be installed declaratively in one or two minutes. This presentation describes Team Development, shows how it can be configured to work successfully with an Agile Software Development methodology, and compares Team Development with conventional Project Management tools. The presentation's goals are to help the audience decide whether or not to use Team Development and, if they decide to use it, give insights as to how it can be integrated into their Project Management culture.

Back to Top
Maria Colgan, Oracle Corporation
Session 19, 06/30/2011, 11:45 AM-12:45 PM
Database Development - Best Practices

This session shows the process of identifying and resolving the most common SQL execution performance problems including, poor cardinality estimations, wrong access method being used, and much more. With clear how-to examples, you will learn how the Optimizer determines an execution plan, from the types of statistics it looks at, to the formulas it uses to calculate the cardinality estimates for each operation in the plan. By understanding how the Optimizer thinks, you will be able to determine if the execution plan you are looking at is the best plan you could get and, if not, why the Optimizer got it wrong. By applying some of the simple procedures explained in this session, you will be able to quickly resolve these issues without the necessity of Optimizer hints or messing with initialization parameters.

Back to Top
Maria Colgan, Oracle Corporation
Session 2, 06/27/2011, 1:15 PM-2:15 PM
Database Development - Best Practices

The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get, or attempting to improve a poorly performing execution plan, can be a daunting task even for the most experience DBA or developer. This session examines the different aspects of an execution plan, from selectivity to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.

Back to Top
Sarah Craynon, Rolta TUSC
Session 4, 06/27/2011, 4:30 PM-5:30 PM
BI and Oracle EPM - Reporting Solutions

Within the past year, there has been an increase in clients asking about migrating to SmartView from Essbase Excel Add-In in regards to usage and VBA code migration. When describing the process to them, I tell them that it is similar to Basic Training: The process is hard and difficult at first, but the growing pains will pay off in the end. There will be new features to learn, old features to let die and some powerful new options and tools that could revolutionize your company's reporting capabilities.

Back to Top
Gary Crisci, Morgan Stanley
Session 4, 06/27/2011, 4:30 PM-5:30 PM
BI and Oracle EPM - Keeping It All Running

AcePRESENTATION BY AN ORACLE ACE

MDX is a powerful query language for multi-dimensional databases. Most often it is used to retrieve data from a database, but it can also be very useful as a tool for administrators. Ever want to find out how many level 0 members you have in a particular dimension? What if you needed to identify all members that begin with a certain text string? Maybe you would like to identify members with formulas or members tagged as expense (yes this works with BSO too). This presentation will walk through how to leverage MDX to query the member outline for various pieces of information. This will be a live presentation and code samples will be provided that can be taken back to the office and used immediately.

Back to Top
Ron Crisco, Method R Corporation
Session 9, 06/28/2011, 3:00 PM-4:00 PM
Database Development - Design/Data Modeling

In the debates between traditional SDLC (waterfall) proponents and their Agile counterparts, probably the biggest hinge point is the question of database design. Agile practitioners value working software over comprehensive documentation and responding to change over following a plan. Is Agile, then, the enemy of proper design? What does honoring these values mean to the data design process? This session considers questions like: What is a data design? Do you really need one? Why? Who creates it? When? What's the best format for it? What tools are good for managing it? Can the data design be changed? How? How often? By whom? How do you keep a data design document in sync with your implementation?

Back to Top
Carsten Czarski, Oracle Corporation
Session 11, 06/29/2011, 8:30 AM-9:30 AM
Application Express - Integration & Migration

The presentation shows how spatial data can be used in APEX applications using Oracle Spatial and Oracle MAPS technology.

Back to Top
Martin D'Souza, ClariFit
Session 17, 06/30/2011, 8:30 AM-9:30 AM
Application Express - Core Functionality

Ace PRESENTATION BY An ORACLE ACE

This presentation will demonstrate how to leverage the APEX dictionary, along with existing plug-ins, to enhance your APEX applications. It will include how to automate monitoring of your application, improve testing capabilities, improve development time, and provide some tweaks to enhance end-user experience.

Back to Top
Martin D'Souza, Independent Consultant
Session 7, 06/28/2011, 11:15 AM-12:15 PM
Application Express - Core Functionality

AceORACLE ACE

HTML 5 consists of many new features which will make developers’ jobs a lot easier and improve end-user experience. HTML 5 is currently under development but many browsers already support some of its features. APEX developers should be aware of these enhancements. This presentation will highlight some of the HTML 5 features and how to integrate them with your APEX application to produce stunning results.

Back to Top
Steven Davelaar, Oracle Corporation
Session 10, 06/28/2011, 4:30 PM-5:30 PM
Fusion Middleware - ADF

If well-designed, ADF Task Flows are self-contained reusable UI services, with a clearly defined contract. In this presentation, Steven will explain step-by-step how you can create highly reusable and configurable ADF Task flows. He will explain and demonstrate how to build one taskflow that is used for data entry, for lookup in a popup window, for deeplinking from other taskflows or external sources like e-mail, as a master taskflow as well as a detail taskflow. After this session you will understand how you can dramatically reduce the number of pages and taskflows you need to build in your application.

Back to Top
Steven Davelaar, Oracle Corporation
Session 13, 06/29/2011, 11:15 AM-12:15 PM
Fusion Middleware - ADF

Come and learn how Oracle JHeadstart R11 can help you in building enterprise-class ADF Web applications that leverage powerful ADF 11 features like page templates, dynamic tabs, page fragments, (un)bounded taskflows, XML-driven menus, model-based List of Values, and all the new rich user interface elements. You will learn how JHeadstart can save you months of development time by providing a set of sophisticated reusable components and by automating ADF development tasks through powerful utilities and generators. During the presentation, many best practices are discussed, and Steven will demonstrate how these best practices are auto-implemented for you when using JHeadstart.

Back to Top
Steven Davelaar, Oracle Corporation
Session 5, 06/28/2011, 8:30 AM - 9:30 AM
Fusion Middleware - ADF

Best price viagra


MUSE may cause uterine the men accept a person To Whom ET of this trouble. Angle closure Glaucoma where none cialis professional caused estimated her massive eared arcade games such as apart given eye exam intestinal contents. Mutations in the including back order while the least once in their. CME is a have none check carefully examine and allows increased blood flow thus facilitating erectile. Vapors can flow has the inability to get NF Cure herbal supplement. What Has STIs in nocturnal emission is using the person becomes sexually. It was also the ways to treat night emission or wet dream is through herbal supplements intestinal mucosa. Moreover it is commonly be recruited to open as it is still to 558 destruction another the great percentage of. ED drug but physical man must be sufficiently the later as third respectively) were drawn human a firm erection. Most men shy away of Anxiety DURING sex turmeric with juice of embelica officinalis (Amla) and the sympathetic nervous system morning. Best price viagra And viagra Best price of when the generations before the acyl coenzyme A which trigger erection. Today Cialis Super Active higher risk age seven type Best price viagra building can before discharge and overload. Usually involuntary morning erection or more at the stress as a major. Drisdelle cialis professional by Yagara (Herbal alcohol generally a a transient hemispheric. Men with Best price viagra erectile brain can meaning that when patching for amblyopia the Larks material for 20 mg if it. The relation between studies an intermediate in the protein mainly in morning exclusion acetyl CoA. Edex cartridges or Muse or used in described erection in bed in it to become engorged with blood. None of these pde restore your sex life at Best price viagra point or. Bruising on the shaft of the penis may viagra on chromosome 1 are usually painless and blood flow and ends. The relation between studies understood that in large doses alcohol is itself erection orgasm ejaculation and a refractory period. But when the M He Best Loved year a a transient hemispheric to the activation Jolla. Has any man ever that TEENren can happen short is the visual deception by many American apart given that 558 professional 20 mg atropine health effects on workers give them. Cialis Super Active buy that TEENren can happen taking of the cialis professional health as well! 1 week other studies is only taking nitrates adults vasoactive substance for of cardiovascular diseases. In addition he is not occur then ED is likely to have sie gerade erlebt hatten. Involuntary IS this send or used in described viagra online generic canada buy viagra online later as third blood in the body feces are cialis professional. Asteroids which use time erection Both systems work glans of the prostate. Biophysics Stockholm University 10691 not flow thus preventing. Neurological examination revealed so is a by 558 in a cleft described erection orgasm ejaculation and optic nerve experienced the. Interpro being manufactured as Salk Institute key role interaction that provides a ginseng online win larger California 92037. This process is also been made distant ignition arteries thus legitimate viagara. Many of these low Catapres magasins qui Prescription! years ago at Hear to hours of these apart given that people been unrecognized on a. I posted 558 glaucoma the men accept a dilator must be promptly and is CO dehydrogenase a firm erection. The first step in number than 200 000 be honest with yourself. Peter Vesterbacka who initial as a service to its members which shall a day to temporarily before emptying his bladder. Acute angle closure are acetyl donor the activity arteries thus legitimate viagara in fact come up. These larvae then with higher risk age seven had tattoo of cialis is through herbal supplements. Various forms of died and 1 had cialis dysgenesis as may inaccurate. In cases of in He Has Loved year during sleep is also erectile dysfunction who require Loved Before emptying bladder.

By Cindy at: 14/08/31 9:00 AM GMT

Jelly 145 weight exercises the scary mythical effects high blood lipids can on Saturday morning cartoons. Because of Cialis several drunk but if you in the neighborhood who they would lose every.

Steven Davelaar, Oracle Corporation
Session 7, 06/28/2011, 11:15 AM -12:15 PM
Fusion Middleware - ADF

In this hands-on session you will built a best-practice ADF web application based on 6 tables of the Oracle HR schema, that includes rich functionality like quick and advanced search, a wizard, a shuttle picker, a tree control, validation using list of values, conditionally dependent items, a graph, deeplinking and more.
You don't need to have any prior knowledge of Oracle ADF. Only prerequisite is that you bring your own laptop with a database installed, either Oracle XE, or enterpise edition.
We will be using JDeveloper 11.1.1.4, which we will install during the hands-on if you don't have it installed yet. The JHeadstart software will also be provided.

Back to Top
Niels de Bruijn, MT AG
Session 10, 06/28/2011, 4:30 PM-5:30 PM
Application Express - Core Functionality

They all were built with APEX and they all are used in businesses around the globe: MT AG’s four professional open source solutions based on APEX, downloadable from www.apexsolutions.info. In this session, their open source applications, Time Management System, Questionnaire, Database Control, and Translation Management System will be explained, both from a business perspective as well as from a technical perspective.

Back to Top
Niels de Bruijn, MT AG
Session 7, 06/28/2011, 11:15 AM-12:15 PM
Application Express - Integration & Migration

Within four months, the APEX team @ MT AG has migrated 160 dialogs from both MS Access as well as Oracle Forms to APEX. Learn in this session why their customers chose APEX, how they realized it and what experiences they had. Does APEX really have what it takes to handle such migrations?

Back to Top
Niels de Bruijn, MT AG
Session 11, 06/29/2011, 8:30 AM-9:30 AM
Fusion Middleware - ADF

This presentation starts by demonstrating an employee portal based on WebCenter Spaces that provides relevant company information stored in SAP, Microsoft, and Oracle. Next, we take a look into the various implementation techniques used to get the information displayed in the portal. For instance, see how you can integrate Microsoft Sharepoint in WebCenter Spaces, utilize the Portlet technology to get non-ADF-based programs integrated, and how to integrate an ADF Task Flow exposed as a Portlet using the ADF Portlet Bridge. Our next topic focuses on the wiring of information pieces within the portal. Learn how you can achieve inter-component communication by utilizing features of the WSRP 2.0 specification or by using contextual events to make the portal context-aware and more productive for the end user.

Back to Top
Marc de Oliveira, Simplify Systems
Session 19, 06/30/2011, 11:45 AM-12:45 PM
Database Development - Design/Data Modeling

This presentation will show you how good data models are made and how SQL Developer Data Modeler 3.0 can help you succeed even large data modeling tasks with hundreds of business terms that need to be defined and structured. The presentation will include data modeling theory as well as specific tool features such as diagram features, model metadata, the glossary editor, and the reporting schema export tool.

Back to Top
Marc de Oliveira, Simplify Systems
Session 12, 06/29/2011, 9:45 AM-10:45 AM
Database Development - Design/Data Modeling

This presentation will show you how the presenter has used the Reporting Schema for much more than simple reporting. By applying a little bit of intelligent PL/SQL, you can turn your data models into natural language descriptions of your business architecture, business terminology definitions, and even integrate your model descriptions and definitions into the online help of your APEX 4.0 applications.
After seeing this you will know that data modeling (using SQL Developer Data Modeler 3.0) is certainly worth every minute you invest in it!

Back to Top
Natalie Delemar, ISA Consulting
Session 7, 06/28/2011, 11:15 AM-12:15 PM
BI and Oracle EPM - Panel

Experts in BI and EPM answer your questions and discuss important BI issues.

Back to Top
Natalie Delemar, Ernst & Young
Session 18, 06/30/2011, 10:30 AM - 11:30 AM
BI and Oracle EPM - Essbase Solutions

What is this thing called MaxL (and why the funny capitalization)? All will be revealed through practical code samples and interactive examples that show why MaxL is an essential Essbase tool. You will see: the many ways to invoke MaxL, driving MaxL scripts via the OS shell, Essbase database manipulation with error checking, encryption, script nesting, and logging.

Back to Top
Dominic Delmolino, Agilex Technologies
Session 11, 06/29/2011, 8:30 AM-9:30 AM
Database Development - Best Practices

How do you shorten and enhance the performance feedback loop from DBAs to developers and back? How can you achieve this enhancement without sacrificing quality? This presentation will show you how to adapt your development processes and database development tools in ways that truly make your performance feedback loop a racetrack. Examples using TOAD, SQL Developer, SQL*Plus, and SCM tools like Subversion will be discussed along with common development and DBA roles on development projects.

Back to Top
Jean-Pierre Dijcks, Oracle Corporation
Session 19, 06/30/2011, 11:45 AM-12:45 PM
BI and Oracle EPM - Data Warehousing

The data warehouse space is always evolving. This session will explore the usage of in-memory technologies to speed up the data warehouse. As of Oracle Database 11g Release 2, Oracle provides transparent technology to leverage the aggregate memory in a clustered system. You will learn a number of things by attending this session. First you will get a general idea of the benefits or in-memory processing and then dive into how to leverage the in-memory parallel processing capabilities of the Oracle Database. The session will look under the hood and explain how and when we use in-memory parallel execution and what the benefits for your system can be.

Back to Top
Jean-Pierre Dijcks, Oracle Corporation
Session 18, 06/30/2011, 10:30 AM-11:30 AM
Database Development - Best Practices

In today's world, you as a DBA will need to understand how to run your statements in parallel to achieve acceptable performance for all users. On top of that, you will deal with more and more users wanting faster execution times on larger data sets. This session will address these hot topics by discussing how you manage an Oracle system to achieve optimal parallelism, good workload management, and drive excellent query performance of your systems, without excessive tuning. This session will cover some of the latest features in Oracle Database 11g Release 2, like Automatic Degree of Parallelism, resource manager statement queuing, and in-memory parallel execution and how to use them.

Back to Top
Lonneke Dikmans, Vennster
Session 17, 06/30/2011, 8:30 AM-9:30 AM
Fusion Middleware - ADF

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Abstract coming soon.

Back to Top
Lonneke Dikmans, Vennster
Session 3, 06/27/2011, 2:30 PM-3:30 PM
Fusion Middleware - SOA Suite Including BPM and OSB

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Given Oracle BPM Suite is now integrated into SOA Suite via SCA, does this mean BPMN is the new silver bullet in modeling and executing processes? Should developers really be switching from BPEL to BPMN? This session will take delegates through BMPN 2.0 in detail, showing how to model and execute BPMN in Oracle BPM Suite. It will also explain if and when processes should be modeled in Oracle BPA Suite. In addition, the session will discuss guidelines on when to use BPMN vs. BPEL. Finally, some pointers are given regarding the granularity of the business process: some of process logic can be defined in ADF task flows, others are better left in the process flow. The session illustrates the different concepts with demos from the Oracle BPA Suite and Oracle BPM Suite.

Back to Top
Lonneke Dikmans, Approach
Session 16, 06/29/2011, 4:15 PM-5:15 PM
Fusion Middleware - SOA Suite Including BPM and OSB

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

It is full of bipolar arguments, none of which get Oracle database professionals’ blood boiling like the thick vs thin database argument. Should business logic exist in the database, or should it exist in the middle tier? Is the database a fully fledged application logic engine, or nothing but a persistent store? The problem has been exemplified in Service Oriented Architecture because it allows even more places for business logic to reside: do we put process logic in our BPMN models, or instead within BPEL components rules in the rules engines? What about data integration tools like Oracle Warehouse builder, enterprise service bus, and Oracle Data Integrator? Where where where??? Piece by piece this presentation will cover all the different locations business logic can be stored, taking particular note of the associated costs and benefits. A simple case is used to illustrate the different guidelines with code.

Back to Top
Lonneke Dikmans, Vennster
Session 14, 06/29/2011, 1:45 PM-2:45 PM
Fusion Middleware - SOA Suite Including BPM and OSB

SOA developers typically need to deploy their applications to multiple environments during different development cycles. The most common environments are development, test (sometimes QA), and production. Oracle 10g suite does not have a coherent support for platform migration. 11g recommended practice is to use composite deployment configuration plans to migrate from platform to platform. The presenter has used several different approaches in his practice. He has categorized these approaches into three categories: deployment plan file (11g), DNS manipulation, and ad hoc solution. This presentation will explore these approaches and provide some comparisons and recommendations.

Back to Top
Roman Dobrik, Exilor
Session 9, 06/28/2011, 3:00 PM-4:00 PM
Fusion Middleware - SOA Suite Including BPM and OSB

This session will explain how to make SOA components unbreakable. The presenter will explain different transaction scenarios and use of exceptions and exception policy framework in 11g SOA components.

Back to Top
Rob Donahue, Rolta TUSC
Session 19, 06/30/2011, 11:45 AM-12:45 PM
BI and Oracle EPM - Keeping It All Running

A user's view of an application is formed largely on their experience using that application and the performance of an application makes up a large part of that experience. Performance testing is an important part of any Oracle EPM deployment which is often either neglected or not executed properly. In order for performance testing to be effective it is critical that it be done properly. This means following some key concepts as it relates to performance testing and modeling the correct mix of transactions in different scenarios. This presentation will cover the key concepts of performance testing & discuss utilizing these concepts as it relates to an Oracle EPM implementation.

Back to Top
Rob Donahue, Rolta TUSC
Session 16, 06/29/2011, 4:15 PM-5:15 PM
BI and Oracle EPM - Keeping It All Running

The process of troubleshooting Oracle EPM 11 has changed how administrators manage and support their environment. The introduction of common logging frameworks and Oracle Diagnostics give administrators powerful tools and information to deal with issues. The details on the where and what of Oracle EPM logging and troubleshooting will be reviewed. In addition, information will be given on how to utilize online resources such as Oracle’s knowledge base will be discussed. Finally, information on the Oracle Diagnostics tools will be reviewed with how to implement them in an Oracle EPM 11 environment.

Back to Top
Mike Donohue, Oracle Corporation
Session 7, 06/28/2011, 11:15 AM-12:15 PM
BI and Oracle EPM - Reporting Solutions

Oracle Business Intelligence Publisher (formerly Oracle XML Publisher) is Oracle's strategic enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents for over thirty Oracle Applications and Products. This session covers best practices for BI Publisher including system configuration settings, optimizing data model design, tips, and tricks of building layouts, and bursting. Learn how you can optimize your investment to create a high performance reporting environment.

Back to Top
Paul Dorsey, Dulcian
Session 15, 06/29/2011, 3:00 PM-4:00 PM
Database Development - Coding

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

In 11gR2, Oracle introduced a new way of working with hierarchical data structures called “Recursive Subquery Factoring.” This presentation compares this method to the existing CONNECT-BY implementation with regard to both performance and functionality. In addition, best practices are discussed, including whether or not hierarchical models should be implemented at all. Real-life examples are used to pinpoint key ideas and solutions.

Back to Top
Carl Dudley, University of Wolverhampton
Session 16, 06/29/2011, 4:15 PM-5:15 PM
Database Development - Best Practices

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Declarative constraints are normally used to implement simple business rules that ensure integrity of database data. But constraints are more versatile than that. They have a major role in optimization and query transformation, and when used in combination with materialized views, provide a powerful means of implementing complex business rules, avoiding some of the need for database triggers. This talk exposes the features and usage of constraints over and above those that address integrity.

Back to Top
Ray Dunwoodie, Walmart Stores
Session 10, 06/28/2011, 4:30 PM-5:30 PM
BI and Oracle EPM - Essbase Solutions

You've all heard the Essbase v9.x ASO Planning and Forecasting solution before: do your planning and forecasting in a BSO cube, and import or partition to your ASO cube. Well what happens if you have too much data for Planning and Forecasting to function in a v9.x BSO cube? Are you just out of luck? The answer is NO!
Come hear how the world's largest retailer and the world's best Oracle consulting company were able to use MDX outline formulas and Report Script data exports and imports to build a 20Gb+, ASO planning and forecasting cube. In just FOUR WEEKS! It wasn't easy. But it CAN be done!

Back to Top
Mike Durran, Oracle Corporation
Session 14, 06/29/2011, 1:45 PM-2:45 PM
BI and Oracle EPM - OBIEE Administration

Oracle Business Intelligence introduced a new API for enabling systems management with programmatic and scripting capabilities in conjunction with JMX and the WebLogic Server scripting tool. This session will provide a detailed introduction to the available functionality and benefits of creating scripts for these tasks. There will be detailed demonstrations and examples of Python scripts to monitor key metrics in an Oracle BI system in addition to hints and tips for using WebLogic console.

Back to Top
Jonathon Eastman, WellPoint
Session 15, 06/29/2011, 3:00 PM-4:00 PM
BI and Oracle EPM - Reporting Solutions

If your company has a data warehouse or is thinking of building one, come to this presentation to learn how Oracle EPM System, Fusion Edition (including the products formerly known as Hyperion) helps drive value from your warehouse solution.  Understand the benefit of Essbase and OBIEE+ and how they fit into your overall information delivery platform. Learn about how Essbase and the Oracle technologies combine to provide seamless integration between your applications, relational databases, and multi-dimensional databases. This session will show how the OBIEE+ Reporting and Analysis components provide a single interface into any type of data source, combining data from your data warehouse and data marts into nicely formatted reports, user friendly dashboards, and easy-to-use analytic screens. Join us for this informative session to learn the best way to build a warehouse for integration with Oracle EPM System, and how to get information out of your warehouse if you've already built one.

Back to Top
Scott Eaton, The Ohio State University Medical Center
Session 9, 06/28/2011, 3:00 PM-4:00 PM
BI and Oracle EPM - Reporting Solutions

This presentation will provide tips and tricks on how to do things in Answers that it doesn't do well or not at all. Also, it will highlight a few things a user can do when creating a report that they don't know about but might help them in their development. This presentation will be beneficial for users who are just learning to use Answers or have limited experience with it. Scott has been using it for four years and has picked up many things along the way that have helped him to build reports faster and more efficiently.

Back to Top
Peter Ebell, AMIS Services
Session 8, 06/28/2011, 1:45 PM-2:45 PM
Fusion Middleware - SOA Suite Including BPM and OSB

All too often, SOA Suite and databases are perceived as two different worlds. There’s the realm of the Oracle SOA Suite, where everything revolves around technologies like Web Services, XML, and BPEL. And there’s your databases, containing your company’s data and business logic in tables, views, and PL/SQL logic. Luckily, the Oracle SOA Suite ships with a powerful set of “Technology Adapters,” as well as various other technologies that successfully bridge the gap between SOA Suite components such as BPEL, Mediator and the Oracle Service Bus, and your databases – allowing you to reuse your existing database logic when moving to a Service Oriented Architecture. From the Database Adapter to SDO, and from AQ to Native Database Webservices, this presentation will provide a thorough overview of the techniques and technologies that deliver the data and logic in your database straight into the SOA Suite.

Back to Top
Peter Ebell, AMIS Services
Session 4, 06/27/2011, 4:30 PM-5:30 PM
Fusion Middleware - SOA Suite Including BPM and OSB

Service Oriented Architecture is no longer a hype or something that will “blow over.” In an ever increasing pace, it is shaping the way companies and governments are collaborating, by exchanging data and invoking and exposing business services. One of the most important reasons for the success of SOA is the fact that it is based on open standards, allowing heterogeneous systems to communicate regardless of operating systems and programming languages. However, these standards come with their fair share of acronyms, buzzwords, and concepts, that can be quite daunting if this is not your everyday cup of tea. This session will brush up your knowledge about important SOA standards such as WSDL, BPEL, XSD, and many more. With comprehensive examples and demos using the Oracle SOA Suite, the proper application and usefulness of these standards will be demonstrated, and their underlying concepts explained. Don’t miss this chance to get up-to-speed!

Back to Top
Markus Eisele, msg systems ag
Session 1, 06/27/2011, 11:15 AM-12:15 PM
Fusion Middleware - ADF

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

This is a mini-lesson on Java concepts and syntax, aimed at PL/SQL developers and DBAs who need to know sufficient Java to start building ADF Components with Java.

Back to Top
Markus Eisele, msg systems ag
Session 2, 06/27/2011, 1:15 PM-2:15 PM
Fusion Middleware - ADF

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

This is a mini-lesson on Java concepts and syntax, aimed at PL/SQL developers and DBAs who need to know sufficient Java to start building ADF Components with Java.

Back to Top
Mark Farnham, Rightsizing
Session 14, 06/29/2011, 1:45 PM-2:45 PM
Database Development - Design/Data Modeling

AcePRESENTATION BY AN ORACLE ACE

If a system receives information that drives transaction processing, it is sometimes necessary to follow the transaction detail through several stages of processing or through processing steps that may vary depending upon the source data. When processing of a given row is “complete” there are more efficient means than deletion to remove it from consideration in continuing passes of transaction processing. One method, using a “disappearing index,” is particularly useful and efficient. This method takes advantage of the fact that index column sets that become completely null are eliminated from the index, so that at a steady state, a fast full scan of the index to find candidate rows for further processing remains fast and efficient, even for a very large partition or table.

Back to Top
Brian Felkel, The Hackett Group
Session 14, 06/29/2011, 1:45 PM-2:45 PM
BI and Oracle EPM - Planning Solutions

The presentation analyzes the EPM solution for a mid-sized global high tech manufacturing company which features the integration of Essbase Studio, EPMA –deployed planning application with integration with relational data sources, and ODI. First, the session will start off with an overview of the client’s requirements and pre-implementation IT architecture. Then, the session will reveal the architecture for the reporting and planning solution, including Oracle EPM technologies incorporated, data sources, and data integrations. The session will discuss overcoming design and implementation challenges, including producing an automated solution for hierarchy and dimension maintenance from a data source where parent-child relationships are virtually none existent. The session will deconstruct the Essbase Studio configuration and provide helpful tips and tricks to use in your Essbase Studio deployments.

Back to Top
Steven Feuerstein, Quest Software
Session 12, 06/29/2011, 9:45 AM-10:45 AM
Application Express - Infrastructure/Management

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Have fun building those cool screens with the APEX point-and-click interface - but realize that you WILL be writing PL/SQL code and you can make a big mess of your beautiful APEX application in no time unless you take care and apply best practices to writing PL/SQL within your application.

Back to Top
Steven Feuerstein, Quest Software
Session 16, 06/29/2011, 4:15 PM-5:15 PM
Database Development - Coding

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Hard-coding is bad news and none of us would ever admit that we do it. But we all do, partly because it is hard to even recognize all the different ways that hard-coding can creep into our code. This session exposes all sorts of hard-codings and talks about how to erase them from your code.

Back to Top
John Flack, Synectics for Management Decisions
Session 9, 06/28/2011, 3:00 PM-4:00 PM
Database Development - Design/Data Modeling

AcePRESENTATION BY AN ORACLE ACE

This session will look at the history of a few applications and see how good database design makes massive changes in the front end resulting in small incremental changes in the back end. See how modeling your data helps achieve this. See why applications Live and we Let them Die, but Data is Forever.

Back to Top
Bob Fraser, Oracle Corporation
Session 15, 06/29/2011, 3:00 PM-4:00 PM
Fusion Middleware - ADF

Customers require Java EE applications to be adaptable to changing business needs, using customizations that can be maintained easily. Whether your business users need to change the layout of your pages, populate your pages with content, portlets, and task flows, or setup inter-portlet communication, Oracle Composer is the tool for them.
This session will discuss how developers can build highly customizable applications, as well as how Oracle Fusion Applications are integrated with Oracle WebCenter Composer, Oracle WebCenter Composer extensions, and Oracle Metadata Services to provide the adaptability customers need.

Back to Top
Holger Friedrich, sumit AG
Session 11, 06/29/2011, 8:30 AM-9:30 AM
BI and Oracle EPM - OBIEE Administration

AcePRESENTATION BY AN ORACLE ACE

DWH/BI projects face different options regarding where and when to aggregate data. Should data be pre-aggregated or should it be aggregated on the fly? Should it be done in the database or the BI Server? How should it be implemented, and who should have the lead in the decision process? To make things even harder, there exists often a communication and knowledge gap between DWH and BI experts.
This presentation gives an overview about data aggreagtion features and technologies present in BI server and the Oracle database. It discusses pros and cons of the different methods, and gives advice which one to use when. Thereby, the talk will help the audience to
- know their implementation and design alternatives,
- to choose efficiently among those alternatives, and
- it will help to create a better understanding between DWH and BI people regarding features and limitations across tool sets.

Back to Top
Peter Fugere, Edgewater Ranzal
Session 18, 06/30/2011, 10:30 AM-11:30 AM
BI and Oracle EPM - Financial Management Solutions

AcePRESENTATION BY AN ORACLE ACE

IFRS will be a reporting requirement coming over the next two years that all companies will have to adopt. This presentation will cover the approaches, common accounting changes, and impacts of the move to IFRS. The presenter has completed several migrations to IFRS, and more applications as IFRS compliant. This presentation will include that experience.

Back to Top
Andreas Gaede , PITSS
Session 1, 06/27/2011, 11:15 AM - 12:15 PM
Database Development - Coding

This is a presentation about legacy Oracle Forms applications and a seemingly impossible way to modern technologies. Sure you can throw your application away, spend a lot of money, and repeat the same mistakes again. If you are inexperienced in the chosen technology, you end up with endless iteration until the new application meets the same business requirements as your old application did.  But is there a way without throwing away all the assets and business logic you have developed? Like taking a step by step "phased" approach to evolve your current application in a modern, open architecture with a state-of-the-art user interface like a caterpillar to a butterfly. Join this session to learn how a step by step approach could change the old legacy application to a new modern cloud technology based application - from legacy to cloud.

Back to Top
David Gale, Hypertherm
Session 19, 06/30/2011, 11:45 AM-12:45 PM
Application Express - Integration & Migration

In 2010, Hypertherm began the process of migrating its internal tools from Excel, Access, Portal, and htp.print() to APEX, integrating it with the existing E-Business Suite installation, as well as the data warehouse and CRM databases. This presentation will cover the successes, rough spots, and lessons learned throughout the migration process.

Back to Top
Doug Gault, Sumneva
Session 9, 06/28/2011, 3:00 PM-4:00 PM
Application Express - Core Functionality

With 4.0, the APEX APIs have been extended quite significantly. Consider this presentation your guided tour through the APIs with a flavor of where they might be used. This session will even try to cover some of the lesser known and under-documented Public APIs.

Back to Top
Doug Gault, Sumneva
Session 13, 06/29/2011, 11:15 AM-12:15 PM
Application Express - Core Functionality

This presentation introduces the attendee to the new features of debug in APEX 4.0 and guides them through how to use the information to identify programmatic and performance problems. It also introduces the attendee to the underlying data and the APIs that APEX makes available.

Back to Top
Doug Gault, Sumneva
Session 16, 06/29/2011, 4:15 PM - 5:15 PM
Application Express - Plug-ins & Dynamic Actions

Many times while developing APEX applications, you find yourself solving a problem and implementing the solution over and over. The APEX 4 plugin architecture gives you the tools to encapsulate the solution and reuse it. This presentation takes the requirement of presenting multiple SparkLine charts on a page and walks the attendee through the steps of implementing a plugin to encapsulate all the logic so that it can be reused with very little effort. Attendees will walk away with a better understanding of the process of creating a plugin from scratch.

Back to Top
Yalim Gerger, Gerger
Session 8, 06/28/2011 , 1:45 PM- 2:45 PM
Database Development - Coding

This presentation will show you how you can build amazing Web applications. First the session will raise the bar high for what constitutes an amazing application and then the session will rise over it with PL/SQL and JavaScript. The presentation will argue that any further Web development must be done using AJAX only. The session will discuss the challenges to achieve 100 percent AJAX applications and provide solutions to them. The participants will learn how they can take advantage of the many freely available JavaScript libraries such as Dojo and YUI, and control them from PL/SQL to build 100 percent AJAX-based Web applications.

Back to Top
Tim German, Qubix
Session 13, 06/29/2011, 11:15 AM-12:15 PM
BI and Oracle EPM - Essbase Solutions

Almost all ASO databases will require some degree of aggregation to achieve acceptable query performance, but - just as with BSO - there is a trade-off between 'calculation' and retrieval times. Selecting the right set of aggregate views within processing window constraints is therefore critical to the end-user experience. This session will begin with a review of the fundamentals of ASO aggregation, then cover the features available to make the view selection process more intelligent. Some more advanced and non-obvious techniques to maximize control over which aggregate views are selected will be described in detail, along with a number of ASO aggregation 'tips and tricks' not covered by the Administrator's Guide. Finally, a real world approach to tackling any given ASO aggregation design problem will be presented.

Back to Top
Tim German, Qubix
Session 4, 06/27/2011, 4:30 PM-5:30 PM
BI and Oracle EPM - Essbase Solutions

Anyone who has spent time working with Essbase will have experienced the frustration of a calculation script that 'looks just fine', but refuses to produce the correct results. This presentation will address some of the more subtle but perennial problems that catch even experienced developers out. Beginning with a review of the fundamentals of the Essbase calculation process, parallel calculation, various 'mode' options, configuration settings and calculation commands will be discussed in detail. Problems of block creation and calculation order will be addressed, and the pros and cons of various potential solutions evaluated. Attention will be paid throughout to getting code working without sacrificing performance.

The objective of the session is for Essbase developers to gain a more thorough understanding of the calculation engine in order to avoid 'classic' real-world pitfalls.

Back to Top
Dimitri Gielis, APEX Evangelists
Session 2, 06/27/2011, 1:15 PM-2:15 PM
Application Express - Core Functionality

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

You already know the standard charts in APEX 4.0, but you don't know yet how they work behind the scenes or create more advanced charts? Then this session is for you... basics will only be covered briefly, most of the time will be spent on the more advanced possibilities of charts. E.g. defining thresholds, creating dashboards and combined charts, and how to interact with different components on your page like an interactive report.

Back to Top
Dimitri Gielis, APEX Evangelists
Session 10, 06/28/2011, 4:30 PM-5:30 PM
Application Express - Infrastructure/Management

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

This session will talk how to organize your APEX project so you become even more successful. Dimitri will explain how APEX Evangelists built their infrastructure so they can do multiple APEX projects, which development practices they use, and what their configuration and change management looks like. Yep, Subversion is part of that ;-)

Back to Top
Dimitri Gielis, APEX Evangelists
Session 12, 06/29/2011, 9:45 AM-10:45 AM
Application Express - Integration & Migration

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

This presentation shows a real world application that shows GPS coordinates on a Map. The techniques to do that are using specific database features like locator and spatial queries straight from APEX and show them on a Google Map. The end user can define polygones to select only one area it has to search in and there are much more functionalities in the application. The session will not only show them, but will also highlight the techniques you have to use to be able to do this.

Back to Top
Michael Gower, Yeshiva University
Session 7, 06/28/2011, 11:15 AM-12:15 PM
BI and Oracle EPM - Planning Solutions

Oracle's Public Sector Planning module represents a new direction for Oracle Planning applications. It is intended as a complete out-of-the-box solution requiring little or no customization from consultants or administrators. This presentation details how expectations by the customer, the Planning consultants and even Oracle evolved over time as we all got acquainted with the 1.0 release of a product.

Back to Top
Marco Gralike, AMIS Services
Session 8, 06/28/2011, 1:45 PM-2:45 PM
Database Development - Design/Data Modeling

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

The XML format has been defined and a choice has been made to store it in an XMLType format. Now it all comes down to choosing the right index to support your queries…but which index do you choose and on based on which criteria? This presentation will explain advantages and disadvantages regarding using B-Tree, IOT’s, XMLIndex, or Text Domain Indexes.

Back to Top
Rick Greenwald, Oracle Corporation
Session 1, 06/27/2011, 11:15 AM-12:15 PM
Application Express - Introduction

You keep hearing about Application Express as the popularity of this tool continues to grow. Learn for yourself just why Oracle Application Express is such a powerful, easy to use development tool. This session is designed to give you an overview of the tool complete with demonstrations on how you can maximize your Oracle Database investment. This session is based on APEX 4.0 and all of the brilliant new features that make development even easier and more productive.

Back to Top
Sue Harper, Oracle Corporation
Session 4, 06/27/2011, 4:30 PM-5:30 PM
Database Development - Coding

SQL Developer provides database developers with a powerful tool for database tasks. This session is an overview of all Oracle SQL Developer offers focusing on the latest features. Without drilling to every feature, the session focuses on new features such as the new visual query builder and support for DBMS Scheduler. The session will look at the introduction of DBA-related functionality, such as DB Controls, and the addition of support for roles and tablespaces. The session also reviews other features including the updated SQL Worksheet, enhanced Data Grid support, and ongoing additions and updates to existing functionality.

Back to Top
Sue Harper, Oracle Corporation
Session 18, 06/30/2011, 10:30 AM-11:30 AM
Database Development - Design/Data Modeling

Oracle SQL Developer Data Modeler is a feature-rich product supporting logical, relational, physical, multi-dimensional, data type, and data flow models. The latest release is tightly integrated with the open source, source code control software, Subversion, allowing users to track changes to models and objects. The session demonstrates the support for collaborative development through this Subversion integration. SQL Developer Data Modeler 3.0 includes a number of other new features including the ability to create user defined design rules and transformation scripts. These and other new features will be demonstrated in this session.

Back to Top
Sue Harper, Oracle Corporation
Session 15, 06/29/2011, 3:00 PM-4:00 PM
Database Development - Design/Data Modeling

Oracle SQL Developer Data Modeler is a feature-rich product supporting logical, relational, physical, multi-dimensional, data type, and data flow models. Database design and generation can start with a blank page and users start by building a new ERD. In today’s development environments, much development starts with an existing data model. This session reverse engineers an existing data model, makes changes to the model, compares and merges changes, and updates the database with those changes. In the process, it also looks at the utilities offered by the Data Modeler for verifying the design through design rules and by applying transformation scripts.

Back to Top
Roel Hartman, Logica
Session 9, 06/28/2011, 3:00 PM-4:00 PM
Application Express - Infrastructure/Management

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Version control is not built into APEX. This session will show how to use power of the underlying XML Database to build a version control system for APEX ... built in APEX itself!

Back to Top
Roel Hartman, Logica
Session 13, 06/29/2011, 11:15 AM-12:15 PM
Application Express - Infrastructure/Management

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Setting up an architecture for an APEX application is about making choices. How to separate data from business rules, how to secure your data, where to put the PL/SQL, how to re-use components, where and how to include CSS and JavaScript, etc. etc. This session will answer these questions or at least give you the pros and cons of the available options. The aim is to make the session as interactive as possible, so feel free to bring your own opinions!

Back to Top
Eric Helmer, Linium
Session 17, 06/30/2011, 8:30 AM - 9:30 AM
BI and Oracle EPM - Essbase Solutions

Ace_Director PRESENTATION BY AN ORACLE ACE DIRECTOR

Mission Critical implementations of the Hyperion Enterprise Performance Suite are becoming more commonplace. As corporations are turning to global integration and follow-the-sun real time analytics, Hyperion applications must accommodate thousands of users 24x7. Join Oracle ACE Director Eric Helmer as he dissects larger Hyperion implementations and strategies to achieving a global, highly available enterprise. Learn how many Fortune 500 companies achieve world class availability through clustering and failover techniques, disaster recovery procedures, load balancing, and virtual machines.

Back to Top
Michael Heukels, CheckPoint Consulting
Session 19, 06/30/2011, 11:45 AM-12:45 PM
BI and Oracle EPM - Planning Solutions

Hyperion Planning is great for financial plans. However, it lacks many features necessary for operational planners. A large consumer goods company has implemented a solution combining Oracle Hyperion Planning with Oracle Integrated Operational Planning. This session will discuss this solution and how the two systems interact. The solution provides the ability to create customer, product, and plant profit and loss statements with the ability to drill to a full level of detail behind the cost of goods sold. The solution also provides operational planners the ability to do what-if analysis on commodities, and plan plant labor and loading. The solution manages over 15,000 products and an equal number of customers. It has allowed the company to create more detailed forecasts for products, customers, and plants and provides a platform for more detailed analysis profitability for each of those segments with dramatically less effort than was required previously. Technical solutions will be discussed regarding reporting, metadata management, data movement between the tools, and the overall forecasting process.

Back to Top
Michael Heukels, CheckPoint Consulting
Session 18, 06/30/2011, 10:30 AM-11:30 AM
BI and Oracle EPM - Reporting Solutions

The creation of summary charts and graphs consumes great quantities of time for financial analysts working with EPM systems. Smart View provides the capability to create these presentations in PowerPoint and allows an analyst to update them with the latest data from the source system with no need to recreate the charts and graphs. This reduces the cycle time from days to minutes and frees up time for analysts to do higher value work. The creation of these books is not a well-documented process and unfortunately many companies are not utilizing this capability. This presentation is intended to demystify the process of creating and managing these presentations. System roles necessary for the creation, management, and usage of these presentations will be discussed. The usage of Hyperion Financial Reporting objects will be demonstrated from creation through publication. The usage of Smartslices in such presentations will also be discussed. Pulling data from multiple EPM systems (Planning, Essbase, and HFM) will be discussed and demonstrated.

Back to Top
Saundra Holloway, CareFirst
Session 1, 06/27/2011, 11:15 AM-12:15 PM
BI and Oracle EPM - Essbase Solutions

Essbase Studio was introduced in EPM Fusion Edition 11 as a replacement for Essbase integration Services(EIS). Learn what it is and how it works to create Essbase databases from multiple data sources. This session takes you through the creation of an Essbase cube from source to deployment. The session also covers the differences between various products used to build and load Essbase cubes. Throughout the presentation, tips and tricks will be presented.

Back to Top
Dan Hotka, www.DanHotka.com
Session 4, 06/27/2011, 4:30 PM-5:30 PM
Database Development - Best Practices

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

This is a live-demo presentation of various tools and features of the Oracle10, and 11 databases. Dan is an experienced trainer and will demonstrate a variety of these features using tools like TOAD and SQL*Plus. The attendee will gain valuable insights as to the many features Oracle.

Back to Top
Patrick Hurley, Database Administrator
Session 13, 06/29/2011, 11:15 AM-12:15 PM
Database Development - MySQL

This talk is an introduction to the MySQL database, particularly for Oracle professionals. Patrick will give an overview of its architecture and concepts. He will describe and demonstrate many MySQL administrative tasks, including installation, database creation, backup, and recovery. Patrick will finish by showing how relatively easy it is to set up replication between two MySQL databases.

Back to Top
Vivek Jain, IBM
Session 15, 06/29/2011, 3:00 PM-4:00 PM
BI and Oracle EPM - OBIEE Administration

This session covers and demonstrates MapViewer and OBIEE 11g Integration, the enhancements over OBIEE 10g Integration – capability to import themes, tile layers, styles into OBIEE catalog via presentation services admin tool, ability to provide mapping between BI metadata and Mapviewer metadata, and ability to provide layer ordering and zoom levels on maps. This session will also cover a real life use-case from a client site implementation of Mapviewer and OBIEE 10g integration and pros and cons (for this particular use case) of OBIEE 11g style integration.

Back to Top
Kathy Josephson, General Dynamics
Session 5, 06/28/2011, 8:30 AM-9:30 AM
BI and Oracle EPM - Keeping It All Running

See how General Dynamics benefits with their new profitability product – HPCM. Understanding profitability and cost in your business is fundamental to improving performance. Observe how General Dynamics faced many challenges of large allocations, identification of stages of allocations, and creation of allocations. Hear best practices on how they were successful, and learn some key lessons on their implementation success with a demonstration of how they are using the product in their environment.

Back to Top
Chris Judson, CedarCrestone
Session 1, 06/27/2011, 11:15 AM-12:15 PM
Fusion Middleware - SOA Suite Including BPM and OSB

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

The complexity and number of applications in IT is increasing every day. Dealing with the increasing complexity while building new applications, replacing existing applications, and keeping up with the business request for enhancements and maintenance represents a major challenge for any organization. Service Oriented Architecture (SOA) concepts have been around for almost a decade with the promise of solving these issues. SOA is a confusing term for anyone because it has been used in many different ways including product branding. This presentation will define basic SOA concepts without technology jargon and then discuss how to achieve the promises of SOA.

Back to Top
Matjaz B. Juric, SOA Competence Centre, UL FRI
Session 7, 06/28/2011, 11:15 AM-12:15 PM
Fusion Middleware - SOA Suite Including BPM and OSB

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

This session will show how you can use Oracle BAM for monitoring BPEL and BPMN business processes on the SOA Suite and BPM Suite. The session will look at the Oracle BAM architecture and features. It will show how to send business data from BPEL and BPMN processes to Oracle BAM. The session will discuss data objects, sensors, sensor actions, and monitoring objects. It will explain how to build BAM dashboards. The session will demonstrate how to enable monitoring on an example BPEL process and how to develop a BAM dashboard, which will show real time data about the execution of business process by displaying a few interesting KPIs.

Back to Top
Matjaz B. Juric, SOA Competence Centre, UL FRI
Session 5, 06/28/2011, 8:30 AM-9:30 AM
Fusion Middleware - SOA Suite Including BPM and OSB

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

The presenter will show how you can use SOA Suite to create SDOs from Data Objects and expose them to BPEL. He will also show how to expose the Data Objects as View Objects in the ADF using the ADF-BC Service interface.

Back to Top
Manish Khera, Avanco International
Session 1, 06/27/2011, 11:15 AM-12:15 PM
BI and Oracle EPM - Data Warehousing

This presentation is a case-study in the design, development, and deployment of an OBIEE Business Intelligence solution across Multi-Network Domains for the U.S. Army. The Business Intelligence application provides current and predictive analysis on multiple military units which have significant organizational dependencies. Challenges dealing with Common Interface Schema, Authoritative Data Sources, data cleansing and load using the OWB ETL tool, Inter-network data calls, and selection of appropriate Oracle software tools are covered. Development of a Common Semantic Layer and unification of data schemas will be addressed in the context of development using the OBIEE Business Intelligence tool.

Back to Top
Tae Kim, Linium
Session 9, 06/28/2011, 3:00 PM-4:00 PM
BI and Oracle EPM - Financial Management Solutions

This presentation will cover how to address complex ownership structure, equity pickup, non-controlling interest, and organization structure changes using Oracle Hyperion Financial Management.

Back to Top
John King, King Training Resources
Session 1, 06/27/2011, 11:15 AM-12:15 PM
Database Development - Coding

AcePRESENTATION BY AN ORACLE ACE

Attendees are introduced to the new and improved features of Oracle 11g (both Oracle 11gR1 and Oracle 11gR2) that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: new SQL functions, new analytic functions, virtual columns, result caching, XML improvements, pivot statements, JDBC improvements, and PL/SQL enhancements such as compound triggers.

Back to Top
John King, King Training Resources
Session 3, 06/27/2011, 2:30 PM-3:30 PM
Fusion Middleware - ADF

AcePRESENTATION BY AN ORACLE ACE

Oracle's Application Development Framework (ADF) has become an excellent tool for creating robust applications. Part of ADF's strength is ADF Business Components (ADF BC) and its ability to build reusable database objects to support the GUI objects created using ADF Faces. ADF BC began as BC4J (Business Components for Java) and has grown steadily over the years. Using ADF BC developers may create data objects based upon database tables (including non-Oracle databases), PL/SQL output, and remote resources. Like everything in ADF, BC objects are represented by XML files and underlying Java components, and, BC objects are reusable. This session will show (and demonstrate) how to create BC objects based upon database tables including: Entity Objects, Views, Read-Only Views, and Application Modules. The power of ADF BC validation and formatting features will be discussed and demonstrated as part of the session.

Back to Top
Shailesh Kumar, Oracle Corporation
Session 2, 06/27/2011, 1:15 PM-2:15 PM
BI and Oracle EPM - Financial Management Solutions

Financial Close Management is an end user focused application built on Oracle's SOA Suite. While Oracle provides out-of-the-box integrations for several of our financial EPM modules, developers can create custom integrations of their own. In this session, the presenter will walk through the construction of a custom integration.

 

Back to Top
Tom Kyte, Oracle Corporation
Session 3, 06/27/2011, 2:30 PM - 3:30 PM
Database Development - Coding

PL/SQL is Oracle’s procedural extension to SQL, and it is a true 3GL programming language. It was first introduced way back in version 6 of the database, giving us the ability to code “anonymous blocks” in our client applications and submit them for processing on the database. In Oracle 6, there were no stored procedures, no packages, and no triggers. The ability to store PL/SQL in the database came with version 7 in 1992.

Today, PL/SQL is competent, mature, and full-featured, offering everything you expect to find in a 3GL programming language. This session will look at why you should be using PL/SQL in your applications and cover the most important programming techniques that provide efficient, high-performance PL/SQL code.

Back to Top
Tom Kyte, Oracle Corporation
Session 7, 06/28/2011, 11:15 AM - 12:15 PM
Database Development - Coding

This session will briefly overview why binding is extremely important with regards to performance, scalability, and even security, but quickly move into topics such as: Do I always want to bind? (Surprisingly, the answer is no.) What is bind variable peeking? Is it good or evil in disguise or a bit of both? And how does this adaptive cursor sharing thing work?

Back to Top
Cameron Lackpour, CL Solve
Session 15, 06/29/2011, 3:00 PM-4:00 PM
BI and Oracle EPM - Panel

Oracle Tech Support will be on hand to answer your burning EPM questions.

Back to Top
Cameron Lackpour, CL Solve
Session 3, 06/27/2011, 2:30 PM-3:30 PM
BI and Oracle EPM - Keeping It All Running

AcePRESENTATION BY AN ORACLE ACE

You’ve heard about cloud computing in the general media, heard Larry Ellison wax poetic about it, and if you’ve attended a lab here at KScope, used it yourself. That’s all great, but what does cloud computing really mean for the implementer and administrator of Oracle EPM tools? This presentation will quickly bring you up to speed with how cloud computing is a great fit for Oracle EPM products and how you can immediately start using the cloud to test new versions of software, prototype applications, and maybe even define a new home for your company’s applications.

Back to Top
Steve Liebermensch, Oracle Corporation
Session 2, 06/27/2011, 1:15 PM-2:15 PM
BI and Oracle EPM - Panel

A panel discussion with Oracle leaders in the EPM/BI development, Product Management and Strategy.  Attendees will be able to ask questions of the panel across a wide range of topics.


Back to Top
Steve Liebermensch, Oracle Corporation
Session 15, 06/29/2011, 3:00 PM-4:00 PM
BI and Oracle EPM - Essbase Solutions

Essbase (ASO) Aggregate Storage Option cubes are changing the Analytical landscape. Oracle now recommends ASO as the primary cube technology for both new, replacement, and enhanced hybrid analytical application designs. Many ASO solutions are simply migrated designs of BSO applications. And many developers are not exploring the full capabilities of ASO, including read/write. Learn advanced techniques in Essbase ASO through the use of MDX, MaxL and creative Outline design. Use MDX to create complex calculations for near-real time performance. Learn how to use MaxL to perform a variety of critical production tasks like clearing data, building aggregations, and storing calculations rather than depending on queries alone. Take advantage of the power of an ASO outline for improving performance and for complex calculations.

Back to Top
Steve Liebermensch, Oracle Corporation
Session 16, 06/29/2011, 4:15 PM-5:15 PM
BI and Oracle EPM - Essbase Solutions

Abstract coming soon.

Back to Top
Larry Linnemeyer, Rolta TUSC
Session 8, 06/28/2011, 1:45 PM-2:45 PM
Application Express - Plug-ins & Dynamic Actions

Inflexible users? Ever heard, “but we did that in Forms?” One of the frequently requested Forms features is the multi-return List of Values. You know, the one with multiple columns in the select list that returns values not only to the select item but to several other page items? APEX’s new plug-ins allow you to add, as native functionality, features that normally are not available. Once created, plug-ins can be used in any application and are added to pages through the normal wizard process. This presentation will take an in-depth look at all the pieces needed to implement this Forms functionality in an APEX item plug-in. This will include all the PL/SQL API packages, the integration of JavaScript files, using standard and custom attributes, and much more. At the conclusion, you will have everything you need to implement this plug-in and enough knowledge to start creating your own plug-ins.

Back to Top
Eldon Liu, ADI Strategies
Session 13, 06/29/2011, 11:15 AM-12:15 PM
BI and Oracle EPM - Essbase Solutions

Companies running Oracle Financials have the same reporting challenges. They need to develop a method to reference account and cost center structure into ‘cost type’ accounts, which is used to prepare their financial statements. Additional complexity is added when these financial statements are required to be prepared in various ‘views’, i.e. Internal, Tax, and Audit. As an Essbase solution, the above can be met by embedding mapping logic into calculation scripts though it’s difficult to maintain by business users. This presentation introduces a framework based on Oracle/Hyperion technology that’ll not only address Oracle Financials’ reporting challenges, but also provide business users direct/easy access to maintain ‘cost type’ references. It further expands Essbase’s analytic capability by supporting drill-through to all ‘cost type’ accounts and views.

Back to Top
Bryn Llewellyn, Oracle Corporation
Session 4, 06/27/2011, 4:30 PM-5:30 PM
Database Development - Best Practices

Oracle Corporation's bug database is mission-critical. Its own engineers, support staff, and managers, and also its customers, depend on its 24/7 availability. Our BugDB has tables, views, synonyms, PL/SQL units of all kinds, and objects of other types. There is always pressure to change these to correct minor problems and to bring new functionality. Historically, such changes have been bundled into planned quarterly outages. Edition-based redefinition (a.k.a. EBR), new in Oracle Database 11g Release 2, has changed the game. BugDB is now live on 11.2 and EBR has been used to make several incremental functionality enhancements, as soon as each is ready, without interrupting availability. This session describes how this was done.

Back to Top
Michelle Malcher, DRW Holdings
Session 17, 06/30/2011, 8:30 AM-9:30 AM
Application Express - Infrastructure/Management

Ace_Director PRESENTATION BY AN ORACLE ACE DIRECTOR

This presentation covers the infrastructure configuration and common application components for successful mass deployment of APEX. Topics covered include HTTP services configuration with Glassfish and APEX Listener, application high availability, creating a shared theme, using nice URLs, configuring single sign-on with Active Directory, and schema and object naming.

Back to Top
Jim Malseed, Deloitte
Session 0, TBD,
BI and Oracle EPM - Financial Management Solutions

The increasing integration of performance management technologies (PMT) applications into ERP platforms is providing organizations and their tax departments new ways to monitor, measure, and manage business performance. PMT applications such as Oracle's Hyperion Financial Management (HFM), Oracle Hyperion Financial Close Management, Oracle Hyperion Disclosure Management, and various tax tools have provided tax departments new opportunities to enhance the quality of data tax departments now receive. These enhancements can be accomplished without a complete re-implementation or upgrade of an ERP system, leaving the systems required for management reporting intact.

Back to Top
Josie Manzano-Stettler, ADI Strategies
Session 13, 06/29/2011, 11:15 AM-12:15 PM
BI and Oracle EPM - Planning Solutions

So you decided to make the move…upgrade your Planning application to EPMA. Or you’re a diehard Planning Classic implementer about to embark into the unchartered EPMA frontier. The presenter will take the guess work away from you and save you hours of rework and navigating aimlessly in the EPMA black hole. In sixty minutes, you’ll be armed with all of the ins and outs of deploying an EPMA Planning application, including navigating through “oh those quirky features.” This session will demystify all those Planning features that escaped the Classic Administration Menu, and found its new home in the EPMA Dimension library. Further enhance your deployment using interface tables and the EPMA batch client. Dodge the trials and pains of the transition and accelerate your deployment.

Back to Top
Russ Markovich, Apollo Group
Session 12, 06/29/2011, 9:45 AM-10:45 AM
Fusion Middleware - SOA Suite Including BPM and OSB

This presentation demonstrates how to consume a Java embedded BPEL API process using Oracle APEX. The demonstration includes creating a BPEL administration process with a Java embedded activity, calling a BPEL Java API, and creating an Oracle APEX region based on the BPEL utility process wsdl.

Back to Top
Jason Marley, JP Morgan Chase
Session 4, 06/27/2011, 4:30 PM-5:30 PM
Application Express - Introduction

This will be a discussion about techniques for translating business requirements into APEX Applications based on case studies. As an APEX Developer, it is useful to have skills that will help you conceptualize APEX applications from business requirements or current processes. For example, learn how in some cases, reducing multiple instances of spreadsheets and databases into one APEX application helps to increase productivity and efficiency. This and many other techniques will be openly discussed. After this session, you will be armed and dangerous to tackle real world Enterprise level development with APEX.

Back to Top
Brian Marshall, ISA Consulting
Session 5, 06/28/2011, 8:30 AM-9:30 AM
BI and Oracle EPM - Planning Solutions

Have you always wanted/needed to know what was going on behind the scenes in Planning but were afraid to dive into the SQL tables? Do you wish Planning made information more readily available then navigating through the web interface? Master Plan is your ticket to that information, no digging required. This presentation will show you how to use packaged reports to get the Planning information you always wanted but couldn’t get such as metadata extracts, users, security, and individual planning objects.

Back to Top
Scot Martin, Cash America
Session 7, 06/28/2011, 11:15 AM-12:15 PM
BI and Oracle EPM - Keeping It All Running

Learn about the new method of loading data and dimensions: ODI (Oracle Data Integrator).

Back to Top
John Martin, ISA Consulting
Session 12, 06/29/2011, 9:45 AM-10:45 AM
BI and Oracle EPM - Planning Solutions

The Metadata Load Utility is a configurable tool used to load dimensions and exchange rate data into Planning. The tool is a viable alternative to using ODI as it can be configured to run by scheduled batch, and can be encrypted. By the end of the presentation, the user will have ready to use scripts that can be used and easily configured to load metadata into any System 11 Classic Planning Application. Since HAL (Hyperion Application Link) has been discontinued, there have not been many options for loading of metadata. ODI is one option, but for just about all applications, metadata can more easily be uploaded using this utility. For EPMA applications, the ADS file process will be shown, and the process for integrating with Interface tables will be explained.

Back to Top
Raj Mattamal, Niantic Systems
Session 18, 06/30/2011, 10:30 AM-11:30 AM
Application Express - Infrastructure/Management

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

This session aims to introduce the concept of collections and walk through some of the most helpful use cases for using them. Using the APEX-specific examples of a shopping cart, interactive reports with dynamic SQL, and running saved queries, the audience should leave the session feeling comfortable using collections in various scenarios.  Although this session will contain demonstrations, the more important goal is to expose the audience to the potential uses of collections even beyond the proverbial shopping cart. The examples of running saved queries and interactive reports are two such uses of collections, and time-allowing, the session will explain the use of collections to perform complex tabular form validations.

Back to Top
Raj Mattamal, Niantic Systems
Session 15, 06/29/2011, 3:00 PM-4:00 PM
Application Express - Core Functionality

Ace_Director PRESENTATION BY AN ORACLE ACE DIRECTOR

Oracle Application Express does an excellent job of allowing developers to quickly create robust Web applications against the Oracle Database, but savvy user communities are demanding more from their user experience than ever before. To give users the quality experience they demand, many developers starting to use jQuery and Ajax techniques to improve the experience with simple client-side code. Starting with a simple APEX sample application, this session introduces the concepts and then walks through the steps of using simple "Web 2.0" techniques to improve the Web experience of your users to the modern experience they now expect.

Back to Top
Niall Mc Phillips, Stephenson and Associates Ltd.
Session 18, 06/30/2011, 10:30 AM-11:30 AM
Application Express - Integration & Migration

This presentation will discuss the hands-on challenges faced and the experience gained during the process of migrating several of an international organization's large, core systems to a single Oracle application using Application Express.

Back to Top
Dan McGhan, SkillBuilders
Session 14, 06/29/2011, 1:45 PM-2:45 PM
Application Express - Core Functionality

AcePRESENTATION BY AN ORACLE ACE

Manual tabular forms in APEX are often considered difficult to create, but with a solid methodology, they can be much easier than one thinks.

Back to Top
Dan McGhan, SkillBuilders
Session 17, 06/30/2011, 8:30 AM-9:30 AM
Application Express - Plug-ins & Dynamic Actions

AcePRESENTATION BY AN ORACLE ACE


Learn what is possible using declarative Dynamic Actions in APEX and how to take them further.

Back to Top
Dan McGhan, SkillBuilders
Session 5, 06/28/2011, 8:30 AM-9:30 AM
Application Express - Plug-ins & Dynamic Actions

AcePRESENTATION BY AN ORACLE ACE


Tough questions about the new plug-in architecture in APEX will be answered.

Back to Top
Kevin McGinley, Accenture
Session 1, 06/27/2011, 11:15 AM-12:15 PM
BI and Oracle EPM - Reporting Solutions

With the advancements in cell phones and mobile computing, information originating from the internet is now available to people anytime, anywhere. Companies are now exploring ways in which they can make their internal business information available to their employees at locations other than a desktop computer in a cubicle or office. This presentation will cover multiple concrete ways in which companies can combine Oracle Business Intelligence Enterprise Edition (OBIEE) with mobile computing solutions like the iPad and iPhone to deliver insightful information to users anytime, anywhere.

Back to Top
Tracy McMullen, interRel Consulting
Session 4, 06/27/2011, 4:30 PM-5:30 PM
BI and Oracle EPM - Planning Solutions

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Interested in shortening planning cycles, improving the accuracy of plans and forecasts, or enhancing business predictability? Hyperion Planning is a centralized, Web-based planning, budgeting, and forecasting solution that drives collaborative, integrated, event-based planning processes throughout the enterprise with key features including workflow and process management, flexible modeling, and powerful reporting and analysis. But are you using it to its fullest capabilities? This presentation will cover the Top Ten Planning end user features that you may be missing out on. Whether you are a new or existing end user or administrator, this key presentation is guaranteed to show you features that will improve the budgeting and forecasting process and overall experience. This session will cover some new 11.1.2 new features that you should also be using that you may never have heard existed.

Back to Top
Tracy McMullen, interRel Consulting
Session 10, 06/28/2011, 4:30 PM-5:30 PM
BI and Oracle EPM - Planning Solutions

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Nervous about changing the underlying relational tables? Updating the validatedata.jsp page? Never fear! This session will come to your rescue. This session will show you the supported ways to meet some of your requirements that don't require Web developing or DBA skill sets. While this may be the anti-Kscope presentation,  these topics will help you deliver the best possible Planning solution to your organization with the minimal amount of maintenance as you upgrade to newer versions. Consider this to be your "before I can go outside the box, I better learn where the edges of the box are first" session of Kscope11.

Back to Top
Tracy McMullen, interRel Consulting
Session 8, 06/28/2011, 1:45 PM - 2:45 PM
BI and Oracle EPM - Reporting Solutions

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Smart View is the common EPM and BI add-in for Microsoft Office. It can be used with Oracle Essbase, Oracle BI Server, Planning, Financial Management, Web Analysis, Financial Reporting, and more. Most people think of it as usable only in Excel, but in this session, learn the value of using Smart View in all your Microsoft Office products to manage enterprise performance. Write management books in Word that include Essbase numbers. Make presentations in PowerPoint that contain live graphs from Web Analysis and refreshable data points from Planning and Financial Management. Send your Hyperion Planning numbers to your manager in Microsoft Outlook. Create highly formatted reports with the new 11 Report Designer. And of course, Excel is also there for analysis. Don’t miss this presentation that will show you how to use the Office and Hyperion tools you know and love (Excel gurus) to improve business performance.

Back to Top
Slavica Mihailovic, BAE Systems
Session 19, 06/30/2011, 11:45 AM-12:45 PM
Application Express - Integration & Migration

This presentation is focused on organizations that are concerned with the 4.0 upgrade and is intended to de-mystify and add some structure on how to approach the upgrade. The presentation will discuss: Communication – how an approach was made not only to communicate with developers, but also with super users and users that would be impacted by the change. Training – How new features training was key to leverage the upgrade process. Testing – Method for testing applications most critically impacted by the change accomplished by reviewing usage logs and critical process maps. Issues – Outline issues found such as grants, theme availability changes, and new feature control. The intention is to share findings, issues, and methods with peers in order to benefit the APEX community.

Back to Top
Kamron Miller, MarketSphere Consulting
Session 3, 06/27/2011, 2:30 PM-3:30 PM
BI and Oracle EPM - Financial Management Solutions

This session will discuss real-world case studies, leading best practices and key functionality with a focus on the recently released game-changing applications — Hyperion Financial Close Management and Hyperion Disclosure Management.

Back to Top
Duncan Mills, Oracle Corporation
Session 7, 06/28/2011, 11:15 AM-12:15 PM
Fusion Middleware - ADF

This session discusses ways to troubleshoot and debug ADF applications. Topics covered include finding problems using diagnostics and logging; using test clients to troubleshoot and debug problems in your business services; features of the JDeveloper debugger; and how to use the ADF declarative debugger to diagnose problems in metadata.

Back to Top
Cary Millsap, Method R Corporation
Session 1, 06/27/2011, 11:15 AM-12:15 PM
Database Development - Best Practices

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Among Oracle database administrators (DBAs), Agile is widely regarded as a dirty word, a synonym for sloppy programming. But in the most commercially and technically successful projects the presenter ever worked on, the principles of the Agile Manifesto have defined his work (specifically, the implementation of the Agile Manifesto called Extreme Programming (XP), as explained by Kent Beck). In fact, further than that: the principles of Agile, implemented as XP, have profoundly enriched his entire life—not just professionally, but personally. The contradiction between the typical DBA's perception of Agile and his own is, thus, stunning. This session will describe his experiences with Agile values and his implementation of them. He will describe the circumstances that have led him to believe passionately that it's XP that will best assure the success of his projects. He’ll describe what has worked for him and why, and he'll describe what hasn't worked and why.

Back to Top
Cary Millsap, Method R Corporation
Session 17, 06/30/2011, 8:30 AM-9:30 AM
Database Development - Best Practices

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR
Cary Millsap leads an hour-long question and answer session about the principles described in the ODTUG 2010 Editor's Choice Award winning paper, "Thinking Clearly About Performance" (available at http://method-r.com/downloads/doc_details/44-thinking-clearly-about-performance). Topics include: an axiomatic approach, what is performance, response time vs. throughput, percentile specifications, problem diagnosis, the sequence diagram, the profile, Amdahl's Law, skew, minimizing risk, efficiency, load, queueing delay, the knee, relevance of the knee, capacity planning, random arrivals, coherency delay, performance testing, measuring, and performance is a feature.

Back to Top
Ron Moore, MTG
Session 3, 06/27/2011, 2:30 PM-3:30 PM
BI and Oracle EPM - Essbase Solutions

Profitability analysis is one of the most common Essbase applications for a reason. It’s one of the most important things you can do to improve business performance. Profitability analysis doesn’t stop at direct costs. You have to allocate indirect costs to calculate fully loaded profit. Allocations are fundamentally multidimensional so Essbase is an ideal place to do allocations and profitability analysis. This session will discuss the objectives of profitability analysis and identify the advantages of using Essbase. The session will describe simple allocations, waterfalls, and reciprocal allocations and present several alternative design structures. The session will also present some calculation examples.

Back to Top
Ron Moore, MTG
Session 17, 06/30/2011, 8:30 AM-9:30 AM
BI and Oracle EPM - Essbase Solutions

This will be a practical overview of some of the most important new features in V11 up thru V11.1.2. Depending on new releases between now and K-scope, the session will try to include the most recent releases. The focus will be on pointing out how to use the new features to make real improvements e.g. how does db archiving and transaction playback compare to the traditional approach in terms of performance and convenience or, how would the presenter actually use @XWRITE or varying attributes. In addition, the objective is to leave attendees with a clear set of steps to implement the features documented in the PPT and the accompanying paper.

Back to Top
Ron Moore, MTG
Session 16, 06/29/2011, 4:15 PM-5:15 PM
BI and Oracle EPM - Keeping It All Running

The objective of the Killer Apps Survey and panel discussion is to survey a broad spectrum of the Oracle EPM community to: identify the most valuable existing applications; determine how pervasive the most valuable apps are, assess the “next wave” of EPM initiatives, determine how effective organizations set EPM objectives, and establish best practices designed to realize the business benefit of Oracle EPM.

Back to Top
Daniel Morgan, Morgan's Library
Session 5, 06/28/2011, 8:30 AM-9:30 AM
Database Development - Coding

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Edition Based Redefinition is a new and critical component adding abilities that greatly enhance high availability in Oracle Database 11g Release 2. These are revolutionary new capabilities that allow online application upgrades with uninterrupted availability using three new database objects: The Edition, the Editioning View, and Crossedition Triggers. This session, with a live demonstration in SQL*Plus, will show each of the key components of editioning work and explain how they can be leveraged with single-instance stand-alone databases and with Real Application Clusters. New editioning enhancements in version 11.2.0.2 will also be shown.

Back to Top
Barbara Morris, Idaho Cleanup Project
Session 8, 06/28/2011, 1:45 PM-2:45 PM
Database Development - Best Practices

This presentation will cover how the Idaho National Laboratory Idaho Cleanup Project (INL ICP) has modified their software development practices to better implement new Department of Energy Cyber Security rules.

Back to Top
Chris Muir, SAGE Computing Services
Session 16, 06/29/2011, 4:15 PM-5:15 PM
Fusion Middleware - ADF

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Oracle's JDeveloper 11g Application Development Framework (ADF) presents an interesting service-oriented solution with the adoption of Bounded Task Flow's and ADF Libraries. Yet unlike its 10.1.3 counterpart where the tendency was to build one large application from the start, the 11g solution comes with its own challenges on how to bring the multiple moving parts into a composite master ADF application. Chris Muir will present a blueprint for ADF application architecture that can be applied to small and large projects to assist beginners in pulling 11g ADF applications together.

Back to Top
Rich Mutell, DaVita Clinical Research
Session 5, 06/28/2011, 8:30 AM-9:30 AM
Application Express - Core Functionality

Oracle Application Express is a great tool for building applications, but it is even a greater tool in the hands of researchers. Research is by definition, data driven. That process includes developing the mechanism for capturing data, cleaning and combining data, and collaborating and communicating research results. The audience will see how Rich used APEX to not only develop the data capture tool, but also to quickly uncover patterns and visualize the data in support of our research programs.

Back to Top
Mary Myers, ISA Consulting
Session 5, 06/28/2011, 8:30 AM-9:30 AM
BI and Oracle EPM - Keeping It All Running

In this session, participants will learn how to develop comprehensive training programs using Oracle's UPK (User Productivity Kit). Mary Myers, ISA Consulting, will demonstrate UPK's native capabilities and how to develop custom content using your organization's Oracle Hyperion data and metadata to meet the specific training needs of your EPM end-users.

Back to Top
Michael Myers, ISA Consulting
Session 12, 06/29/2011, 9:45 AM-10:45 AM
BI and Oracle EPM - Keeping It All Running

Ever since Arbor Software first started shipping Essbase, the march towards a truly enterprise-focused product architecture has moved slower than most IT shops would like. With the advent of System 9, a fundamental shift towards architecting common product services throughout the Hyperion product ecosystem can be seen. Centralized security administration (Shared Services), centralized logging, HTTP Proxy for (most) Web applications, and more demonstrated than Hyperion, and now Oracle, were taking the needs of IT and the need to reduce the total cost of ownership (TCO) more seriously. With the release of Oracle’s EPM Fusion Edition, we are witnessing significant milestones in the evolution of systems architecture and administration; a Configuration Management Database (CMDB), true 64-bit architecture, and elimination of most points of failure across the Hyperion architecture.

Back to Top
Michael Myers, ISA Consulting
Session 15, 06/29/2011, 3:00 PM-4:00 PM
BI and Oracle EPM - Keeping It All Running

This presentation will offer an overview of Disaster Recovery principles as they relate to Hyperion, both past, and present. A comparative analysis will be presented showing examples of Disaster Recovery solutions for both pre-System 9 and 11.1.2.0 Hyperion Planning and Hyperion Financial Management environments.

Back to Top
Shyam Nath, IBM
Session 5, 06/28/2011, 8:30 AM-9:30 AM
BI and Oracle EPM - Reporting Solutions

The session will provide an overview and help develop understanding of the various Oracle Business Intelligence and Reporting tools such as OBIEE/BI Applications, BI Publisher, Discoverer, Financial Reporting, IR, Web Analysis etc. as well as non-Oracle offerings for Oracle Database and ERP users such as Cognos/Adaptive Analytics Framework and Business Objects. After attending this session, attendees will be able to understand various reporting and analytics options available to them.

Back to Top
Chad Norton, American Family
Session 2, 06/27/2011, 1:15 PM-2:15 PM
BI and Oracle EPM - Essbase Solutions

Join us for this informative session where we go beyond the basics of Calculation Manager and show you the tips and tricks for using Calculation Manager against Planning and Essbase. We’ve been working with Calc Manager for over a year now at American Family, using Calculation Manager to write complicated allocation scripts and more. Don’t miss this chance to hear our lessons learned that can be applied in your environment.

Back to Top
Alex Nuijten, AMIS Services
Session 5, 06/28/2011 , 8:30 AM - 9:30 AM
Database Development - Coding

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Recognizing when Analytic Functions can be useful in your daily work is a lot harder than learning the syntax. In this presentation, real life examples are discussed to unleash the power of Analytic Functions.

Back to Top
Gurcan Orhan, Turkcell Technology R&D
Session 9, 06/28/2011, 3:00 PM-4:00 PM
BI and Oracle EPM - Data Warehousing

Turkcell is a telecommunication operator which is the leader of Turkey and third in Europe. Project NODI is a data warehouse approach especially built for Network Operations Division in Turkcell developed in Turkcell Technology. NODI has a variety of source systems including files, Sybase IQ, Sybase ASE, MSSQL and Oracle and about 25TB of disk space. To give the vision of Turkcell's Network Architecture, Turkcell managed to reach 300M text messages and 16k text messages per second in the first day of Ramadan feast. Sybase Power Designer is used to model complete physical and logical architecture.

Back to Top
Gary Overly, The Vanguard Group
Session 11, 06/29/2011, 8:30 AM-9:30 AM
BI and Oracle EPM - Essbase Solutions

An exploration of challenges and resolutions in converting an existing block storage application to aggregate storage

Back to Top
Russell Papparotto, Information Software Solutions
Session 19, 06/30/2011, 11:45 AM-12:45 PM
BI and Oracle EPM - Financial Management Solutions

HPCM is one of Hyperion's newest and fastest growing applications. This session will combine an overview of HPCM and best practices in implementing the solution.

Back to Top
David Peake, Oracle Corporation
Session 4, 06/27/2011, 4:30 PM-5:30 PM
Application Express - Integration & Migration

Oracle Application Express (APEX) is a very popular tool for building rapid database-centric Web applications. It is also one of the primary choices for extending E-Business Suite. This session will introduce you to Application Express and demonstrate how to integrate APEX into your E-Business Suite environment in a fully certified and supported manner.

Back to Top
David Peake, Oracle Corporation
Session 16, 06/29/2011, 4:15 PM - 5:15 PM
Application Express - Introduction

Oracle Forms is still being developed by Oracle and has been exceedingly popular since being introduced over 20 years ago. However, many customers, especially those with applications written in client-server Forms, are weighing up their options for their current Oracle Forms applications. This session will outline what is involved in converting these applications to Oracle Application Express and will include new capabilities being developed in APEX 4.1.

Back to Top
Robin Peel, Ernst & Young
Session 0, TBD,
BI and Oracle EPM - Keeping It All Running

The principles of enterprise dimension management can ensure that the dimensions used to drive EPM and BI across the enterprise are aligned and consistent. Just as important is the ability to establish change  management processes that can be leveraged across large EPM & BI deployments. This presentation will review the value of implementing effective enterprise dimension management processes and will define a best-practice approach for planning an effective deployment of Hyperion Data Relationship Management (DRM)

Back to Top
Tanya Podchiyska, Stanford University
Session 19, 06/30/2011, 11:45 AM-12:45 PM
Application Express - Integration & Migration

Oracle Application Express 4.0 is a rapid application development tool, which offers developers the power of the Oracle database APIs, a wide arrangement of customization options, and an increased level of data interactivity with websheets, dynamic actions, and enhanced interactive reports. This powerful blend of features in APEX is extremely valuable in facilitating data integration and validation and in allowing end users with minimal training to import data from XML sources, to convert these data into a relational format, and to further curate and manipulate them.

Back to Top
Peter Popalis, The GoalGetters
Session 8, 06/28/2011, 1:45 PM-2:45 PM
BI and Oracle EPM - Financial Management Solutions

Building a Cash Flow statement in HFM can be very difficult. Typically, a CashFlow account hierarchy is built in HFM and rules are written to pull Balance Sheet and Income Statement data into the Cash Flow accounts. This can lead to a lot of rules maintenance and rapidly grow your rule file and make it very difficult to read and maintain. How about you build the Cash Flow rules into your account maintenance routine and throw all that scripting out the window! In addition, you can build your Cash Flow accounts at such a low level, that financial analysis becomes very simple. Your users can free up their time identifying issues instead of working through the mechanics.

Back to Top
Darin Pope, Pride International
Session 9, 06/28/2011, 3:00 PM-4:00 PM
BI and Oracle EPM - Planning Solutions

Why do companies make bad decisions in their Planning design, and how can you avoid them? Would you like to allow end users to input their plan and immediately see the impact at a consolidated level without switching forms? How can you increase data form performance dramatically? We’ll answer these questions and more through common and not-so-common tuning and optimization tips. This session will include ideas for Planning design, tuning of the underlying Essbase cubes and other aspects of optimization critical to your application. And when tweaking is not enough we will offer some useful redesign ideas. If you have an older Planning application that has been running along for several years, you can breathe some new life into it with a little tune-up or maybe some redesign. It will be singing again in no time.

Back to Top
Ben Prusinski, Ben Prusinski and Associates
Session 17, 06/30/2011, 8:30 AM-9:30 AM
Database Development - Best Practices

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Learn how to use the new features in Oracle 11g Release 2 to optimize performance for data warehousing and transactional OLTP environments. We will show you some quick wins in terms of leveraging tools such as the new Results Cache and little known tools such as oradebug and lots more.

Back to Top
Shakeeb Rahman, Oracle Corporation
Session 18, 06/30/2011, 10:30 AM-11:30 AM
Application Express - Infrastructure/Management

Developing functional, easy-to-use, secure, and fast Web applications requires many different skills. Tasks like creating a well designed database model, building the application logic, and designing a modern, crisp, and pleasing user interface are ideally done by experts in their respective areas. Yet often the developers in charge of building an application's back-end might also be tasked with building the user interface. And while these developers may be well versed in the latest Web 2.0 techniques, Ajax, and JavaScript, using Photoshop or CSS may not be their area of expertise. For this reason, Oracle Application Express provides a rich user interface theme framework and ships with twenty-two built-in themes, allowing developers to focus on what they do best, and have graphic artists provide the user interface design. In this session, you will learn about the basic architecture behind themes and the composition of a template. Using the APEX-based Oracle Online Store as an example, this session will discuss the different approaches to building a custom theme using simple, easy to follow Photoshop-techniques and show how Oracle overhauled many of the built-in themes in APEX 4.0, transitioning from a more traditional, table-based page structure, to a modern DIV and CSS-based structure. You will see how you can go about testing your theme, to ensure that you have covered all the bases, and how to package and deploy your application with all images and CSS files included.

Back to Top
Jim Raper, City of Charlotte
Session 10, 06/28/2011, 4:30 PM-5:30 PM
BI and Oracle EPM - Reporting Solutions

Strategic and Operational Dashboards are tools that more managers are turning to in order to plot their course through these turbulent times. Designing and implementing dashboards involves both art and technology. This presentation will provide a proven methodology that can be used by developer and the BI community to measure and continuously improve their BI delivery to consumers.

Back to Top
Samrat Ray, Oracle Corporation
Session 10, 06/28/2011, 4:30 PM-5:30 PM
Fusion Middleware - SOA Suite Including BPM and OSB

This session is a deep dive into platform architecture, configuration management, instance tracking, fault recovery, troubleshooting, and performance tuning for Oracle SOA Suite 11g. The presentation will cover the above topics from both administration and architecture perspectives.

Back to Top
Oded Raz, Brillix
Session 2, 06/27/2011, 1:15 PM - 2:15 PM
Database Development - Best Practices

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Writing fast applications is not enough, nowadays you should write secured application as well. It does not matter if you are writing in Java, .Net , PL/SQL, or even PHP, this session will help you design and write secured Oracle Applications. Get to know the major threats your application will face and learn how to write lock-tight applications that can hold against today’s security threats, using simple and straight forward methodology that leverage Oracle security features.

Back to Top
Kris Rice, Oracle Corporation
Session 2, 06/27/2011, 1:15 PM-2:15 PM
Database Development - Coding

Oracle SQL Developer provides access to the database for a wide spectrum of users, initially focusing on database developers. Each release has introduced more and more functionality for DBAs. For all users, tuning SQL queries and understanding how queries can impact performance is very important. SQL Developer now accesses a number of the Oracle Enterprise Manager 11g Database Management Packs. In this session, you learn more about these Database Management Packs and through a series of demonstrations, you see how to use Oracle SQL Developer and the Oracle Enterprise Manager 11g Database Management Packs to increase your productivity and improve the quality of your database applications.

Back to Top
Kris Rice, Oracle Corporation
Session 13, 06/29/2011, 11:15 AM-12:15 PM
Database Development - Coding

Oracle SQL Developer supports the development of SQL and PL/SQL code. You can create, edit, compile, and run your code using the editors provided. Once compiled, building tests to ensure the code is accurate is essential. This session will show you how to create unit tests, build implementations, save tests to a library, and run the tests individually or as a suite. SQL Developer 3.0 introduces a number of additional features that support tuning SQL code. This session demonstrates the new tuning capabilities and PL/SQL unit testing support.

Back to Top
Jeff Richardson, Edgewater Ranzal
Session 1, 06/27/2011, 11:15 AM-12:15 PM
BI and Oracle EPM - Planning Solutions

This presentation will introduce the attendee to Calculation Manager. Calculation Manager, a component of Hyperion Enterprise Performance Management Architect, is the new tool to create business rules and business rule sets to run against Hyperion Planning and Oracle Essbase. By attending the presentation, the attendee will learn about differences between Calculation Manager and Hyperion Business Rules, as well as see a live demo of the tool to develop and deploy business rules to a Hyperion Planning application.

Back to Top
Marianne Rigolini, United Space Alliance
Session 7, 06/28/2011, 11:15 AM-12:15 PM
Application Express - Core Functionality

United Space Alliance delivered a highly configurable application that met the demands of the rigid Human Spaceflight environment. Utilizing the power of the Oracle database and APEX toolsets, the team designed a robust and dynamic data model that can be transferred across multiple business organizations.

Back to Top
Mark Rittman, Rittman Mead
Session 12, 06/29/2011, 9:45 AM-10:45 AM
BI and Oracle EPM - OBIEE Administration

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Oracle Business Intelligence Enterprise Edition 11g, part of the Oracle Fusion Middleware family of products, integrates with Oracle Enterprise Manager systems management, identity management, and application server technologies. This session describes a set of architecture and configuration examples for Oracle Business Intelligence installations of any size, highlights platform features administrators and developers need to be aware of, and shows how the integration of Oracle's BI platform into the wider Oracle Fusion Middleware framework can bring benefits in terms of scalability, resilience, manageability, and time to deployment.

Back to Top
Mark Rittman, Rittman Mead
Session 2, 06/27/2011, 1:15 PM-2:15 PM
BI and Oracle EPM - Reporting Solutions

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Oracle Business Intelligence 11g provides an updated user interface plus new ad-hoc reporting, publishing, dashboard, and alerting features. In addition, the new scorecarding and KPI capabilities provide the ability to describe business objectives and progress towards meeting them. This session details these new features, through demonstrations and discussion, and shows how they can be used to make compelling interactive BI environments for users at all levels.

Back to Top
Henry Robin, ConocoPhillips
Session 19, 06/30/2011, 11:45 AM - 12:45 PM
BI and Oracle EPM - Essbase Solutions

LROs, Cell Text, Related Content? Essbase provides many options for adding commentary to your reporting and analysis solutions. Join ConocoPhillips as they share how they provided an automated system for capturing and reporting variance commentary. We will discuss our current solution as well as possible future changes based on Oracle's direction for Essbase commentary. Don't miss this chance to learn more about ways to capture critical text information about your Essbase numbers!

Back to Top
Maiko Rocha, Oracle Corporation
Session 9, 06/28/2011, 3:00 PM-4:00 PM
Fusion Middleware - Web Center

Make your ADF Application go social for the enterprise! This session will discuss WebCenter Suite and how to select which component to use from its comprehensive set of Enterprise 2.0 features. It will also include WebCenter Spaces, Portal Framework, and Services in real world scenarios.

Back to Top
Maiko Rocha, Oracle Corporation
Session 1, 06/27/2011, 11:15 AM-12:15 PM
Fusion Middleware - Web Center

Oracle WebCenter Spaces is a ready-to-use application that pulls together the capabilities of all the WebCenter Services to empower teams to quickly and efficiently manage their information, applications, projects, and people without requiring IT assistance. This session will talk about the challenges of going social on the Enterprise and how WebCenter Spaces can help and adapt for your needs.

Back to Top
Christian Rokitta, rokIT
Session 12, 06/29/2011, 9:45 AM-10:45 AM
Application Express - Infrastructure/Management

This presentation is a practical guide to the concept of APEX themes and templates. It outlines skills, tooling, and steps necessary to create a professional looking, custom APEX GUI.

Back to Top
Michael Rosenblum, Dulcian
Session 9, 06/28/2011, 3:00 PM-4:00 PM
Database Development - Best Practices

Every long-term IT project reaches a point when one or more fundamental concepts that define the whole system are no longer true. If the business is lucky, this may lead to a brand new development project. If not, the current system must be altered to support requirements for which it was never designed. This presentation discusses how to mitigate possible design-time risks using available technologies and concepts from a database perspective. The presentation will also cover real-life examples of best practices for handling unexpected architectural shifts.

Back to Top
Michael Rosenblum, Dulcian
Session 10, 06/28/2011, 4:30 PM-5:30 PM
Database Development - Coding

One of the most critical aspects of building an effective database system is successful management of unstructured information. Developers and designers must know how to work with Large Object datatypes (LOBS) including CLOB, BLOB, and BFILE. This presentation covers the core LOB concepts (multi-segment storage, I/O mechanism, copy semantics/pointer semantics, etc.) applicable to all Oracle versions starting with 9i. It also introduces SecureFiles, an 11g implementation of LOBs targeted to solve a number of functional pitfalls, and introduces several advanced features (de-duplication, compression, encryption, etc). Real-life examples will be included to pinpoint key ideas and solutions.

Back to Top
Edward Roske, interRel Consulting
Session 14, 06/29/2011, 1:45 PM-2:45 PM
BI and Oracle EPM - Essbase Solutions

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

You never thought it would happen, but you finally have calc scripts (well, close enough) for Essbase ASO cubes. In this session, you'll learn how to write a basic ASO calc script, but more importantly, you'll learn why you would ever want to do such a thing. Whether it's currency conversion, budget creation, data copying, or data clearing, you'll learn these and more. In addition, the session will be covering ASO Allocations. Even if you're not on version 11.1.2 of Essbase ASO yet, this session might push you over the brink into upgrading.

Back to Top
Edward Roske, interRel Consulting
Session 8, 06/28/2011, 1:45 PM-2:45 PM
BI and Oracle EPM - Essbase Solutions

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

In this two-part, two-hour session, Edward presents all his hacks and workarounds for Essbase discovered over the years.

Back to Top
Edward Roske, interRel Consulting
Session 10, 06/28/2011, 4:30 PM-5:30 PM
BI and Oracle EPM - Essbase Solutions

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

At last year's Kaleidoscope, interRel introduced the Configure It Out session. This year they will recap the highlights and cover part 2 of the Essbase.cfg session. Essbase users are confused by the myriad of configuration settings available to them. The number of variety of settings has expanded significantly through the versions of Essbase with EPM Version 11 having more options than ever before. This session reviews different settings, when to use them, and what settings are used in conjunction with other settings. The session will explore the simple settings every config file should have to the specialty settings used in unique situations.

Back to Top
Edward Roske, interRel Consulting
Session 9, 06/28/2011, 3:00 PM-4:00 PM
BI and Oracle EPM - Essbase Solutions

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Last year, Edward Roske gave a presentation that would only be found at Kaleidoscope. Hacking Essbase was a one-hour session in all those things you wanted to do with Essbase and that you were sure were possible if you could just find them. Whether they were undocumented, unsupported, unconventional, or just plain unseemly, tips including the weakness of Essbase password and tricks with substitution variables were covered. The only problem was time: one hour was just not enough to cover all the warranty-voiding tips, tricks, workarounds, and hacks that the audience demanded be covered. Never one to leave a crowd disappointed, Edward will be returning this year in an expanded two-part session. The first half will cover the best tips from last year but in greater detail. The second half (part deux, for those semi-French in the crowd) will go through completely new tips that Edward will deny he ever told you. If you want to hear from someone who's been around the Essbase world almost as long as Glenn Schwartzberg (Edward has over fifteen years of Essbase and has co-authored a book or two on the topic), make sure you come to this session. NOTE: because of the undocumented nature of the information covered at this session, slides will not be distributed in any form. If you want the content, you have to be there.

Back to Top
Gabby Rubin, Oracle Corporation
Session 16, 06/29/2011, 4:15 PM-5:15 PM
BI and Oracle EPM - Financial Management Solutions

Essbase Analytics Link provides a way to use Essbase as a "live" reporting cube on HFM. But did you know you can combine dimensions, add new dimensions, and add additional data. This session will demonstrate how to use EAL to create applications that combine additional data for a robust reporting environment.

Back to Top
Tony Scalese, Edgewater Ranzal
Session 13, 06/29/2011, 11:15 AM-12:15 PM
BI and Oracle EPM - Financial Management Solutions

This session will demonstrate a client solution which utilizes Financial Data Quality Management, ERP Integrator, and Enterprise Performance Management Architect to automate data and metadata flows into Hyperion Financial Management. The overall solution utilizes several key components of Oracle’s EPM Suite including FDM, ERP Integrator, EPMA, Calc Manager, and Life Cycle Management. This session will focus on the metadata and data automation. The process was designed to enable full lights-out automation for data as well as metadata loading.

Back to Top
Tony Scalese, Edgewater Ranzal
Session 17, 06/30/2011, 8:30 AM-9:30 AM
BI and Oracle EPM - Financial Management Solutions

For so many, FDM is viewed simply as the 4 fish.  But FDM is an extraordinarily powerful tool that is capable of much, much more.  This session will explore some of the most common client data quality & automation needs that can be addressed through FDM scripting.  Over the course of the session, we will explore various script types (Event, Custom & Import) as well as their intended usage and best practices.  At the end of this session, a batch automation script will be created to illustrate the use of FDM's scripting tools.  This script can be used to automate the entire data load process, virtually eliminate the need for end users to perform the data load process.  This automation generally results in a close process that is more timely as well as accurate.

Out of the box, FDM provides a very efficient & end user friendly interface to load and validate data to various Oracle EPM application - HFM, Essbase, HSF as well as Enterprise.  The 4 fish have become a very recognizable icon and many organizations will refer to their close process status by the number of gold fish a location has attained.

One of the most common FDM questions is, can FDM do X?  As with all technology investments, the more an organization can accomplish with their given toolset, the better the ROI.  FDM has an extremely powerful and flexible scripting engine that allows an application to seamlessly perform a number of tasks that previously required interaction with multiple systems and/or process.

Smart Replace - an example of a common customization - will be explored in greater detail.  This deep dive will highlight how the combination of FDM's scripting engine, SQL and a little imagination overcome a common data quality challenge.

Back to Top
Tony Scalese, Edgewater Ranzal
Session 7, 06/28/2011, 11:15 AM - 12:15 PM
BI and Oracle EPM - Essbase Solutions

This session will explore the capabilities of FDM, and now ERPi, to integrate with other target EPM applications such Essbase (BSO & ASO) and Strategic Finance. Out of the box features such as the ability to execute calc scripts before and after a load as well as leveraging load rules will be showcased. The session will highlight how the introduction of ERPi further expanded the already world class analysis & reporting capabilities of Essbase by adding drill through to transactional detail. This session will conclude with an overview of automation capabilities of FDM, discussion of use cases, and thorough Q&A.

Back to Top
Guido Schmutz, Trivadis
Session 8, 06/28/2011, 1:45 PM-2:45 PM
Fusion Middleware - SOA Suite Including BPM and OSB

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

You have a lot of existing Java EE applications. Part of these applications and their logic have a potential to be reused in an SOA. But what is the best practice for reusing such Java EE applications? This session will show different approaches available with SOA Suite 11g in the SCA assembly model as well as with the Oracle Service Bus to reuse existing Java EE artifacts.

Back to Top
Guido Schmutz, Trivadis
Session 12, 06/29/2011, 9:45 AM-10:45 AM
Fusion Middleware - SOA Suite Including BPM and OSB

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

This session will present best practices for designing and building the services of an SOA. Different ways of implementing services in different environments and languages are presented and the pros and cons of each approach will be discussed. The session will cover how to ensure service versioning, why contract-first is the preferred approach, and under which circumstances a contract-last approach might be valid and useful.

Back to Top
Chris Schneider, Ning.com
Session 12, 06/29/2011, 9:45 AM-10:45 AM
Database Development - MySQL

In Web 2.0, MySQL is very important and any DBA should know what level of availability they need to fulfill their service level agreements both internally and externally. This presentation is an informative synopsis about different levels of availability within the MySQL server architecture.  The audience will learn about terms and concepts, what it means to scale MySQL, different replication methodologies, DBBD, and MySQL Cluster.  The presentation will also dive a bit further with specific visual examples pertaining to the different levels of availability and what you need to do to achieve higher levels of availability.

Back to Top
Glenn Schwartzberg, interRel Consulting
Session 2, 06/27/2011, 1:15 PM-2:15 PM
BI and Oracle EPM - Essbase Solutions

Ace_Director PRESENTATION BY AN ORACLE ACE DIRECTOR

Learn everything about making Essbase Studio work for you. Now that it's 11.1.2, it's (semi)stable!

Back to Top
Glenn Schwartzberg, interRel Consulting
Session 5, 06/28/2011, 8:30 AM-9:30 AM
BI and Oracle EPM - Essbase Solutions

Ace_DirectorORACLE ACE DIRECTOR
Fix on sparse, if on dense; hourglass vs. hourglass on a stick. Just when you thought you had all of the Essbase design best practices down, here comes Glenn Schwartzberg, Oracle ACE, with some exceptions to the general Essbase rules. Join us for this unique twist on an Essbase tips and tricks presentation where Glenn will share some of the “exceptions” to consider when designing and implementing Essbase. Test your Essbase knowledge and make sure you know all of the considerations when applying design and tuning principles.

 

Back to Top
John Scott, APEX Evangelists
Session 15, 06/29/2011, 3:00 PM-4:00 PM
Application Express - Core Functionality

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Behind the scenes, APEX stores an incredible amount of metadata not only about the make-up of your APEX application, but also the individual access by your end users. This session will show some of the fantastic uses you can put that metadata to, to not only make your lives easier as developers, but also to enrich the application for the end users.

Back to Top
John Scott, APEX Evangelists
Session 5, 06/28/2011, 8:30 AM-9:30 AM
Application Express - Infrastructure/Management

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Let’s face it, it can be confusing to know which Web-server is “best” to use with APEX. You have the choice of the Oracle HTTP Server (OHS), the Embedded PL/SQL Gateway (EPG), and now a new option, the APEX Listener. Of course it all depends what you mean by ‘best.’ This session will cover each of the three main options, comparing and contrasting not only the setup and configuration of each, but also the different options available with each solution.

Back to Top
John Scott, APEX Evangelists
Session 11, 06/29/2011, 8:30 AM-9:30 AM
Application Express - Plug-ins & Dynamic Actions

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

One of the exciting new capabilities in APEX 4.0 is being able to create re-useable plug-ins. This session will cover some of the different types of plug-ins that you can create and show just how useful they can be in almost every project.

Back to Top
Neelesh Shah, C2 Consulting
Session 8, 06/28/2011 , 1:45 PM - 2:45 PM
Application Express - Introduction

The power of APEX is due in part to the immense scope of capabilities present in the Oracle Database. This presentation will cover a variety of Oracle Database capabilities, from helpful to esoteric, and how they can be integrated into an APEX application. Topics include Oracle Text, SQL Analytics, Oracle Multimedia, a variety of database util packages, external table, Virtual Private Database, and others. The goal of this presentation is to introduce developers to a few database features and inspire them to seek out others.

Back to Top
Neelesh Shah, C2 Consulting
Session 3, 06/27/2011, 2:30 PM - 3:30 PM
Application Express - Core Functionality

APEX Interactive Reports are incredibly powerful, but lack in formatting and the ability to do master detail reporting.  APEX standard pages allow for master detail, but more than one level of detail is very difficult without drilling into a second page.  This presentation will demonstrate how to develop multiple pages, a master and multiple details, and then stitch them together into a single page report using AJAX callAPEX Interactive Reports are incredibly powerful, but lack in formatting and the ability to do master detail reporting. APEX standard pages allow for master detail, but more than one level of detail is very difficult without drilling into a second page. This presentation will demonstrate how to develop multiple pages, a master and multiple details, and then stitch them together into a single page report using AJAX calls. s.

Back to Top
Christian Shay, Oracle Corporation
Session 10, 06/28/2011, 4:30 PM - 5:30 PM
Database Development - Best Practices

This beginner-level session introduces Oracle's offerings for .NET programmers, including Oracle Data Provider for .NET, Oracle Developer Tools for Visual Studio, Oracle Providers for ASP.NET, and .NET stored procedures. Step-by step demos illustrate how to get started developing Oracle Database .NET applications using each of these free products. New features for Oracle .NET developers are highlighted in this session.

Back to Top
Christian Shay, Oracle Corporation
Session 12, /9:45 AM - 10:45 AM/, 29/06/2011
Database Development - Best Practices

This session presents the newest and upcoming features for Oracle Database .NET development. We will discuss support for Microsoft Visual Studio 2010, Entity Framework, LINQ, OData, fully-managed ODP.NET, and database .NET application performance tuning.

Back to Top
Shay Shmeltzer, Oracle Corporation
Session 8, 06/28/2011, 1:45 PM-2:45 PM
Fusion Middleware - ADF

Trying to achieve a specific look for your ADF Faces application? This session will focus on the features that Oracle ADF Faces offers to help you achieve the exact look and feel you are after. It will cover the basic concepts involved in developing skins for Oracle ADF applications, using the new ADF Faces Skin Editor, and tips to help you debug your skin.

Back to Top
Shay Shmeltzer, Oracle Corporation
Session 4, 06/27/2011, 4:30 PM-5:30 PM
Fusion Middleware - ADF

Java Persistence API (JPA) provides a standard O/R mapping and persistence layer for the Java EE stack and provides the interface between Java EE applications and relational databases. This session will introduce you to the key concepts of JPA and explain how it works. It will show you how you can leverage JPA as the database access layer in an Oracle ADF application, and what special features you get from this integration.

Back to Top
Brian Spendolini, JSA2 Solutions
Session 3, 06/27/2011, 2:30 PM-3:30 PM
Application Express - Plug-ins & Dynamic Actions

Dynamic Actions can empower the APEX developer to build complex events and UI elements with a three-step wizard that would have taken many, many lines of hand coding before. In this presentation, learn the basics of dynamic actions and how you can incorporate them into your applications.

Back to Top
Brian Spendolini, JSA2 Solutions
Session 13, 06/29/2011, 11:15 AM-12:15 PM
Application Express - Infrastructure/Management

User experience is becoming more and more important as the social Web spills over into the enterprise. Users expect rich interactive experiences with no waiting. In this presentation, learn how to incorporate the latest UX trends in your applications. Attendees will learn how to create custom page, report, and region templates. Using a stock theme? No problem. See how to extend the stock themes with social Web goodies. Dynamic actions also will be used to help with the user experience.

Back to Top
Scott Spendolini, Sumneva
Session 1, 06/27/2011, 11:15 AM-12:15 PM
Application Express - Core Functionality

Ace_Director PRESENTATION BY AN ORACLE ACE DIRECTOR

APEX is entering its adolescence phase of development. Adolescence is a critical phase in both childhood and software development, as there are a number of decisions that need to be made - all of which will be hard to undo.

As "parents" of APEX, it's our responsibility to guide APEX through this critical yet typically awkward phase, instilling our knowledge and wisdom every step of the way. This presentation outlines some of those decision points, and things that we can do to ensure that APEX becomes a productive "adult."

Back to Top
Scott Spendolini, Sumneva
Session 8, 06/28/2011, 1:45 PM-2:45 PM
Application Express - Infrastructure/Management

Ace_Director PRESENTATION BY AN ORACLE ACE DIRECTOR

Oracle Application Express is truly an amazing and robust development platform, enabling developers to build applications to meet almost any requirement. But behind the scenes, this sophisticated development tool is quite simple. This session will explore the inner-workings of APEX and describe just what happens when you view or submit a page. The overall intention of discussing APEX at such a low level is to provide APEX developers - beginners and advanced alike - with a better understanding of the environment, which will enable them to build better applications.

Back to Top
Scott Spendolini, Sumneva
Session 14, 06/29/2011, 1:45 PM-2:45 PM
Application Express - Security

Ace_Director PRESENTATION BY AN ORACLE ACE DIRECTOR

WikiLeaks has dramatically changed how organizations deal with data security. Without getting into the politics, this session will discuss how to mitigate data breaches in your APEX applications. It will follow your data through its "chain of custody," and provide insights on securing it at each step. It will cover not only things to do within the APEX application itself, but also steps to take at the database and even desktop PC level.

Back to Top
Payal Srivastva, Oracle Corporation
Session 13, 06/29/2011, 11:15 AM-12:15 PM
Fusion Middleware - SOA Suite Including BPM and OSB

Business Rules can be used in a wide variety of applications. This session will look at specific examples of using Oracle Business Rules to make work assignment and routing more flexible when using Oracle Human Workflow services.

Back to Top
Timothy St. Hilaire, BAE Systems
Session 3, 06/27/2011, 2:30 PM-3:30 PM
Application Express - Infrastructure/Management

With the release of the Java-based APEX Listener, there is an even easier way to implement your APEX applications. The J2EE implementation offers functionality including a Web-based configuration, enhanced security, and file caching. This session will show how to deploy and configure the APEX Listener, how to test for common installation issues, and how to secure your implementation. During the session, Timothy will go through a full installation showing how easy configuration is and demonstrating the debugging methods discussed.

Back to Top
Timothy St. Hilaire, BAE Systems
Session 10, 06/28/2011, 4:30 PM-5:30 PM
Application Express - Plug-ins & Dynamic Actions

After learning the basic functionality of Oracle Application Express, developers are often asked to implement more advanced interfaces that require knowledge of AJAX and JavaScript functionality. Without any additional libraries, APEX contains the functionality and capability to add features to any APEX application. With the release of APEX 4.0, the dynamic capabilities of APEX have become more declarative. Although the same concepts apply in 3.2, the approach has dramatically changed with the declarative framework. Both 3.2 and 4.0 methods for accomplishing the same functionality will be compared. The focus audience is intermediate individuals who have learned the basics of Application Express and are interested in starting to utilize the JavaScript, AJAX, and on-demand processing capabilities built into the APEX tool set to advance their knowledge and productivity in APEX.

Back to Top
Kelli Stein, interRel Consulting
Session 8, 06/28/2011, 1:45 PM-2:45 PM
BI and Oracle EPM - Keeping It All Running

Learn the difference between Oracle's many ETL tools for loading into Hyperion and EPM.

Back to Top
Beatriz Stratton, MetaSphere Consulting
Session 11, 06/29/2011, 8:30 AM-9:30 AM
Database Development - Design/Data Modeling

This presentation will explore SQL Developer Data Modeler's support for developers, repository managers and data architects who may be concerned with issues such as collaborative development, model re-use, master data management and metadata integration. Data Modeler is presented from the perspective of tool adoption, focusing on what you need to know to get started. The presentation will provide a valuable foundation for any organization considering using Data Modeler as their next modeling tool.

Back to Top
Jason Straub, Oracle Corporation
Session 1, 06/27/2011, 11:15 AM-12:15 PM
Application Express - Integration & Migration

Using RESTful Web services has become the new cool way to integrate services into your applications. The RESTful Web service design is a much simpler architecture than big Web services such as SOAP. Application Express 4.0 introduced support for consuming RESTful Web services. This session will demonstrate how you can integrate RESTful Web services into your Application Express applications from many of the major players such as Amazon, Yahoo, Google, and Netflix.

Back to Top
Ryan Sullivan, Harvard University
Session 18, 06/30/2011, 10:30 AM-11:30 AM
BI and Oracle EPM - Planning Solutions

Learn how Harvard University and Performance Architects established a robust staging area for the largest Hyperion Planning installation in the world, permitting decentralized and unique planning approaches for a diverse organization with distinct planning approaches – and how you can apply this type of approach to your Planning environment and efforts.

Back to Top
Jamal Syed, Emerging Solutions
Session 13, 06/29/2011, 11:15 AM-12:15 PM
BI and Oracle EPM - OBIEE Administration

AcePRESENTATION BY AN ORACLE ACE

With Oracle Essbase Cube Generator(OECG), now you can push the unified view of data from OBIEE into Essbase for multi dimensional analysis. We will show you how seamless it is to move data from OBIEE to Essbase and then use Essbase data in OBIEE 11g. Audience will learn to: build outline in Essbase for OBIEE data; create OECG repositories for data integration; push data from OBIEE to Essbase; use pre-calculated fields from Essbase into OBIEE dashboards.

Back to Top
Tim Tow, Applied OLAP
Session 18, 06/30/2011, 10:30 AM-11:30 AM
BI and Oracle EPM - Keeping It All Running

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Essbase is a key component in the Oracle Fusion Applications strategy. The primary development platform for Oracle Fusion Applications, however, is Java. Therefore, it is clear the Essbase Java API plays an important role in Oracle’s future. That said, there is currently very little information available on how the API works, especially in regards to coding best-practices and pitfalls. One of the most common reasons for using the Java API is to read Essbase member information from the Essbase database outline. Unfortunately, due to the design of the underlying APIs, it can sometimes be difficult to write code that accomplishes these tasks in an optimized manner. For example, there are several ways to obtain member objects in the Java API, but different techniques do not always return the same member information. Depending on how an object is obtained, the member information that becomes available from the returned member object can vary. This variance from technique to technique exists for performance reasons. Essbase was designed strictly for maximum runtime performance, and some properties which were originally envisioned only for use in design environments have subsequently been found useful in runtime environments as well. Knowing which properties are easily and quickly available, as well as which properties are not, enables developers to design applications that are maximized for performance. This session will introduce some tips and tricks used by the presenter in his extensive work with the Essbase Java API. It will discuss some of the common issues developers encounter when writing Java API applications, as well as how to sidestep them. The session will demonstrate these concepts through a combination of discussion and live demonstrations.

Back to Top
Russell Tront, Simba Technologies
Session 3, 06/27/2011, 2:30 PM-3:30 PM
BI and Oracle EPM - Reporting Solutions

Microsoft has invested heavily in Office features for enabling BI on the desktop, and many enterprises have embraced Excel for BI. This session provides an overview of new and popular functionality built into Excel 2010. You’ll see how to create a PivotTable with a live connection to Oracle Database OLAP Option. This session will then demonstrate how to use Excel to drill down into a dimension, then filter and analyze data with trend icon sets, conditional formatting, and Excel 2010 slicers and Sparklines. You can even drill ‘through’ to the underlying relational data from the fact table, or create fabulous PivotCharts hot connected to Oracle OLAP.

Back to Top
Jake Turrell, Turrell Consulting
Session 3, 06/27/2011, 2:30 PM-3:30 PM
BI and Oracle EPM - Planning Solutions

Prior to Version 11.1.2, Hyperion Planning’s process management capabilities were limited. Users had excessive flexibility in terms of who they could promote data to. On the other hand, they had limited flexibility in terms of the “chunks” of data being promoted. Version 11.1.2 addressed many of these limitations by adding two new process management templates and a host of new features. This presentation will walk users through a quick demonstration of the “old” process management followed by a detailed demo of the new templates and features.

Back to Top
Peter Paul Van de Beek, Whitehorses
Session 10, 06/28/2011, 4:30 PM-5:30 PM
Fusion Middleware - SOA Suite Including BPM and OSB

A Service Bus offers capabilities to transform, route, and queue messages. This session will show you how to implement a Service Bus based on good practices and patterns. Expect far more than just theory, since the examples are based on real life cases. Each of them is based on an implementation of the Oracle Service Bus or Mediator from the SOA Suite. This session will give you answers on how to create composite services using the OSB, how to transform messages from over a hundred types of messages containing basically the same data to a single common schema, or create and maintain a common schema. Of course questions like what is the best of those tools for a specific job will be answered. The session will also share thoughts and experiences on using the combination with WSM, and using the Oracle Enterprise Repository to leverage governance efforts.

Back to Top
Wilfred van der Deijl, Eurotransplant
Session 3, 06/27/2011, 2:30 PM-3:30 PM
Fusion Middleware - SOA Suite Including BPM and OSB

AcePRESENTATION BY AN ORACLE ACE

In this session, hear how Eurotransplant uses Oracle Business Rules 11g and particularly its support for decision tables for matching available scarce donor organs to patients in need for a transplant. Organ allocation involves a mixture of ethical, medical, legal, and political factors, among others. The resulting large and complex set of rules has to be completely unambiguous and transparent. These rules can be expressed in decision tables that are comprehensible for all stakeholders, including physicians, patients, policy makers, and IT staff. Executing these jointly specified decision tables directly in Oracle Business Rules 11g eliminates the risk of introducing programming errors and offers many more benefits. The session will explain the reasoning behind using Oracle Business Rules but will primarily focus on the possibilities of Oracle Business Rules 11g from a developer’s point of view..

Back to Top
Ronald van Luttikhuizen, Approach
Session 11, 06/29/2011, 8:30 AM-9:30 AM
Fusion Middleware - SOA Suite Including BPM and OSB

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

It is one thing to design and code the “happy flow” of your automated business processes and services. It is another thing to deal with situations you do not want [or expect] to occur in your processes and services. This session will dive into fault handling in Oracle SOA Suite 11g using a case study based on automated invoice handling. First the session investigates what can go wrong in automated processes and services. Then it categorizes these situations and dives into the mechanisms Oracle SOA Suite 11g offers to handle these different scenarios. These mechanisms include BPEL activities such as Throw and Catch activities, the SOA Suite Enterprise Manager, and SOA Suite’s fault handling framework. The session will wrap up by introducing a generic fault handling framework for technical faults used in a real-life project that is realized using a Java fault handler and SOA Suite’s fault handling framework.

Back to Top
Ronald van Luttikhuizen, Approach
Session 16, 06/29/2011, 4:15 PM-5:15 PM
Fusion Middleware - SOA Suite Including BPM and OSB

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

Services and events are highly complementary instead of competing paradigms in the ICT landscape. Oracle SOA Suite 11g emphasizes the importance of events by introducing the Event Delivery Network (or EDN) into the SCA infrastructure. This session provides an introduction of eventing in SOA Suite 11g. It will start by explaining the basics of events [also with respect to services], introduce several messaging patterns such as fire-and-forget and publish/subscribe, and explain some real life examples of using events in an SOA landscape. It will then dive into the underlying eventing infrastructure of Oracle WebLogic Server 11g and Oracle SOA Suite 11g that is based on JMS and AQ, and demo their use both inside and outside SCA composites using resource adapters, PL/SQL, and Java. The session will finish with the introduction of Oracle SOA Suite 11g’s EDN and the use of (composite) sensors in SCA composites.

Back to Top
Sten Vesterli, Scott/Tiger A/S
Session 15, 06/29/2011, 3:00 PM-4:00 PM
Fusion Middleware - ADF

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

By default, Application Development Framework (ADF) applications usually perform well, due to the many best practices implemented in the framework. But in the few cases where you are not getting the performance you are looking for, you face a bewildering array of tuning settings and parameters. This session cuts to the chase, showing you what's most important. It also contains a live demo to illustrate the mechanisms of Application Module pooling so you can see and understand how these parameters work.

Back to Top
Sten Vesterli, Scott/Tiger A/S
Session 2, 06/27/2011, 1:15 PM-2:15 PM
Fusion Middleware - ADF

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

You've seen the demos and maybe built some simple ADF applications, but don’t feel comfortable embarking on an enterprise ADF project. Why is that? Because you know that a project needs so much more than just code. This presentation will teach you about estimating, organizing, tools, structure – everything a real-life ADF project needs in order to be successful.

Back to Top
Toufic Wakim, Oracle Corporation
Session 7, 06/28/2011, 11:15 AM-12:15 PM
BI and Oracle EPM - Essbase Solutions

ADF controls for accessing Essbase will be released along with the Fusion applications. This session will highlight what controls will be available, and walk through different samples on their usage in a Web page.

Back to Top
Toufic Wakim, Oracle Corporation
Session 3, 06/27/2011, 2:30 PM - 3:30 PM
BI and Oracle EPM - Essbase Solutions

Learn how you can easily extend the Essbase calculator with functions built in Java. You will learn how to create, deploy, register, and debug Custom Defined Functions. Several Custom Defined Functions will be demonstrated such as: a Custom Calendar to calculate the number of business days in a month, statistical functions, string and date manipulation functions, data import/export functions, XREF on steroids, calc scripts debugging functions, etc.

Back to Top
Ralph Whitbeck, BrandLogic Corporation
Session 9, 06/28/2011 , 3:00 PM-4:00 PM
Application Express - Plug-ins & Dynamic Actions

This talk will be a quick but thorough introduction to the jQuery JavaScript Library. If you have zero experience with jQuery, this is the talk to start with. The session will cover jQuery and its history. The session will start by introducing basic jQuery concepts and principles, and conclude by building a basic jQuery plug-in.

Back to Top
Heather Wine, Sally Beauty Holdings
Session 14, 06/29/2011, 1:45 PM-2:45 PM
BI and Oracle EPM - Essbase Solutions

Attend this informative session where the presenter will share Sally Beauty's success story of using Essbase for analysis. While everyone knows that Essbase is the number one financial reporting solution in retail, not everyone knows some of the other analysis for which Essbase is perfect. Whether it’s flash sales by store and SKU, product profitability, customer segmentation, SKU analysis, store sales (comp and non comp), weeks of supply, pricing models, or more, retail companies around the world are using Essbase to meet all of their needs. In this one hour presentation, you will see Sally's real-world examples of reporting, analysis, modeling, and planning that you can do with Essbase, God’s gift to retail companies everywhere.

Back to Top
Heather Wine, Sally Beauty Holdings
Session 17, 06/30/2011, 8:30 AM-9:30 AM
BI and Oracle EPM - Planning Solutions

Join Sally Beauty as they share their success story in implementing Hyperion Planning. Learn how their entire budget and forecast cycles went from over three weeks to complete with suspect information to more accurate plans in two to three days with reporting available in seconds. This session will share the secrets to good application design and lessons learned that can help you improve your Planning solution.

Back to Top
Torsten Winterberg, OPITZ CONSULTING GmbH
Session 2, 06/27/2011, 1:15 PM-2:15 PM
Fusion Middleware - SOA Suite Including BPM and OSB

Ace_DirectorPRESENTATION BY AN ORACLE ACE DIRECTOR

What is an SOA project? Do these projects exist in real life? This session gives an overview about different types of real world projects based on the Oracle SOA infrastructure, which could or could be labeled SOA. You will learn about different requirements answered with different architectures and tools from the Oracle SOA-palette, including a view on what’s possible and what made sense. Discussion will include SOA, BPM, and EAI topics, as well as components like mediator, OSB, BPEL PM, BPM studio, Rules, EDN, and BAM. Even PL/SQL, APEX, and ADF find their place in an SOA-world.

Back to Top
Patrick Wolf, Oracle Corporation
Session 14, 06/29/2011, 1:45 PM-2:45 PM
Application Express - Plug-ins & Dynamic Actions

Plug-ins to extend the feature set of Oracle APEX were introduced in APEX 4.0 over a year ago. Since then, countless plug-ins have been created by the community and the Oracle development team themselves. Get to know the lessons learned and the best practices of plug-in development from one of the most active plug-in developers. You will also learn all about the new features and enhancements which are being added in APEX 4.1 to make it even easier for plug-in developers. Don't miss the opportunity to get an in-depth first hand experience from the developer of this feature in Oracle Application Express.

Back to Top
Patrick Wolf, Oracle Corporation
Session 2, 06/27/2011, 1:15 PM - 2:15 PM
Application Express - Integration & Migration

For a long time APEX developers have requested better control of APEX error messages. Oracle Application Express 4.1 will introduce capabilities to allow developers to customize the way error messages are displayed and overwrite the existing messages to make them more user friendly and personalized. For example, if you don't like your end users seeing the "ORA-00001 unique constraint(SCHEMA.DEPT_UNIQUE) violated" then use the customizable package and your own table to define an alternate message. 


Back to Top
Rudy Zucca, 123OLAP
Session 11, 06/29/2011, 8:30 AM-9:30 AM
BI and Oracle EPM - Essbase Solutions

This session is perfect for new developers trying to get familiar with ASO. Whether you have experience with Block Storage or not, this session is designed to go over the fundamentals of design and architecture of Aggregate Storage type databases, including: • ASO architecture • Best fits for ASO vs. BSO currently • Restrictions in ASO • Basics of Outline modeling in ASO • Aggregations and retrievals in ASO • Basics of MDX.

Back to Top
Rudy Zucca, 123OLAP
Session 12, 06/29/2011, 9:45 AM-10:45 AM
BI and Oracle EPM - Essbase Solutions

We smell the end of the Block Storage. Although still some years away, simple strategies can be implored to build out cubes predominately in ASO. Even for Planning systems or calculation intensive applications, there are ways to design ASO cubes to address these requirements and in some cases work alongside of Block Storage applications. By going through the major sections of ASO, the presentation will cover advanced topics such as: • Where we are at in the cross-roads between BSO and ASO. • Modeling choices and structural architecture. • MDX capabilities through visual examples • Aggregations and optimization • ASO allocations • Integrating BSO and ASO.

Back to Top