This discussion is archived
4 Replies Latest reply: Aug 15, 2013 9:29 AM by SATim RSS

Shuttle oddity - Not populating all values

SATim Newbie
Currently Being Moderated

APEX 4.1

Oracle 11g

 

I have a form where you select a department, P37_PROD_DEPT_CD, select list

Always replacing any existing value in session state

Static Assignment

 

<code>

select PROD_DEPT_CD || ' ' || PROD_DEPT_NM d, PROD_DEPT_HIER_CD r

from PRODUCT_DEPARTMENT

WHERE PROD_DEPT_CD != '-1'

order by 1

</code>

 

Now select a subdepartment, P37_PROD_SUBDEPT_CD, shuttle

Always replacing any existing value in session state

Static Assignment

 

<code>

SELECT prod_subdept_hier_cd || ' ' || prod_subdept_nm d, PROD_SUBDEPT_HIER_CD r

FROM apnew.PRODUCT_SUBDEPARTMENT

WHERE prod_dept_cd in (select substr(column_value,1,3) FROM TABLE(util.split( :P37_SUBDEPT_CD_HIDDEN, ':')))

AND PROD_SUBDEPT_CD not in ('888')

ORDER BY d

</code>

 

Where

P37_SUBDEPT_CD_HIDDEN

Always replacing any existing value in session state

Item source = P37_PROD_SUBDEPT_CD

 

Returns:

dr
936-237 OUTDOOR GAMES/TAILGATE936-237
936-239 LARGE TRAMPOLINES936-239
936-278 COOLERS936-278
936-279 GRILLING936-279
936-281 FURNITURE936-281
936-287 SHELTERS936-287

 

 

Now select a class,  P37_PROD_CLASS_CD, shuttle

Always replacing any existing value in session state

Static Assignment

 

<code>

select PROD_CLASS_HIER_CD ||' '|| PROD_CLASS_NM d, PROD_CLASS_HIER_CD r

from PRODUCT_CLASS

WHERE instr(:P37_PROD_SUBDEPT_CD,prod_subdept_hier_cd ) > 0

order by 1

</code>

 

This code returns a class for all values except 936-278 Coolers.

 

When I run the code in the database using the subdepartment value of 936-278, it returns the following but not in APEX.

 

dr
936-278-135 PERSONAL COOLERS <20QTS936-278-135
936-278-136 TEAM LICENSED COOLERS936-278-136
936-278-140 FAMILY COOLERS 20QTS+936-278-140
936-278-145 SOFT SIDE COOLERS936-278-145
936-278-150 THERMO ELECTRIC COOLERS936-278-150
936-278-155 ACCESSORIES COOLERS936-278-155
936-278-160 JUGS936-278-160
936-278-163 MARINE COOLERS936-278-163

 

I'm stumped.  There are no filters, I've tried adding trim to the subdepartment return and the where clause in the class selection.  Debug shows no errors.  Firebug shows the correct value in the DOM.

 

Has anybody see this behavior?  How do I get this one class to populate in the shuttle?

  • 1. Re: Shuttle oddity - Not populating all values
    Hari_639 Guru
    Currently Being Moderated

    Hello,

     

    Have you specified "P37_PROD_SUBDEPT_CD" as "Cascading LOV Parent Item(s)" for "P37_PROD_CLASS_CD" item?

     

    Regards,

    Hari

  • 2. Re: Shuttle oddity - Not populating all values
    SATim Newbie
    Currently Being Moderated

    Thanks Hari.  Good suggestion.  The subdepartment and class are independent though.  When selecting the left subdepartment shuttle, it populates the left class shuttle.  You can selet the subdept and move to right, then highlite another subdept, get the class and select class and move that to the right.  The processing then uses the shuttle right values.  With that said I tried it anyway and still the same behavior.  I did find some javascript in the HTML Form Element Attribs and am working through that to see if that is my culprit.

  • 3. Re: Shuttle oddity - Not populating all values
    Hari_639 Guru
    Currently Being Moderated

    Can you set-up an example @ apex.oracle.com? That will be helpful to understand your requirement and the issue better

     

    Regards,

    Hari

  • 4. Re: Shuttle oddity - Not populating all values
    SATim Newbie
    Currently Being Moderated

    Finally getting a chance to get back to this issue.  It looks like you were right with the cascading LOV.  The Page items to submit was the culprit.  It was set to the wrong item and when I change it to the class cd, it fixed the problem.  It still is weird compared to the other subdepartments.  When you highlight in the left subdept shuttle, the class values appear for everything except my one problem child still.  After updating the LOV, they still do not appear until you move the subdept to the right shuttle.  But at least they appear now.  Thanks.

Legend

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