Postscript printing in Oracle Applications requires: a registered postscript
printer, registered postscript RDF files, predefined Oracle Applications and
Oracle Report postscript drivers, defined system environment variables, and on
some platforms, an updated Oracle Reports printer configuration file
(uiprint.txt). The following steps are for all platforms; however, any operating
system (OS) specific instruction will be denoted by the platform's name.
On a three-tier NCA configuration, the concurrent processing server typically
resides on the database tier. Nonetheless, the concurrent processing server can
alternately resides on the middle tier. In a mixed platform installation with
both Unix and Windows servers installed, the postscript printing setup and
testing should be performed on the platform where the concurrent processing
server resides.
a. INSTALL & CONFIGURE THE POSTSCRIPT PRINTER AT THE OS LEVEL.
Before attempting to setup a printer in Oracle Applications, it is essential
that printing is possible from the command line.
On some mixed platform or networked environments, additional software tools
or programs may be required to establish a working network or local printer.
Please reference your printer or operating system manuals for specific
information on setting up printers and printer drivers at the OS level.
1. On Unix, a printer / print queue needs to be defined as postscript at the
OS level.(Set printer-type and content-type to PS when adding the printer
with lpadmin.)
2. On Windows NT, install the Windows postscript driver supplied by the
printer manufacturer on the server where the concurrent manager resides.
Under the Windows printer "Properties" dialog box, verify the postscript
driver has been set as the default driver.
3. On the Concurrent Processing Server node, please verify a postscript
document can be successfully printed from the command line:
lp -d <printer_name> <file_name> or
lp -d <printer_name> -T postscript <file_name> for Unix
print /d:\\<server_name>\<printer_name> <file_name> for Windows NT
Note: On Windows NT, remote printers must be managed locally on the server
where the concurrent manager resides. Otherwise, a "REP-0826: Invalid
printer '<name>' specified by parameter desformat" error may occur.
b. DEFINE ENVIRONMENT VARIABLES.
Environment variables are used to specify which printer and executable may be
used for printing. The variables LPDEST and PRINTER identify default printers
available to Oracle Reports. However, the APPLORC variable is set to the
executable used for character-mode printing and the APPLORB variable is set to
the executable used for bitmap-mode printing.
On the Unix platform, the ar25runb executable is used for postscript printing.
This executable resides in the $FND_TOP/bin directory. If the executable is
not present, it can be recreated manually with the Oracle Applications utility
adrelink.
On the Windows NT platform, the r25run32.exe executable is used for both
postscript and ASCII text printing.
1. On Unix, set the following variables in the APPLSYS.env file:
APPLORB=ar25runb; export APPLORB
APPLORC=ar25run; export APPLORC
LPDEST= <Actual Printer Name> ; export LPDEST
PRINTER= <Actual Printer Name> ; export PRINTER
2. On NT, set the following registry entries under \HKEY_LOCAL_MACHINE\
SOFTWARE\ORACLE\APPLICATIONS\<Release Version>\<Value of APPL_CONFIG>:
APPLORB = r25run32
PRINTER = default
c. CREATE OR LOCATE A PRINTER DEFINITION FILE (SRW) - ON UNIX ONLY.
An SRW driver acts like a translator. It tells the printer how to handle
bolding, underlining, printing graphical characters used in lines/boxes, etc.
Printer definition files are defined for both postscript and character printing.
However, these drivers are used exclusively by Oracle Reports for formatting
the output file. It is an ASCII text file with a file extension of PRT that can
be copied and edited as needed.
Postscript printer definition files are required only on character-mode
platforms like Unix. In a bitmap platform, like Windows NT, the SRW driver is
not used for printing postscript reports; however, the driver is used for ASCII
text reports.
SRW driver file are present in the $FND_TOP directory, specifically, $FND_TOP/
srw for Oracle Applications Release10.7 and $FND_TOP/reports for Release 11.
Additional drivers can be found in Oracle_Home/reports25/printers for NT and
Oracle_Home/reports25/admin/printers for Unix. Some generic postscript drivers
are psport.prt for portrait, psl132.prt for landscape, and psl180.prt for
landwide.
1. Select a SRW driver that is compatible with your printer and report.
2. Make sure the driver is present in the appropriate $FND_TOP subdirectory.
d. SETUP PRINTER CONFIGURATION FILES - ON UNIX ONLY
Oracle Reports' Toolkit component uses the Postscript Printer Definition (PPD)
files to determine postscript printer capabilities and font availability. Any
fonts listed in the PPD file must have a corresponding Adobe Font Matrics (AFM)
file in the $ORACLE_HOME/guicommon/tk23/admin/PPD directory. Oracle delivers a
generic set of PPD and ATM files. If additional PPD and ATM files are required
or desired, please check with your printer manufacturer or with Adobe
Corporation.
Another configuration file that needs to be updated is the uiprint.txt file.
This printer resource file lists every available printer and its associated PPD
file. It can be found in the $ORACLE_HOME/guicommon2/tk23/admin/ directory. The
file has a line entry for each printer as follow:
Printer_Name:Driver_Type:Driver_Version:Description:PPD_Name
Printer_Name is the printer's name used at the Unix OS level.
Driver_Type is one of three driver types currently supported by the Oracle
Reports Toolkit: Postscript, ASCII, and PCL.
Driver_Version is one of three driver versions currently supported by Oracle
Reports Toolkit:1 for ASCII or Postscript level one, 2 for Postscript level two,
and 5 for HP PCL.
Description is any helpful free form description.
PPD_Name is any PPD file name found in the
$ORACLE_HOME/guicommon2/tk23/admin/ directory.
1. Examine and select a suitable PPD file.
The default PPD should be appropriate for most printers.
2. Edit the uiprint.txt file and make a similar entry as follows:
SitePr3:Postscript:1:Site Printer on 3rd Floor:default.ppd:
e. DEFINE A NEW PRINT DRIVER
The print driver defines how Oracle Applications printing will be accomplished.
That is, what printing programs, commands, or arguments are needed to submit an
output file to a printer via the operating system.
1. Log on to Oracle Applications and select the SYSADMIN responsibility.
2. Navigate to Install/Printers/Drivers and create a new print driver
record.
3. Enter a driver name and a user driver name. The user driver is the name
that will appear in the LOV window.
4. On Unix only, select a postscript SRW driver like PSL132 for landscape
printing.
5. Platform should be left blank<null>.
6. Set the driver method to command and all driver method parameters options
should remain blank/unchecked.
7. Enter a corresponding argument for Windows or Unix:
PRINT /D:$PROFILES$.PRINTER $PROFILE S$.FILENAME
lp -c -d$PROFILES$.PRINTER -n$PROFILES$.CONC_COPIES -t
"$PROFILES$.TITLE" $PROFILES$.FILENAME
8. The initialization and reset field must be blank<null> for postscript
printing.
Note: Since printer information is cached, the concurrent manager needs to be
bounced or restarted after making any printer information changes.
f. DEFINE A NEW PRINT STYLE
A print style is a description of how your report should be printed. It
specifies the SRW driver to be used and a layout area. The layout area defines
the report's columns, rows, orientation, and if a header should be suppressed.
Create a new style with similar layout property as defined in the report.
Both the print style and the print driver contain a field for an SRW driver. The
SRW driver listed in the print style is used when the report is not being
printed (copies = 0). The SRW driver listed in the print driver is used when the
report is being printed(copies > 0). Unless there is a specific printing need,
the SRW driver should be the same in the print style and the print driver.
1. Navigate to Install/Printers/Styles and create a new print style record.
2. Enter a style name and a user style name.
The user style is the name that will appear it the LOV window.
3. Enter a sequence number.
It organizes the displayed styles by sequence number when a query is
performed.
4. On Unix only, select a postscript SRW driver like PSL132 for landscape
printing
5. Complete the layout block with the same properties defined in the report.
Hint: In the style or driver name, include the letters PS and the paper
orientation like landscape to quickly help identify the new style or
driver.
g. DEFINE OR SELECT A PRINTER TYPE
The printer type is used to list every suitable matched set of printer style and
printer driver for a specific printer. A registered printer can be associated
with only one type. However, several printers can utilize a defined type. An
existing type can be used or a new type can be created.
1. Navigate to Install/Printers/Type
2. Query the desired type and select any supporting style or drivers.
Note: If an existing type is selected for the newly registered printer, do not
alter the existing styles and drivers entries; it may be in use by other
printers. Instead, make additional print style and print driver entries.
h. REGISTER THE PRINTER WITH ORACLE APPLICATIONS
The printer name needs to be the same name used at the command line.
On NT, a network printer name is registered with the share name utilizing the
Universal Naming Convention (UNC). The format is \\Server Name\Printer Share
Name.
1. Navigate to Install/Printers/Register
2. Make a new record entry.
