{"id":2043,"date":"2013-04-17T14:43:00","date_gmt":"2013-04-17T14:43:00","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=5"},"modified":"2026-02-07T15:11:41","modified_gmt":"2026-02-07T21:11:41","slug":"active-or-recently-used-printers-in-oracle-ebs","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2013\/2043\/","title":{"rendered":"Active or Recently Used Printers in Oracle EBS"},"content":{"rendered":"<div dir=\"ltr\">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&#8230;<\/p>\n<div><\/div>\n<div>\n<pre class=\"nums:false nums-toggle:false lang:default decode:true \">select distinct fcr.printer, fu.user_name,\u00a0\n\u00a0 \u00a0 \u00a0 \u00a0fu.description, count(*) jobs\nfrom apps.fnd_concurrent_requests fcr, apps.fnd_user fu\nwhere fcr.requested_by = fu.user_id\nand (fcr.printer is not null and fcr.printer not in \u00a0('noprint','LOCAL_PRINT','LOCAL','LOCAL_PRINTTO', 'LOCAL_PREVIEW'))\ngroup by fcr.printer, fu.user_name, fu.description;<\/pre>\n<p>The caveat is that if you purge concurrent requests, the information is dependent on the records available in concurrent requests table&#8230;<\/p>\n<\/div>\n<div><\/div>\n<div>Hope this helps someone, or if there is a better way to find the printer usage, please let me know&#8230; have a great day!<\/div>\n<div><\/div>\n<div><\/div>\n<p>&nbsp;<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>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&#8230; select distinct fcr.printer, fu.user_name,\u00a0 \u00a0 \u00a0 \u00a0 \u00a0fu.description, count(*) jobs from apps.fnd_concurrent_requests fcr, apps.fnd_user &#8230; <a title=\"Active or Recently Used Printers in Oracle EBS\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2013\/2043\/\" aria-label=\"Read more about Active or Recently Used Printers in Oracle EBS\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10,22],"tags":[144],"class_list":["post-2043","post","type-post","status-publish","format-standard","hentry","category-ebs","category-scripts-tools","tag-printer"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2043","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=2043"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2043\/revisions"}],"predecessor-version":[{"id":2967,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2043\/revisions\/2967"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=2043"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=2043"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=2043"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}