Wednesday, April 17, 2013

Active or Recently Used Printers in Oracle EBS

Recently had a request from one of the admins for list of printers used in the EBS application and how many jobs are directed to a printer. The following SQL provided what the admin needed, thought a good one to share...


select distinct fcr.printer, fu.user_name, 
       fu.description, count(*) jobs
from apps.fnd_concurrent_requests fcr, apps.fnd_user fu
where fcr.requested_by = fu.user_id
and (fcr.printer is not null and fcr.printer not in  ('noprint','LOCAL_PRINT','LOCAL','LOCAL_PRINTTO', 'LOCAL_PREVIEW'))
group by fcr.printer, fu.user_name, fu.description;

The caveat is that if you purge concurrent requests, the information is dependent on the records available in concurrent requests table...

Hope this helps someone, or if there is a better way to find the printer usage, please let me know... have a great day!



No comments:

Post a Comment

Thank you for your time... Appreciate your feedback.