Upcoming ODTUG Webinars

Below is the list of upcoming webinars. If there is a topic you would like covered that is not on our current list, or if you would like to present a webinar, please email alicia@odtug.com.

Did you miss a webinar? Our Webinar File Library lists all of our webinars and can be filtered by subtopic (content track). As an ODTUG member, you can watch all of our past webinars at any time. Not a member? Join now for the low price of $99 per year!

Our webinar calendar is constantly evolving! Check back frequently, as more webinars will be added to the schedule.

Thursday, February 2, 2017 3:00 PM - 4:00 PM EST
Ready. Set. Cloud! Migrating from On-Premise to Oracle PBCS
Deanna Sunde, Key Performance Ideas

Find out how this project started with a cleanup effort so objects, such as forms and reports, could be rationalized and only the appropriate objects migrated and tested on PBCS. Discover how the company migrated from 9.3 to 11.1.2.3 on a lab environment and then to PBCS using LCM. Additionally, learn how the ODI interfaces were updated and Business Rules were migrated to Calculation Manager. Hear tips and tricks for migrating to PBCS and how the build, training, and rollout for this project was completed in eight weeks.

Register Here

Tuesday, February 7, 2017 3:00 PM - 4:00 PM EST
Supporting EPM in the Cloud, Transitioning Roles and Tasks
Mike Turner and Jeff Henkel, CheckPoint Consulting

Cloud environments are unique and lighter but still require a layer of hands-on care. Let’s take a closer look at the demands of an EPM environment’s run and how we can maintain requirements in the cloud. We’ll cover these common on-premise tasks and how to translate these to the cloud:

• Metadata management to data integration
• Admin team’s areas of adjustment to keep the numbers rolling up
• Special considerations for security and backups
• Tricks for Smart View support

All these tasks still have a piece of the action in PBCS. We will highlight the run and maintenance requirements for PBCS. Even though you’re not managing the servers anymore, PBCS still needs hands-on experience and attention. Are your business users ready to absorb this transition?

Register Here

Thursday, February 9, 2017 3:00 PM - 4:00 PM EST
Oracle PCMCS: The Essential Overview
John Maloney, TopDown Consulting, and Mark A. Wright, Oracle Corporation

Oracle’s new Profitability and Cost Management Cloud Service (PCMCS) is a purpose-built solution for finance executives. It brings costs, revenues, and operational systems often fragmented across data silos into a single cloud location where users can leverage Oracle’s powerful database engine to analyze and provide insights that are not possible with fragmented on-premises solutions. Sounds great, so how does it work?

This session is a deep dive into PCMCS so you can get the most out of Oracle’s latest cloud offering. It will cover the data modeling capability using data extracted from ERP systems, including Oracle E-Business Suite Database, PeopleSoft, Oracle Fusion, JD Edwards, third-party General Ledgers, and Oracle Cloud Planning and Budgeting Cloud as well as Oracle Financial Consolidation and Close Cloud. Pre-built reports (e.g. profit curves, scatter plots, and traceability), how to design new reports, and detailed financial modeling are also covered.

Register Here

Tuesday, February 14, 2017 3:00 PM - 4:00 PM EST
Implementing Hyperion Planning Driver-Based Rolling Forecasting
Deanna Sunde, Key Performance Ideas

Driver-based rolling forecasts, simplified. Want a monthly rolling forecast but believe there is a lot of effort required to enter all of the data? Join us for this webinar and find out how companies are implementing a rolling forecast through the use of drivers to streamline the effort. A demonstration will include how a handful of drivers are used along with historical data and trending methods to populate the rolling forecast. This provides more time for analysis, which every company desires. Plus, discover how rolling forecasts are set up and maintained with Oracle Hyperion Planning and how to implement dynamic reporting of overlapping quarters.

Register Here

Thursday, February 16, 2017 4:00 PM - 5:00 PM EST
2017 CodeTalk Series - The PL/SQL Ninja: PL/SQL Can Do What?
Steven Feuerstein, Oracle Corporation, and Morten Egan, the PL/SQL Ninja

The Code Talk Series is Co-sponsored by ODTUG and IOUG

How do we make PL/SQL as easy and fun to develop in as Node/Ruby/Python/[flavor of the day]? What are the things that make a language “cool” to build stuff in? Apart from being hip or used by Facebook/Google/Apple, what is the core functionality that should be available in any language and what are the core parts of the ecosystem around a language that makes it easier to pick up and start building? Looking at PL/SQL, what are the must-know packages that will get you started doing fun, useful libraries or applications?

In this CodeTalk session, Steven Feuerstein interviews Morten Egan, aka the PL/SQL Ninja, who has been asking himself – and then answering via code – these very questions. We’ll take a look at some of the utilities and libraries he has built for codemonth.dk and plsql.ninja to see what is possible and discover the sources of Morten’s inspiration and creativity. And time permitting, he’ll demonstrate with some “live” coding as well!

Register Here

Tuesday, February 21, 2017 3:00 PM - 4:00 PM EST
Version Control for PL/SQL
Yalim Kerem Gerger, Gerger

Version management of the PL/SQL source code has always been challenging. Database programmers lack the tools and utilities that make version control easy for developers who code with file-based programming languages such as Java and JavaScript. In fact, this is one of the primary reasons why large software teams avoid writing code in PL/SQL.

In this presentation, you will learn how you can use Git, the prominent open-source version-control software built for distributed teams, to manage your PL/SQL source code. Using these techniques, you can manage your PL/SQL source code just like any other development team manages their file-based code base written in languages such as Java, JavaScript, or C#.

In this presentation, you’ll also learn:

• How Git can empower you to implement any development workflow within your team and make this workflow an inseparable part of your development process.
• To automate most time-consuming tasks, such as merging changes in multiple packages, procedures, and functions.
• To execute commonly used version-control commands in the Oracle Database, such as reverting to a previous version of your source code, creating a new branch, and changing between branches, and how executing these commands can change the source code in the Oracle Database automatically.
• How to get the differential script between two Oracle Database source-code repositories automatically.
• How to minimize any errors, such as overwriting over newer version of packages, procedures, and function.
• How to prevent anyone from editing source code in the database outside of a version-control system.
• How you can have multiple teams change the same logical packages, procedures, and functions and merge their changes automatically.
• To create a reliable audit trail and change log that documents every change to your code base.

Register Here

Thursday, February 23, 2017 12:00 PM - 1:00 PM EST
Oracle Discoverer Replacement Options: Oracle as Well as a Couple of Others to Consider
Naren Thota, Infosemantics

With the Oracle Discoverer 11g end-of-life statement of direction from Oracle in March 2014, it is important for customers to look at alternatives, including migrating to OBIEE, Oracle BI Cloud Service (BICS), and possible other options. This presentation uncovers these options in detail, with pros and cons and recommended path based on our experiences.

• Tailored discussion to most common customer scenarios in the industry and solution relevance to these scenarios.
• Gain insight into alternatives and options to make appropriate decisions.
  

Register Here