Yearly Archives: 2024

How to create a set of dynamic drop down link for classic report column.

Overview This document is about how to create set of dynamic drop down links for classic report column in oracle apex. Technologies and Tools Used The following technologies have been used…

Read More

Using A Gauge Chart To Display Data Dynamically

Overview In Oracle APEX, Utilizing a gauge chart is an effective means to dynamically display data in a visually intuitive manner. Gauge charts provide a concise representation of a single…

Read More

To Capture Images In Oracle APEX Using Front & Rear Device Camera

Overview In Oracle APEX,  Using the “To Capture Images In Oracle APEX Using Front & Rear Device Camera” form, you can snap pictures with your computer and submit them straight…

Read More

Query to give responsibility details which is missing for a user

Introduction: This query will fetch you the responsibility details which is missing for a user. The input parameter passed is ‘user name’ which will get processed and provide you with…

Read More

Query to give user responsibility details

Introduction:This query will fetch you the user responsibility details such as responsibility name, application name, description, security group, start date and end date. The input parameter passed is ‘user name’…

Read More

Optimizing Web Page Performance Through Interactive Grid Load More Rows Implementation

Overview In the realm of web development, achieving optimal page performance is a perpetual pursuit, particularly when dealing with large datasets displayed in grids. The concept of an “Interactive GRID…

Read More

Implementing JavaScript Validation to Verify and Control the List of Values in a Popup LOV within Apex

Overview This document outlines the comprehensive procedure for implementing JavaScript validation to confirm and regulate the list of values in a Popup LOV (List of Values) within Apex. The validation…

Read More

Building a Contextual Back Button with Application Page Items in Oracle APEX

Overview In ORACLE APEX we generally use page number in the URL to redirect the page from one to another. However in this session dives deep into the hidden potential…

Read More

Enforcing Save Before Adding New Row in Oracle APEX Interactive Grid using JavaScript

Overview In Oracle APEX, a interactive grid had a concept of adding multiple row. Here in some cases the specific requirement here is to insert only one record at a…

Read More

EMPLOYEES HOLIDAY CALENDAR LIST (Core HCM)

Introduction:  This SQL query is used to fetch the Holidays list for Employees like Employee number, Holiday name, Start date, End date etc… Cause of the issue: Business wants a…

Read More