I am on APEX 21.1.5. I did try to reproduce my problem on apex.oracle.com, but I was unable to reproduce in that updated environment.
I have Interactive Grids to which the user can add new rows. These interactive grids filter on a FK. Here is an example:
On this particular example, I also have the following Edit settings:
Now, if and only if the IG opens with no records, I will get an error when I do the following:
- Click “Add Row”
- Click “Delete Row”
- Click “Add Row” again
It shows me this message:
Looking in the console:
desktop_all.min.js?v=21.1.5:6 Uncaught TypeError: Cannot read properties of undefined (reading 'length')
at Object.arrayEqual (desktop_all.min.js?v=21.1.5:6:2245)
at a.<computed>.<computed>._select (interactiveGrid.min.js?v=21.1.5:7:78906)
at a.<computed>.<computed>._select (desktop_all.min.js?v=21.1.5:28:6847)
at interactiveGrid.min.js?v=21.1.5:7:58172
I am very novice when it comes to JavaScript, so I am unsure what to look for here. I will say, I haven't added any JavaScript code that in any way alters this IG programmatically. As shown, I am using ROWID as my PK (this is a legacy table that doesn't have a PK), and for some of my columns I set a default value, for example:
But that's all. I'm not doing anything particularly special or noteworthy. Here is some info about each of my columns (not including APEX$ROW_SELECTOR, APEX$ROW_ACTION, and ROWID):
- Hidden / NUMBER
- Hidden / NUMBER
- Hidden/ NUMBER
- Select List / VARCHAR2
- Number Field / NUMBER / Mask applied (FML999G999G999G999G990D00)
- Number Field / NUMBER / Mask applied (FML999G999G999G999G990D00)
- Display Only / VARCHAR2
- Display Only / DATE / Mask applied (MM/DD/YYYY HH:MI PM)
- Text Field / VARCHAR2
I reviewed the following: