Comments for Integrating XML Publisher and OA Framework at http://www.apps2fusion.com , comment 1 to 68 out of 20 comments http://www.apps2fusion.com Tue, 07 Feb 2012 19:08:44 +0100 FeedCreator 1.7.3 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-10706 Controller: byte buf[] = "".getBytes(); outputStream.write(buf); XMLNode Nodes[] = new XMLNode[10]; Nodes = AM.getDataXML(); for(int i = 0;i - Hande D Wed, 01 Feb 2012 03:33:11 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-10705 Application module code : public XMLNode[] getDataXML() { int r = 0; XMLNode NodeList[] = new XMLNode[15]; try { ByteArrayOutputStream outputStream = new ByteArrayOutputStream(); XxisbtYbnOzlukVOImpl vo = getXxisbtYbnOzlukVO1(); XxisbtYbnTertayVOImpl tvo = getXxisbtYbnTertayVO1(); XxisYbnEgitimVOImpl evo = getXxisYbnEgitimVO1(); XxisHrYbnCezaBilgileriVOImpl cvo = getXxisHrYbnCezaBilgileriVO1(); XxisbtYbnTumPerformansVOImpl pvo = getXxisbtYbnTumPerformansVO1(); TesekkurBilgileriVOImpl tevo = getTesekkurBilgileriVO1(); YakinmaBilgileriVOImpl yvo = getYakinmaBilgileriVO1(); XxisYbnOdulBilgileriVOImpl ovo = getXxisYbnOdulBilgileriVO1(); XxisHrHyoToahVOImpl hvo = getXxisHrHyoToahVO1(); NodeList[0] = (XMLNode)vo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS); ((XMLNode)vo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)).print(outputStream); if(tvo.first()!=null){ NodeList[1] = ((XMLNode)tvo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)); ((XMLNode)tvo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)).print(outputStream); System.out.println(outputStream.toString()); } if(evo.first()!=null){ NodeList[2] = ((XMLNode)evo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)); ((XMLNode)evo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)).print(outputStream); } if(cvo.first()!=null){ NodeList[3] = ((XMLNode)cvo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)); ((XMLNode)cvo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)).print(outputStream); } if(pvo.first()!=null){ NodeList[4] = ((XMLNode)pvo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)); ((XMLNode)pvo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)).print(outputStream); } if(tevo.first()!=null){ NodeList[5] = ((XMLNode)tevo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)); ((XMLNode)tevo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)).print(outputStream); } if(yvo.first()!=null){ NodeList[6] = ((XMLNode)yvo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)); ((XMLNode)yvo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)).print(outputStream); } if(ovo.first()!=null){ NodeList[7] = ((XMLNode)ovo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)); ((XMLNode)ovo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)).print(outputStream); } if(hvo.first()!=null){ NodeList[8] = ((XMLNode)hvo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)); ((XMLNode)hvo.writeXML(4, XMLInterface.XML_OPT_ALL_ROWS)).print(outputStream); } } catch(Exception e) { throw new OAException (e.getMessage()); } return NodeList; } Controller: byte buf[] = "".getBytes(); outputStream.write(buf); XMLNode Nodes[] = new XMLNode[10]; Nodes = AM.getDataXML(); for(int i = 0;i - Hande D Wed, 01 Feb 2012 03:28:17 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-10695 if u getting the issue with the empty/damaged pdf Then create the tmp folder in your local system where jdeveloper is installed.This will fix the issue. suppose if ur jdeveloper is present in D drive ,then create the tmp folder in D drive. It will fix the error. Thanks, Praveen Sudhati. - praveen sudhati Wed, 25 Jan 2012 02:32:32 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-10617 Hi Prabhakar, It was a nice a nice article, I have added few properties to make it work. Now I have a big issues we have developed this XML report based on a view, but when I modify the view like adding a column or removing a column it is throwing some errors. can you please suggest me what to do if VO objects base query that is based on VIEW modified?. Thanks in Advance. Srinivas - srinivasa Telu Wed, 21 Dec 2011 17:21:15 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-10212 Hi Do you think it could be possible to bypass the pop up window "File download security Warning" and go directly to the PDF file Thanks - Rolland Charpentier Fri, 23 Sep 2011 10:01:32 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-9703 Hi My requirement is as below I have a master page which has a simple search region. For eq If i query the master page it gives me 5 records Clicking on any of the records takes me to the details of that record. I have a button which generates the PDF output for that detail record. I want the functionality that when the user clicks the button the PDF output should directly be printed Currently the user has to open the PDF output and then Click on the Print in PDF output to print the record My next requirement is that to bring the PDF button(on the detail Page) to the master page so that on one click i should be able to Print all the PDF report records. Please help me with this Thanks - MandarD Wed, 27 Jul 2011 05:30:44 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-9268 Hi I am also getting the error as mentioned above. I am working on R12. Please suggest something . I am not able to proceed further. ~Richa - Richa Thu, 14 Apr 2011 05:29:17 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-9231 Hi , I am also getting this error Error: file type is not supported or file is damaged while trying this example. Please provide the solution for it,i have gone thorugh the comments above, tried to acchieve,but unable to suceed. :( Please help!! - Udeshika Mon, 11 Apr 2011 03:37:11 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-8560 HI How can i build xdo library from xdo directory on oaf server to my jdeveloper client thanks - musavi Sat, 06 Nov 2010 08:15:36 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-8520 OK.. here is how it started working for me. Hopefully, it might help someone else. Instead of a PDF.. I set the output for html, so I could read the error message. Their was an error message "No corresponding LOB data.." BLAH BLAH. Come to find out, it could not find my template. Through some trial and error, I set the TEMPLATE_CODE = and the error message went away. Set it back to PDF.. and success... it is working beautifully. Not sure why, I'm just a beginner in all this. - Dracis Mon, 25 Oct 2010 07:39:04 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-8512 Thanks for the Article, really learning alot. Unfortunately, I (like many others) am getting the issue with the empty/damaged pdf. I am recieving the message both from within Jdeveloper and after deployment to our unix development box. I'm going to keep after it, because this undoubtedly will come in very handy in the future. I'll post back if I have success. If anyone else has figured it out, please post as well. Thanks !! - Dracis Fri, 22 Oct 2010 08:52:32 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-8472 The issue that the PDF is not readable, empty or damaged is because you run the page from within JDeveloper. I got the same error and in the text that is dumped into the PDF (the PDF contains a complete dump of the error page it seems) i could see that it is because of the file path. The file path in JDeveloper is built with windows "\" separator for the folders, while it should be the unix "/" off course. After installing the page on the server everything worked fine for me. - Robert Jungerius Mon, 11 Oct 2010 10:36:15 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-8195 Hi Dutta, I assume, you want a master detail relationship between VOs. just add thechild VO as View Link and execute the Master VO. When you invoke the master VO to write the xmlNode and write file stream, It will write the xml for all viewlink as well. -Raj www.adivaconsulting.com - Ashihs Raj Sun, 15 Aug 2010 13:48:15 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-8194 I assume, You are calling some thing similar to folling statement. params is the Vactor, you can pass all the value as vector. make sure you pass in the same sequence as defiend in CP definiton. submitRequest("AP", "APXSOBLX ", "Supplier Open Balance Letter", null, true, params); // arguments vector Please check the Comments section og following Blog entery for futher details on the same question. Submitting BI Publisher Concurrent Program from PL/SQL http://www.adivaconsulting.com/adiva-blog/item/8-bip_concurrent_program_plsql -Raj www.adivaconsulting.com - Ashihs Raj Sun, 15 Aug 2010 13:42:42 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-8184 Thank you for the great sample code. I am able to open, save my pdf file after clicking on a button on page, but the problem is that when I closed the pdf window, my other buttons on the base form do not work, I got a message of "You cannot complete this task because you accessed this page using the browser's navigation buttons (the browser Back button, for example)." Have you seen this kind of error before. Thank you in advance. Steve - Steve Thu, 12 Aug 2010 18:39:54 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-8080 Hi I need to call a concurrent program using OAF personalization. I got this working fine but I need to know how to pass parameter values to the concurrent program. Please suggest a way to do this. Regards, Girish. - narne Mon, 12 Jul 2010 13:50:25 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-7934 could not open because it either not a supported file or because the file has been damaged " when the PDF file opens . Please guide in this case. Have been sturggling with this error for almost 4 days.. - Gana Sun, 20 Jun 2010 04:54:28 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-7655 Hi Prabhakar, your article helped me very much to learn how to generate XML data from single VO. Can you please post how to create XML data from multiple VOs. Thanks & Regards Raj - Raj Dutta Thu, 01 Apr 2010 05:18:38 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-7492 Hi, I have an RDF Report which generates the XML data and XML template registered in BI publisher. Requirement is to fire the custom existing report instead of standard report. The standard controller seems to generate XML and generate OA framework report as shown in your example. But I want to extend the existing controller / overwrite the standard to call my custom report. Can you tell me how to do this? - Ambika Thu, 18 Feb 2010 19:31:52 +0100 http://www.apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework#comment-7404 sorry freinds I am unable to add the code. Is is not getting updated in the site - jyoti jain Wed, 27 Jan 2010 03:56:51 +0100