Click on the respective sessions to view the recording

Connect 2022 Oracle E-Business Suite/Cloud Applications Recordings- 7/11/2022

This recording is available for until 7th February 2023 to everyone, and will only be available to AUSOUG members after this date


EBS – Rumours of my death are greatly exaggerated – why many are staying and that’s OK by Debra Lilley

EBS is not dead, nor are you compelled to move from it.

But is Oracle just protecting support revenue or is there real innovation in EBS.

Understand why staying may be right for your organization and what can you do to protect and gain more from your investment.


Oracle E-Business Suite: Update, Strategy, and Roadmap by Jyotideep Singh

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 Jyotideep Singh (JD) as he delivers an update on the Oracle E-Business Suite product line.

JD 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. 


A Guide to Developing Oracle SaaS Extension by Shay Shmeltzer

Looking to build new user solutions that integrate with Oracle SaaS?

We show you how to quickly and easily create such extensions using Oracle Visual Builder.

Visual Builder Studio, which is now included with Oracle Fusion Cloud Apps, lets you build new user experiences on top of Oracle SaaS data in a visual way.

Watch as we demonstrate building cloud extensions leveraging Oracle SaaS service catalog, Oracle Redwood UI patterns, and an intuitive development approach.


Connect Your Team to Powerful Financial Reporting for Oracle ERP Cloud by Sean Chandler and Tim Miller

To get the most out of your technology investment and ensure a smooth migration to Oracle ERP Cloud, you’ll need to provide your finance teams with the tools they need to succeed.

Oracle’s native options may burden your team with inflexible in-built reports, painful drill downs, manually intensive processes, and an over-reliance on reliant on IT.

Without the right solution, you could be faced with longer reporting cycles, lower productivity, and less time to focus on critical analysis.
In this session, we’ll introduce you to purpose-built software that empowers your team with smooth, fast, flexible, Excel-based financial and operational reporting.

We’ll help solve your current and future reporting challenges and give you strategies to optimise and future-proof your investment of Oracle ERP Cloud with sustainable, powerful, finance-centric tools.

This session will cover:
• Oracle ERP Cloud native reporting options and why they don’t offer meaningful solutions for finance teams.
• Easing your migration to Oracle ERP Cloud by porting existing reports, simplifying and de-risking data validation, and providing continuity for your business processes.
• Satisfying your reporting needs by connecting Oracle ERP Cloud to Excel in near real time, giving your finance team control of reporting and empowering deeper analysis.
• Real customer stories and powerful lessons our clients learnt on their journey to optimized financial reporting in Oracle ERP Cloud.


The Cotton On Implementation Story: How Oracle HCM Cloud enabled Cotton On to globalise their business by Richard Atkins

Cotton On are Australia’s largest global retailer, with over 22,000 employees across 18 countries. 

Cotton On Group consists of 7 brands: Cotton On Clothing, Cotton On Kids, Cotton On Body, Typo, Supre, Factorie and Rubi and their Headquarters are just outside Melbourne, Australia.

In 2019 Cotton On engaged in an ambitious programme of work to replace their disparate ageing HR systems with a single global HR Solution supported by a standard global set of processes.

Cotton On selected Oracle HCM Cloud as the solution to deliver their vision of globalisation and KPMG as their implementation partner.

This is the story of how, over a two year period, Cotton On globalised their HR processes, reduced their recruitment costs and elevated the end user experience using Oracle HCM Cloud.

The session will provide an overview of the approach taken, the challenges encountered, the triumphs achieved and the lessons learned from a cloud implementation of Oracle HCM.


Panel Discussion: Best of breed Applications vs one Cloud Solution. What is practical and what is not by Anita Parer

Anita Parer, ex Oracle Consulting Director, Customer Success Director and now Founder and CEO of Kyte Consulting, is inviting industry experts to debate pros and cons of best breed solutions vs one stack approach in the light of total cost of ownership, solution architecture, increasing cyber security threats, vendor dependency and amongst other points.

Panelists include

- John Perusco / DXC Practice for Oracle / DXC Technology

- Atay Erginay / Director Oracle Consulting / Deloitte Australia

- Brendan Cox / Sales Consulting Director / Oracle Australia

The discussion is followed by a presentation from Oracle’s Sales Consulting Director Brendan Cox on the Oracle’s vision of the Fusion Application stack.


Can you keep a secret? Fusion Cloud ERP - What they don’t tell you and what we’ve discovered! by Stu Keast and Nigel Grange

With over 22 years of experience, More4apps has spent a long time learning the ins and outs of Oracle. Now we’d like to share some of the key secrets (ssshhhh) discovered during our data integration journey in Fusion ERP Cloud.

Hear about the quirks and interesting details we have found that no one will tell you unless you ask. Our experts know the challenges you face within Fusion and are ready to share what they have stumbled over while building our Excel integration modules. In this session we will explore:

Learn more about the gaps with Oracle’s Fusion ERP Cloud spreadsheet integrations

We are getting great results from Oracle support, see our example with horizontal time-phased planning for Project Budgets and forecasts

Excel Integration - improving data quality with multiple documents all within one worksheet.


Move, Modernize and Innovate your E-Business Suite with Oracle Cloud Infrastructure (OCI) by Sharad Bansal

Oracle E-Business Suite is a powerful Enterprise Application that delivers tremendous value to organizations around the world.

That value can be greatly extended when coupling it with Oracle Cloud Infrastructure offerings delivered by Oracle Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS).

The purpose of this session is to understand the value proposition, migration accelerators, the solutions offered and the use cases for Oracle E-Business Suite customers to move and deploy their environments on Oracle Cloud Infrastructure (IaaS and PaaS) which results in benefits such as improved performance, lower TCO, better security, agility and pathways to innovation.


Oracle Service Logistics enabled with OFS and Service Cloud by Jeffry Husman

Connects CX customer service, field service and supply chain processes.

A holistic asset and service contract management approach using Oracle B2B Service for Service Request creation, Oracle Service Logistics for Parts Ordering, Debrief and Billing and Oracle Field Service for Field Service Execution.


Integration Options for On-Premise and the Cloud with Oracle E-Business Suite by Rekha Ayothi

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

In this session, learn more about Oracle’s integration offering for cloud, data, event-driven, and process-centric integrations.

Gain a better understanding of Oracle integration technologies and how, when, and where you can leverage them to connect end-to-end business processes across your enterprise, including the Oracle applications portfolio in the cloud.

Presentation Objective 1

Learn about Oracle’s offerings for cloud, data-centric and event-driven integrations with Oracle E-Business Suite

Presentation Objective 2

Learn about Oracle’s offerings for web service based integrations with Oracle E-Business Suite

Presentation Objective 3

Learn how to use Oracle E-Business Suite Adapter in Oracle Integration Cloud for various integration scenarios


Development/APEX Day Recordings- 8/11/2022

This recording is available for until 8th February 2023 to everyone, and will only be available to AUSOUG members after this date


Oracle APEX 22.2: New Features by Marc Sewtz  

Oracle APEX Application Development 22.2 introduces several new features and many enhancements to existing functionality.

The new workflow approval component allows developers to easily integrate task management into their APEX applications.

Further enhancements to progressive web apps (PWAs) enable a more native mobile user experience for end users.

The new application search functionality provides declarative search functionality and a new “Invoke API” process type enables developers to easily map stored procedures to APEX form items.

We’ll share a comprehensive overview of the features introduced with this release and will include several demonstrations of our new capabilities


Crimes Against SQL by Chris Saxon 

Oracle Autonomous Database includes many tools to self-optimize slow-running SQL statements.

But no matter how good the database gets, there are many SQL anti-patterns that will lead to slow applications.

This session covers three of the worst offenders: concatenating user input into statements, placing SQL inside loops, and accessing the same table many times in one query.

Join this talk to learn why these lead to slow data access and how using PL/SQL helps you avoid these problems to build better, faster, more secure data-driven application


Presentation Slides - Crimes Against SQL by Chris Saxon

Oracle Autonomous Database includes many tools to self-optimize slow-running SQL statements.

But no matter how good the database gets, there are many SQL anti-patterns that will lead to slow applications.

