Trouble shooting Oracle Apps (EBS) printer issues can be a headache sometimes

Add the printer in Oracle E-business Suite

Login as Oracleerp user
Install -> Printers--> register

Put the printer name and select the printer type 

For example :  HPLJ3-A4

Few Printer related setups and issue at the OS Server level: 
============================================
To confirm whether the issue is from application end or from the Network/Hardware at Physical end.

So as an Apps DBA we could do the following to get to the root Cause
(After checking that all the printer configuration values such as printer name , print style,driver,etc are present as required in EBS Application).
Also if its newly added server check if the printer host details are entered in /etc/hosts

To check whether printer is enabled or disabled  on the unix server

lpstat -p infy_prt1
printer infy_prt1 disabled since Tue 29 Dec 2015 12:20:40 PM GST -
        No %%BoundingBox: comment in header!

 ping infy_prt1
PING infy_prt1.us.com (86.96.203.59) 56(84) bytes of data.

^C
--- infy_prt1.us.com ping statistics ---
60 packets transmitted, 0 received, 100% packet loss, time 59811ms

Login to the Unix server where the EBS application is running and do the following steps

prod apps $ cat test.log
Test print

Below is the command to print  from unix server.
 lp -d 0668 abc.log
request id is 0668-1983004 (1 file(s))
Data file sent successfully

If the request is able to go to the printer queue than there is no issue from Unix level of the printer configuration Else the Unix team needs to check the Printer setup on the server.

Now if the request is going to the queue and then not able to process at the printer level then physical intervention maybe required to see if  what the issue is with the printer

General Process for Printer Setup steps on EBS environment
1.       Windows Group defines the printer on print server
2.       Linux Team takes that Windows printer server name and defines Linux Print Queue Definition
3.       Oracle DBA’s use the Linux printer created to define the printer in E-Business Suite.

Some useful  Printer related commands on Unix servers :
========================================

 "lpq -a" from your unix application server   this will print all jobs in printer queues 

i.e 
[applprod@erpprod ~]$  lpq -a
Rank    Owner   Job     File(s)                                Total Size
1st     applpro 1116    TEST.txt                                 1024 bytes
2nd     applpro 1117    pasta58079_0.tmp                8648704 bytes

3rd     applpro 1118    pasta16518_0.tmp                11264 bytes

alternately you could also use "lpstat -o" 

 lpstat -o
B57-ENG2-1116           applprod          1024   Mon 09 Sep 2019 08:06:00 AM GST
B57-ENG2-1117           applprod       8648704   Mon 09 Sep 2019 08:34:04 AM GST
B57-ENG2-1118           applprod         11264   Mon 09 Sep 2019 09:50:01 AM GST

Cancel the current job on the default printer:

           lprm

       Cancel job 1234:

           lprm 1234

       Cancel all jobs:


           lprm -

Below is example how to  the list of Printers configured on Unix server :

 lpstat -v
device for 9p03-B56: lpd://199.8.8.37
device for 9903-FF: lpd://199.8.8.215
device for 9903-GF: lpd://199.8.8.252/lp
device for infy_prt1MaterialDPT: lpd://199.8.8.246
device for infy_prt_Finance: lpd://1199.8.8.245/lp
device for infy_prt1: hp:/net/HP_LaserJet_5200?ip=199.8.8.247
device for infy_prt2: hp:/net/HP_LaserJet_5200?ip=199.8.8.248

device for Colourcube-9303-B57: lpd://192.6.0.15