APEX

Social Sign-in has been around since APEX version 18. And with small differences, the main concepts regarding Single Sign On in APEX using Facebook, Google, Microsoft, OKTA or any other 3rd party authentication provider have been the same. There are numerous blog post I have read and videos watched during … Continue reading OKTA authentication for APEX in 5 minutes →

Redwood theme Redwood background textures and APEX CDN Background textures integration Link to DEMO

Adding favicon for your application *Note that the filenames should match the ones you have uploaded into Application Static Files earlier. Adding custom application icon in APEX Builder Bonus icon

Introduction & helpful links Modifying APEX charts colours Modifying APEX charts bar width, donut radius, etc. Other chart attributes

Present and future of Markdown in APEX https://www.markdownguide.org/getting-started/https://blog.bit.ai/what-is-markdown/ Several ways you can utilise Markdown in APEX version 20.2 What’s new in the latest version of APEX – 21.1 Add Markdown support to all your regions Markdown in APEX 20.2 vs 21.1

Switching your application theme is getting more and more popular in recent years. APEX apps and their users are no exception. Most of our devices support this feature, APEX itself introduced dark and light mode for the Application Builder too. I am going to show you a quick way of … Continue reading Auto switch Dark & Light modes of your APEX app →

It happens that you forget your master ADMIN password for the apex_admin page. Here are the two widely user methods to change it and unlock the Admin account: Use @apxchpwd.sql script in your APEX directory. To run it, navigate to the directory through bash or Command prompt. Connect to your … Continue reading Unlock APEX Admin account →

It happens relatively rarely to have an error PLS-00907 (PLS-00907: Can not load library unit). We have encountered it few times in our APEX applications. Here is the way to resolve it (performed by a SYS user). Solution : Ask your DB admin to flush the shared pool 🙂

By default, if you use embedded PL/SQL gateway to run your APEX, PDF printing is not possible. There are several ways to make it possible. By configuring ORDS and running it in either Standalone mode or into Apache Tomcat / Glassfish / or other web server. This option is completely … Continue reading Print PDF reports with APEX 5.1 + ORDS →