Skip to Main Content
Forums

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 cascading popup lov bug?

ApexMeisterFeb 1 2017 — edited Sep 4 2017

I'm using apex 5.1, universal theme and 11g db.

I have a table with deptno and empno columns.

I created a page with IG and add popup lov for both the deptno and empno.

For the empno column.I specified

1. sql query => select empno, name from emp where deptno = :DEPTNO

2. cascading lov parent = DEPTNO

The POPUP lov for deptno works but when you access the emplov I get the error below.

Please note I verified the select statement to make sure its valid, thanks!

pastedImage_7.png

Comments

User173939

I have the same issue.  Works fine using Select List but get this error when using Popup LOV.  I have opened an SR this afternoon about it.

EDIT:  SR said its a known bug and will be fixed with APEX 5.1.1

MarianoSerra-Oracle

Hi, I'm having the same issue, but I'm using Select List items,

The wierd thing is that it was working and I don't know which change I made and now it is not working anymore.

I've tried to delete the entire Interactive Grid and start all over but I still geting the issue.

Any help will be appreciated.

Thanks.

MarianoSerra-Oracle

I found the reason why I'm geting the error using select list.

I changed the Interactive Grid template to "none", and this make the error appears.

Now I put back standar template and it is working again.

Thanks.

S_McNeill

Hi, I am having the same issue and am on 5.1.1.00.08.  Is it possible to share the bug # from the SR so we can track this also?  Thanks!

User173939

That is disappointing to hear.  I have not had a chance to upgrade to 5.1.1 yet to test this out.  The existing bug that they referenced in my SR was:

Bug 25117499 : IN IG REPORT, COLUMN TYPE POP-LOV WITH CASCADING LOV SET THROWS ERROR.

S_McNeill

Thanks for the quick response.  Looks like that bug # is unfortunately not in the 5.1.1 release notes list:  http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-511-patch-set-notes-3661846.html

Our DBA tried to look up your bug number and apparently it's not public.  Does it show a status for you, or indicate that it might still be in a future patch set?

Another person was also having this problem:  Oracle APEX 5.1 Interactive Grid - LOV contents should be different for each row   I'm going to try to implement the workaround described but prefer the feature worked.

1 person found this helpful
User173939

No problem.  I am no able to see the bug details either.  We may have to open an SR about the status of it.  Thanks for the other link too

John Snyders-Oracle

I can confirm that the bug did not make it into 5.1.1 and current target is 5.1.2 but can't promise it will make it or say when 5.1.2 will be ready.

Regards

-John

Nikhil Reddy A

Hi John,

Heard that Apex 5.1.2 is released.

Do you know if this bug is fixed, I went throught he release notes but could not find it (may be I am looking for a wrong description)

Best Regards

-Nihkil

John Snyders-Oracle

Hi

Bug 25117499 is marked fixed in 5.1.2. It was not set to publish (don't know why) which is why it is not listed in the release notes.

Regards,

-John

1 person found this helpful
Nikhil Reddy A

Thanks John for the Information.

Best Regards

-Nikhil

User173939

I have confirmed that this is working in APEX 5.1.2!

However I wonder if this is a bug:

When you define a field as a PopUP LOV and allow it to be "enterable" then value the user enters manually isn't validated against the LOV values.

Marco1975

We have installed version 5.1.2 and the bug has been resolved.

Regards,

Marco

1 - 13
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 2 2017
Added on Feb 1 2017
#apex-discussions
13 comments
14,294 views