Oracle Applications Release R12.2 Printer Registration

Printer Registration, CUPS, Pasta Configuration, PDF
Printing Oracle Applications R11/R12/R12.2
Brother – Network printer – Phote Printer, scanner, fax, copier, – All in one
MFC-295CN
IP                   – 192.168.1.5
Dell Server
8 port hub – One end of Ethernet cable goes to printer and other end goes to Hub, it automatically assigns a IP address
 High Level Steps
-     Download CUPS software
-     Download the driver for your printer
-     Add the printer - Brother_MFC-295CN
-     Modify pasta_pdf.cfg for PDF Printing
-     Register the printer with Oracle Applications
Printer IP Address – 192.168.1.5
In companies, first 3 activities will be done by System Administrators – No worries, lpstat –a – to know all the printers registered from Linix/Unix
hp501 accepting requests since Mon Jun 04 11:08:17 2007
hp9k01 accepting requests since Mon Jun 04 11:38:14 2007
hkhp410001 accepting requests since Mon Jun 04 11:38:54 2007 hkhp410003 accepting requests since Mon Jun 04 11:39:35 2007 hkhp510001 accepting requests since Mon Jun 04 11:42:16 2007 hkhp510002 accepting requests since Mon Jun 04 11:42:50 2007 hp405001 accepting requests since Mon Jun 04 11:43:22 2007 hp9k07 accepting requests since Mon Jun 04 11:49:56 2007
Download CUPS software
Navigate to http://www.cups.org, click on Download next to the latest version, then choose the .tar.gz or .tgz file and save it on your computer. Once installed we perform the following steps (please note that you might have to change the version numbers if you downloaded a newer version).
Steps (see „Description" for definition):
1. tar xvjf cups-1.4.6-source.tar.bz2
2. cd cups-1.4.6
3. ./configure
4. make
5. make install (you need to be root to install the binaries)
6. /etc/init.d/cups start
 Download the driver for your printer
http://welcome.solutions.brother.com/bsc/public_s/id/linux/en/index.html
Click Printer Driver
Select MFC-295CN
mfc295cnlpr-1.1.2-1.i386.rpm mfc295cncupswrapper-1.1.2-2.i386.rpm rpm –Uvh mfc295cnlpr-1.1.2-1.i386.rpm
rpm –Uvh mfc295cncupswrapper-1.1.2-2.i386.rpm
Click MFC295NC
Click Administration – Modify printer
Click Maintenance – Print Test Page
Check printers.conf in /etc/cups
http://welcome.solutions.brother.com/bsc/public_s/id/linux/en/instruction_prn1c.html#ppd1
[root@linux1 cups]# lpstat -a
Brother_MFC-295CN accepting requests since Thu 24 Jun 2010 06:52:15 PM IST
Test the printer
lp <filename>
Modify pasta_pdf.cfg for PDF Printing
cd $FND_TOP/resource
vi pasta.pdf.cfg  - confirm the below.
% Preprocess for PDF output
% This is an example for PDF output to print.
; Xpdf
preprocess=pdftops {infile} {outfile}
; Ghost Script
; preprocess=pdf2ps {infile} {outfile}
; Acrobat
; preprocess=acroread -toPostScript -pairs {infile} {outfile}
For landscape printing only
cp pasta_pdf.cfg pasta_pdf_land.cfg vi pasta_pdf_land.cfg
Modify the below line
printCommand=lp -c -o landscape -d{printername} Restart the concurrent processing server after the changes
Register the printer with Oracle Applications
Login with System Administrator Responsibility
Check printing – Change Style – PDF Publisher
Navigation: System Administrator - Install – Printer
If printer is known printer (HP), select type accordingly else select PASTA Universal Printer
We need to Register the Printer with the same name which has been derived at the Linux BOX
level, and define the Type as Brother_MFC-295CN
Navigation: System Administrator - Install - Printer – Driver
In this we will be having four options where we can define a Custom Printer as well as Custom
Printer Drivers for Printer.
We need to register a Printer in the following Steps: Driver -> Styles ->  Types -> Register
In order to make use of PDF Printing Directly from a Concurrent Program we need to have
PASTA_PDF Driver existing in the Oracle Applications. Navigation: System Administrator -> Install -> Printer -> Driver Driver Name : PASTA_PDF
User Driver : Pasta PDF Driver
Description : Pasta driver to print pdf converted to PostScript by 3rd party utility
Driver Method : Program
Driver Method Parameters : Spool File
Program Name : FNDPSTAX
Arguments: -pn$PROFILES$.PRINTER -f$PROFILES$.FILENAME – c$PROFILES$.CONC_COPIES - Fpasta_pdf.cfg
We need to check whether a PDF Publisher Styles exists or not. Navigation: System Administrator ->Install -> Printer -> Style
Check that for the type PASTA Universal Printer Type - PDF Publisher and PASTA_PDF are present.
Defining and Assigning the Printer at Concurrent Program Level
Let us consider the Example of Defining a printer for Concurrent Program.
Usually we define Portrait or Landscape for the Style in the Concurrent Program at Output Tab. Here we need to specific PDF Publisher as the Style in Concurrent Program and as well we have
to mention the Name of the Printer which was registered in the Oracle Applications.
Run this program to get the output at Printer Tray
Select Options to select printer name and give number of copies as 1
Bounce the Concurrent Managers in case things didn’t work
References: http://www.netikus.net/documents/Linux-Printing-Cups.pdf
http://www.appsassociates.com/resources/bi-resources/PDF_Printing.pdf
Printing junk characters or getting the below error
Problem ->
Request ID 62347 completed warning and below is the log message, but when we use reprint option it printed properly
Printing output file.
Request ID : 62347
Number of copies : 1
Printer : test
Error: May not be a PDF file (continuing anyway)
Error (0): PDF file is damaged - attempting to reconstruct xref table... Error: Couldn't find trailer dictionary
Error: Couldn't read xref table
Pasta: Error: Preprocess failed. Command=pdftops
/d01/oracle/linux1/inst/apps/linux1/appltmp/pasta2433_0.tmp
/d01/oracle/linux1/inst/apps/linux1/appltmp/pasta2433_1.tmp
Pasta: Error: Preprocess or Print command failed!!!
APP-FND-00500: AFPPRN received a return code of failure from routine FDUPRN. Program exited with status 1
Cause: AFPPRN received a return code of failure from the OSD routine FDUPRN. Program exited with status 1.
Action: Review your concurrent request log file for more detailed information.
Solution check
$FND_TOP/resource pasta_pdf.cfg
preprocess=pdftops {infile} {outfile}
Also, Cause
Report" is defaulting to the RTF output format instead of PDF format. The BI Publisher Template
"Default Output Type" is incorrectly set to the RTF format. Solution
1. Verify / set the "Default Output Type" to PDF as follows:
a) Responsibility = XML Publisher Administrator b) Navigate --> Home: Templates
c) Query the Template Code
d) Click on the template name
e) If the "Default Output Type" on the right side of the screen is not set to "PDF", click on the "Update" and set the "Default Output Type" to PDF and save the change.
2. Retest submitting and printing the report with the "PDF Publisher" print style.
In BI-Publisher the output format should be pdf instead of rtf, and output format should be XML