Program / Agenda

Featuring presentations in:
  • Database Development
  • APEX
  • SQL

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


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

Convert to my timezone

TitleDateStart TimeDurationRegister
Oracle E-Business Suite: Update, Strategy, and Roadmap by Nadia Bendjedou As a current Oracle E-Business Suite customer, you want the confidence that your choice of integrated, global business applications will continue to enable your organization to make better decisions, reduce costs, and increase performance.

In this session, hear from Dr. Nadia Bendjedou as she delivers an update on the Oracle E-Business Suite product line.

Nadia will also discuss the benefits you can expect to receive from both cloud and on-premises E-Business Suite investments.

You will come away with an understanding of the value Oracle E-Business Suite applications deliver now and in the future.
9/11/20208:00am AEDT50 minutes
How ECC dashboards and the world’s fastest EBS reporting solution enhance your user EBS experience by Andy Haack ECC Dashboards – Let us give you a tour of the new "Enterprise Command Centers" (ECC) that Oracle includes free of charge with the 12.2 upgrade.

ECC is a completely integrated dash-board system with more than 23 different dashboards currently available. ECC is designed to help users zero in on day to day decision making data from many EBS modules.

World’s fastest EBS reporting solution – Increase your team efficiency by getting end-user operational reports faster than ever before with modern, easy to use reporting.

This presentation shows how a new approach can provide easier, faster, more efficient access to data in an instantly usable format that end users love.

See how to migrate reports from existing ageing and inefficient EBS reporting tools like Discoverer and BI Publisher.

With the ability to export over one million transactions in less than 10 seconds, and with unlimited data output, it is an option that users of large volumes of data need to see to believe!

This presentation will demonstrate how to navigate several of the ECC dashboards, using live data, (not PowerPoint!) It will also demonstrate Blitz Report™, a reporting option available to EBS operational users looking to manage large volumes of transactional data quickly and efficiently.

The goal is to help users understand when and how to use the ECC dashboards and to also help them assess the value of adding a new transactional reporting solution to their current reporting and analytics tools.
9/11/20209:00am AEDT50 minutes
Cloud Applications – Back to Basics by Debra Lilley Nothing New, but if you are new to Cloud Apps, or looking at them for the first time, this is a whistle stop history trip, how did we get here? What’s different than EBS?

Design Principles, Analytics available, all the things Oracle assume you know

--this session is really popular with technical people who want to get under the covers as to what oracle is doing in their apps--
9/11/202010:00am AEDT50 minutes
More4apps & You – Capitalising on the Cloud by David Wright and Derryn Brenan Get a sneak peek into the future of Cloud ERP with the More4apps latest toolbox.

Learn how to improve your strategic objectives by improving the quality and timeliness of data and power up decision making with accurate information.

Organizations in today's economic climate are looking for more efficient ways to create and update data into Oracle Cloud – they are looking at ways to reduce costs and get the most of their new ERP systems – this 35 minute session shows practical hands-on tips, provides real life examples for early adopters and an opportunity to ask questions from our Product Expert David Wright.

The webinar will provide an overview of the options available for data transfer, manipulation and validation into Oracle ERP Cloud.

Attendees will also get a sneak peak into the exciting road map ahead planned by More4apps.
9/11/202011:00am AEDT50 minutes
OAF Personalizations 2020 – Quick Innovation Wins by Susan Behn It's becoming a tradition…almost every year, I provide new examples for OA Framework personalizations to cover new features in the latest release.

In addition, the questions generated by past presentations on personalizations provide real world problems with personalization solutions beneficial to all users.

Learn how to make the user experience more productive with easy to implement improvements.

Pick that low hanging fruit for quick innovation wins.
9/11/202012:00pm AEDT50 minutes
Modernizing your Oracle applications without upgrading? Yes you can! by Eric Helmer Hate upgrading, but want to modernize your ERP and adjacent technology?

This session is for you.

Come discover options Oracle customers have to use modern Java versions, web browsers, MS Office versions, and even operating systems with virtually any version of ERP.

