Technology Stack - EBS (MOSC)

MOSC Banner

Disable wildcard search

edited Aug 20, 2021 11:08AM in Technology Stack - EBS (MOSC) 1 commentAnswered

Hi

I have built a custom form in Oracle EBS using TEMPLATE.fmb.

Oracle EBS 12.1.3, Form Builder 10.1.2.0.2

It contains a query find block and another block that has the search results.

The WHEN-BUTTON-PRESSED trigger in the query find block is coded as below

:parameter.G_query_find := 'TRUE';

app_find.find('XX_SR');

:parameter.G_query_find := 'FALSE';

The PRE-QUERY trigger in the search result block is coded as below

--START

IF :parameter.G_query_find = 'TRUE' THEN

COPY(:QUERY_FIND.VENDOR_NAME, 'XX_SR.VENDOR_NAME');
COPY(:QUERY_FIND.PO_NUMBER, 'XX_SR.PO_NUMBER');
COPY(:QUERY_FIND.INVOICE_NUM, 'XX_SR.INVOICE_NUM');

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center