O'Reilly logo

Oracle E-Business Suite R12 Core Development and Extension Cookbook by Andy Penver

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding a query screen to a form

As part of the TEMPLATE form, we get a standard mechanism to create a query screen. This usually is the first screen that is present when the form opens if no data is passed to the form via parameters. This allows the user to search for specific records. In our form, we want to create a query form that allows us to search for an employee. We want the user to be able to search by their name or their employee number. There are a number of steps required to implement a QUERY_FIND window. In this recipe, we are going to perform the following tasks:

  • Adding code to the WHEN-NEW-FORMS-INSTANCE trigger
  • Copying the QUERY_FIND object group
  • Setting the block, canvas, and window properties
  • Editing the button triggers on the QUERY_FIND ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required