tag:blogger.com,1999:blog-31331079.post6954521199483015664..comments2024-03-16T18:58:49.294+13:00Comments on In Depth Apps - Oracle eBusiness Suite - Gareth Roberts: Short n Fat vs Tall n Slim: Apps Printer Drivers 66 lines per page A4 printingGareth Robertshttp://www.blogger.com/profile/06953577059981917424noreply@blogger.comBlogger31125tag:blogger.com,1999:blog-31331079.post-53398230298884362332011-12-13T23:40:56.687+13:002011-12-13T23:40:56.687+13:00Hi Hari,
I haven't tried it yet, but it may b ...Hi Hari,<br />I haven't tried it yet, but it may b be possible to use PASTA to Ghostscript to convert PDF to PCL, with embedded tray control escape sequences.<br />Something along the lines of this:<br />http://stackoverflow.com/questions/1246413/insert-pcl-escape-sequences-into-pcl-built-from-multiple-pdf-files<br /><br />Regards,<br />GarethGarethhttps://www.blogger.com/profile/04404307445855701633noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-49629702476673908172011-12-13T04:46:25.889+13:002011-12-13T04:46:25.889+13:00Raj , did you find a solution for your issue.
Ga...Raj , did you find a solution for your issue.<br /><br />Gareth -- We have a similar requirement for check and copy to be printed on different tray's.<br />Is there any solution available ??<br /><br />Thanks<br />HariHarihttps://www.blogger.com/profile/07431349980690270988noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-33221765395790372012011-10-21T12:32:12.221+13:002011-10-21T12:32:12.221+13:00Hi Praveen,
I have had a customer with the same r...Hi Praveen,<br /><br />I have had a customer with the same requirements, but they did not get a resolution from Oracle, so a custom or 3rd party solution is probably required here.<br /><br />Regards,<br />GarethGarethhttps://www.blogger.com/profile/04404307445855701633noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-6009646677504420322011-10-17T00:51:43.096+13:002011-10-17T00:51:43.096+13:00Hi Gareth,
We are upgrading the EBS 11.5.9 to R12...Hi Gareth,<br /><br />We are upgrading the EBS 11.5.9 to R12. the Check printing in 11i is Text format and, .prt files and printer side plugin is used to include the MICR code, Signature and Logo. The printer - HP4100_TROY.<br /><br />1. In R12 the Check Printing process generates the PDF output. Using PASTA is it possible to convert otuput to PCL/Text and use the same printer and printer plugin.<br /><br />2. Is there any other method to use the same printer and printer plugin to print MICR code,Logo and Signature on the check.<br /><br />3. We have to generate checks of 3 bank accounts from different Tray. is it possible to send the print request to a particular Tray.<br /><br />Is there any solution to implement above steps without using Third party tools, like Evergreen Docogurd.<br /><br />Please let me know the steps to implement it.<br /><br /><br />Thanks&Regards,<br />Praveen<br />praveen_by@hotmail.comPraveen Yhttps://www.blogger.com/profile/05090574665378610092noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-20050050683221102752011-07-25T11:21:41.433+12:002011-07-25T11:21:41.433+12:00Just wondering if we have any solution for printin...Just wondering if we have any solution for printing check & copy to different trays (tray#2 or tray#3). Would you mind sending it to my email DamuPant@gmail.com<br />Thanks in advance.<br />-DPUnknownhttps://www.blogger.com/profile/11492618676387788038noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-12840092166772974642010-10-08T16:16:29.312+13:002010-10-08T16:16:29.312+13:00Hi Gareth,
We are implementing Std. R12.0.6 AP Ch...Hi Gareth,<br /><br />We are implementing Std. R12.0.6 AP Check Printing. <br /><br />I've designed standard BI Publisher RTF to print the Check and Check-Copy without any issue.<br /><br />My RTF Template has Check design on first page and Check-Copy (Non-Negotiable) on second page of RTF. Std. Conc. Prog. Payment program FORMAT PAYMENT INSTRUCTIONS automaticlly will be printnig the Checks after paying the Vendor, there my RTF is being used for printing through PDF.<br /><br />Issue is Both Check & Copy are by default getting printed from Tray#3. But the requirement is Check to be selected from Tray#2 and its Check-Copy should be selected from Tray#3.<br /><br />Note: output PDF is NOT considering the Print setups made in RTF. <br /><br />My question is: <br />(1) How can we Print Checks from (Check Stock) Tray#2 and Checks those Copies (which are Non-Negotiable) from <br />Tray#3 <br /><br />When printing is happening, it is through one single file (both check&copy) then how can I seperate them to specific two trays even if I modify pasta_pdf.cfg<br /><br />If you can guide me that'll ge great. <br /><br />I even emailed you the same requirement. It is very urgent.<br />my email: nagkode@yahoo.com<br /><br />Thanks a million in advance for your attention and time. <br /><br />Kind Regards, <br /><br />RajAnonymoushttps://www.blogger.com/profile/06491694355242168267noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-66514677923952816902009-08-18T19:10:59.848+12:002009-08-18T19:10:59.848+12:00Hi Jag,
If you're talking about XML (BI) Publ...Hi Jag,<br /><br />If you're talking about XML (BI) Publisher RTF, it doesn't produce text (PCL), but produces PDF which by default is converted to postscript and sent to printer, so no PCL.<br /><br />Check this forum post for alternatives:<br />http://forums.oracle.com/forums/thread.jspa?threadID=939057<br /><br />Regards,<br />GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-64777111670232614152009-08-18T18:54:47.298+12:002009-08-18T18:54:47.298+12:00Hi Gareth,
Nice Article...
I have a requirement ...Hi Gareth,<br /><br />Nice Article...<br /><br />I have a requirement wherein the digital signatures have to be printed on the cheques generated through the RTF. The signatures will be configured in the printer and I have to use Printer Control Language (PCL) commands in my RTF to get it printed. Please let me know if have an idea on how to achieve this.<br /><br />ThanksUnknownhttps://www.blogger.com/profile/16101042578636304273noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-60918976852638624422009-06-10T11:53:10.979+12:002009-06-10T11:53:10.979+12:00Hi Bill,
You can put the dollar sign directly int...Hi Bill,<br /><br />You can put the dollar sign directly into the text, then if you want special format (like bold) that plain text doesn't give you, you can possibly embed PCL commands in the text if you are using Oracle Reports to generate the text by using the "Printer Code Before"/After attributes on the properties of the field in the layout editor.<br /><br />Regards,<br />GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-73354239129683854912009-06-10T01:58:36.715+12:002009-06-10T01:58:36.715+12:00Gareth, excellent article on printing. Quick ques...Gareth, excellent article on printing. Quick question - in APLASP.prt, is there an escape code that turns on the dollar sign for checks? We are printing AP checks in Oracle. Thanks, BillBill Gastonhttps://www.blogger.com/profile/08967160261587807674noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-36276381738422939392009-05-09T09:55:00.000+12:002009-05-09T09:55:00.000+12:00Hi Trupti,
Try solution per comment and let us kno...Hi Trupti,<br />Try solution per comment and let us know how it goes:<br />... first option I see is to modify e.g. $FND_TOP/resource/pasta_pdf.cfg to change the line:<br />printCommand=lp -c -d{printername}<br />to something like<br />printCommand=lpr -Ztray2 -P{printername}<br /><br />GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-5230992114047338002009-05-08T21:14:00.000+12:002009-05-08T21:14:00.000+12:00Hi Gareth
I have a query related to ur blog on PA...Hi Gareth<br /><br />I have a query related to ur blog on PASTA file setting <br />There is a need to print PDF Reports (Generated using XML Publisher) from a specific printer tray (Tray 3). <br />We believe same is possible by modifying pasta.conf file provided by oracle for printing PDF reports. <br /><br />Please advice in case u know how to achieve the above functionality of printing PDF reports generated by XML Publisher to a specific printer tray <br />, would appreciate if you can share the details/code to do so. <br /><br /><br />PS: This being XML publisher report & not a normal RDF, printer initialization string to print to a specific tray does not work<br />Also there are total 4 reports printing together out of which one needs to be sent to a specific tray of printer.<br />Its very urgent (sollution is needed today itself)<br /><br /><br />Thanks in advanceUnknownhttps://www.blogger.com/profile/10076036381040512362noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-49164910282451193832009-03-12T12:11:00.000+13:002009-03-12T12:11:00.000+13:00Thanks Gareth, I will check for PDF to PCL convert...Thanks Gareth, I will check for PDF to PCL converter, in between if you have the converter handy please mail me to ashish.dir@gmail.com. I need help to configure the Zebra printers as well, of you can provide the steps to do that as well will be great.<BR/><BR/>~ Ashish | 630 487 9486Ashishhttps://www.blogger.com/profile/13927961354257381954noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-53726040334109389752009-03-12T07:31:00.000+13:002009-03-12T07:31:00.000+13:00Hi Ashish,Should be possible, there is PDF to PCL ...Hi Ashish,<BR/><BR/>Should be possible, there is PDF to PCL converter available, and in PASTA you can configure the pasta_pdf.cfg to change the preprocess from pdf2ps to the pdf to pcl converter, then possibly modify the lp command if it doesn't work as standard. Of course I haven't tried this so not sure.<BR/><BR/>Let me know how you get on.<BR/><BR/>Regards,<BR/>GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-71411767677048544132009-03-12T07:01:00.000+13:002009-03-12T07:01:00.000+13:00Thanks Gareth for quick response, yes I agree the ...Thanks Gareth for quick response, yes I agree the pdf will be converted to postscript, but the printer is not supporting the postscript. The printer only understands the PCL. IS there a way to configure the pasta to change the pdf to pcl.Ashishhttps://www.blogger.com/profile/13927961354257381954noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-61184705448099376312009-03-12T06:55:00.000+13:002009-03-12T06:55:00.000+13:00Hi,PDF will usually end up being converted to Post...Hi,<BR/><BR/>PDF will usually end up being converted to Postscript and sent to printer. Theoretically you could convert the PDF to plain text, then send via PCL ... but I don't see the point!<BR/><BR/>Regards,<BR/>GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-2089490289361496262009-03-12T04:46:00.000+13:002009-03-12T04:46:00.000+13:00Hi GarethWe are trying to use the old laser priner...Hi Gareth<BR/><BR/>We are trying to use the old laser priner (HP Laserjet 4 plus) which uses the PCL format to print , please suggest if we have a way to setup the pasta to use the pcl printer for printing the pdf documents.<BR/>~ Ashish | 630 487 9486Ashishhttps://www.blogger.com/profile/13927961354257381954noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-10903670552984210632008-11-06T12:04:00.000+13:002008-11-06T12:04:00.000+13:00Just a note that there is a good post on BI Publis...Just a note that there is a good post on BI Publisher and Tray Control here:<BR/>http://www.rittmanmead.com/2008/04/25/printer-tray-selection-using-bip-web-services-and-apex/<BR/><BR/>GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-43970109590155542652008-10-27T06:16:00.000+13:002008-10-27T06:16:00.000+13:00Hi Gareth,We are printing bank details and check n...Hi Gareth,<BR/><BR/>We are printing bank details and check number at the footer. Requirement is to move the check number to very bottom of the page. When we try to move the check number, it is printing partially and when we try to move further it is not printing at all. Problem might be due to fixed margin size for the printer. I am not able to find where to control this size. <BR/><BR/>We are using Letter size and pdftops as third party tool. Can <BR/>you please provide your feedback.<BR/><BR/>Regards,<BR/>Satish.Unknownhttps://www.blogger.com/profile/16757018156229798867noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-15195748065017810502008-04-09T20:10:00.000+12:002008-04-09T20:10:00.000+12:00Hi Tapan,Looks like APLASP.prt has lots of embedde...Hi Tapan,<BR/>Looks like APLASP.prt has lots of embedded PCL codes (you can reference the escape code on the fields within the report).<BR/>I'm not sure what all these codes do in APLASP.prt, but the initialization string on the printer driver that you use will still have effect, so you can control the default margins etc with that using the PCL language.<BR/>If you look at the syntax reference specifically <A HREF="http://pcl.to/reference/#pcl_margin" REL="nofollow">here - margins</A> you will see reference to top Ec&l#E and left margins Ec&a#L plus Long edge (left) offset registration # - Ec&l#U Short edge (top) offset registration # - Ec&l#Z.<BR/>Have a play with those in the initialization string and see how you get on. <BR/><BR/>GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-58794658190827719472008-04-09T17:28:00.000+12:002008-04-09T17:28:00.000+12:00Hi Gareth,Stumbled upon your post while searching ...Hi Gareth,<BR/><BR/>Stumbled upon your post while searching for PCl codes and syntax. Really a great post for customizing printer drivers.<BR/><BR/>I have a question regarding APLASP.prt. In my format payment (APXPBFEL) layout i have put date field at left-most corner of layout. But while printing it using a HPLJ4SI type printer with style "Portrait - Laser Check" that field is printing 3 to 4 chars left and not on exact left-most corner of paper. So is there anyway that we can print on left most corner without any margin using APLASP.prt ?<BR/>Please suggest.<BR/><BR/>Tapan16DEC71https://www.blogger.com/profile/02454875523349103413noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-52090467645077977282007-11-01T08:00:00.000+13:002007-11-01T08:00:00.000+13:00PS. Just noticed you are sending .ps files, did yo...PS. Just noticed you are sending .ps files, did you try putting tray control inside the Postscript file?<BR/><BR/>Hmm, this is getting close:<BR/>http://www.ecrion.com/Support/KB/Kb.aspx?topic=2.xml<BR/><BR/>GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-57666977455979249122007-11-01T07:52:00.000+13:002007-11-01T07:52:00.000+13:00Hi Ashish,Might have missed making my point ... th...Hi Ashish,<BR/><BR/>Might have missed making my point ... the output from BI Publisher is not a straight text file, so it will be sent to the printer in raw mode - I think this means you'll only get tray control at the whole file level as e.g. PostScript has tray control inside the file.<BR/>Perhaps the BI Publisher Delivery Manager / bursting can help here?<BR/><BR/>GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-12982438039005025162007-10-31T20:33:00.000+13:002007-10-31T20:33:00.000+13:00Gareth, thanks a lot for your inputs. First of all...Gareth, thanks a lot for your inputs. <BR/>First of all, I did try section properties in RTF to control tray-selection, however, that did not work. Reason being, this properties are not retained in the generated output.<BR/><BR/>Second, I've not checked options with pdf2ps to generate PS to include tray-control. Will have a look. <BR/>However, from what you are suggesting here (preprocess=pdftops -?sometrayoption? {infile} {outfile}), it seems that the selected tray will apply to entire document rather that pages in it. So maybe I'll have to submit multiple requests to have different pages printed on different trays. I would consider that a less preferable option.<BR/><BR/>Also, I am thinking of using lp command directly from java, instead of using Printer setup defined in Ebiz. And I've tried the following various options with no luck..<BR/><BR/>lp -dpzmn00x170045 -o 1:InputSlot=Middle -o 2-2:InputSlot=LargeCapacity /home/kmahesh/Test.ps<BR/>Outcome: First page from Middle Tray 2 and the second page from Tray 4<BR/><BR/>lp -dpzmn00x170045 -o InputSlot=Lower /home/kmahesh/Test.ps<BR/>Outcome: Tray 2<BR/><BR/>lp -dpzmn00x170045 -o InputSlot=middle /home/kmahesh/Test.ps<BR/>Outcome: Tray 2<BR/><BR/>lp -dpzmn00x170045 -o InputSlot=Tray2 /home/kmahesh/Test.ps<BR/>Outcome: Tray 2<BR/><BR/>lp -dpzmn00x170045 -o media=Middle /home/kmahesh/Test.ps <BR/>Outcome: Tray 2<BR/><BR/>lp -dpzmn00x170045 -o media=middle /home/kmahesh/Test.ps <BR/>Outcome: Tray 2<BR/><BR/>lp -dpzmn00x170045 -o media=Tray2 /home/kmahesh/Test.ps <BR/>Outcome: Tray 2<BR/><BR/>lpr -ppzmn00x170045 -o media=Middle /home/kmahesh/Test.ps<BR/><BR/>None of the above is working. I am thinking of PPD file issue here. But not sure.<BR/>If lp command is able to select tray, my problem is resolved.<BR/>If you ever saw tray selection options with lp command working for HP Laserjet 8150N, please do let me know.<BR/><BR/>Thanks once again for your time.<BR/>Ashish.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31331079.post-17667190626534469772007-10-31T12:18:00.000+13:002007-10-31T12:18:00.000+13:00Hi Ashish,I can't test my answer right now since I...Hi Ashish,<BR/><BR/>I can't test my answer right now since I don't have a multi tray printer... but I'll think out loud.<BR/><BR/>My understanding is that PASTA is used to print the output from your program via Postscript rather than PCL. This blog talks about tray selection when printing a text file using PCL printer commands rather than Postscript. So you'll need to get the tray select codes inside the postscript or instruct PASTA to select the tray at the time it sends the job to printer. If printing at the time file is sent to printer, then the tray will be for the whole file.<BR/><BR/>Let's give the chain of events for better understanding.<BR/>1. Your java concurrent program produces XML<BR/>2. XML is passed to BI Publisher and say, PDF document is produced<BR/>3. PDF document is passed to PASTA for printing<BR/>4. PASTA uses utility pdftops or pdf2ps to convert PDF to Postscript<BR/>5. PASTA sends postscript to printer.<BR/><BR/>So the first option I see is to modify e.g. $FND_TOP/resource/pasta_pdf.cfg to change the line:<BR/> printCommand=lp -c -d{printername}<BR/>to something like<BR/> printCommand=lpr -Ztray2 -P{printername}<BR/><BR/>Alternatively maybe pdftops could achieve something in the preprocess line:<BR/>preprocess=pdftops -?sometrayoption? {infile} {outfile}<BR/><BR/>Finally, to get different pages to different trays would require the postscript having tray control included ... I guess you have tried an RTF template with multiple sections going to different trays?<BR/><BR/>Or if that wasn't possible, then maybe use bursting? and print each bit using one of the prior techniques?<BR/><BR/>Interested to hear from anyone who has this working.<BR/><BR/>GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.com