This session covers three of the worst offenders: concatenating user input into statements, placing SQL inside loops, and accessing the same table many times in one query.

Join this talk to learn why these lead to slow data access and how using PL/SQL helps you avoid these problems to build better, faster, more secure data-driven application






Python and Oracle Database: a new Thin driver with easy installation and fast data access by Christopher Jones

This year’s major update to the Python driver for Oracle Database introduced a new name: python-oracledb.

But more importantly, it now has a ‘Thin’ mode that dramatically simplifies installation.

The updated driver is much smaller and faster. What’s new and how to use the new Thin mode and traditional Thick mode will be shown in this session.

See how to use the driver’s standard Python DB API. Also, learn how Oracle Database’s unique features will let you build scalable and reliable applications.

This talk focuses on using the API directly from Python code, but it also shows basic examples of common Python frameworks and ORMs.

Whether you are doing data analysis, building websites and microservices, or creating management and monitoring scripts, python-oracledb is an easy-to-use and efficient driver you should know how to use.


Becoming a Swan: Using APEX and VBCS to Build a New UX for Oracle EBS by Mia Urman

Today’s users want their Oracle EBS Systems to reflect modern UX expectations while preserving functionality.

In this session, you will learn how to leverage the power of Oracle’s next generation development tools - APEX and Visual Builder (VBCS), to reface your Oracle EBS applications and bring them from out-dated to next-generation.

Enabling users to create rich web/mobile apps from any browser, using drag and drop visual development tool. This session includes a live demo and customer case study.


Charge Me Up! Using Oracle ML, Analytics, and APEX For Finding Optimal Charge Points by Jim Czuprynski

You’re running late for the final 45-minute interview for your new developer position, your brand-new EV’s battery is down to 15%, and if you don’t pick up your five-year-old at daycare on time today,

it’ll cost you big time. So where’s the closest charging point? And why the heck did they put it over there?

This session will take a look at new realities that Smart Cities and the coming re-electrification movement will bring to our world as we transition to EVs.

I’ll show how Oracle technology – including Machine Learning, Analytics, and APEX – can be deployed to determine optimal placement of charging stations based on publicly-available data, as well as provide users the capability to quickly locate the closest and best charge point for their needs at the time.


Who’s Who in APEX by Adrian Png

A modular approach to authentication and authorization is one of the key features that makes Oracle Application Express (APEX), a great platform for developing web applications.

In this session, we will explore the fundamentals and mechanics of identifying and managing access to APEX applications and components.

Learn how we can either use pre-built or custom authentication schemes that take advantage of modern frameworks like OAuth2, SAML2, WebAuthn, Two-Factor Authentication and more


Leverage your internal processes using REST Synchronization and Automations by Andreea Munteanu

As a developer, you may encounter a lot of use cases where you need to manipulate and analyze external data sources.

How you do it in an easy way and centralize it in a single application?

Well, using REST features and automations in APEX has never been simpler.

Following the latest releases of APEX, handling REST APIs and automate processes based on them reduces complexity and your app becomes your single point of truth.

We will have a closer look on a Jira Service Desk integration with Oracle APEX, a way to keep track of the tickets for your specific projects.
A detailed walk-through the REST endpoints along with building automated processes to support the data analysis will be covered in the session.

As a low-code platform, APEX helps developers use features like REST Synchronization and Automations in a declaratively manner, however, another option is also using APEX APIs.

Examples on how to use their respective APEX APIs will be provided as well as tips to handle potential errors.


Using ORDS, REST webservices, PL/SQL and OAuth2 to Build, Deploy and Secure an API by Niall Mc Phillips

In this presentation, through building practical examples, attendees will learn how to build a secured REST API to enable searching on their application.

The resulting technology-independent REST API will be usable by both Oracle and by non-Oracle environments alike.

Topics to be covered include:
- an architectural overview of the creation of ORDS web services in PL/SQL
- setting up ORDS for your database schema
- defining the search API in PL/SQL
- creating ORDS module and templates for the API
- management of HTTP return statuses and result pages pagination
- securing the API via OAuth2 using ORDS clients, privileges and roles.


