Apex Multi Value Item Does Not Work if it's >= 100th Item on Page (Doc ID 1960965.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 4.2.1.00.08 and later
Information in this document applies to any platform.

Symptoms

Multi Value items of type Checkboxes, Select Lists (Multiple = Yes) or Shuttles will not work if they are >= the 100th item on the page. They will always be mapped to the internal p_v10 parameter of the wwv_flow.accept procedure. Single value item types work fine.

 

For example: Checkbox item naming is incorrect when >= 100 items. If you have a page which contains >=100 items and there is one or more checkboxes which are in "position 100 or more", e.g. 109, 110 etc, then instead of the name of the item in the HTML being "p_v109" or "p_v110", it becomes "p_v10" or "p_v11". It looks like the name is constructed from the first two characters of the "item number", so would end up with 10 checkboxes with the same name "p_v10" (if you had checkboxes at position 100-109)., "p_v11" (for checkboxes at 110-119) etc.

Create a page with > 100 items on it and ensure that the checkbox (or Select List which would get rendered as a "p_v" item is rendered in the 100th position or greater. If you look at the name of the checkbox in the HTML from position 100 onwards, it will be p_v10 rather than p_v100 etc.

source html shows:
<excerpts>
...
<input type="checkbox" id="P2_98_0" name="p_v98" value="Y"  ><label for="P2_98_0">Y</label>
</fieldset>
</td></tr><tr><td nowrap align="right"><label for="P2_99" class="uOptional">99</label></td><td  align="left"><input type="hidden" name="p_arg_names" value="66033378220055647430" /><fieldset tabindex="-1" id="P2_99" class="checkbox_group"  >
<legend class="hideMeButHearMe">99</legend>
<input type="checkbox" id="P2_99_0" name="p_v99" value="Y"  ><label for="P2_99_0">Y</label>
</fieldset>
</td></tr><tr><td nowrap align="right"><label for="P2_100" class="uOptional">100</label></td><td  align="left"><input type="hidden" name="p_arg_names" value="66033378414224647431" /><fieldset tabindex="-1" id="P2_100" class="checkbox_group"  >
<legend class="hideMeButHearMe">100</legend>
<input type="checkbox" id="P2_100_0" name="p_v10" value="Y"  ><label for="P2_100_0">Y</label>
</fieldset>
</td></tr><tr><td nowrap align="right"><label for="P2_101" class="uOptional">101</label></td><td  align="left"><input type="hidden" name="p_arg_names" value="66033378601905647431" /><fieldset tabindex="-1" id="P2_101" class="checkbox_group"  >
<legend class="hideMeButHearMe">101</legend>
<input type="checkbox" id="P2_101_0" name="p_v10" ...
...
...


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms