Summer 2018
Preview Issue

Summer 2018
Preview Issue

Features

12
The CFO’s Guide to ­Transforming and Maintaining an Optimal Chart of Accounts Structure

Rethink and redesign accounting structure definition to make it scalable for future growth and able to meet management reporting and statutory compliance requirements.
By Kartik Subbaraman, Infosys Ltd.

16
An Oracle Value Chain Planning Certification Primer

COMPLIMENTARY FULL ARTICLE
This article highlights important ­certifications and dates for two components of VCP: Advanced Supply Chain Planning (ASCP) and Demantra.
By Joseph Imbimbo, PPG Industries

18
APEX Visual Workforce Dashboards

From EBS and non-EBS data with IoT on private cloud.
By Jeff Maag, Chase Brass and Copper Co.

22
EBS Functional Analyzers: Keep Calm and Analyze

EBS Functional Analyzers are your personal help desk.
By Jeff McCall, Oracle, and Michael Barone, OATC, Inc.

26
Is Your Software Vulnerable to Cybercrime?

Cybercrime is real. Oracle Support provides mission-critical security ­updates and protection for your ­Oracle software.

OAUG Leadership

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.

Conferences & Events

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.

President’s Perspective

Highlights
from COLLABORATE 18!

Highlights
from COLLABORATE 18!

Christine Hipp
OAUG President

chipp@oaug.org
Twitter: @Chipp123Hipp

COLLABORATE 18, which was held in Las Vegas in April, was an incredible success, judged by the positive survey feedback received from attendees. Here are my personal top-ten highlights:

  1. Energy: With nearly 5000 attendees, the bustling crowd was enthusiastic about learning and networking.
  2. Knowledge: More than 1200 ­educational sessions covered so many topics, carefully selected for our Oracle customer communities.
  3. Access to Oracle: Oracle road map ­presentations, conversations with support engineers, meet-the-experts sessions and previews of the latest solutions in the Oracle DEMOgrounds provided opportunities to engage in powerful discussions.
  4. Getting Hands-on: Customers were able to get a first-hand look at lift and shift to Oracle Cloud Infrastructure for Oracle E-Business Suite.
  5. Giving Back: The Geo Build-a-Bike event that opened the conference on Sunday brought people together to assemble 30 bikes, which were given to the children of local veterans through Operation Homefront.
  6. Recognizing Members: Outstanding contributors received annual awards for the work they do on behalf of our users community. Meet our superstars, beginning on page 30 in this issue of OAUG Insight magazine. Meet our superstars
  7. Professional Polish: The OAUG ­membership booth featured the ­LinkedIn Corner, where members could have a professional portrait ­photo taken and receive advice on how to amp up their LinkedIn profile.
  8. Turbo Talks: Similar to TED Talks, these compact, laser-focused sessions held in the Exhibitor Showcase were a huge hit.
  9. Networking: The opening OAUG ­welcome reception; Women in ­Technology lunch and panel; ­Analytics, BI, Big Data and EPM ­Hyperion ­Reception; Emerging Leaders ­reception; SIG meetings throughout the week and other gatherings created environments for making connections.
  10. Fun: The Wednesday night closing party reserved the entire Mandalay Bay pool area. The Caribbean food and ­beverages, with a live band that mirrored Miami Sound Machine and ­Selena, made it an evening to ­remember.

See photos and get additional highlights from COLLABORATE 18, beginning on page 27. Let’s meet up at COLLABORATE 19, April 7-11, 2019, in San Antonio, Texas. Save the date!


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

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 Summer 2018

Rajiv Jegannathan, The Wonderful Company
Jim Mooney, Oracle

At The Wonderful ­Company, we ­migrated from ­on-premises ­Oracle ­Transportation ­Management (OTM) 6.4.1 to Cloud OTM 6.4.2 version.

FEATURES Summer 2018

Rajiv Jegannathan, The Wonderful Company
Jim Mooney, Oracle

At The Wonderful ­Company, we ­migrated from ­on-premises ­Oracle ­Transportation ­Management (OTM) 6.4.1 to Cloud OTM 6.4.2 version.

This was a quick, 12-week upgrade plus migration to cloud that affected three business units and four different groups of end users at different locations. We are also on a full-fledged end-to-end Oracle Cloud implementation that involves Fusion ERP and WMS (LogFire) integrating with OTM Cloud.

This article highlights the OTM 6.4.1 on-premises to OTM 6.4.2 Cloud journey and how we continued to integrate with three different on-premises E-Business Suite (EBS) instances.

OTM On Premises vs. OTM Cloud: Key Differences

Unlike Fusion, OTM Cloud and on-premises have only minor differences. In OTM Cloud:

  • No direct access to DB or app/web servers.
  • Uses SSO, so one login per person, no domain admin users.
  • No PL/SQL or custom code/help allowed on OTM instance (use PaaS).
  • SqlServlet is read only.
  • DB.XML runs in App execution mode only.
  • Cannot customize RPD or ETL in FTI/GTI.

Plan to attend the 2018 OTM User Conference to learn, network and share best practices with other professionals using Oracle OTM solutions to manage transportation activities across their supply chains. The event takes place August 5-8, 2018, in Philadelphia, PA, USA.

otmsig.communities.oaug.org/us-conference

Plan to attend the 2018 OTM User Conference to learn, network and share best practices with other professionals using Oracle OTM solutions to manage transportation activities across their supply chains. The event takes place August 5-8, 2018, in Philadelphia, PA, USA.

otmsig.communities.oaug.org/us-conference

FEATURES Summer 2018

Kartik Subbaraman, Infosys Ltd.

Many organizations are ­challenged by financial ­reporting and management analysis.

This is primarily because:

  • Organizations have rapidly grown more diverse and ­globalized.
  • New and maturing statutory and regulatory requirements (IFRS, segment reporting, revenue recognition, etc.) have been enacted.
  • Organizations are operating on a complex ERP platform accompanied by outdated foundational data elements.

The most critical foundational element (from a finance perspective) for an Oracle implementation is the ­accounting structure definition, the chart of accounts (COA) ­structure. Most enterprises struggle with this today because the ­accounting structure was designed decades back when ­organizations made the first move toward implementing an integrated software system. The design has not kept pace with the rapidly changing environment of today.

FEATURES Summer 2018

Joseph Imbimbo, PPG Industries

For companies that manage ­product inventories and have ­large-scale manufacturing ­operations requiring a steady and dependable ­supply chain, ­Oracle’s Value Chain Planning (VCP) Suite provides the means to ­ensure product availability to their ­customers as well as the ­components necessary for their manufacture.

As with any Oracle software product, it’s extremely important to be aware of the certifications and support dates that are critical to ensuring technical support and software updates.

The purpose of this article is to highlight some of the ­important certifications and dates for two components of VCP: Advanced Supply Chain Planning (ASCP) and Demantra. ASCP is a licensed product inside of E-Business Suite (EBS). Demantra is a separately installed component that handles demand forecasting and utilizes an analytical forecast engine to generate those forecasts.

FEATURES Summer 2018

Jeff Maag, Chase Brass and Copper Co.

Using Oracle Application Express (APEX), Chase Brass quickly and accurately provided information to executives, production management and line workers in various departments.

We created a variety of dashboards that are displayed and refreshed every 30 seconds on video monitors throughout the plant. The information links our Oracle E-Business Suite (EBS) to process data from the equipment to help drive ­process improvements.

Using Apex allowed us to compare the actual vs. expected times of operations on the production floor as well as for management in the back office. (Figure 1 shows data from the shop floor downtimes on the lower left. The lower right merges data from EBS scheduling with the start times from the shop floor.)

FEATURES Summer 2018

JEFF MCCALL, ORACLE, AND MICHAEL BARONE, OATC, INC.

Oracle Support E-Business Suite Functional Analyzers are your personal help desk when the need arises.

As they are created and maintained by Oracle Support, you can be assured that the analyzers identify the most common setup / data issues with solutions that point to official ­Oracle solutions. It’s like having your very own Oracle Support ­engineer with you at all times!

Best of all, these Oracle Support E-Business Suite Functional Analyzers are free and updated often with the latest solutions for issues that may be causing anxiety. Do not worry. Keep calm and analyze!

Previously, in the winter 2017 OAUG Insight magazine, we ­discussed what the analyzers are and how to easily install them. For example, the EBS Procurement Approval ­Analyzer can be used to diagnose issues with a specific document or a group of documents. This analyzer provides a detailed ­analysis of the workflow actions that the document engaged during the approval process. The analyzer also provides many more details related to the document itself and common setup issues.

FEATURES Summer 2018

Introduction by Kaberi Nayak and Vivek Puri

OAUG Customer Support Council Chair and Co-Chair

The OAUG Customer Support Council meets regularly with employees and leaders from the Oracle Support organization to trade information – challenges or concerns our members share as well as information and useful tools developed by Oracle Support. We’re pleased to share this article, compliments of Oracle Support.

Cybercrime is real. By 2021, ­estimates say the annual ­worldwide cost for cybercrime damages will reach $6 ­trillion1.

65 percent of organizations say their in-house security ­capabilities are adequate — yet 80 percent have been negatively affected by a cybersecurity attack in the last year2. ­Governments are warning of the growing threat to data security.

CONFERENCES & EVENTS Summer 2018

AN ILLUMINATING EXPERIENCE

The spotlight was on real-world scenarios, first-hand experiences and honest advice aimed at helping COLLABORATE 18 conference attendees:

  • Maximize on-premises solutions
  • Evaluate a path to the cloud
  • Optimize business in the cloud.

5,000 ATTENDEES

200 EXHIBITORS

3 ORACLE HANDS-ON LABS

1,200 EDUCATIONAL SESSIONS

3 KEYNOTE PRESENTERS

20 TURBO TALKS

275 PROFESSIONAL PROFILES OR PORTRAITS IN THE LINKEDIN CORNER

58 EMERGING LEADERS ATTENDING THE COCKTAIL MEET-UP

30 BICYCLES BUILT FOR CHARITY BY GEO COMMUNITY PARTICIPANTS

1 MEMORABLE MEET AT THE BEACH CLOSING CELEBRATION

3 ROUNDTABLE DISCUSSIONS FACILITATED BY THE CUSTOMER SUPPORT COUNCIL

2,000 ANIMALS CALLING SHARK
REEF AQUARIUM HOME

(also the home for the evening for the Analytics, BI, Big Data and EPM/Hyperion Reception)

3 ROUNDTABLE DISCUSSIONS FACILITATED BY THE CUSTOMER SUPPORT COUNCIL

2,000 ANIMALS CALLING SHARK
REEF AQUARIUM HOME

(also the home for the evening for the Analytics, BI, Big Data and EPM/Hyperion Reception)

MEMBERS’ CORNER Summer 2018

Each year at the Meeting of the OAUG Members during COLLABORATE, the OAUG presents awards to its superstars – individuals and groups that serve the OAUG community with their outstanding contributions throughout the year.

2018 Awards

GEOGRAPHIC AND SPECIAL INTEREST GROUPS*

The OAUG’s Geographic (Geo) and Special Interest Groups (SIGs) partner with the OAUG to provide education and networking opportunities for specialized Oracle users communities each year. The groups receiving the Certification of Distinction award for their excellence in delivering the highest quality content and service in 2018 are…

MEMBERS’ CORNER Summer 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.

We were excited to be a part of COLLABORATE 18, which offered a snapshot of the OAUG User Community and its vast offerings to all attendees. Our new community event, OAUG Geo Network Community Service Build-a-Bike was a sold-out event! Our Geographic User Groups enjoyed an afternoon of community and creativity as we constructed 30 bicycles for under-privileged children in the Las Vegas area! We ­presented the bikes during our Meeting of the Members session and surprised five kids and their families from a local charity, ­Operation Homefront, with shiny, new bicycles! Our SIGs hosted more than 30 educational sessions that covered a ­variety of topics including the cloud, Hyperion and EBS and also included panel discussions, user stories and best ­practices.

MEMBERS’ CORNER Summer 2018

MEMBER BENEFIT SHOWCASE:

OAUG Members Connect, Learn and Shine

Thousands of Oracle Applications users and expert consultants connect through the OAUG to share best practices and learn from each other.

Connect

Use the New Membership Directory to Connect with Other Members

The all-new OAUG Membership Directory makes it easier than ever to connect with other OAUG members. OAUG members can use the OAUG Membership Directory to find information about individuals within other OAUG member organizations (by using the Individual Directory) or organizations in your industry or area (by using the Corporate Directory). You can search with the following fields:

  • Company Name: Name of the company or organization.
  • First or Last Name: Name of specific person associated with a member organization.
  • State or Country: Location of member organizations.
  • Job Function or Business Solutions or Oracle Products: Role, solution or products used by individuals associated with member organizations.
  • Primary Industry: Choose from a list of industries.

Thanks for reading our Summer 2018 Preview Issue!