Printer Setup Used for a concurrent program

There might be cases where the printer of the concurrent program might not function properly. There may be errors in printer setup etc. In order to check this, execute the following 3 sqls. 

Get the request id of the concurrent program. And execute the following sequels.

This sql*plus statement will provide general information about printer setup used for the request. (printer name, printer style, orientation, number of copies, NLS setup, log and output file name etc)

SELECT NUMBER_OF_COPIES ,
               NLS_LANGUAGE ,
               NLS_TERRITORY ,
               PRINTER ,
               PRINT_STYLE ,
               COMPLETION_TEXT ,
               OUTPUT_FILE_TYPE ,
               NLS_CODESET ,
               OUTFILE_NODE_NAME,
               OUTFILE_NAME
  FROM FND_CONCURRENT_REQUESTS 
WHERE REQUEST_ID= &REQID




This second one will provide information about the printer style used.
(Printer style name, number of lines / columns, orientation, SRW driver associated)

SELECT PRINTER_STYLE_NAME ,
                SRW_DRIVER ,
                WIDTH , 
                LENGTH ,
                ORIENTATION
   FROM FND_PRINTER_STYLES
WHERE PRINTER_STYLE_NAME= ( SELECT PRINT_STYLE FROM FND_CONCURRENT_REQUESTS
      WHERE REQUEST_ID = &REQID)




The last one provides you about the printer driver used.
(Printer driver name, printing method, spool, associated SRW driver,command used for printing, initialization and reset strings)
SELECT PRINTER_DRIVER_NAME,
                USER_PRINTER_DRIVER_NAME ,
                PRINTER_DRIVER_METHOD_CODE ,
                SPOOL_FLAG ,
                SRW_DRIVER ,
                COMMAND_NAME ,
                ARGUMENTS ,
                INITIALIZATION ,
                RESET
   FROM FND_PRINTER_DRIVERS
WHERE PRINTER_DRIVER_NAME =( SELECT PRINTER_DRIVER
                               FROM FND_PRINTER_INFORMATION
                              WHERE PRINTER_STYLE=( SELECT PRINT_STYLE
                               FROM FND_CONCURRENT_REQUESTS
                              WHERE REQUEST_ID= &REQID 
                            )
  AND PRINTER_TYPE=( SELECT PRINTER_TYPE
                       FROM FND_PRINTER
                      WHERE PRINTER_NAME=( SELECT PRINTER
                                          FROM FND_CONCURRENT_REQUESTS
                                          WHERE REQUEST_ID= &REQID
                                           )
                    )