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 … Read more