Kscope25

Implement a Low-Code RAG Solution with Oracle APEX and OCI Generative AI Agents

Monday, 8-8:50 AM, Pecos 1

Large language models (LLMs) are powerful, but often prone to errors and inaccuracies. Traditional solutions like pre-training and fine-tuning can be resource-intensive and time-consuming. Fortunately, the Retrieval-Augmented Generation (RAG) approach offers a viable alternative. In this session, learn how to develop a low-code RAG solution using Oracle APEX and the Oracle Cloud Infrastructure (OCI) Generative AI Agents service. You’ll leave with a working RAG application that responds to questions about the domain of your choice, grounded in truth and accuracy.

Solve Your Identity Crisis with OCI Identity Domains

Tuesday, 1:30-2:30 PM, Fort Worth 6-7

Are you seeking a comprehensive identity and access management (IAM) solution for your Oracle APEX application? Look no further. The Oracle Cloud Infrastructure (OCI) IAM with Identity Domains is what you need. In this session, learn about the identity domain’s rich features, how to customize them, federate with other identity providers like Microsoft Entra, and integrate with other OCI SaaS offerings like Oracle Analytics Cloud. Join us to appreciate how you can take advantage of what the service offers and build secure web applications.

Build the Intelligent Agents You Need with Oracle Technologies

Wednesday, 9:00-9:50 AM, Austin 3

As the limitations of large language models (LLMs) and generative AI become increasingly apparent, a new era of innovation is emerging. Agentic AI has emerged as a promising approach that combines the strengths of LLMs, autonomy, and decision-making to transform business operations. In the context of a car repair shop, agentic AI can support a mechanic’s workflow by analyzing vehicle data, identifying potential issues, and providing recommendations for repairs. In this session, we’ll delve into the principles of agentic AI, explore the current tools and technologies available, and demonstrate how to implement agentic workflows using Oracle APEX, Oracle Cloud Infrastructure (OCI) services, and Oracle Database 23ai. By leveraging these technologies, a car mechanic can focus on what matters most – getting the customer’s vehicle back on the road quickly and efficiently.

Why all APEX developers should learn more about HTML, CSS and web technologies in general

Monday, 3:45-4:15 PM, Fort Worth 3

Oracle APEX is a powerful platform for building enterprise applications, but to truly unlock its potential, developers must embrace web technologies that power modern user experiences. This session explores why mastering HTML, CSS, and Web APIs is no longer optional in 2024.

You’ll learn about the latest breakthroughs, such as CSS container queries, scroll snap or HTML’s native

You’ll walk away with concrete ideas and techniques for bridging the gap between traditional APEX development and the limitless possibilities of web technologies. Don’t miss this opportunity to strengthen your skills and enhance your career.

Leveraging Server-Side JavaScript in Oracle APEX with Oracle Database 23ai and the NPM Ecosystem

Tuesday, 4:10-5:00 PM, Fort Worth 6-7

Oracle Database 23ai introduces an exciting new era for developers with the Multilingual Engine (MLE), enabling server-side JavaScript within Oracle APEX applications.

This session dives into how developers can unlock the vast NPM ecosystem to enhance their APEX applications, incorporating libraries that provide rich functionalities in no time. Through practical demos, we’ll showcase real-world use cases for server-side JavaScript. Importantly, we’ll also discuss the balance between JavaScript and PL/SQL, demonstrating when sticking with PL/SQL is the right choice for performance, simplicity, or maintainability.

Whether you’re a JavaScript developer looking to use your existing coding skills in the low-code world, or an Oracle APEX developer keen to explore the synergies between Oracle APEX, the 23ai database and JavaScript, this session offers real-world insights and innovative ideas.

Save years of technical debt with an hour of entity relationship modeling

Tuesday, 9-9:50 AM, Grapevine 5-6

“Product numbers include a category, a region, and a 7-digit ID, and we use them all the time. That should be a column in a table.”

“Just add a column with the total cost of all the line items to the order table so we don’t have to calculate it all the time.”

“All the columns should be nullable to make testing data entry easier.”

These types of ‘quick and easy’ decisions lead to years of technical debt. If you spend a lot of time writing lots of complicated code to eliminate ‘bad data’, have tons of DISTINCTs in your SQL statements, or would like to avoid these types of situations in the future, this session is for you.

We’ll take a detailed look at entity relationship modeling and how working this skill can lead to the elimination of years of technical debt in all your future projects, and provide a clear path forward on existing projects.

The material from this presentation makes an excellent reference to bring back to your next design meeting so that you can save years of technical debt.

Case Study: Migrating & Upgrading 100+ Complex APEX Environments Using Ansible

Wednesday, 9-9:50 AM, San Antonio 5-6

Embark on a journey through the intricate process of modernizing over 100 legacy Oracle databases, featuring a transition from outdated APEX and legacy mod_plsql applications to the latest supported versions with pluggable databases. This case study offers a deep dive into the challenges and breakthroughs encountered when using Ansible to automate and streamline a massive upgrade and migration effort.

In this session, we will explore:

Why was Ansible chosen?
Navigating deprecated database functionalities and old APEX versions, including relics like WebDB.
Transitioning from mod_plsql to Oracle REST Data Services (ORDS).
Implementing Apache rewrites to maintain legacy application functionality.

Discover the power of Ansible’s declarative automation as we detail the step-by-step process developed to migrate databases into Oracle pluggable databases on new servers, and to construct a robust ORDS and Apache deployment that supports updated APEX environments without disrupting existing mod_plsql applications.

Join us to learn how automation not only made this daunting task feasible but also reproducible, paving the way for future migrations and upgrades. Whether you’re a DBA, developer, or a project manager, this session will provide valuable insights into managing large-scale database migrations with precision and efficiency.

APEX & ORDS for DBAs and System Admins – 2025 Update

Wednesday 1:30-2:30 PM, Fort Worth 3

“Hey, can you set up APEX for me? It’s easy, all you do is install APEX and ORDS and then it’s ready to go.” says the developer to the DBA or system admins.

Unfortunately, all too often, the answer is not “Sure!” but instead, “But what about security?” followed by “What about this, or that, or this other thing?” 
If you are a developer who wants to be able to answer the “What about?” or understand how APEX and ORDS (Oracle REST Data Services) work at a technical level, or a DBA/system admin who has never implemented APEX & ORDS, or an experienced DBA/system admin who would like to learn to implement APEX & ORDS in a more supportable and maintainable way, this is the session for you.

You’ll leave with clear step-by-step instructions for:

Providing database developers with the functionality of the APEX packages and APIs without exposing your database to browsers.
The correct way to allow database developers to reach out of the database to web-based resources.
Finally, how to install and configure ORDS middleware (especially since the changes in ORDS implementation architecture) so that APEX applications and REST services can be served from your database.

This is a 2025 update of Kscope23’s Oracle APEX Top Speaker award-winning session with the latest versions of Oracle Database, Oracle APEX and ORDS.

Corporate UI in APEX – easier than you think

Tuesday, 10:30–11:20 AM, Fort Worth 3

APEX offers some great UI and components out-of-the-box. And most importantly – it allows us to create our own, easier than ever before. Often customers need their app to follow a corporate standard – colors, fonts, styles, you name it. And even a whole set of components, some of which not even available in APEX.

Join me in this session to see the steps that I usually take in such situations. How the new APEX features, such as Template Components can help and how the flexibility of the Universal Theme and the built-in utilities can be used in achieving this goal. Along the way we will discuss not only the different approaches, but also some challenges and the ways to get around them.

From Impossible to Achieved: Revolutionizing CV Management at a Leading Medical School with Oracle APEX
Wednesday, 3:50–4:40 PM, Fort Worth 2

When a highly esteemed medical school sought to automate the complex process of updating and formatting extensive medical Curriculum Vitae (CVs), multiple vendors told them it was impossible. Faculty members were spending countless hours manually updating CVs—some exceeding hundreds of pages across 71 diverse sections—creating a significant administrative burden and hindering the promotion process. Additionally, the university lacked an efficient way to collect data and analyze faculty activities.

In this session, we’ll share how we leveraged Oracle APEX and Oracle Database to transform this challenge into an opportunity by developing a powerful CV Generator that surpassed the school’s expectations.

By attending this presentation, you’ll gain insights into practical techniques and best practices for tackling intricate data processing and document generation projects using Oracle APEX. Whether you’re dealing with complex documents or looking to streamline administrative tasks, this session will equip you with the knowledge and inspiration to achieve what might seem impossible.