Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Interactive Grid Error "Uncaught TypeError: Cannot read properties of undefined (reading 'length')"

Jared CNov 12 2024

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:

  1. Click “Add Row”
  2. Click “Delete Row”
  3. 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:

Comments
Post Details
Added on Nov 12 2024
6 comments
1,259 views