Each month, Oracle ACEs share practical insights, expert tips, and real-world solutions across the Oracle landscape. This September, we’ve curated a collection of outstanding blog posts covering essential development techniques, deployment strategies, new authentication methods, upgrade best practices, and more, focusing on APEX.

Whether you’re building your first APEX application or fine-tuning a complex environment, these highlighted resources will help you stay up to date with the latest tools, features, and community expertise to elevate your APEX projects.

André van der Put – Using Build Options in the deployment of APEX applications            

Lately there have been some interesting changes in APEX regarding development and deployment of applications. In this blog post I will show how Build Options can be a valuable tool in development and deployment, and are powerful where Working Copies still fall short. Read more

Bharat Bhushan Bhatia – Complete Guide to Setting Up Custom Authentication             

Complete Guide to Setting Up Custom Authentication – learn how to set up Custom authentication. Read more.

Bruno Tiago Cardoso – Substitution Strings in Oracle APEX You (Probably) Aren’t Using — But Should Be      

We all use substitution strings in Oracle APEX like &APP_USER. or &APP_PAGE_ID. — they’re everywhere. But did you know there are some less talked-about substitution strings that can provide powerful debugging, performance insight, or even UI flexibility? Read more.

Jenish Joyal J – Oracle APEX – Custom Sticky Notes Region with PDF Export        

Welcome to the first version of our innovative Sticky Notes Region for Oracle APEX – a fully interactive board to drop your quick thoughts, organize ideas visually, and export the board as a PDF! Read more.

Jonathan Dixon – Is Your APEX Environment Aging Quietly

This post will follow a case study of a client running on-premises APEX (18.2) who is migrating to an Autonomous Transaction Processing Database (ATP) instance running on Oracle Cloud Infrastructure (OCI). Read more.

Lucas Hirschegger – Oracle APEX – The Standard Component Attributes Anatomy Series: Server-side Condition

Preparing for a presentation on APEX items, I’m starting a new series of blog posts exploring the basic capabilities of APEX. The goal is to gain a deeper understanding of how things work behind the scenes and how we can make the most of them. Read more.    

Malik Sikandar Hayat – Keeping Network ACLs Alive Across Oracle APEX Upgrades      

When you patch or upgrade Oracle APEX, Oracle creates a new internal schema whose name embeds the APEX version. Read more.

Niall Mc Phillips – Using PL/SQL to Seed and Publish Oracle APEX application translations     

For multilingual applications, it can become a little tiresome to constantly have to reseed and republish your application while testing multiple languages or debugging language-switch problems. Read more.

Satwik Reddy Jambula – Oracle APEX Upgrades: The 21.1 to 24.2 Constraint Problem and Why Sequential Upgrades Matter           

Oracle APEX upgrades can present unexpected challenges, especially when jumping multiple versions. Based on documented issues in Oracle forums and official guidance, here’s what you need to know about APEX version management. Read more.

 

Want to connect with these experts or discover more? Visit the Oracle ACE Directory and be sure to bookmark the Oracle ACE Program blog for the next round of cutting-edge community knowledge.