Mastering sending template based emails in APEX by Dimitri Gielis

Your application can send rich HTML emails using the email templates defined in Shared Components - Email template.

This session will cover the declarative and programmatic options you have to create stunning personalized emails straight from APEX and PL/SQL.

Many demos will show how to send emails to a group of people from using simple to complex email templates with tabular data.

We will even include some customized PDFs as attachments by combining email templates with AOP.


Big Data/Analytics/Security/EPM & BI Summit Recordings 9/11/2022

This recording is available for until 9th February 2023 to everyone, and will only be available to AUSOUG members after this date


AI/ML To The Rescue: How IT Operations Got Out Of A Monitoring Mess by Craig Shallahamer

Key business SLA objectives were not being met. IT Operations was stuck in the middle of declining service levels, a tight labor force, and IT needed to be better aligned with business goals.

To be better aligned, the IT Operations capacity had to be increased by reducing costs of both IT and business operations. More specifically, IT Operations needed to better detect problem trends and unusual activity across all their Oracle systems. False alerts were a real problem wasting employee time and energy. A solid operations picture required Oracle’s Active Workload Repository data for near real-time analysis, in conjunction with machine learning and AI 

Join us for a key business goals-focused perspective into how a business problem was solved using a variety of Oracle products, machine learning and AI.


Oracle In-database Machine Learning with OML4SQL/OML4Py in Oracle Autonomous Databases by Kai Yu

As next generation enterprise applications are more data driven and more intelligent, advanced analytics and machine Learning bring great business value.

Oracle In-Database machine learning moves the algorithms to database where the data is stored.

In this session, we will discuss how Oracle In-database machine learning is provided in Oracle Database including Oracle Autonomous Database with scalability, simplicity and high performance.

We will discuss how to build, evaluate and deploys machine learning models natively with large enterprise data using Oracle Machine Learning for SQL(OML4SQL) and Oracle Machine Learning for Python (OML4Py).

This session will take some use cases as examples to show the process of machine learning: analyze and prepare data set; build and evaluate and apply machine learning model with Oracle Autonomous Databases environment.

Some Oracle 21c new features such as AutoML will also be discussed.


Securing Workloads in Oracle Cloud Infrastructure - “A Hackers Perspective” by Scott Fletcher

Cloud adoption has grown rapidly and accelerated as a result of recent global events. Organisations are increasingly looking to the cloud to drive innovation, improve scalability, performance, and reduce overall operational costs. As a result over 98% of organisations are using some form of cloud infrastructure to run critical application workloads, store and process sensitive company and user data.

Cloud environments differ significantly from on-premises data centers. Traditional security methodologies often don’t translate nicely into the cloud, and the combination of these challenges can often be seen as a barrier to fully realising the potential of cloud-first strategies. Understanding and solving these challenges is critical to preventing security incidents and overall long-term success.

Sun Tzu aptly said “If you know the enemy and know yourself, you need not fear the result of a hundred battles”. As a Cloud Security Engineer and Ethical Hacker I’ll share the learnings from my involvement with cloud migrations, and pragmatic advice on how organisations can protect themselves from adversaries.


Defence against the Dark Arts – Spell’s for DBA’s to secure databases by Aishwarya Kala

The spell has been cast, and the evil forces are lurking in the shadows, but are you ready for a fight? 

Hop on to join Dumbledore’s DB Army as we learn to brew our security potions, practice database safety duels & put on our kevlar.

In this era of “cyber-espionage”, where network security steals the prime focus on every organization, database security is often overlooked. 

Like in any battle, let’s spend some time & understanding the battlefield and common database vulnerabilities. 

During this session, we will look at some elementary instruments, e.g. listeners, security patches, database roles, privileges, users, and audits- that a DBA can use to build a strong shield around the databases. 

Along with this, we will glance at various tools that can be leveraged to assess & detect threats. Let us also explore best practices that can help us conduct forensics in case of an incident. 

So, if you want to learn the various “low-hanging fruits” that can give you a quick win or delve into more complex solutions, this session is most certainly for you


