CODEWITHSUNDEEP
oracle-databaseoracle-apexoracle-apex-23
Santi
Santi

Reputation: 1

Oracle APEX Popup LOV on IG

I'm working with Oracle APEX 23.2.3 (Latest Version) and I have an issue. With a Multi Column Popup LOV on an Interactive Grid, I'm trying to set values for 2 columns. The Task ID column, which is the one that has the Popup LOV itself, and the Project ID column. I do this with Additional Output option.

SQL Popup LOV Multi Column Image

This is the SQL Query for the IG.

IG SQL Query NULL Column Image

As you can see, when the Popup LOV column is a NULL column, it works perfectly fine.

Selecting Popup LOV Value Image

But when the Popup LOV column is a DB column, the situation is different.

First situation: if the row doesn't have a task, it works perfectly fine too.

Row With No Task Data Image

Row With No Task Data - Works Fine Image

Second situation: if the row does have a task, it throws an error, although it still works fine and sets both column values.

Error Thrown On Opening Popup LOV Image

Selecting Popup LOV Value with Error Image

If I remove the PROJECTE_ID from Items to Submit to the Popup LOV, then the error is not thrown anymore and everything works fine.

I've tried many combinations until I found out where the problem was coming from, but I can't find a way to solve this.

Thanks in advance!

Cheers.

Upvotes: 0

Views: 407

Answers (0)

Related Questions