Location matters: The new Map Region Type in APEX 21.1

This presentation introduces the new Map Region Type, which was introduced the latest APEX release 21.1.

Attendees will learn, how to easily visualize location data from a SQL query or a REST Data Source on a map – all declarative, without manual coding and without external Plug-Ins.

The session will also cover how to integrate a Map region with other APEX region types like Charts, Reports or Faceted Search.

Tips and tricks about visualizing larger amounts of data and how to leverage Oracle Spatial functionality will wrap the session up.

Migrate Your Oracle Forms Apps to Oracle APEX

Oracle Forms is an established technology that has been popular for building data applications for decades. Today, there are several approaches for building such applications.
In this session, you will learn:
• How to use Oracle APEX to modernize your Oracle Forms-based applications.
• When it’s a good moment to modernize
• What you should do before starting this type of projects
• Demonstration from Forms to APEX

Low Code Development with Oracle APEX on Autonomous Database Workshop

Oracle APEX is the world’s most popular low-code application development platform for building and deploying modern data-driven applications. Business users and application developers can create enterprise apps 38X faster without having to learn complex web technologies.

Gain hands on experience learning how the new APEX Service works to build a fully functional APEX app in less than an hour. Go from zero to hero in a ridiculously short period of time! This workshop includes two parts:

Creating an App based on Existing Tables for Oracle Autonomous Cloud Services

 In this hands-on lab, you’ll learn how to quickly and easily build impressive apps on top of your existing data.

Automating Invoice Processing in Oracle Cloud ERP Leveraging Bots

Organizations embracing automation into their finance function have experienced reduction in process cycle time and costs up to 70% – 80%. When your team spends less time processing invoices, they can focus on more value-generating tasks. 
Join our subject-matter experts – Dr. Nikhil Jain, Solution Architect in conversation with Vishal Saxena, Finance and Supply Chain Specialist, as we bring to you an exciting session on how you can achieve Invoice Process Automation within Oracle Applications leveraging MS Power Automate.
Minimize invoice processing effort and time
Eliminate manual data entry and errors
Improve vendor association
Improve visibility across the Accounts Payable process
Improve reconciliation

Learn how our Bot based solution can transform Finance and Accounting to ensure faster, error-free tasks and process optimization in your Enterprise. We will also walk you through a short demo automating invoice processing using our Bot based solution.

Automating Invoice Processing in Oracle Cloud ERP Leveraging Bots

Organizations embracing automation into their finance function have experienced reduction in process cycle time and costs up to 70% – 80%. When your team spends less time processing invoices, they can focus on more value-generating tasks. 
Join our subject-matter experts – Dr. Nikhil Jain, Solution Architect in conversation with Vishal Saxena, Finance and Supply Chain Specialist, as we bring to you an exciting session on how you can achieve Invoice Process Automation within Oracle Applications leveraging MS Power Automate.
Minimize invoice processing effort and time
Eliminate manual data entry and errors
Improve vendor association
Improve visibility across the Accounts Payable process
Improve reconciliation

Learn how our Bot based solution can transform Finance and Accounting to ensure faster, error-free tasks and process optimization in your Enterprise. We will also walk you through a short demo automating invoice processing using our Bot based solution.

Modals and Popups and Dialogs, Oh My! …Which to Use When, How and Why

Learn the subtle and not-so-subtle distinctions between APEX modals, popups and inline dialogs: Which to use when, why to choose one over the other, and how to use them appropriately in your APEX applications. We will cover modal and non-modal dialog pages, inline dialog and inline popup region types, when to use a dialog page vs an inline dialog or popup, and caveats and challenges to be aware of with each element type. Emphasis is on use of declarative APEX elements and documented JavaScript APIs whenever possible, and best practices for employing these various elements in your APEX pages, including specifics for launching from interactive grids.

What’s new with the Worlds fastest EBS reporting solution?

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 aging and inefficient EBS reporting tools like Discoverer, Polaris, Report Wands, and BI Publisher. With the ability to export over one million transactions in less than 10 seconds, and with our unlimited data output, it is an option that users of large volumes of data need to see to believe!

This presentation will demonstrate how job satisfaction and productivity can be increased for all EBS business users and developers. We demonstrate Blitz Report™, a reporting option available to EBS operational users looking to manage large volumes of transactional data quickly and efficiently, and how using this solution with Oracle’s Enterprise Command Centers is a game-changer for EBS teams.

Objective: The objective is to help EBS business users and developers increase their job satisfaction and productivity by adding a new transactional reporting solution to their current reporting and analytics tools.

Tips and Tricks: Linux Best Practices and Automation for DBAs

Red Hat Enterprise Linux and Oracle Linux continues to gain market share as a reliable 7/24
mission-critical enterprise server platform. As a DBA in today’s economy, you must possess
both the system and database expertise. In this session, learn the tips and tricks to install and
configure Linux with all the industry best practices. Don’t stop there. You need to learn the
secrets of automating the Grid Infrastructure and database software stack for both RAC and
non-RAC environments. Imagine being able to provision a 4 node RAC cluster that is fully
patched and being able to create a RAC database on Oracle 19c in couple of hours.
Learn all the best practices for Red Hat/Oracle Linux 7 and 8 required to implement Oracle
Databases in bare metal servers and in virtualized infrastructures. Leveraging real-life
experiences and techniques, learn from the author of the Linux Recipes for DBAs book by
APress on how-to:
1. Leverage PreInstall RPMs to prepare the Linux environment for Oracle database, OEM
Agents, and EBusiness Suite environments
2. Setup and leverage a local Yum Repository
3. Setup Huge Pages / Disable Transparent Huge Pages
4. Setup Jumbo Frames
5. Setup Oracle ASM Filter Driver vs ASMLIB
6. Setup correct partition alignment
7. Automate Grid Infrastructure provisioning
8. Create ASM instance in silent mode
9. Automate Database provisioning
10. Automate installation of release updates and one-ff patches
11. Automate Grid Infrastructure and Oracle Database software cloning
12. Create ASM disk group with XML files
13. Create Golden Image databases for future cloning
14. Setup rsync to synchronize file system from source and target servers
And much more.

Pluggable Databases Risen From the Dead

With the recent announcement at Oracle OpenWorld, starting in Oracle Database 19c, we are
allowed to have up to 3 pluggable databases per container database. Effective Oracle Database
20c, non-containerized databases will no longer be supported.
As an attendee of this session, you will receive a free copy of the PDB Me to Oracle Cloud book
written by Oracle ACEs. Come learn what it takes to effectively create, configure, manage and
monitor Oracle PDBs. Learn all the latest and greatest new features of Oracle PDBs from Oracle
12.2/18c/19c.
Innovations in pluggable databases will blow your mind. Innovations in Oracle PDBs will change
how you:
• patch your databases
• perform database upgrades
• provide reporting databases
• provision clones of pre-production, QA and DEV environments
• setup Data Guard between the primary and standby environments
• setup performance governors on the database tier
• setup security with pluggable DBAs
• consolidate your database environments
• ask for outage windows to perform maintenance
• can confidently provide higher availability, reliability and scalability

DBA 3.0: The Next Evolution

The database administration role as we knew it is dead. DBAs who have been around for
decades have become irrelevant in this data driven economy. Developers want autonomous
management and executive leaders want to cut costs anyway they can. Join Oracle community
experts as we discuss the next evolutionary role of the database administration role and what
we must do to adapt and survive in this ever changing dynamic technology driven world. Learn
what future skills you need to possess and how you can stay on top of the demand.
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
#6. Pluggable Databases Risen From the Dead
With the recent announcement at Oracle OpenWorld, starting in Oracle Database 19c, we are
allowed to have up to 3 pluggable databases per container database. Effective Oracle Database
20c, non-containerized databases will no longer be supported.
As an attendee of this session, you will receive a free copy of the PDB Me to Oracle Cloud book
written by Oracle ACEs. Come learn what it takes to effectively create, configure, manage and
monitor Oracle PDBs. Learn all the latest and greatest new features of Oracle PDBs from Oracle
12.2/18c/19c.
Innovations in pluggable databases will blow your mind. Innovations in Oracle PDBs will change
how you:
• patch your databases
• perform database upgrades
• provide reporting databases
• provision clones of pre-production, QA and DEV environments
• setup Data Guard between the primary and standby environments
• setup performance governors on the database tier
• setup security with pluggable DBAs
• consolidate your database environments
• ask for outage windows to perform maintenance
• can confidently provide higher availability, reliability and scalability