Posts by Karthik Senthilmurugan

Set Page/Application Item value within PLSQL Package/Procedure/Function

1. Overview This blog talks about the setting Page/Application Item value within PLSQL Package/Procedure/Function. 2. Technologies and Tools Used The following technologies have been used to achieve this functionality, PLSQL APEX API 3. Use Case To set the session state page item or application item value within PLSQL. 4. Architecture  Usually,…

Read More

Enable/Disable IR Download button based on User Role

Overview By default, the IR region allows to either enable the Download button to all users or disable the Download button to all users. Suppose if there is a requirement…

Read More

What is an recursive sub-query factoring?

1. Overview This document talks about an example of a recursive subquery factoring clause. 2. Technologies and Tools Used The following technologies have been used to achieve exporting IR data to Word format. Oracle SQL…

Read More

How to split comma/colon separated string using Oracle APEX API

1. Overview This blog talks about an example of splitting any special character string to an apex collection table using apex API. 2. Technologies and Tools Used The following technologies have been used to achieve…

Read More

Set Session State Value for APEX Application Item

1. Overview This blog talks about the setting session state value for application item using the JavaScript function in Oracle APEX. 2. Technologies and Tools Used The following technologies have been used to achieve this…

Read More

Set Session State Value for Oracle APEX Page Item

1. Overview This document talks about the setting session state value for page item using the JavaScript function in Oracle APEX. 2. Technologies and Tools Used The following technologies have been used to achieve this…

Read More

Integrating APEX with Oracle E-Business Suite hosting in the same hostname

Follow the steps given below to call APEX application from EBS, Step 1: Create an Oracle Apex Application and go to Shared Components => Application Items, then create the following items, Application Items  Scope: Application Session…

Read More