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…


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!

 

2 Responses to Active or Recently Used Printers in Oracle EBS

  1. Good one, Biju! Thanks for sharing.

Leave a Reply

%d bloggers like this: