Winter 2018
Preview Issue

President’s Perspective

Inspiring the Next Generation of OAUG Members and Leaders

Christine Hipp
OAUG President

chipp@oaug.org
Twitter: @Chipp123Hipp

As 2018 draws to a close, I look back with pride on the work the OAUG has accomplished and look forward to new personal and professional opportunities.

Among other initiatives, the OAUG has increased its focus on our up-and-coming leaders and their careers as well as the next generation of members. For example:

  • Building on its efforts to provide ­education and networking for those who are new on their career path with Oracle Applications, the OAUG ­Emerging Leaders introduced a Mentorship Program in 2018. Mentors and mentees are matched one on one to work on setting goals in areas such as networking, career progression and new manager or general professional development.
  • The OAUG Collegiate Forum ­partnered with Oracle Academy and ­California State University East Bay in ­November 2018 to host students looking to ­develop a ­post-graduation career ­strategy with a focus on ­Oracle ­Applications and Technology ­opportunities.

Next year, I’d also like to encourage you to consider promoting STEM ­opportunities in your local community. Oracle ­Academy offers a simple way to make this a ­reality with their freely available “Workshop in a Box” options. These are easy to ­access through an Oracle Academy Individual Membership, and they make it simple for you to deliver introductory ­computer ­science workshops without any ­specialized knowledge. Taking the time to deliver one of these to a local club or at a STEM day can inspire a child who may not have otherwise been exposed to ­computer science, and they may become our next generation of OAUG members!

“Next year, I’d like to ­encourage you to ­consider promoting STEM opportunities in your local community. Oracle Academy offers a simple way to make this a reality.”

I found it simple to create my own ­individual account using my Oracle ­account and choosing my local high school as the educational institution. To do the same, join Oracle Academy and use this handy guide to get started.

I personally look forward to delivering the “Alice Workshop in a Box” in my own community and hope to hear your stories of inspiring the next generation.


Contact me at chipp@oaug.org.

3525 Piedmont Road, Building Five,
Suite 300, Atlanta, GA 30305
phone: +1 404.240.0897, fax: +1 404.240.0998
email: membership@oaug.com, oaug.org

Al Garver, Executive Director
Cindy Force, Managing Editor
Jim Grove, Creative Director

To contribute to OAUG Insight, send letters to the editor, or obtain advertising information, contact:
Cindy Force, Director, Marketing Communications
3525 Piedmont Road, Building Five,
Suite 300, Atlanta, GA 30305
cforce@oaug.com

Photographs appearing throughout OAUG Insight courtesy of Meeting Expectations.

OAUG Insight is designed to provide members of the Oracle Applications Users Group with ­organizational and other information. The opinions and viewpoints published herein are not ­necessarily those of OAUG. OAUG, its article writers, directors, officers, employees, agents, and members and Oracle Corp. make no warranty for the accuracy, veracity, or completeness of any information herein, nor do they have any ­responsibility or liability for any losses or damages incurred as a result of reliance on any information provided herein or from the use of any program or program segment discussed herein. OAUG assumes no responsibility for any errors that may appear herein. The information published herein is subject to change without notice. Acceptance of advertising is for the benefit and information of the membership but does not constitute ­official endorsement of the product or service by OAUG.

Copyright © Oracle Applications Users Group 2018. All rights reserved. OAUG is a registered trademark of the Oracle Applications Users Group. Oracle and Oracle Applications are trademarks of Oracle Corporation, Redwood Shores, Calif. Any other trademark cited herein is the property of its owner. No part of this publication may be reprinted or reproduced without the prior written consent of OAUG.

SUBSCRIPTIONS:
OAUG member organizations may receive up to 10 copies of OAUG Insight magazine by mail.

The electronic version of OAUG Insight magazine is available to all members on oaug.org/publications. Contact membership@oaug.org or +1 404.240.0897 with questions about your subscription options.

2018 Oracle Applications Users Group (OAUG) Board of Directors.
First row: Tamicka Camp, Christine Hipp, Andrew Farber, Douglas Manning, Kathleen Fauerbach, Karen Brownfield.
Second row: Beth McLaughlin, Alyssa Johnson, Felecia Alston-Green, Joseph Imbimbo, Donna Rosentrater, Mohan Dutt, Bill Dunham, Jason Watkins.

2018 Board of Directors

Christine Hipp
OAUG President
Los Alamos National Laboratory

