Posts by arockiyajegan

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

Detailed Margin Report

1.Overview This document talks about getting the report of detailed sales margin by customer by invoice by item (both Invoice and credit memo). 2.Technologies and Tools Used The following technologies…

Read More

Sales Daily Pick Report

1.Overview This document talks about getting the sales daily stock pick report in oracle apps r12 2.Technologies and Tools Used The following technologies have been used to achieve the expected…

Read More