Is there a topic you would like covered but do not see here? We are happy to take webinar suggestions. Email us at firstname.lastname@example.org.
Did you miss a webinar? As a full ODTUG member, you can view all of our past webinars at any time. Just log in and you will see the link for the recorded list under the Resources tab. Not a member? Join now for $99!
ODTUG is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.NASBARegistry.org.
How to qualify for CPE Credits:
- Register for the webinar, indicate that you are a Full (paid) ODTUG member, and check the box on your registration form to indicate you'll be earning credits.
- Attend the session and fill out an evaluation form; make sure to include your name. The evaluation form will be sent to you once the webinar is completed.
- You must respond to all poll questions that will show up on the screen at random during the presentation.
- After the webinar, you will receive a certificate via email for the session you attended.
- Submit the certificate to your State Board of Accountancy.
Webinars are free to all. No cancellation is required. If you do not attend, your registration will automatically be cancelled.
Webinars that are eligible for CPE credit will be noted as such in their description.
Our webinar calendar is constantly evolving! Check back frequently, as more webinars will be added to the schedule.
Thursday, July 9, 2020 12:00 PM - 1:00 PM EDT
Migrating Oracle Analytics to Oracle’s Gen2 Infrastructure – A Real World Customer Story
Brendan Flanagan and Mark Daynes, Beyond Systems
Beyond Systems migrated Galliford Try’s complete Oracle Analytics platform to Oracle’s next-generation cloud infrastructure (OCI GEN2). Learn how the customer benefited from increased performance and security as well as reducing overall costs. We discuss the remit for the transition, the approach, and the details of the successful outcome and how you can plan for the same.
Tuesday, July 28, 2020 12:00 PM - 1:00 PM EDT
Finding the Right Fit: Interviewing and Being Interviewed in the DB World
Liron Amitzi, GotoDBA
Have you ever been to a job interview that didn’t go that well? Have you ever interviewed a DBA or a DB developer and didn’t know what questions to ask? An interview is an integral part of being employed, and it’s very different from one company and interviewer to another, but the goal is the same: to get a feel for the candidate and see if the candidate is a good fit for the position.
As a DBA consultant and past manager of a team of professional services DBAs, I have both interviewed and been interviewed myself many times. In this session I will present my view on interviewing (or being interviewed) for a DBA or DB developer position, questions I like to ask and why, what I’m happy (and less happy) to hear from the other side, and how to respond to certain situations as a candidate.
Wednesday, July 29, 2020 12:00 PM - 1:00 PM EDT
WIT Webinar Series: Finding Your True Leadership Style
Seema Shah, Alithya, and Steisi Manco, Huron Consulting Group, with panelists Mia Urman, AuraPlayer and Toby Hatch, Oracle Corporation
Following a leadership model that does not fit your personality or aspirations can be detrimental to your career as well as your happiness. How do we explore a leadership style that is authentic, yet yields results at the same time? How do we recognize the positive aspects of leadership in those around us? How do we learn from other people's leadership experience and take stock of what must change with the passage of time? Our leadership style is constantly evolving on our journey toward achieving our goals. Find out more about developing your unique leadership style and the importance of a clear path forward from our panelists.
Thursday, July 30, 2020 12:00 PM - 1:00 PM EDT
Craft Beer in the Cloud: A Data Warehouse Case Study
Dani Schnider, Trivadis and Andrea Kennel, Consultant
Data vault modeling is getting more and more popular for designing data models of enterprise data warehouses. It is an appropriate method for the integration of multiple data sources in agile data warehouse environments. But for analytical queries, it is not very easy to use. A dimensional model with star schemas is still the better choice for this purpose. But how can we combine these two modeling approaches?
In this presentation, we will show several techniques for how a star schema can be built and loaded on top of a data vault model. As a practical example, we created an Autonomous Data Warehouse for our microbrewery using a data vault model. We will show how the data can be extracted in an easy and efficient way to load dimensions and fact tables. But is this really needed? Is it possible and realistic to access the data directly via views on the data vault tables? Can this be implemented effectively and efficiently with the database features available in the Oracle Cloud?
Tuesday, August 4, 2020 12:00 PM - 1:00 PM EDT
Migrate from HFM to Financial Close and Consolidation Cloud – Now Is the Time!!
Ashwin Tandon and Manav Anand, Infosys
Oracle FCCS application is built using the industry best practices, optimized consolidation engine, and inbuilt efficient business rules for a faster close. It is imperative for most organizations to plan their move from HFM to FCCS now given the benefits it offers without worrying about infrastructure and scalability.
In this session we will share insight from HFM to FCCS migration projects, covering the key features and considerations mentioned below to make your migration from HFM to FCCS streamlined and seamless:
- How key design elements like # of scenarios, historical data, alternate hierarchies, and intercompany setup are key to success
- Migration of master data and using pre-seeded members
- Use out-of-the-box functionalities for retained earnings, CTA, and overrides instead of writing complex business rules
- Understanding optimized fix statement, missing block creation, nested IF statements before creating business rules
- How to improve business rules performance through dynamic block creation, bottom up calculation, and user defined attributes
- Use of substitution variables to improve performance
- Application security: user groups and roles, dimension level security
- Application maintenance for system stability: clear empty blocks, refresh database, restructure, data archival
Thursday, August 6, 2020 12:00 PM - 1:00 PM EDT
Uses of Row Pattern Matching
Kim Berg Hansen, Trivadis
With 12c came the ability to search efficiently for patterns within your rows of data using a syntax similar to searching for character patterns in strings with regular expressions, but instead of searching text, it searches for data patterns.
This is useful for pattern recognition like finding ups and downs in values over time (e.g., stock tickers) or transaction patterns in accounts that may look like fraudulent behavior. But it can also be used for grouping consecutive data, finding gaps, finding or merging overlapping periods, calculating number of children in hierarchical data, and more.
Join me for a discussion of different use cases of row pattern matching.
Tuesday, August 11, 2020 12:00 PM - 1:00 PM EDT
Oracle Fusion ERP Metadata Management and Governance with EPMware
Abhi Nerurkar, EPMware
Join this webinar to learn how to manage, govern, and synchronize Oracle Fusion ERP metadata with enterprise applications.
In this webinar you will learn how this seamless integration can quickly streamline the following:
Managing value sets, and value set hierarchies from a single source
Building real time validation rules
Synchronizing changes between Fusion ERP and cloud/on-prem applications like PBCS, FCCS, and OAC
Deploy and publish hierarchy changes with one click
Tuesday, August 18, 2020 12:00 PM - 1:00 PM EDT
Configuring Financials: What You Click is What You Get!
Ron Moore, Alithya
Out of the box, the EPBCS Financials module “includes a robust, complete chart of accounts to get you up and running quickly.” But what does that actually mean? You implement features by selecting from dozens of options in the Enable Features screens. That triggers creation of outline structures, web forms and business rules. But, how do you know the implications of your selections?
In this webcast we will examine the most significant sections of the Enable Features screens and trace their impact on the resulting Planning artifacts. We will answer the questions, “What happens if I click this?” and, “I need feature X. What do I need to click?”
Thursday, August 20, 2020 12:00 PM - 1:00 PM EDT
Supplemental Data Manager: An Untapped Gem of Close Consolidation!
Mohit Jain and Megha Chopra, Genpact
*This webinar is eligible for one (1) CPE credit for Computer Software & Apps. To receive the credit attendees must be a Full (paid) ODTUG member, attend the entire webinar and answer all poll questions that will pop up on-screen during the webinar, and fill out the evaluation form (with your name) that will be sent out immediately after the webinar.
Are you using a sophisticated financial consolidation system but still collecting supplemental information in Excel? Are there two different systems for the consolidation system and supplemental data?
Attend this exciting session to analyze how FCCS can be used not only as a sophisticated financial consolidation system but also for collecting supplemental data.
By the end of this session attendees will learn:
- Introduction to SDM
- SDM product functionality:
- o Metadata and data integration with FCCS
- o Flexible attribute and dimensions creation and formatting
- o Flexible data set and templates to load data into SDM
- o Data loading and drill down to and from FCCS
- o Data validations and calculations for attributes
- o Configurable frequencies, data collection periods, and workflows
- o Pre-built dashboards to monitor data collection process in FCCS
- o Filling of SDM input form with FCCS number
- o Integration with Smart View
- SDM use case overview and live demo
Program Level: Beginner to Intermediate
Instructional Delivery Method: Group Internet Based
Tuesday, August 25, 2020 12:00 PM - 1:00 PM EDT
Meet A-IOS: Autonomous Inbound/Outbound System
Rodrigo Radtke de Souza and Eduardo Zancanella, Innive, Inc.
Today’s world is all about autonomy. We have autonomous cars, houses, databases and even operational systems. If everything is being automated, what work is left for us? The answer is simple: it’s time for us to build our own robots! We are going to introduce to you the concepts on how to build an A-IOS, which is a set of automated ODI ETL processes that are able to consume any number of inbound interfaces into a data lake and produce any number of outbound results based on a self-service approach driven mostly by data analysts.
This session talks about the necessary steps, starting from the base concepts, going through overall architecture, and finishing with the possible approaches to consume and deliver different kinds of data to final users. We are going to share a use case that is daily ingesting 480+ source data elements and producing 140+ KPI metrics using only two robots created with ODI.
ODI ETL engine serves as a base for our robots as it contains all the knowledge and rules to automatically consume new sources into the data lake. Data analysts can easily produce any number of new KPI information with minimum, or in most cases no, IT intervention, providing them extreme flexibility to change business rules as needed.
Thursday, August 27, 2020 12:00 PM - 1:00 PM EDT
Remote Learning Solution Through Modern Visualization
Grace Peng, Los Angeles Unified School District
*This webinar is eligible for one (1) CPE credit for Computer Software & Apps. To receive the credit attendees must be a Full (paid) ODTUG member, attend the entire webinar, answer all poll questions that will pop up on-screen during the webinar, and fill out the evaluation form (with your name) that will be sent out immediately after the webinar.
Accelerate business insights through data discovery, advanced analytics, and comprehensive visualization delivered through Oracle BI. This session focuses on LAUSD deployment of advanced, customized remote learning dashboards in Whole Child Platform to track key information related to distance learning due to COVID-19 pandemic. These dashboards allow different levels of users to quickly monitor device availability to students as well as login/usage online applications data. Also, to track food distribution and student progress monitoring, information is available over time and by student group.
LAUSD has effectively integrated the analytics to be a part of the operations and not sidelined it as a nice-to-use tool. This is a live demonstration on how we adopted a simplified reporting platform for line-of-business users on key metrics, dazzling visualization, and infographics delivered through BI dashboards to help improve the decision-making process across the organization.
Learning Objective #1: Understand the business analytics use cases and approach to develop a story through extreme visualization
Learning Objective #2: Make data accessible to everyone via simplified visualization to improve transparency and increase productivity
Learning Objective #3: Business process optimization through visual navigations and insights to achieve operational excellence
Program Level: Beginner to Intermediate
Instructional Delivery Method: Group Internet Based
Tuesday, September 15, 2020 12:00 PM - 1:00 PM EDT
Options for Existing Customers of Oracle BI Applications
Myles Gilsenan, Perficient
In 2007, Oracle Business Intelligence (BI) Applications became generally available. They were an immediate success and have enjoyed great popularity ever since. Although they are now considered ‘content complete’, Oracle is committed to supporting this important customer base. Attendees will learn all the options and strategies available to existing customers of Oracle BI Applications, understand key dates for Oracle support, and be provided with practical, implementable guidance for taking the next step with Oracle BI Applications.
Thursday, October 8, 2020 12:00 PM - 1:00 PM EDT
Oracle Enterprise Manager: Seven Robust Features to Put in Action
Rakesh Nagdev, Datavail
Oracle Enterprise Manager (OEM) brings your Oracle deployments together in a single management, monitoring, and automation dashboard. Oracle developed this solution, so it offers deep integration with many of its technologies. The ease of integration, coupled with the support of both on-premise and cloud-based Oracle databases, allows it to fit into many enterprise infrastructures. Oracle Enterprise Manager can also monitor and manage non-Oracle databases, making it a cost-effective and central tool to manage IT environments with a mix of database platforms.
The single point of control is appealing for complex enterprise infrastructures, especially when they’re heavily invested in Oracle technologies. Out-of-the-box monitoring and reporting templates cover many common use cases, and simplifies the configuration of management automation for databases, applications, and more.
This presentation takes on a brief history of OEM and then does a deep dive into seven robust features organizations should consider implementing:
1. Intelligent Incident Compression (Smart Alerting)
2. Chief Job Support
3. Always-ON Monitoring
4. Notification Blackouts
5. System Broadcast
6. Export & Import Incident Rule Sets
7. Metric Enhancements