Introduction:- To improve user experience in Oracle APEX by implementing a Recently Visited Pages dashboard. By using APEX activity logs, it demonstrates how to track user navigation and dynamically display…
Read MoreIntroduction:- This blog explains how to implement a reusable character counter for normal text fields in Oracle APEX, similar to the built-in character counter available for text areas. It demonstrates how a…
Read MoreINTRODUCTION: In Oracle APEX 19.2, Pie charts are widely used to visualize proportional data. However, the default 2D Pie chart sometimes lacks visual depth, especially when displaying many categories. Business…
Read MoreINTRODUCTION: In Oracle APEX 19.2, Donut charts are commonly used to represent proportional data in a visually appealing way. While the chart effectively displays individual segment values, there is no…
Read MoreImage Validation in Oracle APEX Introduction Oracle APEX provides a Image Upload page item that allows users to upload files easily. However, in real-time applications such as profile management,…
Read MoreVideo Recording in Oracle APEX Introduction:- Oracle APEX allows seamless integration of modern web technologies to enhance application capabilities. This document explains how to implement client-side video recording in…
Read MoreIntroduction Oracle REST Data Services (ORDS) is the middleware layer that powers Oracle APEX, REST API s, and database-backed web services. While ORDS works out of the box, default settings are not…
Read MoreIntroduction: Java-based middleware components such as Apache Tomcat and ORDS are highly dependent on correct JVM configuration. Misalignment between Java versions and heap settings can result in critical startup failures.…
Read MoreIntroduction: This document explains the implementation of Multiple Session Restriction in Oracle APEX applications. The objective of this solution is to ensure that a single user cannot maintain multiple active sessions at the same time across different browsers, devices, or tabs. Why We Need to Do This? Restricting multiple sessions per user is a crucial requirement for maintaining both security and control within an Oracle APEX application. Allowing the same user account to be logged in from multiple devices or browsers simultaneously can lead to risks such as credential sharing, data misuse, and difficulty in tracking true user activity. How Do We Solve It? STEP 1: In APEX Application Go to Page 0 and Create Page Item (P0_ACTIVE_SESSION). STEP 2: Create Dynamic Action, Event :On Page Load Name : Find active session Items to Return : P0_ACTIVE_SESSION Client-Side Condition : Item is null (P0_ACTIVE_SESSION) Server-Side Condition : Current page != Page Value : 9999 TRUE ACTION 1 : Plsql Code:- Declare …
Read MoreIntroduction: This document explains the implementation of a Login and Logout Audit mechanism in Oracle APEX. The objective of this solution is to capture and track user activity within the…
Read More