Unlock the mystery out of building profitability model by EPM cloud Profitability & Cost Management by Mohit Jain and Megha Gupta

Every organization is challenged with improving product and customer profitability. To maximize profitability, a business must be able to accurately measure, allocate, and manage costs and revenue.

Profitability and Cost Management is an analytic tool which help organizations to create allocation model to achieve this. It enables cost decomposition, consumption-based costing and scenario-playing to measure profitability. Session will include Live demo of application. By the end of this session attendees will learn:

· Creation of Application

· Dimensions

· Model Views and Validating application

· Data loading

· Calculation of application

· Driver based allocation

· Working with Rules

· Rule Analysis

· Prebuilt analytics – Queries, Profit Curves and Analysis Views

· System Reports

Note to Review committee

This session will create awareness about PCMCS and how this product will help organizations to improve product and customer profitability. This session will talk how it take the mystery out of building profitability models and put the business users back in control with help to take action. How entire transparent allocation processes will be owned by business, not IT.


Automation Improves Database Security and Compliance Chetan Vithlani

With Compliance Management, one can run automated, continuous security checks based on industry standards and best practices, such as the Center for Internet Security (CIS), 

Security Technical Implementation Guide (STIG), Payment Card Industry Data Security Standard (PCI DSS), and Health Insurance Portability and Accountability Act (HIPAA). Reinforce industry standards such as STIG and CIS with custom policies to protect against threats, providing secure databases and hosts for applications.


Time Series Analysis - Forecasting IT Alerts & Growth by Suresh Gandhi

Timeseries analysis is the backbone for prediction and forecasting analysis, specific to the time-based problem statements, by Analyzing the historical dataset of the Infrastructure or database alerts and its patterns, understanding and matching the current situation with patterns derived from the previous stage.

Understanding the factor or factors influencing specific variable(s) in different periods. With the help of “Time Series” using different methodologies and frameworks, we can prepare numerous time-based analyses and results such as Forecasting, Segmentation, Classification, Descriptive analysis, and Intervention analysis.

We can forecast some of the events happening in future.


IPM in Cloud EPM - AI ML in Cloud EPM Planning by Muthu Ranganathan

To support finance’s shift toward becoming more data-driven, Oracle is investing significantly in advanced technologies such as AI, and machine learning (ML), for the Oracle Cloud Enterprise Performance Management platform.

Learn the new AI and ML capabilities, practical considerations, the connected planning use cases, and capabilities.

These capabilities are known as Intelligent Performance Management (IPM).


 Database/Cloud Day Recordings 9/11/2022

This recording is available for until 10th February 2023 to everyone, and will only be available to AUSOUG members after this date


Oracle Database deployment on Oracle Cloud Native Environment by Simon Coter

Kubernetes has become the most popular and ubiquitous open-source framework for automating Continuous Integration and Continuous Delivery (CI/CD) pipelines.

During this session learn how-to automate the Oracle Database deployment on Oracle Cloud Native Environment and its Kubernetes solution.


Securing your Oracle Database assets from operational, disaster and cyber incidents by Trichy Premkumar 

Many organisations spend enormous amount of time protecting their Mission Critical workloads that uses Oracle database.

Discover how you can modernise and manage your Mission critical databases by exception in private and public cloud.

Learn how to automate and provide self-service capability that allows to simplify the process to provide operational, disaster and cyber security.


Presentation - Securing your Oracle Database assets from operational, disaster and cyber incidents by Trichy Premkumar

Many organisations spend enormous amount of time protecting their Mission Critical workloads that uses Oracle database.

Discover how you can modernise and manage your Mission critical databases by exception in private and public cloud.

Learn how to automate and provide self-service capability that allows to simplify the process to provide operational, disaster and cyber security.

10/11/2022Presentation Slides

Oracle & Ansible - A Devops Love Story by Mark Burgess

For DBA’s there is one thing that is certain - there are more databases to manage across more complex deployments.

This session will explore how Ansible can be used to better manage and maintain an Oracle environment.

We will explore use cases that help reduce keystrokes for standard maintenance procedures all the way up to supporting complex devops workflows.

