SAVE THE DATE  : 11th November 2020

Program / Agenda

Featuring presentations in:
  • Oracle E-Business Suite
  • ERP Tools
  • EPM
  • Analytics

Sessions of the conference will be recorded and the sessions will be available to AUSOUG members to access after the conference.


Registration for Virtual Connect 2020 is now OPEN, with more at least 35 sessions over 4 streams.

Register NOW by clicking on the ‘Register’ button next to each session.

Registration for Development / APEX Day Series – 10th November 2020

Convert to my timezone

TitleDateStart TimeDurationRegister
Improving performance of your APEX application Abstract by Anderson Ferreira This session will walk through some performance problems extracted from real world APEX applications.

It will be a practice presentation that will show slow pages and the techniques that solve the issue.

It will be presented some basic concepts and some ways to improve the performance of a lot of APEX components like pages, authorizations, reports and forms.
10/11/202011:00am AEDT50 minutes
Voyage to Visual Builder Studio by Karen Cannell Hear lessons learned on a voyage to Visual Builder Studio, Oracle’s updated visual application development environment.

Visual Builder Studio allows one to build web and mobile applications, extend Oracle cloud applications, and manage the full development life cycle as part of the development process.

Sounds great – but how does it really work? What is the difference between Visual Builder Studio and Visual Builder?

When do I use one vs. the other? How hard is it to get started?

How hard is it build a real production application?

How hard is it to extend my cloud applications?

Do I have to be a JavaScript expert?

What investment – time, money, learning - is required to be productive?

Was this voyage worth the effort?

Can Visual Builder Studio make a difference for one's Oracle cloud investment?

Attend and learn about a long-time Oracle APEX developer’s continued adventure into Visual Builder development, now through Visual Builder
10/11/202012:00pm AEDT50 minutes
MySQL Database Service (MDS) overview and migration from on-prem by Ronen Baram During this session you will get a sneak peak into the brand new MySQL Database Service (MDS), which is MySQL fully-managed service.

You will also get to see, in live demo, how easy it is to migrate your data from on-prem, or even another cloud services (such as RDS, Aurora and such) to MDS using the new dumpSchema utility.
10/11/20201:30pm AEDT50 minutes
A Gentle Introduction to Polymorphic Table Functions by Patrick Barel Oracle database 18c introduces Polymorphic Table Functions.

This session will tell you about Polymorphism.

How can you apply this in pre-18c databases?

I will show you what problem and the solution when your data or structure changes.

I will also show you an example of a Polymorphic Table Function and how this can help protect you from changing table structures and how you can apply the same code to different table structures without changing or even recompiling the code.

After this session you will understand when to use which technique.
10/11/20202:30pm AEDT50 minutes
But that worked yesterday! Testing with utPLSQL by Samuel Nitsche It is a period of war and you, a developer of the imperial army, took over responsibility for a database application.

Things are getting bad when a mighty Sith-Lord requests a last-minute change…

- Practical advice based on a sample-project in a Star Wars setting how to introduce self-testing with the free open source framework utPLSQL v3:
- Why your code and project benefits from automated tests
- Demonstration of techniques and strategies to get your existing (legacy-)projects tested
- Examples for meaning- and useful tests and mistakes you should watch out for
- Thoughts on the testing "mindset"
- Presentation of features utPLSQL provides to help you develop reliable automated self-tests
10/11/20203:30pm AEDT50 minutes
APEX and automated testing - CYPRESS by Lino Schildenfeld "The web has evolved. Finally, testing has too. Fast, easy and reliable testing for anything that runs in a browser."

We build apps but we all struggle with testing.

How hard can it be to get automated UI testing going?

Join me for this session where we will get insight how difficult it is to incorporate openSource tool like into your everyday development life cycles.

Aimed at audience of all levels
10/11/20204:30pm AEDT50 minutes
When to use Plug-ins in APEX (and when not to) By Peter Raganitsch The first thing that comes mind when talking about plug-ins in APEX is cool new features.

Things that can't be done in APEX without “that" particular plug-in.

But there are more good reasons to use plug-ins like re-usability, centralization, enabling less skilled developers to re-use a solution, and so on.

This short session is all about the different aspects you should think about when developing APEX applications, because there are more use cases for plug-ins than you might think.

Not to mention several things you should also be wary of.

