Yearly Archives: 2020

Interactive Report Filter Query

1. Overview This document will be helpful to find the query in the IR report when the filter condition is applied dynamically. (Source code should be in SQL format ). 2.…

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

Dynamic Height Adjusting For Text Area Using JS

This blog talks about how to adjust the height of a Text Area automatically using JavaScript. We know that a text area can hold a multi-line text input and you…

Read More

Simple File Browser Item To Drag and Drop Look and Feel In Oracle Apex

This document is about  to change a style of simple file browse item to Drag and Drop look and feel. Technologies  Used: Oracle Apex Javascript CSS Use Case: By default,…

Read More

Fade Out Alert Message In Oracle Apex

Fade Out Alert Message In Oracle Apex   The fadeOut() method gradually changes the opacity, for selected elements, from visible to hidden (fading effect). Note: Hidden elements will not be displayed at all (no longer affects the layout of the page). Syntax: $(selector).fadeOut(speed) speed Optional. Specifies the speed of the fading effect. The default value is 400 milliseconds Possible values: · milliseconds · “slow” · “fast”…

Read More

Download Jasper Report with Dynamic Names from Oracle Apex

This document is to download jasper report with dynamic names from oracle apex. Technology and Tool Used : Oracle Apex Jasper Reports Javascripts HTML Use Case : If a requirement…

Read More

Integrating JavaScript map chart with APEX

Integrating JavaScript map chart with APEX This document talks about how to Integrate APEX with JavaScript map chart.   Technologies and Tools used: The following technologies has been used to…

Read More

Pay Alone Functionality in Oracle Fusion Application

pay-alone-functionality-in-oracle-fusion-application

Read More

GST Number Updation for a Customer Record

PL/SQL Anonymous Block to update Customer GST number: As we do not have any Standard API / Process to update the GST number in Oracle, the only way to correct…

Read More

Reasons for an AP invoice not selected in a Payment Batch

  AP invoice should not be selected by any other PPR The payment schedule’s relevant date should be between the PPR’s Pay From and Pay Through dates. The relevant date…

Read More