Skip to Main Content



For appeals, questions and feedback, please email

Popup LOV shows the same value in display and return value

I get the same display and return value when I specify the following SQL query in Popup LOV :

select distinct location_name as d, location_id as r from json_table(:P145_RESPONSE_JSON, '$.items[*]'
columns(location_name path '$.participants[*]?( == "location")',location_id path '$.participants[*]?( == "location")'))

Not quite sure why ?

If I swap location_id as display and location_name as return, it gives me the appropriate values although that's not what I want.

Any ideas to fix this.

This post has been answered by Subramaniam Shastri-Oracle on Feb 11 2024
Jump to Answer
Post Details
Added on Feb 11 2024
1 comment