We will then finish with some best practices on usage of plug-ins in bigger teams.
10/11/20205:30pm AEDT50 minutes
Boost your Application Capabilities with Supported Open Source Plug-ins by Matt Nolan Did you know you can develop event faster in APEX?

There are a set of free professional plug-ins that plug the functionality gaps in your APEX application.

Things like:
- Refreshing Static Content
- Refreshing PLSQL Content
- Downloading Files with Zip Support
- Resizable Responsive Regions using Splitters
- Executing PL/SQL and performing client-side actions
- Showing Notifications and Messages
- Timing your Actions using Debounce, Throttle, Delays, and Repetitions
- Put conditions between your actions for IF/THEN/ELSE capability
- Easily Process Interactive Grid Selections and add buttons

In this session we will show you just how easy these plug-ins are to use, and the benefits they provide to increase your solution capabilities.
10/11/20206:30pm AEDT50 minutes
Pushing the Limits at TDK InvenSense: setting Workforce and Sales Planning to Auto-Pilot by Matthias Heilos Organizations are expanding the use of their Enterprise Planning (EPBCS/PBCS) applications across various departments and business processes like Workforce and Sales Planning.

The source data is coming from HR and CRM systems which contain very delicate information: HR systems store sensitive data about their employees, CRM systems track the pipeline for sales revenue.

One the one hand, managing flat files poses security risks.

On the other hand, there are frequent metadata changes to capture new or changed employees/positions as well as customers/opportunities/sales organizations.

In this session we are going to discuss how workforce and sales planning applications can be fully automated and which challenges need to be overcome.
11/11/202012:00pm AEDT50 minutes

Registrations for Applications / EPM And Analytics Summit – 11th November 2020

Convert to my timezone

TitleDateStart TimeDurationRegister
A Logical Approach to Oracle EPM Security by Jake Turrell As an EPM Solution Architect, I am often asked to perform "Health Checks" on my clients' Planning and Budgeting applications.

These health checks focus on performance, usability, data integrity, automation, governance and the overall maintainability of the application.

Having performed a number of these Health Checks, one of the most common deficiencies that I uncover is related to security.

With enough time, and enough cooks in the kitchen, all security schemes seem to deteriorate into a mess of confusion and conflicting assignments.

This presentation will walk users through a common-sense approach to security design within Oracle's EPM solutions.

It will illustrate how administrators can lower maintenance, simplify debugging, and avoid common pitfalls.
11/11/202011:00am AEDT50 minutes
Pushing the Limits at TDK InvenSense: setting Workforce and Sales Planning to Auto-Pilot by Matthias Heilos Organizations are expanding the use of their Enterprise Planning (EPBCS/PBCS) applications across various departments and business processes like Workforce and Sales Planning.

The source data is coming from HR and CRM systems which contain very delicate information: HR systems store sensitive data about their employees, CRM systems track the pipeline for sales revenue.

One the one hand, managing flat files poses security risks.

On the other hand, there are frequent metadata changes to capture new or changed employees/positions as well as customers/opportunities/sales organizations.

In this session we are going to discuss how workforce and sales planning applications can be fully automated and which challenges need to be overcome.
11/11/202012:00pm AEDT50 minutes
The Force is Strong with Enterprise Reporting and Data Analytics by Ahmed Hafez A new dawn is upon us where Data is the world’s most valuable commodity! In fact, concepts like Enterprise Reporting, Data Analytics, Machine Learning and AI are all hot topics for modern business leadership, with the biggest question being:
how can my data work for me? Recognizing this, organizations are in a race to become data driven. Simply put, this is about making informed and timely decisions and unlocking possibilities based on having access to valuable insights.

Oracle Narrative Reporting, Oracle Analytics and Autonomous Data Warehouse are front and centre of this new dawn for Oracle.

The reality is every organization will be at a different stage in their journey to become data driven;
by adopting Oracle technology and the appropriate digital transformation plan, you are able to maximize success on this journey.

This session will cover:
• Measuring your Reporting and Analytics maturity
• Understanding the Reporting Pyramid
• The difference between manual and automated reporting processes
11/11/20201:30pm AEDT50 minutes
So, You want to be a Data Scientist (Or Understand What One Does)! by Andrew Preston The Harvard Business Review said that Data Scientist “The Sexiest Job of the 21st Century“.

Are you confused as to what is Data Science, if so you are in good company because even among data scientists there is confusion.

This talk will provide a basic overview of data science principals, for those wishing to become a data scientist, or just those who wish to understand what a Data Scientist does and how to start down the road to either become a data scientist or enable you to deal with one.

