EBS Customizations (MOSC)

MOSC Banner

Value Set for Concurrent Request - Where clause not working

edited Jul 25, 2019 5:03AM in EBS Customizations (MOSC) 10 commentsAnswered

I am creating a application value set LOV for a custom report. It works except it does not exclude the disabled values from the LOV.  The validation set has a validation type = Table. Below is a screen shot of how I defined it. However, the LOV is returning rows for items where the data_to is populated. My expectation/goal is that if date_to is not null then the rows will not be part of the LOV. What am I doing wrong?

Here is the definition:

Thanks!

Nancy

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