Technology Stack - EBS (MOSC)

MOSC Banner

Mapping Picklist field in Search Region to NULL value in a table

I have a requirement where in there is a field "Operating Unit" which has a pick list assigned to it.

This field is in a Search Region.

Currently if don't enter any value for this field and do a search , it returns all the records from the table, irrespective of the operating unit.

The requirement is to:

If a user does a search without any value in this field, then it should return only those records from the table, where in the "OPERATING_UNIT" column is NULL.

Can someone please suggest how to achieve this.

Thanks

Sunil

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