We will also cover the data science team, data traps, and why failing can be beneficial.
11/11/20202:30pm AEDT50 minutes
Changing face of Integrations in EPM by Navan Mehra Transitioning to the cloud is both a strategic priority, but also a strategic risk for many companies.

With investments over the years in a combination of both on-premises and cloud technologies, any new EPM tool will require a hybrid approach to data management – where sourcing metadata and data from multiple sources is the norm, not the exception.

EPM Cloud and the new features contained with the EPM Integration agent are a great step forward in delivering that new reality.

This session explores various options available to make these integrations flexible and powerful with tips and tricks around the following topics:
• Integrating on-premise systems using Integration Agent
• Integrating cloud systems using the integration agent
• Marrying Groovy and Data Management to deliver robust and reliable solutions
• On-demand data load from sources – real-time data for your clients By the end of the session, you’ll have all the information to convert Data Management into a true Data Hub.
11/11/20203:30pm AEDT50 minutes
Predicting Good Wines in the Database with Oracle Machine Learning & Oracle analytics Cloud by Francesco Tisiot, Brendan Tierney Oracle Machine Learning includes a set of tools enabling data scientist to create production ready Machine Learning models close to where the data sits: the database!

The presentation and demo shows a full data science process: from the creation of an Autonomous Data Warehouse in the cloud in few clicks, the data upload, the creation of a deeply customisable Machine Learning model via notebooks available immediately with ADW which enable also the the visual data exploration.

Few PL/SQL calls will create the ML model which will then be used to create predictions on the fly.

The model itself and the results generated will be visualised in Oracle Analytics Cloud showing how easy is the Business Analyst - Data Scientist collaboration within the Oracle ecosystem.

So, sit back, grab a glass and learn some practical and fun Oracle tech tips.
11/11/20204:30pm AEDT50 minutes

Registration for Database / Cloud Day – 12th November 2020

Convert to my timezone

TitleDateStart TimeDurationRegister
Database 12c to 20c, Journey of key feature sets by Anuj Mohan This presentation will look at 12c to 20c new features that should be investigated for use which include Multitenant, IN-Memory and Oracle 19c Automatic Indexing and many more.

I will discuss the 12c to 20c Journey for these new features with examples and sample code.

Attendees can expect brief introduction of all the new features with deep dive into Multitenant, INMemory and Automatic Indexing
12/11/202010:00am AEDT50 minutes
Creating Order in the Database Patching Chaos by Liron Amitzi Have you ever found yourself staring at a list of patches and wondering what to do? What patch should I install?

What are the risks?

Is there anything I should do after the patch?

This becomes even more stressful in a complex environment: How to install patches on RAC?

What about standby databases?

This session will try to put things in order and help create a roadmap for patching databases.

We will discuss the different types of patches (RU, RUR, DBBP, PSU, OJVM, One-off), installation will discuss the different types of patches (RU, RUR, DBBP, PSU, OJVM, One-off), installation types (RAC rolling patches, standby first patches), known issues and where to find them, and how to plan the patch installation in order to have as few surprises as possible.
12/11/202011:00am AEDT50 minutes
Achieving Extreme Scalability &Total Fault Isolation with Oracle Sharding by Kai Yu Oracle Sharding was further improved in 18c/19c for linear scalability and complete fault isolation of OLTP workloads.

With Oracle sharding Data are partitioned horizontally partitioned across discrete Oracle Databases (shards) in shared-nothing architecture that collectively form a single logical database.

Come to this session to learn its latest improvements in Oracle 19c and 20c, sharding on database cloud(DBCS) and leveraging sharding for your business.

We will share the experience and tips of configuring sharded database architecture with HA replication for massive scalability and complete fault isolation.

We will also discuss some of considerations of choosing sharding method in a global geographic distribution application and the experience of using Sharing Advisor.

We will also discuss some new sharding features that are coming in Oracle 20c such as Federated Sharding and sharding with database in Persistent memory.
12/11/202012:00pm AEDT50 minutes
DBA 3.0: The Next Evolution by Charles Kim Discussions will include how technical enhancements to autonomous databases, cloud innovations and what you must learn to survive, how AI and machine learning can impact the database scene and understanding which technologies you need to learn to adapt.

