Queue Management Query 2
Date: Mon, 13 Sep 1999 12:53:13 -0500
From: "Gregg Ney (s)" gney@cap.org
To: "'Oracle Forum'" OraApps-L@cpa.qc.ca
Subject: Gen: Print queue management
Has anyone found a solution to managing printer output from Oracle? Our
print shop needs to identify jobs arriving in their queue (Xerox 6135): i.e.
Invoices, Statements, Reports, etc. Unfortunately they all look alike, and
identify only APPLMGR as the user id. We are on NCA 10.7, with HP-UX
backend, NT 4.0 apps servers and workstations. Has any of this been
resolved in 11.0 or might it be in 11i?
We would like to find something with less setup and maintenance overhead
than an Optio-type solution, but would consider it if it really will resolve
the issue.
Thanks in advance
Gregg Ney
Project Manager, Oracle Applications
College of American Pathologists
gney@cap.org
847/832-7276
Date: Tue, 14 Sep 1999 08:44:22 +1000
From: "Bevin Watson" bevin.watson@abs.gov.au
To: oraapps-l@cpa.qc.ca
Subject: Re: Gen: Print queue management
I presume you need to do this to select different types of pre-printed
stationery.
I would think about creating a number of different printer drivers and
assigning
them to your jobs in the define concurrent programs screen.
You could have a printer driver called, say, "Invoice" which passes a
different
title or job name or paper type or form name in the arguments. There are
lots
of parameters to lp so you would need to talk to your print shop.
If the problem is just separating postscript from ascii text you can write a
printer driver program whch calls the unix "file" command to identify the
file
type.
Bevin Watson
Financial Systems Administrator
Australian Bureau of Statistics
FSG Reports not printing
Date: Tue, 14 Sep 1999 15:18:10 -0700 (PDT)
From: DIPANKAR BASU dipankar_99@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: FSG - Printing of Reports
Hi Everybody,
We are currently on Character version in 10.7 in one of our sites. We
are having a problem in printing of reports which are above 132 chars.
We are getting a warning status when we run the reports and we are not
getting any printouts.
I included the concurrent Program-Run FSG Reports onto the
responsibility and tried to run FSG through Standard Report Submission,
where I can specify the print style. Unfortunately, even now I am
getting the same error even though I am defining Landwide style, which
is 180 chars.
Can anybody suggest a way out? All suggesions welcome.
tia,
Dipankar
Date: Tue, 14 Sep 1999 19:41:44 -0400
From: =?iso-8859-1?Q?Fran=E7ois_Gendron?= francois.gendron@videotron.ca
To: OraApps-L OraApps-L@cpa.qc.ca
Subject: Re: FSG - Printing of Reports
Hi,
I don't know if you have just upgraded to 10.7 character mode, but
one of the changes in behaviour from earlier versions is in the way
column heading definitions are handled.
Previously, when a column heading definition contained trailing spaces
at the end of each line, these spaces where trimmed off. The result
is that the width of an FSG report was potentially defined according
to the length of the longest line in the heading.
With 10.7, trailing space are no longer trimmed. Therefore if you
define a column heading with text that is within 180 characters (for
example), but you have trailing spaces at the end of your lines that
go beyond that, then you will get an error. This is because FSG will
then look for a print style defining 256 columns in a report. If none
is defined, FSG will abort with an error.
Hope this helps,
François Gendron
La Société d'Informatique Gendron Inc.
Tél: (514) 212-3994 Fax: (450) 651-7375
Statements print directly to Printer
From:
James.Walker@blackwell.co.uk
10/14/99 Thu 6:07 PM
Subject:
[orafin] Making Statements print directly to a printer?
To:
orafin@mail-list.com
The Print Statement form doesn't let us specify the Copies so it does not
print automatically. Has anyone found a way around this?
Thanks
10.7 SC Prod16.1 on 7.3.3.5 SUN/Solaris 2.6
From:
John Sweeney jsweeney@goaa.org Okidata Printer - initializatin strings to go to 12 pitch
Date: 20 Oct 99 13:53:15 MDT
Date: Wed, 20 Oct 1999 15:46:39 -0500 High volume invoice printing
From: Venkat Gopalakrishnan[SMTP:gvenkat@oracleassist.com]
Date: Thu, 21 Oct 1999 16:51:07 -0400
Date: Thu, 21 Oct 1999 15:59:17 -0500
Date: Fri, 22 Oct 1999 13:41:24 +1000
Date: Thu, 21 Oct 1999 23:08:41 -0600
Date: Fri, 22 Oct 1999 12:08:09 -0400
Date: Fri, 22 Oct 1999 11:12:50 -0500 Document Size for Cheque Printing
Date: Fri, 22 Oct 1999 14:28:18 +0600 (GMT)
Date: Fri, 22 Oct 1999 10:51:50 +0200 Printer truncating reports
Date: Tue, 26 Oct 1999 09:11:47 GMT
Date: Tue, 26 Oct 1999 11:39:35 +0200
Date: Tue, 26 Oct 1999 12:55:40 +0300
Date: Thu, 28 Oct 1999 00:34:23 GMT
Date: Wed, 27 Oct 1999 09:32:51 +1000
Date: Thu, 28 Oct 1999 02:20:47 GMT Printer not printing
Date: Tue, 26 Oct 1999 06:06:34 -0700 (PDT)
Date: Tue, 26 Oct 1999 06:34:09 -0700 (PDT) Evergreen format prints big exclamation mark on checks
From: Dinesh Makked [mailto:dmakked@deltadentalva.com]
Date: Fri, 29 Oct 1999 10:11:45 -0600
10/14/99 Thu 7:07 PM
Subject:
RE: [orafin] Making Statements print directly to a printer?
To:
"'orafin@mail-list.com'"
Two things (there may be more) that you can do:
1. Create a custom printer driver that specifies how many copies you
desire. Then associate that driver with the concurrent program for the
statement you are generating through the Print Statement form. The downside
to this is that the number of copies you set within the custom driver
applies to all users and responsibilities that do the statement generation
via the Print Statement form (i.e. there is no flexibility in the number of
copies). The number of report copies "hard-coded" within the driver cannot
be overriden by the user running the request...it can only be changed at the
concurrent program level.
2. Set the profile option Concurrent:Report Copies to 1 (or the number of
report copies you desire) at the user, responsibility, or application level.
If there is only 1 or a few users who generate the Statements, set this
profile option at the user level for each user who generates the statements.
The downside to this is that, depending on which level you set the profile
option for, the # of report copies will apply to every request (assuming the
concurrent program is enabled for printing) that the user, responsibility,
or application runs. The good thing is that the # of report copies that you
set via this profile option is simply the default...it can always be
overriden on the Request Submission form by the user running the request.
As far as I'm concerned, this is the preferred option.
Both options are done via the system admin responsibility.
John Sweeney
GOAA, IT Department
407-825-3280
From: JONATHAN BOURNER jbourner@usa.net
Subject: AOL:Okidata Printer
Hi All !!!
I am having trouble with a dot matric Okidata printer, ML 395. We are trying
to get this to print purchase orders. The problem is that no matter what we
put in the driver as far as initialization strings it is having no effect
Can someone shed some light on this. What is the initialization string to get
this to go to 12 pitch. The command is ESC M but no matter if this entered as
/e P (ASCII) or /027 080 (Dec) it is having no effect.
I FTP'ed the file to my PC and then printed it on the printer directly and
this work find.
Any assistance would be greatly appreciated.
Regards,
Jon Bourner
From: "Robertson, Cassandra F." cfrobert@southernco.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Okidata Printer
Hello Jonathan,
I had this very same problem with an Okidata 320 and a 395. What I had to
do to resolve the problem is the following:
Arguments: lp -d $PROFILES$.PRINTER $PROFILES$.FILENAME
Initilization:
Reset: control Z
I also created a drive file with the following commands:
height 66
width 132
between pages control(L)
linefeed control(J)
code "bold on" " "
code "bold off" " "
code "underline on" esc "-1"
code "underline off" esc "-0"
It was really the weirdest thing having to put the control Z in the reset.
Hope this helps. Oh, I also set the font size to 17 pitch.
Hope this is helpful. Let me know.
Be Blessed!!!
Cassandra Robertson
Southern LINC - CIS Operations
(desk) 678-443-1619
(LINC) 770-550-0484 PRVT ID. 4484
Reply To: oraapps-l@cpa.qc.ca
Sent: Thursday, October 21, 1999 10:50 AM
To: Multiple recipients of list
Subject: High volume invoice printing
Hi all
I am implementing OE at a distribution company who require high volume
invoice printing while shipping orders. The invoice is to be printed at
the end of the shipping line and is to be sent along with the shipping
container. About 2500-3000 shipments are made everyday.
Oracle is incapable of handling such high volume transaction and it takes
anywhere between 3-4 minutes to print one invoice even if the concurrent
managers are made to run every 15 seconds.
Can anyone share their experiences in handling such high volume invoice
printing and can anything be done to speed up the process.
thanks
venkat
From: "Mark W. Farnham" mwf@rsiz.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: High volume invoice printing
I suggest you check with Cisco.
From: "Shockey, David" DShockey@jwrinc.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: High volume invoice printing
You might consider sending invoices via EDI if it is possible.
From: "Bevin Watson" bevin.watson@abs.gov.au
To: oraapps-l@cpa.qc.ca
Subject: RE: High volume invoice printing
The 3-4 minutes surprises me a bit.
I'm on 10.7 character and we have a customised invoice print routine
(portrait
and bitmapped). Ours takes about 20 seconds to run. We've done nothing to
optimise it - the code is basically the same as the standard routine. I'm
sure
we could make it take less time than that if it were a concern to us.
Is the time in the actual printing, or is it in waiting for the CM to pick
up
the job? It could be that with such high volumes of jobs going through
there
could be some performance bottleneck in the CM itself. This gets pretty
complex, but the obvious and simple things to do are purge old requests more
often and get your DBA to check indexes and things on
fnd_concurrent_requests
and other fnd_concurrent_* tables.
The other possibility is that the delay is in the print spool or the printer
itself. That is way, way out of my league.
HTH
Bevin Watson
Financial Systems Administrator
Australian Bureau of Statistics
From: Amber Allen-Sauer amber@allen-sauer.com
To: "oraapps-l@cpa.qc.ca" oraapps-l@cpa.qc.ca
Subject: RE: High volume invoice printing
Venkat,
Bevin is on the right track, you need to determine whether the slowness
is in the creation of the report (which can be fixed with some
report/manager tuning) or actual printing. Running your process every 15
seconds is probably overkill, possibly even making the problem even
worse.
Look at few factors to help determine the problem area:
* Is your invoice bitmapped (postscript or print logos) or character?
Images in bitmapped reports can print slow, but this can be resolved by
reducing the image colors, etc.
* Look at the report DETAILS screen. How long are the requests waiting
before that begin running and what is there actual run time. Write a
script which evaluates times for invoices on the FND_CONCURRENT_REQUESTS
table to make this part easier. The end time is when Oracle sends the
print command.
* Ask your network admin to monitor network activity during shipping
peak hours
* Are you using the right kind of printers for such large volumes? Is it
slow printing non-Oracle docs as well?
* Is your volume too great for your hardware? Is everything this slow or
just printing?
* Since these are high priority docs, create a separate concurrent queue
for them to run in and not be interfered with.
You have probably already done alot of this, but you should be able to
achieve faster results!
Good Luck!
Amber
Allen-Sauer Consulting, Inc.
Phone : (303) 399-4137
Fax : (303) 399-0660
Internet: amber@allen-sauer.com
From: "Venkat Gopalakrishnan" gvenkat@oracleassist.com
To: oraapps-l@cpa.qc.ca
Subject: RE: High volume invoice printing
Thank you very much for your inputs. The problem as I see is in the
concurrent programs itself. The auto invoice import program itself takes
about a minute to complete. I don't see problem in the printers speed.
Is it a good idea to create a separate queue to auto invoice import program.
thanks
venkat
From: "Shockey, David" DShockey@jwrinc.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: High volume invoice printing
You could increase the priority of the concurrent requests that produce
invoices. This will not make them run faster but will make them move
through the queue faster.
From: satyam@sri.lanka.net
To: OraApps-L@cpa.qc.ca
Subject: Cheque Printing : Document Size
Hi All,
We have a problem with the Cheque printing program which is skipping cheque
stocks (Physical instruments and not number) while printing for a batch
payment. We are using a dot matrix printer and a continuous stationery. We
are not using the standard RDF provided by Oracle. The Cheque printing
program is a customised one.
The stationery we have is of a unique size. Width-wise it is 132 character
(11 inches) equal to that of Landscape. However length wise it is only 3.75
inches .
When printing cheques for a payment batch comprising of more than 1 cheque,
the first cheque is printed properly after which it skipps paper length to
the tune of another 2 instruments approximately.(It looks like, it is using
the length of an A4 size paper).
We are on Rel. 11.0.3 on SUN Solaris.
Request immediate help
Thanks in Advance
Prabu
From: "Sridhar RAO" sridhar_rao@salomon-sports.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Cheque Printing : Document Size
Hi,
You can probably try defining a new print style and a printer driver. A
paperof
size 3.75 inches will take 30 lines, printer setting 8 lines per inch. Set
the
number of rows to 30 in the definition of the print style and the driver.
Another option probably is to set lines per page on the printer to 30, 8
lines
per inch. This way page break occurs only after 30 lines from the printer
side.
Hope this works
- sridhar
From: "YOU HIN TAN" tanyouhin@hotmail.com
To: OraApps-L@cpa.qc.ca
Subject: Defining printer driver in Rel 11
Hello sys. admin guru,
I have a problem in defining printer driver. I try to define a
landwide printer driver. I have enter the column layout as 180
both in printer driver, printer styles and also SRW Driver. But,
the printer only print up to 93 column. Any ideal why ? (fyi: we are
using HPLJ4000N printer)
thanks in advance,
YH
From: "Sridhar RAO" sridhar_rao@salomon-sports.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Defining printer driver in Rel 11
I think the data is truncated by the printer for some reason. Try adding
the following to the end of the initialisation string in driver
definition.
/e&k11.8H
If you still canot see the full report
you can try reducing the value from 11.8 to 11.5 and so on until all the
data fits into the page.
Hope this helps.
- sridhar
From: Mohammad Fouwaaz Mfouwaaz@savola.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Defining printer driver in Rel 11
Hello
Are you sure it is a printer driver definition problem? Sounds like a
report problem to me. You may want to check the concurrent program
definition -- is it for 180 columns? Have you chosen the style 'landwide'
there? In report file itself go to properties of the report and see whether
width is 180 characters. Further, in the layout of the report, click
margins and see whether the margin outline (black line around the body)
covers the full width of the report.
Hope this helps.
Regards
From: "YOU HIN TAN" tanyouhin@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Defining printer driver in Rel 11
Thanks for the reply. Actually we just start our implementations and
start installing at the new machine. So, this is our first printer
driver that we start working on and we are using oracle std. report as our
testing. Still working on this problems.
thanks,
yh
From: Paul_Thien@gecfa.com.au
To: oraapps-l@cpa.qc.ca
Subject: Re: Defining printer driver in Rel 11
1. LooK at your SRW driver in $FND_TOP/reprts to see if you have a width of
93.
2. Does your report have a width of 93? This is defined in the report. The
best test is to print a std 180 report.
3. Is your font size correct? If your font size is too bug, you may have
this problem.
Rgs,
Paul
From: "YOU HIN TAN" tanyouhin@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Defining printer driver in Rel 11
Thanks for the reply . I have found out the root cause. Is it actually
when we create the printer in the unix level, system default it to
80 col. We went in and change the printcap file default it 180.
thanks again,
YH
From: Sivakumar K sivamanj@yahoo.com
To: OraApps-L@cpa.qc.ca
Subject: Need to know how to setup Printer on Oracle Apps Rel 11 - Urgent
Hi
Can someone help. I have setup Oracle Apps Rel 11
(fastforward) on Windows NT. It is a standalone PC.
I have connected a IBM 2391 Plus(Lexmark) printer
to its parallel port. It is configured properly
on NT and prints from normal Windows applications
like Excel etc.
But unable to figure how to register it in Oracle
Apps. I tried in Install-Printer-Register screen
to give Printer name as IBM 2391 Plus and the
printer type as FX850 as that seems closest of
the available types. Saved it, and set it as
Printer for the site in System profile option.
All this I did logged on as SYSADMIN.
Logged as a user, the report request though states
as completed, does not print.
Thanks and regards
Sivakumar
CIS
Beirut-Lebanon
From: Mark Myszkowski myszko@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Need to know how to setup Printer on Oracle Apps Rel 11 -
Urgent
One thing that has helped me troubleshoot printing on
NT is printing a test file from the command prompt.
So try "print /d:\\servername\printername test.txt" on
your server. Once this is working you are in good
shape. Just make sure the printer name you registered
in Oracle matches \\servername\printername in the test
above. Also check that the driver you are using in
Oracle has PRINT /D: in its argument line. If it
doesn't, there is a patch you need to obtain from
support (this was the case in 10.7). You often need to
bounce the concurrent managers after making printer
modifications in Oracle, please keep this in mind
also.
HTH
Mark Myszkowski
Entre
Milwaukee, WI
Sent: Friday, October 29, 1999 7:37 AM
To: Multiple recipients of list
Subject: AP: Evergreen Check Priting!
We are trying to print Checks using Evergreen format. A big bold Exclamation
sign prints on check. Any Suggestions?
Thanks
From: tom prado-irwin tprado-irwin@Quark.Com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Evergreen Check Printing!!
Dinesh-
On our system the exclamation point occurs because the print file is
expecting a signature cartridge in the printer but the cartridge is not
installed. If you are not using a cartridge, try deleting 121, 122 and 123
if they exist from the p_printer_code_mask string specified in the Options
field, Executable block, of the concurrent program with the short name
APXPBFEL. Other codes that may need to be deleted are:
101, 102 Print check number on remittance & check
111 Activate MICR line
141 Activate special font for address portion of check
I have an old (1996) document from Synapsis (Evergreen's cartridge supplier)
that explains this pretty well. If you give me your fax number I can fax it
to you.
Tom Prado-Irwin