Skip to Main Content

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!

Unable to find item ID for item "F01" , APEX_ITEM related

bin zhangMar 15 2022

Hi,
I have a dynamic form. http Request input is a JOB_NAME, then a PL/SQL dynamic content region executes below query to get which text box to show.
select item_index,item_type,item_label,default_value,....,map2parameter from job_input_ui_definition where job_name=:P10_JOB_NAME;
then it calls
htp.p(apex_item.text(p_idx=>i.item_index,p_item_id=>'f'||to_char(i.item_index,'FM09'), p_value => i.default_value,p_size=i.item_width,p_maxlength=>i.item_maxlength));
to print necessary html form items for that job.
Then user input value for all text box. then later in submit, i can use apex_applicaiton.g_f01(1) to get the user input.
everything works well at this point. the single form can work for all different jobs as long as I config job input item into table job_input_ui_definition.
Now i have a new requirement to show different default value for a job text box. User don't need to input all text box, user just click a link type column from a classic report. each column in a the classic report is mapped to a dynamic text item in the form.
i know in job form html, the <input> has name="f01" id="f01", I try use a link builder.
f01.jpgbut i get below error when click the link.
err1002.jpgDoes APEX support set value for dynamic apex item in http request?

Comments
Post Details
Added on Mar 15 2022
2 comments
281 views