Oracle APEX 20.2 Problem with the cascading LOV (built on Web Source) in an Interactive Grid

Question

I have a master form and a detail interactive grid.

And I have two LOV's on the interactive grid, both of them are built on Rest Web Source.

First LOV is a master & the second one is the cascading LOV with a parameter from the master.

The problem is that the cascading LOV does not fetch any data.

I noticed that when I make the master LOV to be in the form (not in the IG), the cascading LOV works fine and fetches data.

But if both of them are on the IG, the parameter of the first LOV not passed to the cascading LOV, so it returns no rows.

I don't know if this is a bug in APEX 20.2 or what.

if anyone can help, I will appreciate that a lot.

Thanks,

Master LOV

Cascading LOV

!Parent IG Column

Child IG Column

Answer 1

When you turn on Debug, and review debug output for your Interactive Grid, are there any error messages logged?

Can you stage a test case for your issue on apex.oracle.com, so that we can see what you actually implemented and review? For the test case, you might use SQL Workshop > REST Services to create simple REST APIs on the EMP and DEPT tables, which you could use for REST Data Sources and for the LOVs.