Blog / Category
Oracle Forms
11 articles in this category
How To PLAY_SOUND in Oracle Forms
Introduction Play sound is used to play audio files in Oracle Forms, Play Sound plays the sound object in the specified sound item PLAY_SOUND examples The follo…
Populating TDS Tax Category through Form Personalizations
Objective: Populate TDS Tax Category for multiple lines through the custom procedure for an invoice before doing the validation and at the time of Action button…
How to disable of the Add New Record Button, Clear Button and Delete Button from the Oracle apps Custom Form Oracle Apps R12.
Overview In order to disable New Record Button, Clear Button and Delete Button, Please follow below step Write the code in the Form Level Trigger (WHEN-NEW-BLOC…
Change group query associated to LOV Using Forms Personalization in Oracle Apps R12
Overview Requirement: We have to change the “type” field LOV query for populating the custom values. To achieve this we have to follow the below process. Step-1…
To display all data for a particular block while opening the EBS form.
Overview Sometimes having a requirement to display all block data whenever form is open. In order to achieve please follow below step, Open Form builder> Open y…
Disable Descriptive Flex field (DFF) at form level through CUSTOM.pll
Sometimes, We have a requirement to disable the DFF at form level. Either have to do disable the DFF as well or Read-Only of the attribute of the DFF. So, First…
Using Oracle Forms to load local files
using the below code In load file “button” using “when-button-pressed” trigger. DECLARE l_userhome &…
Oracle Forms – Dynamic Message Tool Tip
Multiple tooltip message in single text field Step 1:- Create canvas and Using below script. Below screen shot for reference. Step 2 Create Text_field and Using…
Oracle Forms – Stacked Canvas creation over the Content Canvas
This article explains the technical aspects of developing a Stacked Canvas in Oracle Forms. Canvas is a surface inside a window container on which we pla…
Implementing Search Functionality using LOV during query in Oracle Forms
Requirement : Enable ‘Execure-Query’ using an LOV field (non-database items) . Approach: When user clicks on CTRL+F11 we need set dynamic where clause. No…
Parsing Comma Separated string in WHERE Clause of SQL Statement in Oracle Forms
In some cases, we get a comma separated string as output (say from another select statement or block) that we would need to pass to the IN clause of a Select st…