In this session, you will learn:
• what is important in the database industry
• how to generate your “OpEx Value” in an era where everything is about the bottom line
• how to understand how business knowledge plays in the DBA role
• how to innovate and win with Oracle Cloud, Azure and AWS
• the value of the heterogeneous DBA
• the critical role of the data driven DBA
• the impact of autonomous in the DBA world
• what relevance DBAs have in the autonomous world and how we can adapt
• how does the pluggable DBAs have relevance?
• why is the Cloud database administration worth while for me to learn
12/11/20201:30pm AEDT50 minutes
Optimizer Statistics: The Key To Efficient, Scalable Databases and Applications by Richard Foote One of the more common reasons why SQL statements run inefficiently is due to poor execution plans as a result of optimizer segment statistics that are either missing, inaccurate, incomplete, misleading or potentially too accurate for its own good.

In this presentation we examine a number scenarios where SQL execution plans are inefficient due to deficiencies in the underlining segment statistics, how they can be addressed with appropriate statistics gathering processes and how more recent statistics gathering features and capabilities such as adaptive statistics, real-time statistics and high frequency statistics gathering can assist in enabling a more stable and performant database environment.
12/11/20202:30pm AEDT50 minutes
Turbocharge Performance with Oracle 19c In-Memory Database by Gavin Soorma This session will be entirely a live hands-on demo and will enable attendees to experience under the hood all the exciting new In-Memory features introduced in Oracle database 19c as well as cover all the main features since the product was introduced in Oracle 12c.
12/11/20203:30pm AEDT50 minutes
Hybrid Cloud with Oracle Linux KVM by Simon Coter Backed by affordable enterprise support for hybrid environments, Oracle Virtualization reduces operation and support costs while increasing IT efficiency and agility—on premises and in the cloud.

Oracle Linux KVM is the same hypervisor used in Oracle Cloud and today can be also leveraged to run on-premises workload.

The introduction of Oracle Linux Virtualization Manager, built for OSS oVirt, allows to run same hypevisor, on-premises and on-cloud, managed by one unique web management interface; unique advantages of the solution are:
Open source optimized by Oracle hypervisor, Simplified management with Oracle Linux Virtualization Manager, Designed for hybrid cloud, Easy to move VMs to cloud, Security updates without rebooting and Hard partitioning for Oracle Software.

Oracle Linux Templates as well as Oracle Database templates, built for Oracle Linux KVM, allows to automate and speed-up the deployment of your services; automation, built on cloud-init, allows to automate any configuration option as well as add custom command execution on the first boot of your Virtual Machines.

Many more options and tools dedicated to migration (from legacy hypervisor to KVM), backup and best practices will be shared during the session.
12/11/20204:30pm AEDT50 minutes
Comparing Postgres to Oracle by Jan Karremans There is a lot of disruption going on at present time.

These changes range from "the adoption to big data", through “migration to the cloud” and focus shifts within businesses.

Creating opportunities to explore and adopt all these changes are important.

Renewal of legacy systems and opportunities to build new applications, are important but can be very expensive.

Using a smart alternative data platform can help you out.

In this session you will see the possibilities of PostgreSQL in the EnterpriseDB Postgres Server edition.

You will be able to asses if this platform is the right alternative for you to disrupt your operation and open doors to new success.
12/11/20205:30pm AEDT50 minutes
Oracle on Azure: An Overview by Osama Mustafa In this interactive session see why Azure is a great cloud to run Oracle Databases and applications.

You can confidently use Oracle Database supported by Oracle and certified by Oracle to run on Azure.

Rely on field-tested reference architectures that can accelerate your deployment times while reducing risks. Build and deploy cloud native enterprise-class Java applications on Oracle WebLogic Server in Azure and on Oracle Linux.

The session also explores in detail some of the lessons learned regarding Microsoft Azure and Oracle’s cloud interoperability based on early customer deployments and use cases
12/11/20206:30pm AEDT50 minutes


Are you interested in becoming a sponsor for this event? 


Thank you to all the following speakers, from within Australia and around the globe, who have kindly submitted their papers for Virtual Connect 2020.

Virtual Connect Day 2 – Applications/EPM and Analytics Summit

Practice Manager, Oracle Analytics Cloud


EPM Solution Architect

ODTUG / Turrell Consulting, LLC

Director – EPM & Analytics Solutions

DXC Red Rock

Oracle Ace Associate Full
Oracle ace alumni

Oracle Ace Alumni

AUSOUG reserves the right to change speakers, events and/or session times, dates, prices and other details as deemed necessary.