Douglas Manning
OAUG President-Elect
Johns Hopkins University –
Applied Physics Laboratory

Andrew Farber
OAUG Treasurer
Consumer Reports

Kathleen Fauerbach
OAUG Secretary
City of Las Vegas

Felecia Alston-Green
DeKalb County Government

Karen Brownfield
Infosemantics, Inc.

Tamicka Camp
Southern Company Services.

Bill Dunham
OATC, Inc.

Mohan Dutt
Equinix, Inc.

Joseph Imbimbo
PPG Industries

Alyssa Johnson
Keste

Beth McLaughlin
Dunkin’ Brands

Donna Rosentrater
PAREXEL

Jason Watkins
Hillsborough County Aviation Authority

Features

14
Stabilizing Database ­Performance Using SQL Plan Baselines

SQL Plan Baselines can help ­stabilize the execution plans of SQL ­Statements to help make programs faster and perform more consistently, thus returning their Elapsed Times back to normal acceptable levels.
By Mark J. Rogers, Garmin International

20
How to Make Customers Happy: Ship Products on Time!

There are many reasons why a supply and demand picture might change in an ERP system. Changes in the net supply availability can impact existing orders, so they might be available to ship early, or their shipment could get delayed.
By Ankur Kulshreshtha, TaylorMade Golf Company

34
Vendor Corner: Planning a ­Migration from Oracle EBS to Oracle ERP Cloud?

COMPLIMENTARY FULL ARTICLE
Get tips and tricks to help improve your chances of a smooth migration.
By David Wright, More4Apps

OAUG Leadership

Conferences & Events

Members’ Corner

SUBSCRIPTIONS: OAUG member organizations may receive up to 10 copies of OAUG Insight magazine by mail. The electronic version of OAUG Insight magazine is available to all members on oaug.org/publications. Contact membership@oaug.org or +1 404.240.0897 with questions about your subscription options.

SUBSCRIPTIONS: OAUG member organizations may receive up to 10 copies of OAUG Insight magazine by mail. The electronic version of OAUG Insight magazine is available to all members on oaug.org/publications. Contact membership@oaug.org or +1 404.240.0897 with questions about your subscription options.

Oaug Star
Partners
(List updated as of press time.)

Oaug Star
Partners

(List updated as of press time.)

The OAUG Star Partners are a ­vital force in supporting the OAUG’s ­mission of ­providing ­Oracle ­Applications users the tools ­required to enhance their ­productivity, ­maximize their investment, and ­influence the quality, usability and support of Oracle Applications. ­Participants in the OAUG Star ­Partner Program represent some of the most experienced and most successful ­providers of services and solutions to the Oracle users community.

Five-Star

Four-Star

FEATURES Winter 2018

PATRICK CALLAHAN, AST LLC

What is Oracle Analytics Cloud?

Oracle Analytics Cloud (OAC) is the culmination of ­Oracle ­legacy, ­on-premises Oracle BI (OBIEE), BI Cloud (BICS), Data Visualization Cloud (DVCS) and Essbase ­(multi-dimensional database from Hyperion or OLAP cubes) all coming together into a complete analytics ­platform. It includes options for traditional ­reports and dashboards with structured ­analytics models. It includes the ­latest data ­visualization ­capabilities with unstructured data. New ­machine ­learning and data ­profiling features, easy ­connectivity to dozens of sources and the ­incorporation of “Essbase as a Service” make Oracle ­Analytics Cloud a one-stop shop.

FEATURES Winter 2018

PATRICK CALLAHAN, AST LLC

What is Oracle Analytics Cloud?

Oracle Analytics Cloud (OAC) is the culmination of ­Oracle ­legacy, ­on-premises Oracle BI (OBIEE), BI Cloud (BICS), Data Visualization Cloud (DVCS) and Essbase ­(multi-dimensional database from Hyperion or OLAP cubes) all coming together into a complete analytics ­platform. It includes options for traditional ­reports and dashboards with structured ­analytics models. It includes the ­latest data ­visualization ­capabilities with unstructured data. New ­machine ­learning and data ­profiling features, easy ­connectivity to dozens of sources and the ­incorporation of “Essbase as a Service” make Oracle ­Analytics Cloud a one-stop shop.

