Who's Online
We have 21 guests onlineMain Menu
| Home |
| Technical Articles |
| Training Articles |
| Receive Email for New Articles |
| Contributors |
| Hands-On-Training |
| Apps Book |
Also see here fully verifiable feedbacks/testimonials
| XML Publisher - Developing reports printed on Pre-Printed Stationary | | Print | |
| Written by Anil Passi | |
| Thursday, 07 June 2007 | |
|
I am pleased to introduce to you Mr Darshan Bhavsar. Darshan is a Senior Technical Oracle Applications Consultant and amongst many things, he specializes in XML Publisher. In this article, he will explain the steps to implement XML Publisher reports for Pre-Printed Stationary in Oracle eBusiness Suite.
The article below is from Mr Darshan Bhavsar. The Sample Template and Data file can be downloaded from the end of this article. Abstract I was inspired to come up with this because I feel that lots of people want this solution and they are struggling to implement this. In this whitepaper, I am going to explain the approach which I used for developing pre-printed stationary reports by XML publisher’s RTF method. This approach I used for 2 customers and it works absolutely fine. They are very happy. Example Pre-Printed stationary reports which I worked on are following ‘AP Check Printing(Bank)’ ,’AR invoice Printing’,’PO purchase Order Printing’ …. etc…. I have a customer who wants to convert their 40+ Oracle Apps reports to ‘XML publisher’ Reports. These reports are fall in categories of AR invoice report, check printing report and PO print report which they are printing on pre-printed (pre-defined) stationary. Just a little background of pre-printed stationary report’s layout where there is a fix Header section and fix Detail Section Table. Detail section table should always have fix table height, in the sense it should always have fix number of rows in the table no matter how many rows returned by actual report run. For example Invoice stationary has fix 30 rows in line detail table, and Actual report run is returning only 5 rows then rest 25 blank rows should be generatedprogrammatically.
So far it has not been discovered because of the limitation of for-loop in XSL-FO (XML Technology).Limitation I mean is ,we can not write loop like ‘ for (i=10;i<15;i++)’ in XML. In XML ‘for’ loop will always iterate till it gets data, if we want to go beyond that then we can not go. I mean we can write for loop based on data value. To overcome this problem, I have used Sub-template concept which I am calling recursively.
I am giving this solution for Standard Check Printing Report. Tree structure of data (Sample XML data is as follow). <LIST_G_CHECKS> <G_CHECKS> -- Top Most root -- Header <C_CHECK_NUMBER>21897</C_CHECK_NUMBER> <C_VENDOR_NUMBER>2205</C_VENDOR_NUMBER> <LIST_G_INVOICES> <G_INVOICES> -- Inner loop - Line Section <C_PAYMENT_NUMBER>1</C_PAYMENT_NUMBER> <C_INVOICE_NUMBER>ERS-20-SEP-06-243</C_INVOICE_NUMBER> </G_INVOICES> <G_INVOICES> -- Inner loop - Line Section <C_PAYMENT_NUMBER>2</C_PAYMENT_NUMBER> <C_INVOICE_NUMBER>ERS-20-SEP-06-244</C_INVOICE_NUMBER> </G_INVOICES> </LIST_G_INVOICES> </G_CHECKS> </LIST_G_CHECKS>
Below is the step-step guide which I follow.
1) Open the Outermost for loop -- G_CHECKS <?for-each@section:G_CHECKS?>
2) Declare Global Variable called ‘no_of_lines_per_page’ -- In this case I have fixed 40 lines per page. <xsl:variable name="no_of_lines_per_page" select="number(40)"/>
3) Declare incontext variable for inner group (G_INVOICES), variable is called ‘inner_group’ <xsl:variable xdofo:ctx="incontext" name="inner_group” select=".//G_INVOICES"/>
4) Open the Inner Loop <?for-each:$inner_group?>
5) Before putting any elements with the help of current record pointer 'position()’, I am checking if the current position is modulizing with the no_of_lines_per_page equals zero or not. If it reaches the first record after modulizing then I will create local variable 'first_rec' and initialize it with '0'. <?if:(position()-1) mod $no_of_lines_per_page=0?><xsl:variable name="first_rec" xdofo:ctx="incontext" select="position()"/>
Note : -- Above 3 steps ( 3,4,5) are created under ‘V_inner_group_And_V_First_rec’ form-field. Here there is limitation of Microsoft-word. We can enter upto 138 characters only in ‘Status’ field of ‘Add help text’ button.If you want to add more , you can do this by clicking on ‘Help Key’ which is adjacent to ‘Status’ tab.
6) If above condition holds true then we will iterate the inner loop. <?for-each:$inner_group?>
7) I will check with the help of current record pointer 'position()' that the current record position is either greater than 'first_rec' i.e. the first record or less the 'no_of_lines_per_page' value set up earlier. If it is then show the record otherwise not otherwise it will not go in loop. <?if:position()>=$first_rec and position()<$first_rec+$no_of_lines_per_page?>
8) Here I am closing the inner for loop and if condition <?end if?><?end for-each?>
9) Here I am checking if no_of_lines of invoice is modulizing with the no_of_lines_per_page equals to zero or not ,and the same time I am checking if $first_rec+$no_of_lines_per_page is greater than no_of_lines of invoice or not. This is important step for filling the blank rows. <?if:not(count($inner_group) mod $no_of_lines_per_page=0) and ($first_rec+$no_of_lines_per_page>count($inner_group))?>
10) Now I am calling sub-template recursively for filling the blank rows. While calling this template I am passing one parameter which is having value of no_of_rows to fill. Sub-template will have just one row table. <xsl:call-template xdofo:ctx="inline" name="countdown"><xsl:with-param name="countdown" select="$no_of_lines_per_page - (count($inner_group) mod $no_of_lines_per_page)"/></xsl:call-template>
11) Sub-template declaration <xsl:template name="countdown"> <xsl:param name="countdown"/><xsl:if test="$countdown"><xsl:call-template name="countdown"><xsl:with-param name="countdown" select="$countdown - 1"/> </xsl:call-template></xsl:if> </xsl:template>
12) I have created page break after the fixed number of rows have been displayed. <xsl:if xdofo:ctx="inblock" test="$first_rec+$no_of_lines_per_page<=count($inner_group)"> <xsl:attribute name="break-before">page</xsl:attribute> </xsl:if>
13) Finally closing outer if and inner for loop and outer for loop. <?end if?><?end for-each?><?end for-each?>
If you want more information then please contact me on Darshan.bhavsar@gmail.com
Thanks Darshan
Comments
(62)
 written by pandit , June 09, 2007 written by Dhaval Rathod , June 09, 2007
