Posts by arockiyajegan

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

Seamless Navigation Between Oracle APEX Applications

Introduction:– In Oracle APEX, seamless navigation between two applications without requiring users to log in again enhances user experience and efficiency. This can be achieved by securely passing authentication details…

Read More

Fetching Selected Values from Oracle APEX IG Report

Introduction: –  In Oracle APEX, the Interactive Grid (IG) is a powerful component that allows users to interact with and manage data dynamically. One common requirement when working with Interactive Grids…

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

Dynamically set Decimal value Using JavaScript

1. Overview This document talks about dynamically setting decimal value for a particular column in an Interactive Grid report or Item using JavaScript. 2. Technologies and Tools Used The following…

Read More

On closure of the popup set focus to IG column

1. Overview This document talks about how to set focus to a particular column in an Interactive Grid report on the closure of inline pop up region using JavaScript. 2.Technologies…

Read More

Vendor Transaction Report

1.Overview This document talks about getting the vendor transaction detailed report in oracle apps r12 2.Technologies and Tools Used The following technologies have been used to achieve the expected output.…

Read More

Sales Margin by Item

1. Overview This document talks about getting the sales details of the item in oracle apps r12 2.Technologies and Tools Used The following technologies have been used to achieve the…

Read More