Monthly Archives: August 2025

Restricting multiple sessions per user in Oracle APEX

Introduction: 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 More

APEX USER LOGIN LOGOUT AUDIT

Introduction: 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

Converting UTC to Local Time with DST in Oracle Integration

Working with time zones can be tricky—especially when Daylight Saving Time (DST) comes into play. This Oracle Integration recipe offers a ready-to-use solution to convert UTC into any local time…

Read More

OIC 25.04 New Features – Auto-Retry actions generation

I have an integration with one or more invokes and I want to apply retry functionality to them, e.g. retry on failure up to 3 times etc.  Now you could…

Read More

Journals Uploaded Twice into Oracle Apps r12

Introduction/ Issue: The Same details Journals Uploaded Twice into Oracle. Why We need to do / Cause of the Issue: User was uploaded the same GL File Twice into Oracle.…

Read More

In the AP Interfile file Program Getting Duplicate Invoice Error.

Why we need to do /Cause of the issue: When we are uploading the AP Invoice Refund data into Oracle. In the Payables Open Interface Import Program We are getting…

Read More

Lot Genealogy Report

Introduction: This blog has the SQL query that retrieves the complete lot genealogy, detailing the full lifecycle of product creation. Cause of the issue: Business wants a report that contains…

Read More

Quality Test Sample Throughput Report

Introduction: This blog has the SQL query that retrieves all Quality test samples along with their corresponding results. Cause of the issue: Business wants a report that contains the details…

Read More

API to Update Item Status in Oracle E-Business Suite

API to Update Item Status in Oracle E-Business Suite Introduction In Oracle E-Business Suite (EBS), Item Status controls key aspects of how an item behaves across different modules such as…

Read More

API to Update the Item Categories in Oracle EBS

API to Update the Item Categories in Oracle EBS Introduction In Oracle E-Business Suite (EBS), item categories play a crucial role in organizing and classifying items for inventory, costing, and…

Read More