HOUG Spring 2015

Oracle ACE Director Eric Helmer walks you through what you need to know before considering upgrading to 11.1.2.4. Technical considerations are covered along with best practices and proven methodology to ensure you know what you can expect with your transition to Oracle’s newest version.

Are you using Oracle Discoverer? Need an ad hoc reporting tool for all modules in E-Business Suite?

Attend this session for an in-depth look into the functionality and benefits of Reports Wand 5 by Excel4apps, including:
• Effective alternative to Oracle Discoverer
• Report on any E-Business Suite module
• Develop highly customizable reports
• Refresh reports and drill down to live data
• Stop exporting from other tools to Excel and reformatting
Learn how the Reports Wand platform offers incredible flexibility in terms of filtering, sorting, formatting and refreshing real-time date into Excel from any Oracle EBS module.

Oracle Endeca Information Discovery is not the average BI tool. Endeca has the ability to analyze large unstructured data sets and yield insights that can metamorphosize a business. In this session, we will showcase and demonstrate 15 strategies/functions within Endeca that provide tremendous business value. An introductory course for Endeca novice, we will show true value methods and uses for Endeca. The 15 demonstrated activities are:
1. Tag Cloud Discovery. Let Endeca show the most prolific results, without even being asked
2. Autofill in Searches. No longer is 100% precision needed to find out that answer!
3. Follow the BreadCrumbs. Building specific searches saves time, especially when you can transfer to other dashboards.
4. Searching Data Vs Metadata. Too often in BI, we search the wrong field, and thus miss the answer, Endeca allows us to avoid this pain point.
5. Geographical Filtering. A picture is worth a thousand words, and filtering via a map cuts thousands of white noise records to really hone in on the true issues.
6. Frequency vs Intensity Filtering. Some records are more important than others…how do we showcase records that matter most.
7. Record Interrogation (Lowest Level). In some cases, the lowest level of detail is needed…so how do we get there?
8. Sentiment Analysis. Let Endeca tell you how your product rates from reviews!
9. Summarization Traffic lighting. Measure your results versus KPIs.
10. ODI ETL. Leverage your ETL tool to provide maximum coverage and results.
11. Multi-chart/MultiField Discovery. Utilize multiple charts to articulate the whole truth
12. Alerts. Why wait to discover bad news for yourself? Let’s have Endeca tell us when we are off course.
13. Causal Links/Correlations. Causal link can be identified if you know the right way to search.
14. External Sourcing (Web content). Knowing the data of external sources provides a competitive advantage when scaled to your own metrics.
15. Extracting Themes using Text Analytics. Use Endeca's ability to navigate and interpret unstructured content to determine trends in de-normalized data sets.

To keep your business systems and applications up and running, you need an easy way to ensure Oracle® database high availability. And while high availability means different things to different organizations — some measure it by the response time in a given application, and others continually sample transaction or network throughputs — the ultimate goal of a highly available environment is to maximize the time it’s accessible and operational. Because any IT system downtime incurs serious costs.

In this educational session you’ll learn simple methods to:

• ·        Improve scalability, availability and data integration.
• ·        Affordably replicate Oracle data on-premises, remotely or in-the-cloud.
• ·        Improve performance of OLTP systems by offloading reporting.
• ·        Minimize risk and downtime during migrations and upgrades.
• ·        Optimize analytics and the use of business intelligence applications by copying Oracle data to Hadoop® and other non-Oracle DBMS systems.
• ·        Quickly migrate from the now deprecated Oracle® Streams® to an easy-to-use, low-cost solution that includes everything you need to meet your data-sharing 

Whether merging technologies or making a complete migration to MySQL, there are definite design and language differences to consider for the Oracle professional.
This session is designed to help ease the burden by walking through major paradigm shifts to the MySQL world.
Topics covered will include:
- Things which may be missed, such as packages and DB links.
- Alternative design patterns to make up for the lack of encapsulation.
- What MySQL can do... just differently.
- "Gotcha's" and caveats

The new 11.1.2.4 Fusion edition of Oracle EPM brings many new features and functionally and options for deployment.  Weather it is Oracle Cloud, SaaS, Exalytics, or in-house systems, Oracle ACE director Eric Helmer walks through best practices and considerations to make your journey to Fusion painless by choosing the right deployment scenario for you.   For those opting for an on-premise solution, this session discusses how world class companies deploy Hyperion environments. Topics include performance design principals, critical project considerations, high availability and business continuity methodologies, and ongoing support.

Here is a case study of how HNI a leading office furniture manufacturer is using Oracle EBS and SOA technology to increase flexibility, transparency and collaboration with its customers. Its customers sales force interact interchangeably using various medium such as web, industry standard web portals, EDI and telephone to place orders, get order status, get special pricing and configure customer specific products. By using Oracle EBS as single source of truth and creating SOA services for each customer interaction, HNI is able to provide its customers seamless experience and consistent results across the various technology mediums.

