This Blog post outlines the process for setting up A4 printing from a US-based (Letter Size) server site. A4 Printing is not included in the Oracle Apps configured database, therefore, if you are using A4 printing you must configure manually.
Configure Printers
Identify Existing US-based Printer Styles
- Log into SQL*Plus
Example: | sqlplus username/pwd@host |
- At the SQL*Plus prompt spool to a file:
Example: | SQL>spool c:\data\clients\a4_printing.lst |
- At the SQL*Plus prompt enter the following SELECT statement:
Type | SQL>SELECT a.printer_name, a.printer_type, 2 b.printer_style, b.printer_driver 3 FROM fnd_printer a, 4 fnd_printer_information b 5 WHERE a.printer_type = b.printer_type; |
Type: | SQL>spool off |
- Open the file you spooled to. This file will list the Styles and drivers currently assigned to your US Printers.
Identify Drivers Needed
Decide which of the above drivers you will need at the A4 sites.
Navigate to: | Install>Printer:>Driver |
· Enter query mode and search for the required printer driver.
· Record configuration values for each required driver.
Note: You will use the configuration values for the US-based printer driver and modify the values for A4 Printer Drivers.
The below information shows an example of an existing US based Printer Driver:
Printer Driver: | HPLJPORTRAITDYNAMIC |
User Name: | HPLJ – Portrait Dynamic |
HPLJPD | |
Arguments: | lp –c –d$PROFILES$.PRINTER –n$PROFILES$.CONC_COPIES – t"$PROFILES$.TITLE" $PROFILES$.FILENAME |
Initialization: | /eE/e&10O/e&12A/e&17C/e(S0P/e(8U/e&k2G |
Initialization Description: | /reset/portrait/letter/7 vmi/fixed char spacing/roman 8/unix mode |
Driver Method: | Command |
Spool File: | No |
Standard Input: | Yes |
Reset: | /eE |
Define A4 Printer Driver
Navigate to: | Install>Printer>Driver |
· Create new driver using the configuration values you have documented from the existing required driver.
Note: You must create a new driver configuration and then modify it for A4 printing. Do not modify the existing US based Printer Driver configuration. Refer to the appropriate manufacter’s documentation and web site for valid driver definitions.
The below information shows an example of a new A4 Driver (modifications highlighted):
Printer Driver: | HPLJPORTRAITDYNAMIC-A4 |
User Name: | HPLJ – A4 Portrait |
HPLJPD | |
Initialization: | /eE/e&10O/e&126A/e&17C/e(S0P/e(8U/e&k2G |
Description: | /reset/portrait/A4/7 vmi/fixed char spacing/roman 8/unix mode |
Driver Method: | Command |
Spool File: | No |
Standard Input: | Yes |
Reset: | /eE |
Define Printer Types and Assign Printer Drivers
Navigate to: | Install>Printer>Types |
· Create a new printer type and assign the same Styles used for the US-based Letter-size printing to the new A4 Drivers.
The table below shows an example of a new A4 Type.
Type: | HPLASERJET-A4 |
Description: | For HP Laserjet Printers – A4 |
Printer Drivers>Style: | DYNAMIC |
Driver Name: | HPLJPORTRAITDYNAMIC-A4 |
Register Printers
Navigate to: | Install>Printer> Register |
· Assign the new printer type to your A4 Printers:
Printer: | ORACLE APPS_PRINTER |
Type: | HPLASERJET–A4 |
Description: | Enter user-friendly description of printer |
Note: Some programs, such as Format Payments, may require special treatment which may include modification of the SRW driver file and the Style which is not included in the scope of this document at this time.