AOL A4 Printing Setup

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.

It also provides the necessary steps for completing this configuration.

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;
  •  Turn off spooling:
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
SRW Driver:
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
SRW Driver:   
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.