Yearly Archives: 2024

Visualizing Time-Series Data with Event Drop Charts in Oracle APEX

Introduction:- In Oracle APEX, Event Drop Charts provide a powerful way to monitor and analyze events occurring over time, making it easier to identify patterns, trends, and anomalies. including setting…

Read More

How to create a Plugin to Refresh Report Using Timer and Dynamic Actions

1. 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

Client-Side Validation for APEX_ITEM Elements in Classic Report Using JavaScript

Introduction Client-Side Validation for APEX_ITEM Elements in Classic Report Using JavaScript” refers to the process of implementing validation checks directly in the browser for elements created using the APEX_ITEM package…

Read More

Displaying an Icon on Page Item Dynamically Based on User Input

Introduction The goal is to display an icon on a post text of page item, dynamically based on user input. This approach enhances user experience by providing immediate visual feedback…

Read More

Reading Outlook Emails with Microsoft Graph API using OAuth 2.0 Authentication

Introduction: – The Microsoft Graph API provides a powerful way to interact with a wide range of Microsoft 365 services, including Outlook, using a unified endpoint. By leveraging OAuth 2.0…

Read More

Steps to Fix Export Issues with expdp full=y Not Exporting All Tables

If a point-in-time recovery is not an option, follow the steps below: Backup the Database as sys user. We will have to patch fed$apps and obj$. startup restrict; Create backup…

Read More

Elevate Your Oracle APEX UI with Card Zoom and Hover Effects Using Tailwind CSS

Introduction: Enhancing the user experience is pivotal in modern web applications. In Oracle APEX, implementing intuitive and engaging UI elements can significantly improve the application’s appeal. One such feature is…

Read More

Enhancing Oracle APEX Interactive Reports with Hover and Zooming Effects

Introduction: Interactive reports are a cornerstone of Oracle APEX applications, allowing users to explore data dynamically. However, adding visual flair can make these reports not only functional but also more…

Read More

Validation Based on Row Value in Interactive Report

1. Overview This document will be helpful to validate interactive report column value using dynamic action. 2. Technologies and Tools Used The following technologies have been used to achieve this functionality, SQL Javascript 3. Use Case I had a situation to restrict the user input based on the “helpline” column,…

Read More

Updating InteractiveGrid using JSON

1. Overview This document will be helpful to update interactive grid data using JSON without using an automatic process or manual process. 2. Technologies and Tools Used The following technologies have been used to achieve…

Read More