APEX version: 22.1.0
We get an "APEX - ERR-1002 Unable to find item ID for item" in our application when we do the following:
- Go into Cell Selection mode F8
- Select multiple cells beneath each other in the same column
- Then use the [Fill] function on the selected cells
It throws: APEX - ERR-1002 Unable to find item ID for item "C24931535621788113507" in application "200280". - Unexpected error, unable to find item name at application or page level.
There is a Dynamic Action on the column that executes some PL/SQL code and submits the IG column in "Items to Submit".
*Please note:
[Copy Down] and [Clear] work perfectly.
Also, when multiple cells are selected in the same row and then [Fill] is applied, it works perfectly.
It's only when cells are selected in different rows that the error is thrown.
I've tested this in the latest APEX 23.2.0-17 on apex.oracle.com and it's doing the same there.
There is a simplified demo on apex.oracle.com which shows this behaviour:
Workspace:
headbyte
Username: demo
Password:
Demo1234
In order to replicate the issue on apex.oracle.com:
- Run app Sandbox
- Go into Cell Selection mode F8
- Select some cells in column [The Value]
- Use the [Fill] function
It throws: Ajax call returned server error ORA-20987: APEX - ERR-1002 Unable to find item ID for item "THE_KEY" in application "299764". - Unexpected error, unable to find item name at application or page level. for ajax_set_session_state.
See attached screen dump of error.
Many thanks in advance
Andre'