Oracle LCM is a relatively new module that can be pretty helpful for companies looking to integrate procurement costs into the total product costs and achieve better insights into product profitability. The module should also help Accounting/Costing teams track inventory costs better.

As data and analysis becomes central to business success, how to educate, promote and increase the effectiveness of analytics across your organization is becoming mission critical.
How do you transition from the old way of doing business to becoming an evidence based decision making organization without breaking the bank or having to hire an army of data scientists?
Come discuss with Vlamis Software Solutions how many of the country’s leading corporations are building these teams and how you can get started leveraging new tools and methods.

This presentation is a must-see for anyone doing SQL tuning. Dan has a thorough understanding of how the Cost-Based Optimizer works and shares that knowledge in this presentation.

Dan covers:
· Useful Explain Plan tools and scripts
· Understanding Oracle Explain Plan
· How the CBO makes its decisions
· Query Transformations
· How tables are processed/joined
· How Indexes are processed
· Explain Plan Line Items
Summary:
This is a live-demo presentation. Dan shows how to work with Explain Plans then goes into considerable detail about exactly how Oracle arrives at an Explain Plan. Dan is an experienced trainer with considerable knowledge on this topic. The attendee will gain valuable insights as to how Oracle processes SQL and many tips on how to improve SQL performance.

The emergence of cloud solutions has generated considerable excitement due to the potential they have to transform the way companies operate and to enable businesses to access world-class applications with little upfront cost. But in order to maximize the impact these solutions have, organizations need to be aware of the expected benefits and the resources needed to achieve them.

This session will discuss how companies can optimize the impact of their cloud investments by aligning technology with business strategy and understanding how the organization must adapt.

The new visualization interface for OBI is a game changing new tool designed to give end users the ability to intuitively explore organizational data and combine it with other sources.

Come see a live demonstration of Visual Analyzer by Vlamis Software Solutions to learn about the exciting new features it provides and find out how you can get your hands on it.

MySQL operationalization. Differences in MySQL and Oracle 12C database approach. Cross technology fits. MySQL 101 and installation. Reduce database TCO with MySQL.

One of our key learning objectives is to help project managers understand the importance and balance of SMART with HEART. Both are major components of Emotional Intelligence (EQ). We will discuss where Emotional Intelligence is required in order to manage change effectively, lead others to the vision, and produce the desired results. We will review the history of EQ theory, the evolution of EQ models, measurement techniques to assess your EQ, and how to form a cohesive team using the five basic behaviors. Recognizing and facing the different types/maturity levels in EQ can and will lead to a smoother project.

We have proven experience in implementing FDMEE and would be able to provide industry’s best practices around implementing FDMEE for integration between Oracle E-Business Suite and Hyperion Essbase/Planning. We will highlight the value around the related 11g product features and capabilities and then look at a few examples.

• Objective 1: Offer FDMEE tips and tricks spanning E-Business integration with Essbase/Planning
• Objective 2: Provide background and “how to” steps for these helpful FDMEE tips and tricks
• Objective 3: Include specific examples of FDMEE integration features

This is a Vendor Awareness Session showing Oracle EBS users how they can use Excel as a front-end to Create Download, Update and Maintain Oracle EBS Master data (like Suppliers, Customers, Employees, Price Lists, Projects, Items and more) as well as Transactional data (like AP Invoices, AR Invoices & Receipts, Purchase Orders, PO Receipts and much much more). They will learn about the time savings that can be realized by removing all the navigation necessary in EBS.

Have you been wondering -
• What the BICS environment looks like?
• What the business cases for using BICS are?
• How it fits into Oracle’s future direction with BI and you’re existing on premise OBI environment?

Come see a live demonstration of BICS by Vlamis Software Solutions and hear the answers to these questions and more.

Many organizations that run, or plan to run, their Oracle Business Critical Applications on VMware virtualization do not understand that the Oracle contract is agnostic to VMware and how that translates to their infrastructure and purchasing. We invite you to join this session for a frank presentation and conversation about Oracle on VMware licensing by the contract.

This session includes Oracle representatives’ Oracle-on-VMware assertions that:

• Soft-partitioning, a host-level concept, is disallowed

• Soft-partitioning may also be a cluster-level concept

• vSphere sub-cluster licensing is disallowed

• The so-called 10-Day Rule is moot

• Licensing of all SAN or NAS-attached vSphere hosts
is required as of vSphere 5.1

• Enterprise-wide licensing is required as of vSphere 6

We will outline the terms that have improved and gotten worse through the last two decades of contract history, and disclose what relevant case law has been uncovered by House of Brick clients' legal teams.

This presentation is a must-see for anyone supporting applications! The presentation will be broken into 4 parts:

· Pluggable Database
· New SQL Syntax
· New PL/SQL Syntax
· New Oracle Optimizers Features


Summary: Dan will cover quite a number of new features of the Oracle12 database that should be of value to developers and DBA’s.