Spring 2019
Preview Issue
Spring 2019
Preview Issue
Oracle E-Business Suite Training at COLLABORATE 19: One User Shares Her Experience.

President’s Perspective

Transformation: It May Be the New Thing, But We are Not on Unfamiliar Ground

Douglas Manning
Douglas Manning
OAUG President

dmanning@oaug.org

First off, a brief introduction. My name is Douglas Manning, and I have the honor and privilege to be your 2019 OAUG Board President.

I started my IT career in 1985 and have worked with the Oracle E-Business Suite (EBS) product since 1996 (as a solution designer and project and service manager). For those of you who are fans of the BBC science fiction series Doctor Who (I count myself as one), that is six transformations of Doctor Who since 1996 and eight since 1985. You could say I’ve seen my share of transformation, especially in regard to EBS.

In the early days, I was two years in using, supporting and designing solutions for our Oracle EBS product at Johns Hopkins University Applied Physics Laboratory (APL for short) before I went to my first OAUG conference. I thought I had learned a lot in my first two years, but being able to speak with the people who actually use the product day in, day out and who lived in and faced the same challenges I encountered in my world (not just the marketing or support types) gave me a whole new perspective. (It was very transformative.)

Still, a number of years passed before I felt knowledgeable and confident enough in what I had learned and mastered to start sharing my knowledge and presenting papers. I had gained so much, attending every conference I could…At some point, you want to pay it back as a tribute to the folks who helped you along way. One of the great things I love about the OAUG is that you have all kinds of opportunities to do just that, and helping others succeed through information was one of the main reasons that led to my participation on OAUG’s Board.

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

Ragan Cohn, Executive Director
Cindy Force, Managing Editor
Dimitri Papadimitriou, 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 2019. 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:
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.

2019 Oracle Applications Users Group (OAUG) Board of Directors.
First row, seated: Andrew Farber, Sharhonda Rush, Karen Brownfield, Douglas Manning, Beth McLaughlin, Felecia Alston-Green, Donna Rosentrater.
Second row, standing: Ragan Cohn, Alyssa Johnson, Troy Haan, Kathleen Fauerbach, Joseph Imbimbo, Jason Watkins, Dianne DeNezza, Tamicka Camp.
2019 Board of Directors

Douglas Manning
President
Johns Hopkins University –
Applied Physics Laboratory

Kathleen Fauerbach
OAUG President-Elect
City of Las Vegas

Andrew Farber
Treasurer
Consumer Reports

Beth McLaughlin
Secretary
Dunkin’ Brands, Inc.

Ragan Cohn
Executive Director

Felecia Alston-Green
DeKalb County Government

Karen Brownfield
Infosemantics, Inc.

Tamicka Camp
Southern Company Services.

Dianne DeNezza
University of Pittsburgh

Troy Haan
Boise State University

Joseph Imbimbo
PPG Industries

Alyssa Johnson
Keste

Donna Rosentrater
PAREXEL International Corp.

Sharhonda Rush
Jacksonville Transportation Authority

Jason Watkins
Hillsborough County Aviation Authority

Features
15
Taking Off to Oracle Analytics Cloud

Today’s business users are data jockeys. Oracle Analytics Cloud provides user-friendly features to support their advanced needs out of the box.
By Raghav Venkat, City of Las Vegas

22
DBA Access for Oracle Value Chain Planning (VCP) Analyzer

The OAUG’s Customer Support Council led the way in requesting a new approach to Oracle support-driven file requests WITHOUT requiring the APPS password.
By Jeff Goulet, Oracle

25
OAUG Collegiate Forum

In partnership with Oracle Academy and California State University East Bay, the OAUG hosted a day of informational training n the skills needed to be marketable in a fast-paced industry.

OAUG Leadership
Conferences & Events
Members’ Corner
Vendor Corner
40 Oracle Projects Close Out Process
COMPLIMENTARY FULL ARTICLE
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: 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

More4Apps
insightsoftware

Four-Star

vertex

FEATURES Spring 2019

