Page 1 of 1

check printing

Posted: Fri Sep 14, 2007 9:38 am
by ORACLE123
hi
I have problem for check printing.i want to submit 3 request for check print first original copy ,second finance ,third file.fnd_request is not helpful can anybody give soln for this

Thanks
Avinash

Posted: Wed Sep 19, 2007 4:25 pm
by anne simms
I have used the following in the past:

/*******************************************************
Update statement for applications
to print two copies for any report.
******************************************************/


UPDATE fnd_conc_pp_actions -- Table for applications
SET number_of_copies =2
WHERE concurrent_request_id = fnd_global.conc_request_id; -- By user request id
COMMIT;

Anne