Posts by Venkatesh Balasubramanian

Performance Issue – Hierarchical query LEVEL

Description: A parts hierarchy, particularly the case of parts in a kit with the kit/assembly having multiple levels. Another example is parts succession, where older parts are replaced by newer…

Read More

Shrinking of Navigation Menu on page load

Requirement: Navigation menu should be shrinking on page load. Challenges faced:  In Oracle Apex 5, universal theme the navigation menu is strengthening on default page load. If we want to shrink the menu we need to click on the  navigation menu controller. Resolution: Created a dynamic action with event as page load and condition as JavaScript Expression and value as                      $(‘#t_Button_navControl’).attr(‘aria-expanded’) === “true”. A true action is provided with JavaScript code as $(‘#t_Button_navControl’).click(); Output:  

Read More

Search bar for Tabular form with auto complete option for Date values

Description:The search button in tabular form is helpful to identify the exact data in the tabular form, that will act like a filter in interactive report shows the particular values…

Read More

Retain checkbox value after refresh the page

     Step1: Declare global variable to get all the checkboxes   var i; checkboxes = document.querySelectorAll(‘input[type=checkbox]’);  Step2: Use the following function to save the checked checkboxes values into localstorage…

Read More

Report Carousel in APEX 5 UT

      Description: This document describes how to dynamically moves your data from the report in oracle apex 5.  When you add a region to your page with a couple…

Read More

Removal of close button from Select2 plugin

Description: The users who completed their tasks in selected Delivery PDVD must not be deleted from team allocation. Select2 plugin was used for selecting multiple users, which will have a…

Read More

Oracle Test Manager

  Description: Oracle Test Manager is an easy to use tool that allows you to organize and manage your overall testing process. It provides a single unified platform for sharing…

Read More

Oracle OpenScript

                                             Oracle OpenScript Description: OpenScript is the next-generation environment for developing Oracle Application Testing Suite scripts for Web application testing.   Features: 1)Scripting Workbench 2) Test Modules 3)Graphical/Tree View Scripting…

Read More

Sending E-mail with Excel Attachment Using UTL_SMTP

Description: The utl_smtp package is used to send e-mails from any database to a valid recipient/recipients with or without attachments. The generic code is given to send e-mail with excel…

Read More

Global Alert Box in APEX

Description: This is developed as we need customized alert boxes all-over application. A region created in the global page and been referred to in dialog box wherever been called. Step:1:…

Read More