tag:blogger.com,1999:blog-5406107793530126650.post2645829575160555732..comments2024-01-10T00:22:07.234-08:00Comments on BI Publisher Blog: BI Publisher: Let Go My LogoIke Wigginshttp://www.blogger.com/profile/03629933955296401382noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-5406107793530126650.post-55269016666741189502010-11-08T00:49:14.641-08:002010-11-08T00:49:14.641-08:00Hi,
I am unable to access the signature for check...Hi,<br /><br />I am unable to access the signature for check printing.<br />Signature file (image) is not in Oracle apps server. It would be stored in some secured server.<br /><br />I tried to access the image file through the command<br />url:{'${OA_MEDIA}/signature.gif'} it is working fine as the file is located in Apps server. <br />But this syntax is not working when the file is another server. <br />My file is located in the path: \\xxxx\zzzz\abc\signature.gif.<br />I am trying to access like url:{'\\xxxx\zzzz\abc\signature.gif'}. <br />But, it's not working. Please suggest me how to access the image.<br /><br />Best Regards,<br />Ramesh.Rameshnoreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-90191080151518954792010-06-04T05:06:39.638-07:002010-06-04T05:06:39.638-07:00Hi Wiggins,
I am trying to display a blob in rtf ...Hi Wiggins,<br /><br />I am trying to display a blob in rtf in a similar way you suggested. I am able to view the image in pdf, but gettting a blank page before and after the image file.<br />My rtf just has only one field with tag similar as follows,<br /><br />i tried other image types(gif, png) also,image is getting displayed but with blank page.<br /><br />Please assist me to resolve this issue.<br /><br />Also Please let me know options to resize the image as required. <br /><br />Thanks<br />IyeswariyaUnknownhttps://www.blogger.com/profile/17383510665225881779noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-71445986808409493012010-03-07T09:18:57.296-08:002010-03-07T09:18:57.296-08:00oh sorry i inserted a tag the full text didn't...oh sorry i inserted a tag the full text didn't show i meant use<br /><br /><br /><br /><br />notice the './/' in the select="" clause....that is what i was trying to point out...thanksSarfraz Ramayhttps://www.blogger.com/profile/04155521600255508428noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-84063033166376852762010-03-07T09:14:01.626-08:002010-03-07T09:14:01.626-08:00Depending on the image format you may have to chan...Depending on the image format you may have to change it. For your example you had to do that, for my example it was a gif....<br /><br />fo:instream-foreign-object content-type="image/jpgIke Wigginshttps://www.blogger.com/profile/03629933955296401382noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-50188106243828487262010-03-07T00:44:16.595-08:002010-03-07T00:44:16.595-08:00Hi there Ike,
regarding the FUNCTION mob_getbase64...Hi there Ike,<br />regarding the FUNCTION mob_getbase64String( P_blob BLOB )<br />i have some suggestions if you want to update this post its upto to you but i came across this scenario so i thought i will give people the heads up. I have having trouble using this funciton when BLOB column was null so a slight change i would suggest.<br />CREATE OR REPLACE FUNCTION mob_getbase64String( P_blob BLOB )<br />RETURN CLOB<br />IS<br />l_result CLOB;<br />BEGIN<br /> if P_blob is not null then <br /> DBMS_LOB.createtemporary(lob_loc => l_result, CACHE => FALSE, dur => 0);<br /> Wf_Mail_Util.EncodeBLOB ( P_blob,l_result);<br /> RETURN ( l_result );<br /> else<br /> return(null);<br /> end if;<br />END mob_getbase64String;<br /><br />Secondly,<br />The code for rendering the image in rtf template also needs to be changed slightly i.e<br />fo:instream-foreign-object content-type="image/jpg">Sarfraz Ramayhttps://www.blogger.com/profile/04155521600255508428noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-89667872154802021112010-03-06T12:32:15.426-08:002010-03-06T12:32:15.426-08:00Hey Ike,
Good news i did it :) Thanks mate for the...Hey Ike,<br />Good news i did it :) Thanks mate for the debug parameter help....it finally gave me the clue to what was wrong.....if you must know...you would notice a semi-colon at the end of the query in my data template....that was the invalid character :D anyways i still have the complex report at my hand and CLOB to handle so will bother you for your expertise :D thanks once again....Sarfraz Ramayhttps://www.blogger.com/profile/04155521600255508428noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-55907894152851086922010-03-05T09:19:06.188-08:002010-03-05T09:19:06.188-08:00Hi, I even tried with property=debug on, still the...Hi, I even tried with property=debug on, still the same error! what do you suggest?<br /><br />sarfrazAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-91106360762065599342010-03-05T08:46:22.320-08:002010-03-05T08:46:22.320-08:00Hi Ike,
I am uploading the url to screen shot of m...Hi Ike,<br />I am uploading the url to screen shot of my data template...can you please take a look at it and tell me what is wrong with it....i have made it manually after taking the guide lines from developers guide and some suggestions from the SR i raised....i can't even get this simple data template to run from apps with XDODTEXE as the executable.....can you help and i posted it last time but your comment box won't show it :) <br />http://www.freepicsupload.com/pics/phpqufcZO-DataTemplateScreenShot.jpg<br />Lets start from the very begining and make it simple....it is the same data template as the one in my last post so when i run this data template it produces the same error as described in my previous postSarfraz Ramayhttps://www.blogger.com/profile/04155521600255508428noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-31208435212014044152010-03-02T06:08:52.215-08:002010-03-02T06:08:52.215-08:00Turn on the debugging parameter in your data templ...Turn on the debugging parameter in your data template to see what query is getting executed and to get more details about the error. <br /><br /><property name="debug_mode" value="on"/><br /><br />What did you define the field data type as?<br /><br />Please tell me your not appending the clob data....Ike Wigginshttps://www.blogger.com/profile/03629933955296401382noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-27805639449747161092010-02-26T07:55:36.251-08:002010-02-26T07:55:36.251-08:00For the field that is pulling the clob what do you...For the field that is pulling the clob what do you have that defined as in the data template? <br /><br />What version of BIP are you running?<br /><br />What is the data type of field in oracle: Clob, blob, lob, long?Ike Wigginshttps://www.blogger.com/profile/03629933955296401382noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-45151517178608777742010-02-26T07:37:49.293-08:002010-02-26T07:37:49.293-08:00can someone please tell me whats wrong with this t...can someone please tell me whats wrong with this template and why is application erroring out when i run this as a concurrent request.I have made a concurrent program with XML as the output and XDODTEXE as the executable....please help<br /><br /><br /><br /><br /><br /> <br /><br /><br /><br /><br /> <br /> <br /><br /><br /><br /><br />and the error generated is <br />+---------------------------------------------------------------------------+<br />Human Resources: Version : 11.5.0<br /><br />Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.<br /><br />TDP_BLOB_CLOB module: TDP BLOB to CLOB XML<br />+---------------------------------------------------------------------------+<br /><br />Current system time is 26-FEB-2010 16:03:39<br /><br />+---------------------------------------------------------------------------+<br /><br />XDO Data Engine Version No: 5.6.3<br />Resp: 53838<br />Org ID : 1041<br />Request ID: 38224060<br />All Parameters: review_id=<br />Data Template Code: TDP_BLOB_CLOB<br />Data Template Application Short Name: PER<br />Debug Flag: N<br />{review_id=}<br />Calling XDO Data Engine...<br />--SQLException<br />java.sql.SQLException: ORA-00911: invalid character<br /><br /> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)<br /> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)<br /> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)<br /> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)<br /> at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:850)<br /> at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2599)<br /> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2963)<br /> at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)<br /> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:584)<br /> at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:515)<br /> at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:429)<br /> at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:300)<br /> at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:266)<br /> at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:205)<br /> at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:237)<br /> at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:364)<br /> at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:236)<br /> at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:293)<br /> at oracle.apps.fnd.cp.request.Run.main(Run.java:161)<br /><br />+---------------------------------------------------------------------------+<br />Start of log messages from FND_FILE<br />+---------------------------------------------------------------------------+<br />+---------------------------------------------------------------------------+<br />End of log messages from FND_FILE<br />+---------------------------------------------------------------------------+<br /><br /><br />+---------------------------------------------------------------------------+<br />Executing request completion options...<br /><br />+------------- 1) PUBLISH -------------+<br />Beginning post-processing of request 38224060 on node TLNT09 at 26-FEB-2010 16:03:45.<br />Post-processing of request 38224060 failed at 26-FEB-2010 16:03:45 with the error message:<br />One or more post-processing actions failed. Consult the OPP service log for details.<br />+--------------------------------------+<br /><br /><br />Finished executing request completion options.<br /><br />+---------------------------------------------------------------------------+<br />Concurrent request completed<br />Current system time is 26-FEB-2010 16:03:45<br /><br />+---------------------------------------------------------------------------+<br /><br /><br />i am working on<br />Database Server<br />----------------------------------------<br />RDBMS : 11.1.0.7.0<br />Oracle Applications : 11.5.10.2Sarfraz Ramayhttps://www.blogger.com/profile/04155521600255508428noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-84832700429401011402010-02-26T07:37:49.294-08:002010-02-26T07:37:49.294-08:00At last i did and still not working....i am not ev...At last i did and still not working....i am not even to get a simple template to work<br />can someone please tell me whats wrong with this template and why is application erroring out when i run this as a concurrent request.I have made a concurrent program with XML as the output and XDODTEXE as the executable....please help<br /><br /><br /><br /><br /><br /> <br /><br /><br /><br /><br /> <br /> <br /><br /><br /><br /><br />and the error generated is <br />+---------------------------------------------------------------------------+<br />Human Resources: Version : 11.5.0<br /><br />Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.<br /><br />TDP_BLOB_CLOB module: TDP BLOB to CLOB XML<br />+---------------------------------------------------------------------------+<br /><br />Current system time is 26-FEB-2010 16:03:39<br /><br />+---------------------------------------------------------------------------+<br /><br />XDO Data Engine Version No: 5.6.3<br />Resp: 53838<br />Org ID : 1041<br />Request ID: 38224060<br />All Parameters: review_id=<br />Data Template Code: TDP_BLOB_CLOB<br />Data Template Application Short Name: PER<br />Debug Flag: N<br />{review_id=}<br />Calling XDO Data Engine...<br />--SQLException<br />java.sql.SQLException: ORA-00911: invalid character<br /><br /> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)<br /> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)<br /> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)<br /> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)<br /> at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:850)<br /> at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2599)<br /> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2963)<br /> at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)<br /> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:584)<br /> at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:515)<br /> at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:429)<br /> at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:300)<br /> at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:266)<br /> at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:205)<br /> at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:237)<br /> at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:364)<br /> at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:236)<br /> at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:293)<br /> at oracle.apps.fnd.cp.request.Run.main(Run.java:161)<br /><br />+---------------------------------------------------------------------------+<br />Start of log messages from FND_FILE<br />+---------------------------------------------------------------------------+<br />+---------------------------------------------------------------------------+<br />End of log messages from FND_FILE<br />+---------------------------------------------------------------------------+<br /><br /><br />+---------------------------------------------------------------------------+<br />Executing request completion options...<br /><br />+------------- 1) PUBLISH -------------+<br />Beginning post-processing of request 38224060 on node TLNT09 at 26-FEB-2010 16:03:45.<br />Post-processing of request 38224060 failed at 26-FEB-2010 16:03:45 with the error message:<br />One or more post-processing actions failed. Consult the OPP service log for details.<br />+--------------------------------------+<br /><br /><br />Finished executing request completion options.<br /><br />+---------------------------------------------------------------------------+<br />Concurrent request completed<br />Current system time is 26-FEB-2010 16:03:45<br /><br />+---------------------------------------------------------------------------+<br /><br /><br />i am working on<br />Database Server<br />----------------------------------------<br />RDBMS : 11.1.0.7.0<br />Oracle Applications : 11.5.10.2Sarfraz Ramayhttps://www.blogger.com/profile/04155521600255508428noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-55587601373016011482010-02-25T19:44:31.908-08:002010-02-25T19:44:31.908-08:00Don't why my comment is not getting posted.......Don't why my comment is not getting posted....you mean to say that i should develope the data template manually? Then register the data template definition and run the concurrent program with XDODTEXE as an executable?Sarfraz Ramayhttps://www.blogger.com/profile/04155521600255508428noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-80814432608704892892010-02-24T07:20:07.662-08:002010-02-24T07:20:07.662-08:00Thanks Ike for a prompt response,
Yes clobs are su...Thanks Ike for a prompt response,<br />Yes clobs are supported in 6i but as soon a try to call or use them in xml, trouble begins. i have tried every angle on this believe me...I am using BIP 5.6.3 desktop add-in to word. I have tried<br />1)register the rdf with clob column as a concurrent program with xml output....its errors out with message in my last post<br />2)i first converted the rdf to xml using the rwconverter utility. the xml generated from that is perfect...no errors it even shows the clob column and its properties etc....but when i run the report with xml ouput....same xsl error appears.....but as soon as i convert the clob to varchar2 it works fine! now varchar2 has its limitation of 4000 bytes so that too is not a viable solution.....any comments are welcome! i am using ebs 11i 11.5.10.2Sarfraz Ramayhttps://www.blogger.com/profile/04155521600255508428noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-75497002340123301682010-02-24T05:24:39.739-08:002010-02-24T05:24:39.739-08:00Try generating your xml in a data template. What ...Try generating your xml in a data template. What version of BIP are you on.<br /><br />Clobs are supported in reports6i. Now, with that said xml is supported output option but it doesn't mean it isn't "quirky." Furthermore, enhancement or bug requests for reports6i is not really supported. You could try and log an SR but good luck with that :-)<br /><br />My advice, try it in a data template and see if you have the same problem. I don't think you will since a lot of people have been using blobs for sometime.Ike Wigginshttps://www.blogger.com/profile/03629933955296401382noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-52543695423494298822010-02-24T04:36:37.968-08:002010-02-24T04:36:37.968-08:00Hello there, i have spent a lot of time on the pro...Hello there, i have spent a lot of time on the problem u have stated and have been successful on ocassions too….but still hanging.<br /><br />wht report builder are u using. m using reports 6i and when i include a clob column and select xml ouput from the application ebs 11i i get the following error. no xml output is generated! do you have any solution?<br /><br />The XML page cannot be displayed<br />Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. <br /><br />——————————————————————————–<br /><br />The following tags were not closed: MODULE1, LIST_G_IMAGEID. Error processing resource ‘http://tlnt03.fi.gi.telenor.com:800…<br /><br />next i was able to get two segments by converting the blob to varchar2 using dbms_lob.substr(clob,4000,1) function and xml was perfect but when i go beyond two sengments the report starts to error out! can you please help, i am unable to solve this!<br /><br />can you please direct me to what is the limitation of reports 6i so that i can give reference to my boss!Sarfraz Ramayhttps://www.blogger.com/profile/04155521600255508428noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-8315870392339119302009-12-30T12:05:58.346-08:002009-12-30T12:05:58.346-08:00I love this site! Thank you sooo much for all your...I love this site! Thank you sooo much for all your posts!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-25244774994126893282009-04-29T08:44:00.000-07:002009-04-29T08:44:00.000-07:00This is a good example though I found another exam...This is a good example though I found another example which served my purpose<br /><br />http://blog.vmladenov.com/?p=310Unknownhttps://www.blogger.com/profile/07999918823742796308noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-35610964449964889022009-04-01T09:54:00.000-07:002009-04-01T09:54:00.000-07:00Valeria, Please try changing the mime type to: ty...Valeria, <BR/><BR/>Please try changing the mime type to: <BR/><BR/>type="image/gif" <BR/>or try<BR/>type="image/tiff" <BR/><BR/>Also, verify that the your xml file has data in the THUMBNAIL field. If the THUMBNAIL field only exists once in the xml file change your syntax //THUMBNAIL.<BR/><BR/>Ike WigginsIke Wigginshttps://www.blogger.com/profile/03629933955296401382noreply@blogger.comtag:blogger.com,1999:blog-5406107793530126650.post-34175585455957497322009-04-01T08:02:00.000-07:002009-04-01T08:02:00.000-07:00HiI'm in very difficult with oracle BI Publisher!I...Hi<BR/>I'm in very difficult with oracle BI Publisher!<BR/><BR/>I have create a report PDF whit Oracle BI Publisher.<BR/><BR/>I'm using blob2clobase64 function (to converto into base64) and I can see that this is doing the job when I test the query (both in SQL*Plus and from within APEX).<BR/>I download the XML and then imported it into Word using the BIP plugin - All fine.<BR/>My SQL is returning the blob2clobase64 result as column name THUMBNAIL (the blob column).<BR/>I have edited the properties of the THUMBNAIL field in my rtf document as follows...<BR/><BR/>fo:instream-foreign-object content-type="image/jpg"<BR/>xsl:value-of select="THUMBNAIL"<BR/>/fo:instream-foreign-object<BR/><BR/>When I try to generate a PDF, PDF will be produced but the thumbnail image does not display also if there is one image file of about 13Kb.<BR/><BR/>Can you help me?<BR/><BR/>ValeriaValeriahttps://www.blogger.com/profile/06461268269023737964noreply@blogger.com