ERPstuff - Oracle EBS Community

Hello all,

I would like to get the code to call a report from forms.

How can i do that.

Also what are the setting that i have to do it on forms fields.

Abbas.

HEllo All,

My requirement is to get the reports data into form i.e. there is an ap check report and i would like to create a new form and call those check report fields into that form.

I am writing the following code

declare
v_plist_id paramlist;
pl_name varchar2(50) := 'rep_params';

begin
v_plist_id := get_parameter_list(pl_name);
--check_param_list (pl_name);

if not id_null(v_plist_id) then
destroy_parameter_list(v_plist_id);
end if;

v_plist_id := create_parameter_list(pl_name);

--add_parameter(v_plist_id, 'P_PAYMENT_BATCH', text_parameter, :block_name.item);
add_parameter(v_plist_id, 'PARAMFORM', text_parameter, 'NO');
add_parameter(v_plist_id, 'DESTYPE', text_parameter,:control.dest_type);
add_parameter(v_plist_id, 'DESNAME', text_parameter,:control.dest_name);
add_parameter(v_plist_id, 'DESFORMAT', text_parameter,:control.dest_format);
add_parameter(v_plist_id, 'F_AC_PAYEE', text_parameter,:control.payee);
run_product(reports, 'XXEGAPGBPCHK', asynchronous, runtime,filesystem, v_plist_id, null);
end;


Please suggest/advise how should i get the data populated into the forms in apps 11i. Its urgent.

Regards,
Abbas

hi abbas

i am not sure is it correct or not but i am giving the info
first go to u r form and place a button in that form and write when_button_pressed trigger
in that trigger paste your code and compile it.
it will populate the parameters dynamically.when u press the button