Recently, Oracle also introduced the “autonomous” version, or Oracle Autonomous Analytics Cloud (OAAC), and refers to the original OAC as “customer-managed.” From a feature perspective, OAC and OAAC are the same product. OAAC is ­essentially a SaaS offering, whereby Oracle ­manages ­everything, including the underlying Oracle database that houses the metadata, and applies the product updates ­automatically during the advertised maintenance periods. With “customer-managed” OAC, the updates are pushed into the customer’s OAC environment, but the customer must decide and initiate when the updates are applied. ­Moreover, within a “customer-managed” OAC environment, the ­customer has access to many more back-end configurations, though most changes would not survive a patch/update.

FEATURES Winter 2018

Mark J. Rogers, Garmin International

Have you ever been baffled by sudden poor performance in a ­critical program and unable to identify a cause? Here are steps to ­systematically identify whether the culprit could be changes in the SQL Execution Plan and how to successfully address such issues.

FEATURES Winter 2018

Mark J. Rogers, Garmin International

Have you ever been baffled by sudden poor performance in a ­critical program and unable to identify a cause? Here are steps to ­systematically identify whether the culprit could be changes in the SQL Execution Plan and how to successfully address such issues.

FEATURES Winter 2018

Mark J. Rogers, Garmin International

Have you ever been baffled by sudden poor performance in a ­critical program and unable to identify a cause? Here are steps to ­systematically identify whether the culprit could be changes in the SQL Execution Plan and how to successfully address such issues.

The Issue

SQL statements are the building blocks of programs. Each program may contain hundreds, if not thousands, of SQL Statements.

  • How could you identify which SQL Statement in a program may be the cause of a sudden performance problem?
  • More importantly, how could the problem be fixed quickly and reliably?

Oracle provides SQL Plan Management tools starting in 11g that help the DBA ensure that performance will not degrade beyond an accepted minimum level (or “baseline”) using SQL Plan Baselines.

FEATURES Winter 2018

HOW TO
MAKE CUSTOMERS HAPPY:
Ship Products on Time!

Ankur Kulshreshtha, TaylorMade Golf Company

There are many reasons why a supply and demand picture might change in an ERP system. Changes in the net ­supply availability can impact existing orders, so they might be ­available to ship early, or their shipment date could get delayed.

FEATURES Winter 2018

HOW TO
MAKE CUSTOMERS HAPPY:
Ship Products on Time!

Ankur Kulshreshtha, TaylorMade Golf Company

There are many reasons why a supply and demand picture might change in an ERP system. Changes in the net ­supply availability can impact existing orders, so they might be ­available to ship early, or their shipment date could get delayed.

FEATURES Winter 2018

HOW TO
MAKE CUSTOMERS HAPPY:
Ship Products on Time!

Ankur Kulshreshtha, TaylorMade Golf Company

There are many reasons why a supply and demand picture might change in an ERP system. Changes in the net ­supply availability can impact existing orders, so they might be ­available to ship early, or their shipment date could get delayed.

For example, let’s assume Order #1 is placed with a shipment date of April 30. As the inventory levels were adequate when the order was placed, the order received a good date. The next day, Order #2 is received for a priority customer, and it is picked and shipped the same day. This decremented the ­inventory that was originally scheduled for Order #1 and means that the first order will not go out on time. In this ­situation, Order #1 will not be identified as late until its ship date of April 30, and the customer will not be informed about this delay until April 30. (Figure 1)

Standard Process

There is a standard process that can be run on a daily basis for all open orders to “reschedule” them, i.e., reevaluate the shipment date on all the orders based on the current supply availability. This process is called “Schedule Orders.”

CONFERENCES & EVENTS Winter 2018

Members Share Highlights
from Oracle OpenWorld 2018

“The highlights of Oracle Open World 2018 were many. The sessions were good and the keynotes were informative. Among Public Sector sessions, I attended the City of San Jose’s session on ‘Next Generation of Citizen Experiences using Emerging Technologies’ and found it fascinating. It was great to see three different organizations: Oracle, the City of San Jose, and their system integrator (AST), come together and provide a very viable solution for the citizens of the city. I also attended ‘Improving Government Operations with the Cloud’ which was presented by the City of Detroit. During this session, I caught a glimpse into what cloud can do for a city, including how one moves forward with the transition of on-prem to cloud. Last but not least, I attended the OAUG Public Sector SIG where Hyperion in the Cloud was presented and well received.

A session that was specifically asked for by public sector organizations for COLLABORATE 19 was a comparison of ERP ­on-prem and in the cloud, including pros and cons and a roadmap for it. I look forward to learning more about that.”

