Thursday, May 28, 2009

How To Determine Printer Setup Used When Printing For A Particular Concurrent Request

Purpose

This note explains how retrieve printer setup used when you are facing a concurrent request printing issues.
In other words what to do when the printing is not compliant with what was expected and you want to know all the printer
setup involved in the printing phase done by concurrent manager.

Troubleshooting Details

The 3 following sql*plus statements will provide you the printer setup used by the concurrent request facing the issue.
What you have to do is to

1) note the ID of the concurrent request having printing troubles,

2) access to the database using sql*plus tool via apps oracle account

3) run the 3 following sql*plus statements

4) provide the request ID you noted when requested for a REQID value.
set pages 999

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/


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


SELECT PRINTER_DRIVER_NAME, USER_PRINTER_DRIVER_NAME , PRINTER_DRIVER_METHOD_CODE , SPOOL_FLAG , SRW_DRIVER , COMMAND_NAME , ARGUMENTS , INITIALIZATION , RESET FROM FND_PRINTER_DRIVERSWHERE 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 ) ) )/

The first 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 ...)

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

The third one all you need to know about the printer driver used.(Printer driver name, printing method, spool, associated SRW driver,command used for printing, initialization and reset
strings)

No comments: