Simplifying Multi-Site Customer Data for Reporting and Analysis Oracle Fusion’s Trading Community Architecture (TCA) is a powerful framework for managing complex customer, partner, and supplier data. However, working with normalized data models often...
Introduction This article aims to provide a comprehensive guide for beginners to get started with Oracle Cloud Infrastructure (OCI) Generative AI service. This article covers everything from creating an account to setting up the environment and runni...
The Easiest Way to Expose Uptime Kuma to the Internet (Using Cloudflare Tunnel) If you’ve ever struggled with setting up a reverse proxy for your self-hosted apps like Uptime Kuma, you’re not alone. Traditional tools like Nginx, Caddy, and Traefik ca...
¡Hola, comunidad de La Botica del DBA! Hoy vamos a tomarnos una píldora para una efectiva estrategia en la aplicación de parches en Oracle Exadata. En el dinámico mundo de la administración de bases de datos, mantenerse al día con las actualizaciones...
Have you ever seen a mysterious tilde ~ when using APEX_STRING.FORMAT? Neither had I until today It’s just an observation but when I ran this computation on an Oracle APEX Page Item… RETURN TO_CLOB( apex_string.format( '%0', q'[Leeds...
Want Dracula Theme in Oracle APEX Page Designer? 🧛♂️ of course you do… Good choice!🧄 Instructions Here is what you need to do: Install Violentmonkey by clicking on the one of the Installation options. Alternatively, If you are unable to install ...
I wanted to unzip a file using APEX_ZIP today, and found that the old method was deprecated and now there is a completely different method. Lets unpack it all with examples aplenty. Preparation For this demonstration, I’ve decided to zip up the apex\...
This blog details the steps required to enable users to access OIC File Server and also use Key Based Authentication. Pre-requisites IDCS: Admin Console Access - Enable the File Server. Refer this documentation. OIC User with ServiceAdmin Role - To...
This blog will detail the steps required to setup JWT Authentication for invoking ERP SOAP and REST Services. Pre Requisites The SaaS user should have access to Security Console to setup JWT A local machine which can run OpenSSL commands to generat...
This is a Quick Reference / Cheat Sheet take your pick. SQLcl Projects is a feature in Oracle's SQLcl tool that helps manage and automate database changes and deployments for Oracle Database and APEX applications. It provides a structured approach to...