Introduction When working with data-dense Oracle APEX Interactive Grids, users often struggle with standard filter menus—especially when navigating complex datasets with multiple columns. Traditional UI filtering requires users to manually…
Read MoreIntroduction When building transactional forms in Oracle APEX—such as sales orders, requisition lines, or booking forms—business logic often requires capping the maximum number of detail lines a user can add…
Read MoreIntroduction / Issue Many Oracle APEX applications successfully meet business requirements but often overlook one critical aspect—the User Interface (UI) and User Experience (UX). Developers tend to focus primarily on…
Read MoreIntroduction Oracle APEX applications often display large amounts of data in Interactive Reports, Interactive Grids, dashboards, and forms. When users need to inspect small text or closely packed information, increasing…
Read MoreHighlight Important Dates in Oracle APEX Modal Dialog Date Picker Using JavaScript Introduction Oracle APEX provides a built-in Date Picker component that makes date selection simple and user-friendly. In many…
Read MoreIntroduction Oracle APEX applications often require efficient search functionality. However, traditional SQL LIKE searches do not handle typos or similar words effectively. A fuzzy search can improve search accuracy by…
Read MoreIntroduction Oracle APEX applications often require storing complex, structured data in a flexible way. Instead of creating multiple tables for dynamic data structures, we can leverage JSON storage in a…
Read MoreIntroduction: In this blog, we will walk through the process of enabling debug logging and tracing in Oracle APEX applications. Debug logging and tracing are essential techniques for diagnosing problems, understanding application behavior, and improving performance. By capturing detailed logs and execution traces, developers can gain insights into the inner workings of their APEX applications, making it easier to pinpoint and address issues. Step 1: In the Browser login into APEX as “DEVELOPER” Step 2: Run the application which will be running the Report Take down the URL’s session ID as like below. “https://***.**.*.**/ords/f?p=521:101:8786047580303:::::” In my scenario the session ID is 8786047580303 Navigate to Administration–>Monitor Activity as per below snip Step 3: Monitor Activity–>Active Sessions Search for the session ID of Apex runtime “8786047580303” The screen appears like below. Click on Active session id. We can find the session details below Step 4: Make below changes as per below image attached Debug Level –>”APEX Trace” & Trace Mode –>”SQL Trace” Apply the changes. Step 5: After applying changes we can able to see the Debug id as below Once you click the “Debug ID”, you should be seeing page Step 6: Clicking Actions–>Download–>HTML. Step 7: Finally we can download the trace file as PDF or HTML Format. Conclusion: Enabling debug logging and tracing for our Apex application is crucial for effectively diagnosing and resolving runtime issues. By carefully configuring debug logs, we can capture detailed information on code execution, database operations, and other critical components of our environment.This detailed logging allows us to identify and address problems efficiently.
Read More1. Introduction:- In Oracle APEX (Application Express), configuring dynamic search field behavior in an Interactive Grid (IG) based on inputs from a previous page enhances user experience by creating a more…
Read More1. Overview This document provides a comprehensive guide on creating a plugin to refresh a report using a timer and dynamic actions. The tutorial is divided into two main sections, detailing…
Read More