Darshanbhai....
Great Job... I am pleased to work with you. This document is wonderful.... it will really help to all of us. Regards, Dhaval Rathod written by Anil Passi , June 15, 2007 written by uma , June 18, 2007
Hi Darshan,
Thanks for your Information. We need to develop same thing for my client. very nice... Thanks tonn.. written by Baji , June 25, 2007
Hi Darshan/Anil,
i am new to XML Publisher, can u tell me the steps that r to be followed when create a report using XML Publisher. Regards Baji written by Anil Passi , June 25, 2007
Please visit this link
http://oracle.anilpassi.com/xm...xmlp.html thanks anil written by Jay , June 27, 2007
Anil,
Can i put reference of your articles on my page? Thanks, Jay written by Anil Passi , June 27, 2007
Dear Jay
Of course you can give links onto here Its all about sharing the knowledge cheers anil written by Anil Passi , July 02, 2007
Hi Raj
Possibly Oracle thinks that you are still running your report via XMLP. Assuming all that you need is new XML Output, I suggest you do this:- 1. Query the concurrent program 2. Use copy concurrent program into xx temp xmlp, with parameters 3. Include this in record group 4. Run this cocurrent program 5. Pick XML 6. Modify template and attach that to EBS 7. Disable xx temp xmlp 8. re-enable your template 9. run your original program Thanks Anil Passi
Hi,
My requirement almost similar.But the output should be in RTF format.When I am trying with this.I am getting blank pages in the middle of the report.Can you please help me. Regards, cma
Hi CMA
It appears that the issue is most certainly with your RTF Template. In the RTF Template, go to "Page Setup" option and within Layout tab see if "Different first page" checkbox is checked? If so, try to uncheck this and try again Thanks, Anil Passi
Hi Anil Passi,
Different first page is unchecked.But still I am facing this problem.Pdf layout is coming but its creating problem when the output type is RTF.Also added to this,when I run this in oracle the request is ending in completed warning.When I checked the OPP log the following is the log [7/3/07 10:50:25 AM] [UNEXPECTED] [1131929:RT18857336] java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(XSLT10gR1.java:580) at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:37  at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:197) at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:156) at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:916) at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:869) at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:204) at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1535) at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:925) at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:210 at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:136 at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:245) at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:153) Caused by: oracle.xdo.parser.v2.XPathException: Variable not defined: 'inner_group'. at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1526) at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:517) at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:485) at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:264) at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:150) at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:187) ... 17 more Regards, CMA
Hi CMA
The error below is an internal XMLP error. oracle.xdo.parser.v2.XPathException: Variable not defined Please raise SR with Oracle, as I think you might be hitting some bug in XMLP. Thanks Anil
Hi Anil,
I have a very basic question about generating xml output for Check printing. In the check print setup i found we are using executable APXPBFEG. Now I have made a copy if this program and set the output to xml. I will assign it to the format payment program. I am not clear after this step. Can you please suggest something? Thanks narain
Hi Narain
I think to begin with you need to get familiar with basics of XMLP. This can be found on link http://oracle.anilpassi.com/xm...-xmlp.html Thanks, Anil
Hi Anil,
Sorry i dint phrase that question correctly. I was running the format program directly from sysadmin to get the XML output. I just realised I have to submit the check(from payables) and then the XML gets generated. Thanks for you patience Narain
Hi Darshan
thnx a lot for a very useful article. i will try to run the template with sample data and try some variations in it. but presently i couldnt get the preview from XML Template Builder, which used to work prefectly before. I tried re-installing it, but in vain. When i press Preview from the menu, nothing happens. Regards Kishore
Hi Darshan
Preview is working after i installed the latest version of XML Template Builder from http://edelivery.oracle.com Regards Kishore
Darshan/Anil
I think a simpler approach would be to use hidden tables in the rtf template
Above 3 steps ( 3,4,5) are created under ‘V_inner_group_And_V_First_rec’ form-field. Here there is limitation of Microsoft-word. We can enter upto 138 characters only in ‘Status’ field of ‘Add help text’ button.If you want to add more , you can do this by clicking on ‘Help Key’ which is adjacent to ‘Status’ tab.
thats whats written in the above article please tell me what if the code does'nt even fit there?????????? where can i add more code????
hi anil,
i am a technical consultant working on r12 xml publisher. created xml file and rtf template. my issue is have to create concurrent program to register & run a report.how to do that can u pls help me out if permits with necessary screenshots. thax in advance.struggling alot. thx madhavi
Hi,
I need the sql used to generate the Xml availbale here for download. If it is .rdf then please provide me the same as well
Thanks for sharing the knowledge
i am learning apps from your site and your site really helps with respect to this article i would like to know the basics of XML programming , if you can provide some basic examples or link for that
Hi,
I am unable to display the barcodes.Initially I am able to display the barcode using Code128 font but I am trying to encoding the barcode by using the blog http://blogs.oracle.com/xmlpub...Reader$281 , even barcodes are also not displaying. So please help in this regard. Thanks, SubbaRao
Anil,
This article is awsome. Really helped me a lot. I need little more on this template. Could you please tell me how to add page totals, and if there are more than one page I want to print check on every page with "VOID ON THAT" and print signature only on last check page. I appriciate you response Thanks Naveen navchep@yahoo.com
Anil/Dharsan
Nice artilce, I want the subsequent copies of the check to print VOID on them. How can I do this? Thanks in Advance Naveen navchep@yahoo.com
Hi Anil,
I am writing the RTF template for XMLP Report. And i have a situation that i am displaying the total of Adjustment and payment made on each invoice and lines level. And like this i may have several invoices under one Customer. So when i am running the total for Invoice level payment and Invlice level adjustment on the customer level. It is not showing me the proper total. I wants to use the Variable in my RTF template. Can u tell me how to do that.
Hi Anil,
I am workin gon Print Po Report, i have a requirement that i have to display the Buyer signature (sign.gif) file based on the buyer parameter at run time. for this im using url:{concat('${OA_MEDIA}','/',IMAGE_FILE)} method here sign.gif
Hi Anil,
I am workin gon Print Po Report, i have a requirement that i have to display the Buyer signature (sign.gif) file based on the buyer parameter at run time. for this im using url:{concat('${OA_MEDIA}','/',IMAGE_FILE)} method here sign.gif
Hi Anil,
I am working on the AP check print report using xml publisher.I am using standrd report Format Payments (Everygreen,form feed)-APXPBFEF for printing the checks and I am running the report from the payment->entry>payment btaches.My probelm is when we submit the request the from the payment btaches,its printing only the xml tags ,it did not bring the xml templates?Can you help me out how to bting xml layouts from the payment batches? thanks in advance krishna kishore kumar
hi Darshan/Anil,
I am trying to convert Invoice report to XML. I find an article 'Converting Reports from Oracle Reports to Oracle BI Publisher' using BIPBatchConversion, in download.oracle.com where they have given steps for converting reports to XML. You have any opinion on it. Have you tried it?
Hi Darshan/Anil,
Its a Great article, helping to many people.i learned many things from this.I have some issues in my Print PO Report could you pls clarify, i appriciate u r response..thanku. My client was using Oracle Apps reports and Optio Reports (for Printing the Layouts), now my client wants to convert Oracle Apps reports to ‘XML publisher’ Reports .Now i am working on "Print PO report" my reuirement are : 1. Dispalying the Image (james.gif) signature file dynamically based on the 'Buyer' (parameter), im getting the buyer (james) name and buyer email address(james@xxx.com) in XML file and in the $OA_MEDIA directory the related file is james.gif how to get the james.gif file from the $OA_MEDIA directory in to Oracle Reports (in to RDF) or if this is possible in the RTF Templates how to handle this in RTF templates? 2.for the above report i hve to email/fax to perticular supplier based on email address/fax number. 3. running the Batch Reports: for the above report im getting the pDF output for perticular PO number = 1001, where as in the Batch processing (running the Ten PO's in a batch) how to handle all the Po's output in the same/different RTF Template ? and after getting the OutPut i have to email/fax to different suppliers based on the PO NUMBER ( for suppose out of PO#1001 to PO#1010 PO's i have to semail/fax PO#1001 to supplier A, and PO#1002 to supplier B .Where as previously this was handling by Optio Reports im not sure abt Optio reports but as per my KT i came to know this. 4.Suppose in the report if i have 10 lines, 8 lines printed on the first page and 2 on the second page.. immediately im displaying the total with some NOTE, and email ddress.. here my requirement is, In the second page if i get the less number of lines in the second page i have to display the TOTAL and EMAIL ADDRESS and NOTE at the bottom of the page. 5. How to develop multilanguage RDF Templates and how to set the Multilanguage Templates (different templates) at run time based on the OPER.UNIT and SUPPLIER COUNTRY my requirement is ..based on the oper.unit and supplier country i have to select the RTF template (English,spanish and Portuguese languages)at run time and email/fax/print the report? I Appriciate your response. Thanks in Advance. Madhu
Hi Everybody,
I am converting invoice rdf report to XML. Do anyone have any idea on how we can use format triggers in XML report? Thanks in advance, Shankar
Hi Anil,
I am having issue with the Invoice on pre-printed stationary.... I have used darshans template, but mine is bit complex i am having two sub groups below Main group.. Isssue is, i am able to fix the length for the first sub group but for second sub group i am unable to do so. Besides that my second group resets it self and start from the first record.Uploading the rtf template and xml file.Appriciate your help.. --Raj
hi,
Currently the description field is limited to 30 char only. When the description exceeds 30 chars and we have to show the full description, then the template seems to be not working, the count($inner_group) only counts the printed no. of rows for the group.It does not take into account the extra lines due to wrapped up data. Can anyone suggest how to handle such situations? Thanx Amitav
Dear Anil/Darshan
This is the best site that I have found to get help with XML Publisher. Your example in this article is exactly what I needed to create our check forms with XML publisher. I could have never figured this out on my own without this article. I am having on minor problem with my template and I was wondering if you had any advice. The layout of our check forms has the check portion at the bottom of the page. The top of the page is the stub with the repeating lines. I'm finding that the more lines of output that I have on the stub, the farther down the page the end of the stub box floats. I'm using courier new font and it should be fixed width and height, but something is causing the repeating area to grow and this is pushing the check portion of the layout off the end of the page. Any suggestions would be greatly appreciated!! Thanks, Diane
Hi Anil/Darshan,
pls answer this issue. How can I retrieve additional data from tables using the XML Publisher. We are using XML Publisher 5.6.2 v. What we are trying to do is to display additional data that is not a part of the standard oracle seeded report output. We have seeded reports in Oracle apps. Lets take an example of a purchase order report. Say the seeded out-of-the-box report has the following information: PO number, PO details I can go ahead and use the template builder and create a nice looking report with that information. Now, lets say that I want to display the supplier name in my purchase order report. Since the seeeded purchase order report does not have the supplier name (it is not there in the xml generated by the standard out-of-the-box report), the only way I can display the supplier name on the report is by querying up the supplier table and getting that information. I know that I can go ahead and modify the existing out-of-the-box report, but I do not want to do that. I do not have control over the XML that is generated since the XML is generated when the report is run. Is there any way to retrieve the extra information (the supplier name in this example) AFTER the xml has been generated and BEFORE the template is applied ? I really appriciate your response. Thanks, Madhu
Hi Darshan,
I'm working on R12. Can you tell me which the standard report that I need to use for the check printing in R12? Thanks Geetha
Hi all,
This site is doing great. Thanks for all your work. Thanks, Sd
Hi Darshan/Anil
I am having issues with the consolidated Invoice on pre-printed stationary... I need to fix the number of lines in the first page. I am using the Invoice template we have in the current system. But Here i am having two sub groups below the main group and i couldn't able to fix the number of lines. I couldn't able to attch my template here, let me know how can i sent that to you. Thanks in advance, Kumar  written by Mohammad Rafi.Shaik , November 07, 2007
Hi,
I have a requirement as Multiple Layouts in a single RTF and each layout in the RTF opening in a new or Seperate PDF or EXCEL Can you eloborate on the solution Thanx In advance Mohammad Rafi.Shaik
Hi Anil,
I have been working on XML Publisher since past few months and couls successfully implement XML Publisher functionality called "Bursting Engine". I have prepared a white paper on this and would like to share with all through the medium of this site. Please let me know how would you like me to go ahead with this task. Thanks and regards, Kalyani
I have a requiremnt where we have abt 8-9 differnt layouts for ame report, Based on few parameters we want to dynamically choose a specific layout, we do not want the user to choose any specific layout.
Request you to pls guide me how to go abt this.
Hi Anil,
I have few problems in page breaks in the XML publisher 1) I have two detail blocks for a master. How to do the page break if the information is not fitting in one page. 2) How to check the page number and do the page break accoringly, say if the output is having 2 pages, I would like to move certain information to the second page. Thanks
Anil
I am working on the AP check print report using xml publisher.I am using standrd report Format Payments (Everygreen,form feed)-APXPBFEF for printing the checks and I am running the report from the payment->entry>payment btaches.My probelm is when we submit therequest the from the payment btaches,its printing only the xml tags ,it did not bring the xml templates?Can you help me out how to bting xml layouts from the payment batches? i am planning to use the solution to call FND_REQUEST.SET_PRINT_OPTIONS) and calling template using fnd_submit (FND_REQUEST.SUBMIT_REQUEST) XDOREPPB. is this a practical solution. Please advice
Hi,
I am new to XMLP and developing RTF for AR Invoice Report. When i try to view the output in pdf format.In the Invoice lines details there is more gap between the lines,For e.g if i have five lines for single invoice, many gaps between the lines and also for each line it shows in indiviual rows. please help on this where to correct to get the line details one after another. with regards prabu
Hi Darshan/Anil,
I ma writing you first time and hoping for good solution! I have developed number of reports in XML publisher but all were based on XML output file from RDF. Now my requirement is to make Data template to make XML report,We dont have RDF for the report. Please suggets me the steps! Regards, Sumit Mittal
Hi Darshan,
i am working on invoice report, on the top i have customer details, and on below i have invoice totals etc, in between these two my invoice lines will start, i have created table in RTF template for invoice lines, my problem is Suppose in the report have 10 lines, 6 lines printed on the first page and 3 goes to the second page, i am not getting table end line on first page, its printing only after end of all the records. one more thing is i dont want line in between each record. Please suggest me. Regards, Jagadish
Hi,
I would like to print page totals in my a xml report please tellme the steps i shou;ld follow to get the page totals.
This is great site.I have two queries
1. How to handle blank pages .Iam getting blank page after main details.For eg you have project which have assembly details.After printing the first assembly details it is printing blank page then starting with second assembly details. 2. How do we handle duplicate rows in XMLP? Iam giving the eg of xml data.It consists of 4 groups.Lets say G1-project-11 G2- main assembly-22 G3- shortages-Purchase Order G4- Po Number-44 G1- It will have project details G2- will have main assebly details for that project G3- Shortages for the main assembly G4- Shortages details such as purchase order details When you run the template you will have duplicate rows ie above group data repeating two times ie. 1st receord project-11 main assembly-22 shortages-Purchase Order Po Number-44 2nd record project-11 main assembly-22 shortages-Purchase Order Po Number-44 Can you help in this how do i restrict single record.
hi anil
hi i want XML reports tutorial notes from scrach onwords ok thanks  written by Mani , December 28, 2007
Hi Anil,
This site is very informative and simple to understand. Need your help... I'm trying to convert the Oracle Reports to XML Publisher. The Steps I have followed are, 1) Open the report in Report Designer and convert to .xml using file conversion menu. 2) Transfered the .xml file into $JAVA_TOP 3) using RTFTemplateGenerator class, created the .RTF file. During this process another logfile which holds the Format trigger information also created. 4) Created the datadefinition using XML Publisher Responsibility and the code I have given the same as the short name of the concurrent program. 5) Created the Template and attached the datadefinition created in step 4. 6) Attached the .RTF file created in step 3 with the template. 7) Open the concurrent program definition using System administrator responsibility and the output type as 'XML'. When I executed the program, the lexical parameters used in the .RDF and the format triggers are not handled in the conversion. Could you please advice how to handle the lexical parameters and the format triggers used in the .RDF files. If possible, please give me an example. Thanks in advance for your help. Regards, Mani
Hi Anil/Darshan,
I am working on same thing.I need to print void on checks if the number of invoices overflow to the second page.I tried using ur steps but was not able to get the same.Can u help me out. Thanks, Navneet
Hi Anil/Darshan,
I am working on same thing.I need to print void on checks if the number of invoices overflow to the second page.I tried using ur steps but was not able to get the same.Can u help me out. Thanks, Navneet
Hi Darshan,
I am working on one of the pre printed stationary report. They have comments column in the report. This comment can take maximum of 4 lines in the stationary. But the column which stores the data is of 4000 chars and hence user can enter good amount of data. The requirement is that when column has data that is not fitting in 4 lines.. the row expands until it displays all the data. This causes all tables and rows below that to move down. I have set the row property to 2 inches exactly but this is not helping. The catch here is that by doing this if we manually key in the value for the row in the .rtf file only first 4 lines are visible and rest are not displayed as the row does not expand, but the same behaviour is not with the actual data when previewed with xml. Please let us know if there is a way to tackle this. Thanks, Suresh
Hi Anil,
I Am facing an issue.In my report,the length of aline is not fixed,it varies with data.so the no of lines per page cannot be fixed.Is there some other method by which i can keep the lentgth of table constant?? Its urgent.Please hep me out. Thanks, Navneet
Hi Darshan ,
Great work.. I have tried similar implementation in our office and works real great .. I have used PDF template for preprinted sttionary thou.. I am having problems with routing to printers when submitting a report from Applications.We wanted to automate the process of invoice printing .. but he hurdle is to route to a printer.. Any thoughts or an article.. Thanks
Hi Anil,
I need few drops from your sea of knowledge.. Dutch and US have diffrent requirements for layout. I've created two RTF and attached them to single Template(Created one and than Add File). But when I submit the program , asyou know it submits it for Multiple LAnguage and than in turn the invoice print program. But it always picks US layout(Default language AMERICA). Could you please throw some light on it or anyone. Thanks Manu - mail2manuamit@yahoo.com
Just to clarify-- I submit program from Dutch responsibility, I also change the layout to the one for Dutch. But when the programs runs it picks up US layout.
I would highly appreciate any direction on this, can't ignore to mention ur's is a Great website. Thanks Manu
Hi all,
I am creating a template to print AR Invoices in which I need to print a detachable part of it at the last page of each invoice. I am following the steps that Anil recommended using sub-templates, but for some reason it is not working. Below you will find the error I am getting. Font Dir: C:Program FilesOracleXML Publisher DesktopTemplate Builder for Word onts Run XDO Start RTFProcessor setLocale: en-us FOProcessor setData: U:XMLP ReportsReceivablesOpen AR Invoices.xml FOProcessor setLocale: en-us java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(XSLT10gR1.java:586) at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:383) at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:201) at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:161) at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1015) at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:96 at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:209) at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1561) at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:951) at RTF2PDF.runRTFto(RTF2PDF.java:626) at RTF2PDF.runXDO(RTF2PDF.java:460) at RTF2PDF.main(RTF2PDF.java:251) Caused by: oracle.xdo.parser.v2.XPathException: Variable not defined: '_MR'. at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1526) at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:517) at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:485) at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:264) at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:150) at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:187) Any help you can provide me would be greatly appreciated. Thanks in advance,
Hello Anil,
I am using XML Publisher version 5.6. I have build a template the same way you did yours using the template builder. I loaded a data source and than test the template. Everything looks good. I am getting correct page number. Than i created a data definition and upload my template in oracle Apps R11 XML publisher Module. After running the request, i am getting wrong ouptut for the page numbering .( in my template, i am using to reset the page number for every customer satement). Now if a customer have multiple invoices that needs to be print on 4 pages, i am getting the error - for example on the last page : page 4 of 1 when i run it from apps. Please i need to know why i am getting a false output for the page number when running the template from oracle apps requests. Please Anil i need you to reply ASAP... because it is urgent. Thanks for you support!
Hi,
how to design template as the above example you are provided. regards ram You must be logged in to a comment. Please register if you do not have an account yet.
|
Subscribe to this comment's feed
Thanks for sharing the knowledge
i am learning apps your site really helps
with respect to this article i would like to know the basics of XML programming , if you can provide some basic exaples or link for that
regards