13 Replies Latest reply: Apr 19, 2013 3:55 AM by Patrick Wolf-Oracle RSS

    APEX 4.2 cascading LOV with select lists not working for mobile UI

    959525
      Hi, I have a cascading LOV problem. It appears to work on my browser, but when I access the page on a smartphone I receive the following error message:

      http://apex.oracle.com
      Error: parsererror - Syntax Error
      unable to parse JSON string

      Appreciate any assistance. Larry
        • 1. Re: APEX 4.2 cascading LOV with select lists not working for mobile UI
          David Gale-Oracle
          Larry,

          Mind giving us a bit more information? Say, a URL we could go to to test, perhaps? Sample query? Maybe even the type of smartphone?

          It's awfully hard to figure out what's going wrong when we have to guess at all of the details.

          -D.
          • 2. Re: APEX 4.2 cascading LOV with select lists not working for mobile UI
            959525
            Hi, thanks for getting back with me.

            URL is apex.oracle.com/pls/apex/f?p=10416:101

            Login is ljkay@actaexpress.com password is mrcrd2083

            After logon choose Document CDAC Shift

            Go down to the field where it says Select Service Code

            Chose any item, then the error will pop up.

            Thanks again. Larry
            • 3. Re: APEX 4.2 cascading LOV with select lists not working for mobile UI
              David Gale-Oracle
              Larry,

              Those login credentials don't seem to work.

              -D.
              • 4. Re: APEX 4.2 cascading LOV with select lists not working for mobile UI
                959525
                My bust David, the password is mcrd2083, not mrcrd2083...sorry. Larry
                • 5. Re: APEX 4.2 cascading LOV with select lists not working for mobile UI
                  David Gale-Oracle
                  Larry,

                  Good news and bad news. Good news: I'm able to replicate your issue--page working on a desktop system, but throwing a parse error on an iPhone--in your application. Bad news: I'm not able to replicate it in a [url http://apex.oracle.com/pls/apex/f?p=13954:1]simple sample application (login: test/test) of my own.

                  I did note that you're not using the default select list--clicking on one of your page items brings up a box of choices, rather than the iPhone's default "wheel" interface. What are you using, and does the problem resolve itself if you switch to the standard select list?

                  -D.
                  • 6. Re: APEX 4.2 cascading LOV with select lists not working for mobile UI
                    959525
                    Hi David, thanks for taking the time to check it out. When I'm creating the page items, it let's me choose select list,which is what I do. Where do I find the default select list? Apologies for the probably simple question, I'm a bit of a novice at APEX. Thanks again. Larry
                    • 7. Re: APEX 4.2 cascading LOV with select lists not working for mobile UI
                      Patrick Wolf-Oracle
                      Hi Larry,

                      you did nothing wrong. I will have a look on Monday. Please keep your data because it appears to be data related.

                      As a test, can you set the application attribute "Escaping" (or something similar) from "Extended" to "Basic" (Edit Application Properies -> Security)

                      Regards
                      Patrick
                      • 8. Re: APEX 4.2 cascading LOV with select lists not working for mobile UI
                        Patrick Wolf-Oracle
                        Hi Larry,

                        does the problem still reproduce? I noticed that the page has changed and the "Service Code" select list isn't a cascading LOV anymore. I also noticed that you have set the "HTML Escaping Mode" to Basic. Did that resolve the problem?

                        Do you still have an app where the problem reproduces so that I can have a look?

                        Regards
                        Patrick
                        -----------
                        My Blog: http://www.inside-oracle-apex.com
                        APEX Plug-Ins: http://apex.oracle.com/plugins
                        Twitter: http://www.twitter.com/patrickwolf
                        • 9. Re: APEX 4.2 cascading LOV with select lists not working for mobile UI
                          Jeremy T James
                          I am now experiencing this same issue. The application is not accessible from the internet, but the code is as follows:

                          select distinct
                          data.display_val,
                          data.return_val
                          from
                          (
                          select
                          mp.organization_code || ' (' || hlat.location_code || ')' display_val,
                          mp.organization_code return_val
                          from
                          mtl_parameters mp,
                          hr_all_organization_units hr,
                          hr_locations_all hlat,
                          APPS.LVY_EXACT_USER_TO_ORG uto
                          where
                          mp.eam_enabled_flag = 'Y'
                          and mp.organization_id = hr.organization_id
                          and hlat.location_id = hr.location_id
                          and uto.person_id = :P1_PERSON_ID
                          and uto.org_code = mp.organization_code
                          and nvl(uto.effective_start,sysdate) <= sysdate
                          and nvl(uto.effective_end,sysdate) >= sysdate
                          union
                          select
                          mp.organization_code || ' (' || hlat.location_code || ')' display_val,
                          mp.organization_code return_val
                          from
                          mtl_parameters mp,
                          hr_all_organization_units hr,
                          hr_locations_all hlat
                          where
                          mp.eam_enabled_flag = 'Y'
                          and mp.organization_id = hr.organization_id
                          and hlat.location_id = hr.location_id
                          and :P1_SUPER_USER = 1
                          ) data
                          order by 1

                          when I use only:
                          select
                          mp.organization_code || ' (' || hlat.location_code || ')' display_val,
                          mp.organization_code return_val
                          from
                          mtl_parameters mp,
                          hr_all_organization_units hr,
                          hr_locations_all hlat,
                          APPS.LVY_EXACT_USER_TO_ORG uto
                          where
                          mp.eam_enabled_flag = 'Y'
                          and mp.organization_id = hr.organization_id
                          and hlat.location_id = hr.location_id
                          and uto.person_id = :P1_PERSON_ID
                          and uto.org_code = mp.organization_code
                          and nvl(uto.effective_start,sysdate) <= sysdate
                          and nvl(uto.effective_end,sysdate) >= sysdate

                          I do not get the error, but when I add the additional values for a super user (who sees all of the values) I do get the error.

                          Data returned:
                          1PL (LEVY PLANT 1)     1PL
                          AAH (AA HIGHLAND PLANT)     AAH
                          AAP (ACE ASPHALT GARAGE)     AAP
                          BMW (BURROUGHS N WALLACE)     BMW
                          CBH (CALUMITE BURNS HARBOR)     CBH
                          CCC (CLAWSON CENTRAL SERV)     CCC
                          DEL (DELTA TRUCKING)     DEL
                          GMO (GMS MOBILE)     GMO
                          IFS (INDIANA FLAME SERV)     IFS
                          IMF (IMI GM FOUNDRY)     IMF
                          IMI (IMI OFFICE)     IMI
                          MAC (MESA COOLIDGE PLANT)     MAC
                          MAG (MESA PLANT)     MAG
                          MCC (COLUMBIA CITY MS)     MCC
                          MEE (MEMPHIS MOBILE EQUIPMENT)     MEE
                          MMB (BUTLER MS)     MMB
                          MMC (CHARLESTON MS)     MMC
                          MMD (DECATUR MS)     MMD
                          MMF (FULTON MS)     MMF
                          MMT (CANTON MS)     MMT
                          MMW (WHITESVILLE MS)     MMW
                          SAC (SAG ASP CROW ISL ASP)     SAC
                          SAP (SAG ASP PAVING COMP)     SAP
                          SCC (SCHMIDT CON DELTA)     SCC
                          SPA (SSP ALPENA)     SPA
                          STM (SEATAC STEEL MILL AND RECYCLING SERVICES)     STM
                          TLC (THE LEVY CO GARAGE)     TLC
                          WYN (WAYNE ENGINEERING)     WYN
                          • 10. Re: APEX 4.2 cascading LOV with select lists not working for mobile UI
                            Jeremy T James
                            At the point where the 24th record was added...and the select list turned into the entire page with black screen behind it rather than a drop down where the issue appears. As long as the list of values is less than 24 (in my case) the dynamic actions work fine. Is there a fix that will allow the dynamic actions even in the case where the list is long and displays as the scrollable page rather than a drop down list?
                            • 11. Re: APEX 4.2 cascading LOV with select lists not working for mobile UI
                              Patrick Wolf-Oracle
                              Hi,

                              this is bug# 16527183 - mobile: cascading lov doesn't work if select list is displayed in dialog
                              which will be fixed in our upcoming patchset 4.2.2

                              Regards
                              Patrick
                              -----------
                              Member of the APEX development team
                              My Blog: http://www.inside-oracle-apex.com
                              APEX Plug-Ins: http://apex.oracle.com/plugins
                              Twitter: http://www.twitter.com/patrickwolf
                              • 12. Re: APEX 4.2 cascading LOV with select lists not working for mobile UI
                                Jeremy T James
                                OK, thank you! Is that already released or coming soon?
                                • 13. Re: APEX 4.2 cascading LOV with select lists not working for mobile UI
                                  Patrick Wolf-Oracle
                                  Hi Jeremy,

                                  can't comment on release dates, but we plan to upgrade apex.oracle.com with a pre-release very soon.

                                  Regards
                                  Patrick
                                  -----------
                                  Member of the APEX development team
                                  My Blog: http://www.inside-oracle-apex.com
                                  APEX Plug-Ins: http://apex.oracle.com/plugins
                                  Twitter: http://www.twitter.com/patrickwolf