APEX

APEX & ORDS UPGRADE

Description: This document explains how we upgraded Oracle APEX, ORDS, and Java on the DBNAME database. It covers the checks and backups done before starting, the steps for installation and configuration, and how we fixed common issues during the process. The aim was to move from older versions to APEX 24.1, ORDS 24.1, and Java 11 smoothly, without affecting service availability. Componets Current versions   Upgrade version Apex 22.2 24.1 Ords 21.2 24.1 Java  Jdk-1.8 11.1 Pre checks and backups.      Apex Workspace backups.   Steps: Login to admin responsibility and take the workspace level backup. Using APEX port utility to take workspace and application backups in backend.   Tomcat and Ords backup Taking current tomcat and ords backup using tar.   Validate workspace schema backup should be taken in DBA team.   Installation of apex in DB level.…

Read More

Enhancing Jasper Reports with Dynamic PDF Titles

Introduction: In many web applications that use JasperReports, the same JSP export logic serves multiple report templates (.jrxml files). Each report may represent different business documents such as share certificates,…

Read More

Changing Interactive Grid Headings Dynamically in APEX

Introduction: In Oracle APEX, Interactive Grids often display fixed column headings, which may not suit scenarios where data is time-bound or varies with user input. When working with reports spanning…

Read More

Dynamic Row-Wise Validation Across Two Interactive Grids in APEX

Introduction :   Interactive Grids in Oracle APEX are a powerful feature for managing and editing tabular data within applications. However, when it comes to dynamically summing column values as users input…

Read More

Single Date Range Picker In Oracle APEX Using JavaScript

Introduction : In many Oracle APEX applications, date selection is a common task — whether it’s filtering reports, exporting data, or running analytics. Traditionally, this requires two separate date pickers: one…

Read More

Display Report Execution Time with #TIMING# in Oracle APEX

Introduction/ Issue:   The *TIMING# substitution variable represents the elapsed time (in seconds) taken to render a region, including the time to fetch data and render region items. This variable is…

Read More

Displaying Counts in APEX Navigation Menu in Oracle APEX

Introduction/ Issue:   In Oracle APEX, it’s possible to dynamically present the number of items—such as pending modules, unread messages, or active records—next to navigation entries (e.g., “Modules [5]”). This live…

Read More

Build a Digital Signature Pad in Oracle APEX Using Only JavaScript & PL/SQL

Introduction:   Capturing a user’s handwritten signature directly within an Oracle APEX application is a powerful way to streamline approvals, confirmations, and form submissions without relying on paper-based processes. By building…

Read More

Implementing Row ID Capture into Page Items in Oracle APEX Interactive Grids

Introduction Capturing selected row IDs in Oracle APEX Interactive Grids is essential for many dynamic applications where developers must perform batch operations, updates, or any processing based on user-selected records.…

Read More

Designing a Robust File Upload Architecture in Oracle APEX

Introduction Oracle APEX 24.2 has significantly evolved its file handling capabilities, supporting multiple file uploads, file type restrictions, and enhanced integration with both temporary and persistent storage options. Let’s walk…

Read More