Dear all,
I'm currently building a page in Oracle apex where I have a simple interactive grid, based on one table. In said table there a 2 columns called “LEVEL1” and “LEVEL2”.
Level1 is based on a simple LOV, and seems to be working correctly.
Level2 is based on a “function body returning”, and uses LEVEL1. I've added LEVEL1 as parent item in the cascading LOV part, and also added LEVEL1 to “items to submit”. The good news is, it seems to be working. When I select the value “ROOM” or “TECHNICAL”, the list in LEVEL2 changes. When I select other values, the list is empty (correct).
However, 2 problems…
- Somehow the LOV adds empty (null) lines to the LOV. And the more I change LEVEL1, the more lines in LEVEL2 seem to show up.
- In the DEBUG logging, I get the error "ERR-1002 Unable to find item ID for item "LEVEL1" in application "294553"."
I was able to reproduce this on a temporary workspace, I will put the login details below.
Does anyone have an idea what is causing this, or could this potentially be a bug?
https://oracleapex.com/ords/r/apex/app-builder/apps
WORKSPACE = BUGTEST
User = FORUM_EXPERTS
Pw = randomPassword874#
App = 294553 (only 1 present)
Page = 50
Oracle Version = 24.2.8
Public link: https://oracleapex.com/ords/r/bugtest/bugtesting/questions