By the end of the session you will hopefully obtain a greater appreciation of the value of automation, and have the confidence to implement procedures as code across on-prem, hybrid and cloud deployments.


APEX for DBAs: What Every DBA Must Know by Charles Kim

APEX has become a household name in the Oracle community. As a fellow DBA or Developer, you have encountered APEX in your workplace.

As of Oracle Database 18c, Oracle’s no longer upgrades the Apex schema as part of the database upgrade. Don’t get caught without knowledge and skillset to maintain Apex. In this session, learn how to install, upgrade and patch Apex. We will share our experiences of maintaining Apex for the enterprise environment. In this session, you will:

• Learn how to install and upgrade/patch Oracle Rest Data Services (ORDS)
• Learn how to install and upgrade/patch Tomcat
• Learn about the minimum Apex schema versions relative to the database versions
• Learn how to create and deploy applications in Apex
• Learn how to enable tracing with Apex
• Learn how to monitor Apex applications
• Learn how to setup the Apache listener and Reverse Proxy for external access
• Learn how to configure Apex
• Learn how to secure Apex
• Learn how to setup / configure Apex in with the Cloud vendors
• Oracle Apex Service
• Infrastructure-As-A-Service


Oracle Database 19c (Your next ORACLE_HOME) by Venkata Ravi Kumar Yenugula

This session deals with the following topics with best practices, tips and tricks

1. Oracle Database Release and Support Timelines
2. Direct Upgrade to Oracle Database 19c
3. Oracle Database Offerings / Features App
4. Zero-Downtime Oracle Grid Infrastructure Patching
5. Oracle 19c – Silent Modes
6. Oracle 19c – Active Data Guard – DML Redirection
7. Oracle 19c – Data Guard Broker Features
8. Oracle 19c – Multi-Instance Redo Apply
9. Oracle Database 19c Important Recommended One-off Patches
10. Replicating Restore Points from Primary to Physical Standby


Are you an Oracle DBA wanting to learn Oracle Cloud Services? Learn for free! by Biju Thomas

To manage and get the best out of any hyperscalar public cloud services, you need to understand the essential architecture components, available services, and service dependencies. Luckily, learning Oracle cloud is free.

Let me show you the various learning opportunities available for a DBA and what to know with recommended course order. We will explore Oracle Education courses, Oracle Partner Network courses/webinars, and Oracle LiveLabs.

I will also show you how to sign up for Oracle Cloud free trial and the “Always Free” services.


Exadata Only Database Features - Some Highlights And Why You Need To Know by Richard Foote

The Oracle Database has a number of key features that are only available on the Exadata platform.

Even if you don’t currently work with Exadata, understanding some of these capabilities can be important and useful for any future endeavors.

Free access to the Oracle Autonomous Database Cloud environments can certainly help with keeping up to date with some of these unique capabilities.

This session will explore some of these Exadata only database features, including Zone Maps, SQL Quarantine, Real-Time Statistics, High Frequency Statistics Gathering, PDB Snapshot Carousel and some of the Automatic features, such as Automatic Indexing, Automatic Zone Maps and Automatic Materialized Views.


Accelerate migration to Oracle Cloud Infrastructure with minimal downtime using Zero Downtime Migration (ZDM) by Gavin Soorma

This session provides insight into Oracle’s Zero Downtime Migration tool which enable organizations to rapidly and seamlessly migrate to Oracle Cloud Infrastructure with minimal outages and disruption to the business.

Attendees will learn how to use both physical as well as logical downtime methodologies of ZDM.


5 great features in the database you are probably not using by Connor McDonald

In this session, we’ll look at five things you might not have known about the Oracle Database - or that you might have known about but never realized how they could benefit you.

For each topic, we will provide a detailed explanation of the functionality and demonstrated the benefits using real-world examples.

The topics covered are applicable for anyone running Oracle Database 11g and up including Standard Edition, with only a couple of minor exceptions.

After this session, we hope that you’ll understand a little more about these features and how they’ll benefit you and your organization.

  • 9th November 2022 - Big Data/Analytics/Security/EPM & BI Summit

  • 10th November 2022 - Database/Cloud Day


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