Michael Urgo, Sinclair It
Change Management Diagram
Introduction
To start, I would like to level set definitions. “Change Management” for the purposes of this article refers to the Release and Deployment Management area from an ITIL perspective. This does not refer to the “Change Management” ITIL process that has to do with managing systematic change requests made within an IT organization.

Change management tends to be a topic that organizations like to talk about, yet when it comes to planning and execution, many organizations recognize missed opportunities in post project reviews. Fitting into the ITIL Service Transition Management Cycle, change management can make or break the success of any project. This article highlights some tips and tricks that can assist organizations with change management initiatives based on my experience as part of the project team with my organization.

FEATURES Spring 2019

OAUG Spring 2019 - Taking Off to Oracle Analytics Cloud
Raghav Venkat, City of Las Vegas
“Cutting edge cloud applications:
enabling agility, mobility and
innovation.”

FEATURES Spring 2019

OAUG Spring 2019 - Taking Off to Oracle Analytics Cloud
Raghav Venkat, City of Las Vegas
“Cutting edge cloud applications:
enabling agility, mobility and
innovation.”

FEATURES Spring 2019

OAUG Spring 2019 - Taking Off to Oracle Analytics Cloud
Raghav Venkat, City of Las Vegas
“Cutting edge cloud applications:
enabling agility, mobility and
innovation.”
Embrace the Future
Analytics is becoming more vital for every organization in today’s technology landscape. In fact, cloud computing is the new normal! It has evolved as the next big, bright and excellent idea. There are several quantifiable benefits, such as greater agility, lower cost and better utilization of skills; more reliable infrastructure; and elasticity, that have encouraged several businesses to consider it as the next best improvement. In this article, I offer real-life experiences and some lessons learned in planning and executing a transition from on-premises analytics applications to Oracle Analytics Cloud.
Don’t Get Caught up in the Hype
Oracle Analytics Cloud is a great option for many, but not all, enterprises. A prerequisite for successful migration is a cloud assessment. A detailed analysis on several facets of the cloud product, such as financials, security and compliance, and technical, should be included. A general total cost of ownership (TCO) calculation and a plan to measure success should be the outcome of this exercise. This is a great time to make the case for or against moving to the cloud, separating truth from noise. Specifically, customers with Oracle BI Applications might have to spend some extra effort when assessing the journey to cloud.

FEATURES Spring 2019

DBA Access
DBA Access
for Oracle Value Chain Planning (VCP) Analyzer
for Oracle Value Chain Planning (VCP) Analyzer
Jeff Goulette, Oracle
Although often required, working with multiple file requests from Oracle Support can be a challenging, time consuming exercise. The OAUG’s Customer Support Council has led the way in requesting a new approach to Oracle Support-driven file requests WITHOUT requiring the APPS password!
Introducing the Value Chain Planning (VCP) diagnostic single-submission concurrent program, version 1.
The new Perl program is submitted as a concurrent process and includes the following diagnostic programs:

  • VCP Collections Analyzer.
  • VCP Partitions Analyzer.
  • APScheck.sql and the new APScheck parser Perl program.
  • MSCplan10.sql.

All output is easily identified as the concurrent request parent ID is embedded into the output of each diagnostic file name. This approach eliminates the database administrator (DBA) role, enabling the submission of a concurrent process without the APPS password.

FEATURES Spring 2019

FEATURES Spring 2019

FEATURES Spring 2019

OAUG Spring 2019 - The OAUG Collegiate Forum
OAUG Spring 2019 - The OAUG Collegiate Forum
OAUG Spring 2019 - The OAUG Collegiate Forum
OAUG Spring 2019 - The OAUG Collegiate Forum
OAUG Spring 2019 - The OAUG Collegiate Forum

The OAUG Collegiate Forum held its inaugural meeting in October 2017 in partnership with Penn State Erie, Black School of Business. The program hosted students enthusiastic to learn more about post-graduate life, possibly as an Oracle technologist.