Medik Ghazikhanian
City of Burbank

OAUG Members Save on COLLABORATE 19 Registration

Did you know that OAUG members save on the face-to-face networking and extensive education that happens at COLLABORATE? The average OAUG Corporate User member sends 2.7 people to COLLABORATE, each saving $400 on registration.

Take full advantage of your OAUG membership benefits by making sure your organization’s membership is up to date. Then register to attend the COLLABORATE 19 – OAUG Forum, April 7-11, 2019, in San Antonio, Texas.
Contact membership@oaug.org if we can help you check your membership status. Or join or renew online at ­oaug.org/membership.


The COLLABORATE 19 — OAUG Forum delivers expert on-prem Oracle Applications knowledge and guidance for the cloud so users can derive greater value from their Oracle investments and strategically plan for the future. Join live, expert-led education that synthesizes best practices and cutting edge insights, peer networking, access to solutions providers with the best new products and more.

The OAUG Forum covers Oracle E-Business Suite, On-Prem EPM/Hyperion, Cloud EPM/Hyperion, ERP Cloud, Data Science & Analytics, SCM Cloud, CX Cloud, Personal Growth & Leadership and more.

MEMBERS’ CORNER Winter 2018

Geo-SIG News
Letter from the Chairs

Jon Riley and Michelle Thiessen

Jon Riley

Michelle Thiessen

Jon Riley and Michelle Thiessen
Geo/SIG Committee Co-Chairs
Email us at geo-sig@oaug.org.

As 2018 comes to an end, we reflect on a successful year for the OAUG Geographic (Geo) and Special Interest Groups (SIG). We have a lot to reflect on this year:

  • We created new SIGs this year to expand OAUG’s content offering, including the E-Business Suite Advanced Architecture and High Availability SIG and the Emerging Technology SIG.
  • Our Geos and SIGs had a successful COLLABORATE 18 with over 40 face-to-face SIG sessions allowing attendees to discuss hot topics in their product areas across EBS, Hyperion and Cloud Applications. The Geos hosted their inaugural charity event, the OAUG Geo Networking ­Build-a-Bike! Geos networked with attendees by geographic region and built 30 bikes for underprivileged children in the Las Vegas area!

MEMBERS’ CORNER Winter 2018

OAUG Membership Spotlight

An average OAUG Corporate User member company sees a 317% return on their membership investment through valuable problem-solving resources and networking opportunities.

Save on face-to-face networking and extensive education

at COLLABORATE 19: Technology and Applications Forum for the Oracle Community – OAUG Forum.

  • The average OAUG Corporate User member sends 2.7 people to COLLABORATE, each saving $400 on registration.
  • COLLABORATE offers 22 hours of breakout sessions at an average rate of $75 per hour — far less than competitive training options, plus it’s live and interactive. Your team gets answers in real time.

Learn from the experts in ­convenient live eLearning ­webinars

The average OAUG Corporate User member has 6.2 employees attend OAUG live eLearning webinars each year. Valued at $100 per session, that’s $620 of learn-in-place education.

MEMBERS’ CORNER Winter 2018

OAUG Emerging Leaders Mentor Program

Russell De Leon, OAUG Emerging Leaders Committee Chair

The OAUG Emerging Leaders (formerly known as the OAUG Young Professionals Forum) is focused on helping people who are just beginning their career with Oracle Applications or just beginning their career in general. Grow in your career by networking with peers and mentors as well as registering for helpful educational content.

The group has many initiatives, like webinars that are held multiple times a year with a focus on professional development or Oracle Applications topics.

VENDOR CORNER Winter 2018

Planning a Migration from ­Oracle EBS to Oracle ERP Cloud?
Tips and Tricks to Help You

David Wright, Global Pre-Sales Manager, More4Apps

All migrations have impacts, not just to your source and target systems. The impact will be substantial with various touch points within your organization. Your project team will need to take into consideration costs, process impacts and resource requirements. Regular communication to business, data security and general IT staff are paramount in your migration project plan.

A key aspect of any migration is what data to take across and what is the most efficient way to make this happen? Key questions include:

  • Are there scripts that I can just execute and extract all the data from my EBS legacy system?
  • What data cleansing tasks should I perform?
  • Where’s the best place to clean the data?

Thanks for reading our Winter 2018 Preview Issue!