This discussion is archived
13 Replies Latest reply: Apr 19, 2013 1:55 AM by Patrick Wolf RSS

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

959525 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points