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 your custom form >Go to form level trigger>Select WHEN-NEW-FORM-INSTANCE trigger> Add a piece of code like below

–## Display All records While opening the form ##—-
BEGIN
Go_Block(‘Your Database block name’);
Execute_Query;
END;

Save, deploy to the server and compile the form.