In November 2018, the program was hosted in partnership with Oracle Academy and California State University East Bay, presenting a day of informational training on the skills needed to be marketable in a fast-paced industry. Experienced Oracle professionals and Oracle employees facilitated sessions and panel discussions covering hot topics including interviewing (and how to wow them), what it’s like being a consultant, Oracle Cloud Apps, data requirements and how it drives business in today’s economy, as well as transitioning into a professional role.

Thank you to the 2018 OAUG Collegiate Forum panelists and presenters:

  • Jean-Pierre Dijcks, Oracle Corporation
  • Mohan Iyer, FSCP Solutions
  • Elizabeth Kensicki, Denovo Ventures, LLC
  • Douglas Manning, Johns Hopkins University – Applied Physics Laboratory

MEMBERS’ CORNER Spring 2019

Geo-SIG News
Letter from the Chairs

Michelle Thiessen and James Liu

Geo-sig News contributor Michelle Thiesson.

Michelle Thiessen

Geo-sig News contributor James Lui.

James Lui

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

New Year.
New Opportunities.
New Victories.

The new year provides an opportunity for many to make resolutions. It’s a time in which people evaluate their goals and make plans for success. The OAUG Geographic (Geo) and Special Interest Groups (SIG) have spent time in 2018 strategizing and now are moving full steam ahead in 2019 with new opportunities and new developments.

This year, we are excited to bring the skills and expertise of our user community to a new city for COLLABORATE 19: San Antonio, TX. Our Geo leaders and conference attendees will have the opportunity to participate in our second annual OAUG Geo Networking Community Service Build-A-Bike® event on Sunday, April 7, 2019.

MEMBERS’ CORNER Spring 2019

OAUG Member spotlight

The OAUG Board of Directors Welcomes Three New Members in 2019

The Oracle Applications Users Group (OAUG) Board of Directors provides leadership, influence and guidance to drive and enhance the focus of the OAUG. In following the mission of the OAUG, the board works with the OAUG Executive Director to create a strategic plan for the year that supports the views of the members and works to enhance the capabilities of the organization.

Joining the OAUG Board in 2019 are:

Dianne DeNezza, OAUG Board member.

Dianne DeNezza

Executive Director, Business Solutions, Financial Information Systems, University of Pittsburgh

Dianne has more than 20 years of experience with Oracle E-Business Suite (EBS), primarily with financial, purchasing and human capital management (HCM) applications. In her role at the University of Pittsburgh, Dianne is responsible for software implementations and upgrades, system assessments, process improvement, strategic management, customer support and training.

MEMBERS’ CORNER Spring 2019
OAUG Member Benefit Showcase
OAUG Member Benefit Showcase
The OAUG is all about helping users of Oracle software make the most of that investment so companies prosper and the software users and support teams are working smarter, not harder.

The hub of the excitement here is the COLLABORATE: OAUG Forum – an annual gathering of Oracle software users from across the U.S. and around the globe. It’s THE place to learn from, present to and build connections with other Oracle users and vendors who live to make your work life better. Plan now to join us April 7-11, 2019, in San Antonio, Texas.

One week is all you need. One week at the COLLABORATE 19 – OAUG Forum will equip you with the expertise and insight you need to do your job more effectively and maximize your organization’s investment in Oracle Applications in the coming year.

VENDOR CORNER Spring 2019

Oracle Projects Close Out Process
THINKING OUTSIDE THE BOX!

BRAD SAYER, FOUNDER, MORE4APPS
Recently, an Oracle Projects user commented that their Project-Close business process was convoluted and very time consuming. When projects were to be finally closed, they needed to undertake the following actions in succession:

  1. Determine what revenue accrual adjustments were required.
  2. Create Revenue Events to write-on – or write-off – the WIP or Unearned Revenue values from their accounts.
  3. Adjust the Project Budgets.
  4. Adjust the Agreement Funding and Baseline these updates.
  5. Generate the Revenue and Accounting reports.
  6. Close the Project.

As it’s a lengthy process requiring a high-level analysis and checking, this task was often left to year-end, meaning time pressure for their year-end accounts added to the stress equation. Of course, depending on which version of Oracle E-Business Suite you are on, there are some efficiencies that can be configured when closing projects.

Thanks for reading our Spring 2019 Preview Issue!