Home » Applications » Oracle Fusion Apps & E-Business Suite » Access Report Through Forms in Apps 11i
Access Report Through Forms in Apps 11i [message #385518] Tue, 10 February 2009 00:09
abbas9001
Messages: 20
Registered: April 2008
Location: Hyderabad
Junior Member
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
Previous Topic: How to import Configured Items in Oracle Apps
Next Topic: Concurrent Reports in OLM (HRMS)
Goto Forum:
  


Current Time: Sat Dec 10 16:49:58 CST 2016

Total time taken to generate the page: 0.06209 seconds