Hello everyone,
This is my first post on the forum. First of all, I apologize in advance for any mistakes.
I want the PROFILE_VALUE column in Interactive Grid to get its values from LOV, but my LOV query is dynamic. It returns a SQL query from a function as follows.
return fnd_profiles_pkg.get_lov_query(p_lookup_id => :LOOKUP_ID, p_application_id => 1000);
The LOOKUP_ID I give to this function is another column on the interactive grid.
I chose the LOV type as Function Body returning SQL Query. When I give this function, I get the warning (ORA-20999: PL/SQL function body did not return a value.) It allows me to save it this way, but when I open the screen, it gives an error as in the screenshot.
It does not give an error when there is no value in the PROFILE_VALUE column. It gives an error when there is a value in the column.
How can I go about setting up such a dynamic LOV structure?
Thanks and regards,
Furkan