We will also be talking about modernizing the UX, mobile integration, extracting advanced analytics, and implementing future-proofing modern security techniques on any ERP version – all with a fraction of the costs and efforts associated with disruptive patching or expensive upgrades.
9/11/20201:30pm AEDT50 minutes
Reconcile Your Inventory to G/L Balances With Ease, From 1 to 1,000 Inventory Organizations! by Douglas Volz This presentation will help any organization that carries Inventory, and struggles with the monthly inventory reconciliation, regardless of how many Inventory Orgs they support.

In this session, we will cover the do's and don'ts that ensure a smooth and balanced Inventory Reconciliation process, including:
General Reconciliation Principles Standard Reconciliation Steps Common Reconciliation Challenges Custom Solutions
9/11/20202:30pm AEDT50 minutes
Oracle EBS 2020: Transform Your End-User Experiences (UX) by Mia Urman Looks DO matter, and today’s users are fed up with the look and feel of their tired, old Oracle EBS systems.

We know these applications are getting the job done, however, they are in DESPERATE need of a makeover.

In this session, you will learn how to leverage the power of Oracle’s next generation development tools – VBCS, Oracle Digital Assistant Cloud and RPA automation to reface your EBS applications and bring them into the next generation.

Oracle’s cloud-based tools enable you (and your business users) to create rich web and mobile and chat applications from any browser, quickly and efficiently.

This session will help you learn from the successes of others with tips and tricks, live demos, and details on architecture design and security.

Participants will be able to take their first steps towards transforming their Oracle EBS user experiences using Oracle’s next-generation development tools.

In this session, you will learn the following: Learn UI / UX modernization strategies to have your system enter 2020 with a bang Learn how to structure a hybrid application through tips and tricks and live demos.

Learn about the features and benefits of Oracle’s next-generation toolsets Learn how to leverage existing systems and modernize using VBCS, Chat, and RPA.
9/11/20203:30pm AEDT50 minutes
Web Service based Integrations with Oracle E-Business Suite by Rekha Ayothi Application connectivity and integration options are critical for every application in the software industry.

Oracle E-Business Suite provides various tools and technologies to address application integration challenges.

Web service based integrations play a key role in Cloud, Mobile and SOA integration use cases.

In this session, gain a deep understanding about Integrated SOA Gateway and its rich capabilities to provide APIs as REST and SOAP based web services.

Hear about the new features and enhancements available with the recent Oracle E-Business Suite Integrated SOA Gateway release.

Explore how you can leverage Oracle E-Business Suite web services for cloud based integrations and modern use cases to accelerate digital transformation.
9/11/20204:30pm AEDT50 minutes
Building Successful Applications on the Autonomous Database by Connor McDonald Well done!
You’ve come up with the killer idea for 2021.

You’ve got the best UI design anyone has ever seen! Your modern application ticks all the boxes — serverless, functional, Kubernetes, microservices, API-based, the list goes on.

It runs on every OS and every type of device. But unfortunately, all of this counts for absolutely NOTHING if your data access is slow or buggy.

But an Autonomous database will fix all that right?

Only if you understand the fundamentals of how SQL is processed by the database.

For novice developers, SQL can be hard to understand and sometimes totally hidden from view under an ORM.

Let’s peel back the covers to show how SQL is processed, how to avoid getting hacked, and how to get data back to your application in a snappy fashion.

10/11/202010:00am AEDT50 minutes
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
I am paying for my Cloud License. What's next? by Alecsandra Mlynarzek Oracle launched in 2019 the Enterprise Licensing model, a bundle that includes by default Profitability and Cost Management.

We often pay for services/subscriptions that we never really use, but not because of their lack of usefulness, but rather a lack of knowledge on our part.

This presentation will kick off with an overview of the different types of business problems that can be solved by Profitability and Cost Management, based on real-life implementations, followed by a short demo of how to quickly get up to speed with Profitability and Cost Management and where to start using this service that now comes included with your subscription.

This session is ideal for both customers and implementation partners who have not yet embarked on the journey of discovering how dynamic Profitability and Cost Management really is.
11/11/202010:00am AEDT50 minutes
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
Oracle Analytics and Dashboards OOTB with Fusion Analytics Warehouse (formerly OAX) by Paul Vella & Reshma Shinde This session will include:

What is OAX?
How is it deployed?
What does it include?
How can it be customised?
11/11/20205:30pm AEDT50 minutes
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
Program will be announced shortly. 


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.

Oracle ace

Oracle Ace

Oracle Ace Director

Oracle Ace Director

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.