Apps To Fusion

Concurrent Executable
written by hari , May 14, 2008

good article,I did not find the Concurrent Executable creation step. could you provide the steps to create the executable step for this.

Thanks
hari

Multi language
written by Ashok rayapudi , May 15, 2008

Hi,

Nice article. can you please explain how to do develop Multi Lingual report using XML Publisher.

...
written by hari , May 15, 2008

Hi Anil,

I am working on the 11i version, could not get the XDODTEXE while creating Concurrent program.let me know any alternative.

multiple templates having same data defintion
written by Senthilkumar J , May 15, 2008

Hi Prabhakar,

If I have multiple template files over a common data definition file, how will this work?
For ex, say I have 1.rtf, 2.rtf, 3.rtf and I am registering all these with the same data definition xml. While running the CP, which rtf will it pick?

- Senthil

Hi Prabhakar
written by ved prakash , May 16, 2008

nice articles. can you please let mew know that how can use formatting of the reports.

thanks
Ved

Re: multiple templates having same data defintion
written by kishore Ryali , May 16, 2008

Hi senthil,

If there are multiple templates attached to your data definition, you can choose one template to be your default template while registering the Template in XMLP Administrator responsibility. The same template will be defaulted when we run the XMLP report from SRS. You can change the default template to you template of choice, by going to "Options" on SRS form. In the Layout frame in Options, you can select the other templates that are attached to report's data definition.

Hope it clears the question.

Regards.

xdo Data Engine Fails with a exception [052208_095045950][][EXCEPTION] java.lang.NullPointerException
written by ruhu , May 23, 2008

xdo Data Engine Fails with a exception [052208_095045950][][EXCEPTION] java.lang.NullPointerException

Oracle XML Publisher V 5.6.3
xdo Data Engine Fails with a exception [052208_095045950][][EXCEPTION] java.lang.NullPointerException

Trying to genarate XML Data File from a custom XDO Data Template using XML Publisher.

Example of the Data Template is :






















The follwoing is the error on view log:
XDO Data Engine Version No: 5.6.3
Resp: 20420
Org ID : 84
Request ID: 3865200
All Parameters: p_name_like=Shaik
Data Template Code: EMP_DETAILS
Data Template Application Short Name: EGLCUST
Debug Flag: N
{p_name_like=Shaik}
Calling XDO Data Engine...
[052208_095045950][][EXCEPTION] java.lang.NullPointerException
at oracle.apps.xdo.dataengine.DataTemplateParser.GetNodeNumChildren(DataTemplateParser.java:345)
at oracle.apps.xdo.dataengine.DataTemplateParser.templateParser(DataTemplateParser.java:277)
at oracle.apps.xdo.dataengine.XMLPGEN.setDataTemplate(XMLPGEN.java:599)
at oracle.apps.xdo.dataengine.DataProcessor.setDataTemplate(DataProcessor.java:193)
at oracle.apps.xdo.oa.util.DataTemplate.(DataTemplate.java:136)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:282)
at oracle.apps.fnd.cp.request.Run.main(Run.java:161)

java.lang.IndexOutOfBounds*xception: Index: 0, Size: 0
at com.sun.java.util.collections.ArrayList.RangeCheck(ArrayList.java:492)
at com.sun.java.util.collections.ArrayList.get(ArrayList.java:306)
at oracle.apps.xdo.dataengine.DataTemplateParser.getParentDataSource(DataTemplateParser.java:1737)
at oracle.apps.xdo.dataengine.XMLPGEN.writeDefaultGroup(XMLPGEN.java:320)
at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:279)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:266)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:205)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:237)
at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:364)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:236)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:293)
at oracle.apps.fnd.cp.request.Run.main(Run.java:161)

The following is the template file if i am missing
written by ruhu , May 27, 2008

Including bind parameters in the xml output with type as sql query instead of Data Temlpate
written by Sumit Modi , May 28, 2008

Hi,
This article is really good!
Can u help me for the following scenario
I have to include the Bind parameters in the xml output so that I can display them in the rtf file. But I have already created the report with sql query.
Now, I have to display the bind parameters in rtf but i could not found any place where I can specify to include the parameters.
With Data Template, it can be done by specifying the include_in_output attribute to true.
waiting for ur reply....................

xdo Data Engine Fails with a exception [052208_095045950][][EXCEPTION] java.lang.NullPointerException
written by ruhu , May 28, 2008

I tired it some many times but i still get the same error. Am i on a different version or something is not enabled on our system for this. Did some see this king of an error.

xdo Data Engine Fails with a exception [052208_095045950][][EXCEPTION] java.lang.NullPointerException
written by ruhu , May 29, 2008

Thanks.

This artcle is very good.

Actually i was using word to create the data template...which was sending a lot of junk.
I tired it with notepad, it worked perfectly.


Thanks Ruhu

Can we make use to Bursting concept in XML Here
written by ruhu , June 04, 2008

Hi,
Can we make use of the busrting cconcept of XML here. I fso how can that be done.

Thanks,
Ruhu

...
written by Anil Passi , June 04, 2008

Hi Ruhu

Indeed you can use bursting. Simply follow the Bursting article.
Bursting file will parse the XML Output generated, regardless of how you generate that XML.

Thanks,
Anil Passi

...
written by ruhu , June 04, 2008

Thanks Anil.
I figured that out. But I wanted to know, on how to make use of the trigger in SQL Query procedure. The last step of the Bursting article - Oracle rdf -AFTER REPORT TRIGGER. The same thing where should that be defined on the Data Template Definition is my question.

You all are doing great work....and helping us...
its always pleasure to read all the articles posted on this site..

Hope some answer from you.

awsome articles
written by ved prakash , June 13, 2008

Hi anil,

i generated reports through XMLP, it is working fine, but Excel reports is not opening. it is giving errors like data not found, while other types of report is running fine. please help me.

thanks
Ved

how to move xml publisher reports from one instance to another instance using fndload.
written by ramkumar1981 , June 16, 2008

Hi

we are developing the xml publisher reports using report builder.First we are creating the data definition in oracle report builder and
placed in sever registered it as a concurrent program and taking the output as xml.And we design the template in MSword and
loaded the xml data and we registered the template in xml publisher responsibility all are working fine.but my question we developed this reports in Development instance how to move this xml publisher report to production using FNDLOAD.i know how to move the
concurrent program request group using FNDLOAD.But how to move this XML Publisher report because it is having xml file,RTF file,
RDF file.Using Fndload we can upload concurrent program along with rdf but how can i move the xml and rtf file.

regards
ramkumar.ch
09940651244

whether .xml file shpuld be saved in server
written by Rajesh211983 , July 10, 2008

Hi,

Really very good article.

have some doubts please clarify

1)whether we need to put the .xml file any where on the server like we will be putting rdf.
2)while creating Executable what we have to give for Executable File name

Thanks
Rajesh

Can we use SQL*PLus Statements in XML
written by Rajesh.badsha , July 14, 2008

Hi,

Thanks For Reply.

please clarify on this

whether we can use SQL*plus Statements like DEFINE, set serveroutput off,..
in the Data Template XML

i have tried bus it showing error.

Thanks
Rajesh

How to generate Master Detail data using a Data Template
written by Sameer Darbha , August 19, 2008

Hi

How can we generate Master-Detail data in the same XML file using a Data Template ?
Suppose for each Master row, I need to get all the Details rows and show the XML in a heirarchical format,
how can we achieve that using a Data Template ?

Thanks and Regards
Sameer

xml publisher load data in to rtf tempelete
written by sivaiah gowni , September 16, 2008

hi hari

this is siva your article is good but i want to know how to instal xml publisher admin

thanks & regards

siva g

document section protected
written by Mitzi , October 14, 2008

Hello
In relation to this article, is it possible to protect the documents by section only like in MSword documents where you can easily set the section break and protect only that section? I hope xml publsiher has this kind of properties
Because this is one of the requirements on most of our letters.
Thanks in advance

...
written by joe , October 20, 2008

good explination

Ratan
written by Ratan24 , December 04, 2008

Good Article, Thanks a lot,

Problem with RTF Template and XSL Stylesheet
written by Raju Kakarlapudi , December 23, 2008

Hi
This one is (Mr. Pabhakar's "XML Publisher and Data Template - SQL Query to develop BI Publisher Reports ") very nice article. I got some problem with import style sheet into RTF Template. We are in Oracle Apps 12. We are implementing Contracts Core Module. Our Contracts clauses data embeded with html tags like for bold , for italics like that. Some reason we are getting the output same as data stored in database, that means not converting html tags. I am using OKCCOMRTE subtemplate to convert these html tags for formatting.
Please let me know, is it bug? or configuration issues?. Same xsl style sheet is working fine, if run this with generated xml from my computer.
Thank you
Raju

Data XML Template
written by Shireen , January 09, 2009

Hi,
How can we attach dynamically generated Data Template XML File with the Data Definition in XML Publisher, when we are Defining a Concurrent Program With executable = XDODTEXE. Do we have to create a executable which generates the desire output at runtime using sql and attach this to the concurrent program and attach this conc program to the Data template? Or is there any other way to attach dynamic XML output to the Data defintion using the executable XDODTEXE?

Thanks and Regards,

Execute package/procedure from the data template by passing parameters
written by Sandeep_KG , January 14, 2009

How to execute a package/procedure by passing parameters under the data template and using commit at the end ?

Thanks,
Sandeep

Default value for output format
written by Sergey , March 03, 2009

Hi,
Good article!. Could you tell me how can I default output format not to PDF but to EXCEL type when submitting request?
Thanks in advance,
Sergey

problem in data template designer
written by nirav shah , March 09, 2009

Hi,

below is the xml code.















now when i load xml data in world by pressing data tab then it shows data loaded successfully.

but when i press field under insert tab then it does not shows me filed which i written in xml query.

do you have any suggestion.

pls let me know.

e-Mail : This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Regarding bursting for report output
written by Gollu , April 01, 2009

Hi

I have created a report in the similar way.
Now If i want to burst the report to customer.
How can i do that.
Is there any setups for this.

Thanks,
Praveen

...
written by srivardhan , April 06, 2009

Excellent article, did the same exact stpes and it went like a charm, thanks prabhakar for the education,
things I messed, and which would of interest to others are
1) the executable used it a java concurrent program; and it uses token to pass parameters; and like reports, the token name on the conc program definition should be exactly same as the one used in the data template.

...
written by Pam , April 13, 2009

Thanks for taking the time to post this information. I am struggling with creating a parameter and wondering if you have any tips that might be tripping me up. I have the parameter defined in the data template as well as the concurrent program






called in the sql:
WHERE FULL_NAME = nvl(:EMP_NAME,FULL_NAME)

Token used in Concurrent Program Parameter is EMP_NAME

The program runs and returns results; however, the parameter never seems to limit the query.

Any ideas? I'm stumped.

Thanks
Pam

Eliminate mutiple concurrent program definitions
written by HemaTri , April 22, 2009

Prabhakar,

It is my usual practice to use oracle report to generate the XML data and then design the template for XML Publisher Reports. In the process I end up with 2 concurrent program definitions.

Question : Is it possible to make these concurrent program definitions redundant? IF not could you elaborate on the reason behind this.

Thanks,

...
written by Madan Mohan , May 07, 2009

HI,
I am unable to see the screenshots. Only X mark is avaiable. Could you pls let me know how shall I go with this?

Thanks,
Madan

...
written by sheena , June 23, 2009

Hi, wondering if some on this blog used a dymanic image url in their template. my problem is:
i am trying to use a dynamic url on a dummy image field in the RTF. I inserted the actual URL on the web tab. this url is an element in my xml file.
if the value in the 'url:{}' is static, it works, but i cannot get this to work:
url:{image_url} as per the oracle documentation.
the preview in word does not show the image, and neither does it show in the concurrent prog o/p.
Need help!! Please.

How to generate Data template for XML reports
written by Rahman , June 24, 2009

Hi Prabhakar,
This is good article. I just want to know how can we generate data template for any XML reports?
Is there any tool for it?

...
written by sheena , June 24, 2009

Rahman, Look there is utility on Ike Wiggins web site/blog for creating the data template. Works great!

Sheena

Bursting
written by tmilowski , June 24, 2009

All looks good but how do I enable bursting?

Printing different template for same data definitions conditionally
written by Pratul , June 30, 2009

Hi,

I've a requirement where I need to print template "T1" based on certain condition otherwise template "T2". Both the template have common data definitions. Is there a way where user need not to select template and we can do it programmatically based on value of some tag from data definitions??

Regards,
Pratul

http://www.nimtree.com
written by seo company , July 01, 2009

Excellent!!

[url= ]http://www.nimtree.com] seo company

Excellent
written by George Joseph , July 23, 2009

Its a fantastic article and explained well. Keep it up.!!

last page only content
written by Chithambaram Perumal , August 03, 2009

Hello Sir,

I want to show my RTF's last page as different..In that i have used ""
tag with 'Continuous' break...It shows double of each page.
If The file wants to print 2 pages,It shows 4 pages with One Blank pages...
Plz Kelp me to solve this problem..Its Urgent...

Thanx in Advance,
Chithambaram Perumal

...
written by Stephen Campbell , August 13, 2009

Thanks for your excellent article.

I have some parameters in my report that I need to derive the value of before the report runs. I tried setting the values by calling a trigger, but the values remain null after the trigger is called.
The trigger seems to be running OK, and returns the correct true/false status.
Do you know what I need to do to pass the parameter values from the trigger back to the report. (They are defined as package variables in the Oracle package associated with the report).
Many thanks,
Stephen
I'm wondering how to have a parameter value updated by a trigger. I have some

...
written by Anil@maverick , August 21, 2009

Hi,

Is it possible to drill through from one RTF template to another RTF template . I want to navigate from one report to another report through a hyperlink.Please suggest how can I achieve this

Thanks in advance

Regards
Anil

Excellent
written by DJ , September 22, 2009

Thanks..this helped me solve my problem.
My HRMS letters are now ready without RDF.

------------------------------------------------------------------------------------------

flower delivery
flower delivery glasgow

Nice explanation
written by Artigg , September 22, 2009

This is called fine arts of Apps programming...thanks for sharing

Nice article
written by Joe , September 30, 2009

Very nice article and site.

Thanks for sharing your oracle knowledge.



flower delivery

...
written by jithender goud , October 26, 2009

When i am running concurrent program of xml reports in the option buton i could not attach my rtf template as the fields are in disabled mode can i know is there any profile need to be set to enable that fields.Plz repond to it immediately as it is urgent for me

Thanks,
Jithen

error in xml in 11i
written by mohan12 , October 29, 2009

Hi,

I tried the BI publisher in 11i using the executable XDODTEXE.
But i got the following error.

java.lang.ClassNotFoundException: oracle.apps.xdo.oa.cp.JCP4XDODataEngine
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at oracle.apps.fnd.cp.request.Run.main(Run.java:144)

when i checked for the class file JCP4XDODataEngine.class in unix, the file was missing.
in other instances also the file was not there.
I'm now wondering whether we can do this BI publisher in 11i.
some help please.

Regards,
Mohan

SQL Query to develop BI Publisher Reports
written by Thomas_isc , December 29, 2009

HI,

This is a very important information. I cannot see the pictures in each step. Since I am new to this, could you please email me the article with pictures. Thank you for your help.

thanks
thomas
This e-mail address is being protected from spambots. You need JavaScript enabled to view it

access to docs.google.com
written by Anil- , December 29, 2009

Perhaps your firewall blocks http://docs.google.com
Images are on google docs server

Dynamic Images in XMLP template
written by jack_saji , December 31, 2009

Hi Sheena,

I also faced issues with dynamic images in the template. My issue was something similar, that I had the image URL in my xml file, but when I gave url:{IMAGE_URL} it dint work. I resolved it by giving the exact path to the image url element in the XML file. Something like this,
url:{ROOT/IMAGE_URL}. It worked, but I have issues with its size, as it was displaying the image in the size of the dummy image I have placed in y template. I am stil looking for an answer for that.

Thanks
Sajith

Dynamic images
written by sheena , December 31, 2009

Sajith, not sure about what the issue is with teh size. Can you please rephrase your question. Iwill try my best to answer.

Thanks

About Date format
written by Varun Mittal1 , January 05, 2010

I tried to create the report as suggested but I am facing the date format problem.

2008-01-01T00:00:00.000+04:00

this date format is coming. Please let me know how to extract date from this.

...
written by sheena , January 05, 2010

Varun, is this the date in the report? try converting to date to a char in the sql. i dont see a reason why it should not display as is. pls provide more info and maybe i can help.
Sheena

Date Format Problem.
written by Varun Mittal1 , January 06, 2010

Hi Sheena,

Thanks a lot for quick reply. When I running the sql query on toad, I am getting date in correct format but when running concurrent program, I am getting date in format 2008-01-01T00:00:00.000+04:00 in XML.... In the example above also, date is printed in same format.... I tried to do some operation in sql considering it as string.... I mean first substr then to_date.. but in that case date is coming as null in XML file..

I tried this in sql... but in this case date comes null.....
to_date(substr(pps.date_start,0,10),'YYYY-MM-DD')

You can check the example above... in pdf output screen shot (just above starting of comment).. date is in format 2008-01-01T00:00:00.000+04:00.

XMLP data defination error
written by Neena , February 01, 2010

I have created data defination and later I deleted the definations from backend tables ,when I try to create data defination now and when I click on Apply its throwing me an error .Errorls conatct system administrator.
After deleting only I'm not able to create data defination.Any help ?????

XMLP data defination error
written by Sheena Sidhu , February 01, 2010

hi neena, did you try creating a data definition with a different name or are you using the same name? if nothing works, try and see if u can create the data in the backend tables once again..

...
written by HST , February 11, 2010

Could you tell me how can I default output format not to PDF but to EXCEL type when submitting request?
is it possible to set it by default rather than changing it each time when submitting the request??

thanks for the great site

...
written by HST , February 11, 2010

Actually what i need is to change the output format to RTF, so it could be opened using word processer
how can i achieve that??


thnx alot

...
written by sheena , February 11, 2010

i would recommned looking on metalink for that. i believe there is a patch, but not sure..

HTH
Sheena

How to resize a picture dynamically?
written by jack_saji , February 16, 2010

Hi Sheena,

Sorry, I did not check this forum after that. The issue is like this.
Suppose I have 2 photographs. One of size 100 X 100 and another one 1000 X 500. I have made my RTF in such a way that it has a 100 X 100 picture loaded in it, and I have setit up to take the photograph from a url which I will be passing in the XML. Now the issue is, if I am passing the URL to the 100 X 100 picture, it is fine. But when I give the URL to the 1000 X 500 picture, what happens it, it will try to fit it in the 100 X 100 space, and it will look distorted. I was actually looking for a way to pass the dimentions of the size in the XML so that I can tell it to display the second photograph with the dimention 100 X 50 so that it doesn't look distorted.

Sajith

Thanks,
Sajith

How to resize a picture dynamically
written by Sheena Sidhu , February 16, 2010

sajith,
there is a way within the url tag of the picture in ur word doc that you can specify the size of the image. i was under the impression that the picture will format based on what gets passed in.
i have not tried with the size you mentioned, but if you look at the xml or bi publisher document, i believe, it has the details on how to specify the size.

good luck
sheena

XML Data Template Error
written by Sarfraz R Ramay , February 26, 2010

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
















and the error generated is
+---------------------------------------------------------------------------+
Human Resources: Version : 11.5.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

TDP_BLOB_CLOB module: TDP BLOB to CLOB XML
+---------------------------------------------------------------------------+

Current system time is 26-FEB-2010 16:03:39

+---------------------------------------------------------------------------+

XDO Data Engine Version No: 5.6.3
Resp: 53838
Org ID : 1041
Request ID: 38224060
All Parameters: review_id=
Data Template Code: TDP_BLOB_CLOB
Data Template Application Short Name: PER
Debug Flag: N
{review_id=}
Calling XDO Data Engine...
--SQLException
java.sql.SQLException: ORA-00911: invalid character

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:850)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2599)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2963)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:65
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:584)
at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:515)
at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:429)
at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:300)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:266)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:205)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:237)
at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:364)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:236)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:293)
at oracle.apps.fnd.cp.request.Run.main(Run.java:161)

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...

+------------- 1) PUBLISH -------------+
Beginning post-processing of request 38224060 on node TLNT09 at 26-FEB-2010 16:03:45.
Post-processing of request 38224060 failed at 26-FEB-2010 16:03:45 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
+--------------------------------------+


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 26-FEB-2010 16:03:45

+---------------------------------------------------------------------------+


i am working on
Database Server
----------------------------------------
RDBMS : 11.1.0.7.0
Oracle Applications : 11.5.10.2

the data template was not displayed before
written by Sarfraz R Ramay , February 26, 2010

...
written by Sheena Sidhu , February 26, 2010

sarfaraz, is this o/p from the OPP error log? if not, then i recommend you look there pls..

[UNEXPECTED] [546478:RT.......] java.io.FileNotFoundException: /arch/xdo.....
written by jean carlos , March 05, 2010

Hi my friends,

I created Data Definition and Template on XML Published, but when I started the Concurrent Process this finished with "WARNING" status and create log with the following message:

Template code: XLAACCPB01
Template app: XLA
Language: pt
Territory: BR
Output type: PDF
[2/27/10 8:29:08 PM] [UNEXPECTED] [546478:RT12955480] java.io.FileNotFoundException: /arch/xdoTX5kEkMOL8022710_0829083004.fo (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.(FileOutputStream.java:179)
at java.io.FileOutputStream.(FileOutputStream.java:131)
at oracle.apps.xdo.common.tmp.TmpFile.createTmpFileJDK118(TmpFile.java:146)
at oracle.apps.xdo.common.tmp.TmpFile.createTmpFile(TmpFile.java:113)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:987)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1659)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:969)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5926)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:345
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3547)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:259)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:172)

Could anybody help me with this issue ?

Thanks a lot,

Jean Antunes.

opp error log
written by Sarfraz , March 06, 2010

Hi sheena,
What is OPP Error Log and where can i find it? Please provide navigation to avoid confusion. Thanks. Btw i sent you email might wanna check that please.

opp err log location
written by Sheena Sidhu , March 06, 2010

pls google the opp error log like i did. google is an excellent tool and if you are really looking to learn (and theres nothing like self learning believe me!) I would recommned using it before posting ur question here pls.

check OOP file as follows:
sysadmin -> Concurrent -> Manager -> administer -> Output Post Processor -> processes -> manager log

or better way is from find request window , choose concurrent program -> Diagnostics -> view XML
Check the xml file in the end for error.

link : http://www.oracleappsblog.com/.../831/#1726

BIP Reports to get Logo dynamically from a location
written by Anil80 , March 09, 2010

HI There,

Kindly let me know if there is any way where when we generate BIP Reports in Siebel(8.1.1) Logo(any company's logo image) should get assigned to the Report Dynamically. I mean we don't want to put the image in the .RTF templates Report Header but the image should come automatically by accessing a particular location while generating it. Please help me in achieving this.

Thanks
Anil

Adding a parameter to copied Data definition
written by milwell , March 25, 2010

I'm customizing one of the standard data definition file namely "Sales Order Acknowledgement (XML)".
I added a parameter for Transaction number named "P_TRX_NUMBER"
this will filter the sales order item to match transaction items.
when i run the concurrent request, it says
PLS-00302: component 'P_TRX_NUMBER' must be declared.

Dynamic images in XMLP template
written by DD , March 25, 2010

Hi,

I am also trying to show an image based on a criteria. I am using this in the Alternative Text of the dummy image.
url:{concat('/11.5/common/java/oracle/apps/media/','')}

IMAGE_FILE is one of the elements on the template.

I am not getting the image to be shown on the page.

Anybody with a solution to this ?

Sheena: Did you get a soluion to this ?

Regards,
Deepak.

...
written by Beena , March 25, 2010

I am using WORD 2007 with BI Publisher and trying to create a chart in the RTF document. I added a dummy image using Insert Picture -> Link to File, Right click on the picture and select size and then alt text to add the code for the chart but I only get the picture in the image. I have a very simple XML data file for this. How do you get a dummy image added.

I am also trying to use the CHART object Bi Publisher in word but the Preview and Ok button are always disabled. I am using the same XML dat file. Any ideas?

Thanks for any help.

Beena

Mr
written by K , March 27, 2010

Hi, How can I run a BI publisher report other than using the concurrent program. How to use JCP4XDODataEngine from a PL/SQL?? Thanks K

...
written by Sheena Sidhu , March 27, 2010

deepak, pls see my blog on xml publisher with blob/image on the same site.

if that does not help, feel free to post a note on that blog.

sheena

Attributes to XMl output
written by V123 , April 19, 2010

Hi,
Could you please let us know if there is any chance to add attribute to the XML elements that are generated by the Data template concept in oracle.

Thanks

Is there a template sort of thing, similar to Template.fmb for creating Data Templates coming into R12?
written by 4future , May 04, 2010

Is there a template sort of thing, similar to Template.fmb for creating Data Templates coming into R12? If so, please let me know regarding that.
Also, what is the best editor, for creating these xml files? Is JDeveloper a convenient tool to develop these? If so, which version would do? I would like to have a lighter version of JDeveloper not the Studio.

Master Detail data in XML Data Template
written by Amity Scott , May 05, 2010

Hi,

I am looking for a code sample to achiever master/detail data in a single data template. Similar to this person's question below:

How can we generate Master-Detail data in the same XML file using a Data Template ?
Suppose for each Master row, I need to get all the Details rows and show the XML in a heirarchical format,
how can we achieve that using a Data Template ?


Please advise.
Thanks,
Amity Scott

RE:Master Detail data in XML Data Template
written by Ashish Raj , August 05, 2010

Hi Amity,
There is one example in following blog on how the achieve Master detail Data Template hierarchy in Data Template. Please check it out.

http://www.adivaconsulting.com/adiva-blog/item/5-datatemplate

Thanks
Raj.

How to get XML template name for a running request
written by Hemant Daiya , August 27, 2010

Could you explain me how we canget the tamplate name of a current running request, when user selects the template using option button.

Thanks
Regards

Where's the use of BI Publisher
written by Derrick , September 08, 2010

Good article! Thanks!
But I noticed, BI Publisher was not used in any of the steps. There's a data model section in BIP where you can create a data template. Can it help in this case?

Regards,
Derrick

One data template contains multiple
written by anupam_shiv , September 14, 2010

Hi All

I have a requirement where i need to create three tables in a same rtf whihc should populate the data from a single data template.
I have created a single data template with three and 3 groups in the . All the 3 qeries are independent
and mapped to 3 seperate groups inthe data sttucture sections.
But When running the reprot i am not getting the correct result . the query displays the result from onyl one query only. but whn i run the 3 queres in the backend i am getting data. Any help will be great.

Thanks
written by Róbert Temesi , October 01, 2010

Hi Prabhakar,

Thanks for the tutorial. This was extremely useful for me. I had little time and you have everything here. Thanks alot.

Data Template Query Issue
written by henry , January 07, 2011

hello i have the data template XML as :
name of the file XMLPDF.xml

























Date Definition:
Name XMLPDF Code XMLPDF
Application Receivables Start Date 07-Jan-2011 Concurrent Program
registered the report output xml and used the seeded executable XDODTEXE

OUTPUT:

-
UNAPP


i do not see my query in the data template getting executed. i am expecting my 3 columns that i have defined in the query to be shown up in the output xml file.
I'd really appreciate if someone can help me here. also my query gives out around 200 records so there is no problem of no data found.

Thanks a lot

Job submission from backend
written by Kiranmayi , January 14, 2011

Hi,

In step 6, for concurrent program submission, we need to select the layout from options screen manually. If I am submitting the job from backend/plsql script, how can provide this layout value. I am using the API call Fnd_Request.submit_request. Please help.

Help with report builder and initializing variable R12 xml
written by kerrycsc , January 25, 2011

Using Oracle EBS R12
Creating report for XML and data def.
I created a query in SQL Developer
Initalized variables
execute fnd_global.apps_initialize(&user_id,&resp_id,&resp_appl_id);
execute mo_global.init('SQLAP');

Then ran the query
select
invoice_num,
(sELECT VENDOR_NAME FROM AP_SUPPLIERS APSU WHERE APSU.VENDOR_ID = API.VENDOR_ID) AS VENDOR,
(select amount_remaining from ap_payment_schedules APS WHERE API.INVOICE_id = APS.INVOICE_id ) AS REMAINING_aps,
(SELECT DUE_DAYS FROM AP_TERMS_LINES APTL WHERE API.TERMS_id = aptl.TERM_ID) AS TERMS,
(select DUE_DATE from ap_payment_schedules APS WHERE API.INVOICE_id = APS.INVOICE_id ) AS INVOICE_terms_DATE_aps,
invoice_date,
invoice_amount,
nvl(amount_paid,0),
nvl(discount_amount_taken,0),
nvl(invoice_amount-(nvl(amount_paid,0) + nvl(discount_amount_taken,0)),0) as remaining,
discount_amount_taken,
cancelled_date
from ap_invoices API
where
--invoice_amount amount_paid
cancelled_date is null
and nvl(invoice_amount-(nvl(amount_paid,0) + nvl(discount_amount_taken,0)),0) 0
ORDER BY INVOICE_DATE

Got my data
Now I usually move the query to the report builder save it as a rdf run it through the report coverter by IKE wiggins
And take the files move them into Oracle and create word template for the xml template and it works except this time I'm having an issue and I think it's due to the execute fnd_global.apps_initialize(&user_id,&resp_id,&resp_appl_id);
execute mo_global.init('SQLAP');

1)I'm not sure how to get my query to work in the report builder? I believe I need to do something about the id's so I can see the data
2) After I get that working I presume when I run it through the converter it will create the needed files?

Help with report builder and initializing variable R12 xml
written by Sheena Sidhu , January 25, 2011

Hi- can you not add that piece of code that accepts IDs in a trigger in the report. I believe it should work when you convert the report...

...
written by None123 , March 16, 2011

Im trying to add the signature of an employee based on the employee id. I have build the query to fetch all the other data to be displayed in the template but to get the URL of the image how do i insert the image server details etc in the xml generated

adding signature
written by Sheena Sidhu , March 16, 2011

you will have to add the image as a blob. there is an article posted on this site that explains that..

XML Schema
written by Nivedita , April 01, 2011

Hi,


I have the xml shema alone to develop a bi publisher report.. Can u pls tel how to convert xml schema to xml data.. So that i can proceed further..

Thanks
Nivedita

Senior Technical consultant - Perth
written by Venkatraman , May 31, 2011

Thanks! you saved my Day



Venkat

Error in XML Publisher
written by Kausik , July 22, 2011

Hi,
My data template looks like this:
























On running the program I am gettingnullpointer exception :
Calling XDO Data Engine...
java.lang.NullPointerException
at oracle.apps.xdo.oa.util.DataTemplate.getDataTemplate(DataTemplate.java:379)
at oracle.apps.xdo.oa.util.DataTemplate.(DataTemplate.java:226)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:283)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

I am not able to find the cause of this issue.

Can anyone tell me what may be causing this issue. and how to debug these kind of java exceptions?

Thanks,
Kausik

...
written by Roy Meron , August 18, 2011

I have the parameter defined in the data template as well as in the concurrent program

called in the sql:
WHERE MSIB.INVENTORY_ITEM_ID = MOQD.INVENTORY_ITEM_ID
AND MOQD.CREATION_DATE > SYSDATE - 10
AND MSIB.ORGANIZATION_ID = MOQD.ORGANIZATION_ID
AND MSIB.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.organization_code = nvl(:p_org_code ,MP.organization_code )
ORDER BY 4
Token used in Concurrent Program Parameter is p_org_code
The program runs and returns results; however, the parameter never seems to limit the query.

Any ideas?

Null parameters handling
written by rsyed , September 05, 2011

Hi Gurus,
Excellent job you are doing.Thanks for sharing valuable knowledge.I have requirement of passing parameters to the xml data template file.But those parameters are optional.User may pass or may not pass the parameters if the parameter value is null then how to use this in xml data template file.
I am using like this msib.segment1=nvl(:p_item,msib.segment1)
and pha.segment1=nvl(:p_po_num,pha.segment1)
but while i am submitting the program with null values to the parameters the result is empty even though there are records with null values.
Please gurus provide me the solution as early as possible u can.
Thanks in advance.

Got error while Preview the Report after load XML and RTF
written by Bhushan Shinde , September 07, 2011

I am trying to preview the Report after loding XML file with RTF , but got the following mention error.
Please Help me out to rectify on this ?

ConfFile: C:Program FilesOracleBI PublisherBI Publisher DesktopTemplate Builder for Wordconfigxdoconfig.xml
Font Dir: C:Program FilesOracleBI PublisherBI Publisher DesktopTemplate Builder for Wordonts
Run XDO Start
Template: C:Documents and Settingsuswmad80DesktopActivity_Sort_Solution_Option sOption 1BIP_Loss Report123.rtf
RTFProcessor setLocale: en-us
FOProcessor setData: C:Documents and Settingsuswmad80DesktopActivity_Sort_Solution_Option sOption 1BIP CRN INS Claims3.xml
FOProcessor setLocale: en-us
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:597)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source)
at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source)
at RTF2PDF.runRTFto(RTF2PDF.java:629)
at RTF2PDF.runXDO(RTF2PDF.java:439)
at RTF2PDF.main(RTF2PDF.java:289)
Caused by: oracle.xdo.parser.v2.XPathException: Extension function error: Class not found 'com.siebel.xmlpublisher.reports.XSLFunctions'
at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)
at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:521)
at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:489)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:271)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:155)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:192)
... 15 more

...
written by Bal , September 18, 2011

Is there a way to remove the added Data Template in Data Definition?

Adding column/field which not include in data defintion
written by Jusuf-I , September 22, 2011

Hi expert,

Need advise here. How can I add field/column which not listed in the data definition? For example in Customer Open Balance Report (XML), how can I add the due date of invoice into the template? Second question will be, how to add a column which base on formula? For example I want to add number of days base calculation of Invoice Date and Print Date.
Appreciate your help. Thank you.

bi PUBLISHER
written by rajeshkumar , November 08, 2011

hi freinds...

Parameterized reports(bi publisher)
written by rajeshkumar , November 08, 2011

paramparam1
From Date:To Date:
the above coding i used for date .
Now i want to know what parameter is used for product or location ?

I am new to BI publisher ...i searched but couldnt find ...can any one help ...

Regards
Rajesh

XML publisher report based on the regional language
written by Anugrah , January 03, 2012

Hi Prabhakar,

Thanks for the valuable input on this topic. I need one help on the same topic ( Xml publisher report).

I have one requirement like need to print the xml publisher report based on the language from one concurrent program. I have 2 seperate template in 2 regional language ( Spanins and Portuguise) and it should print based on the input parameter ( Language parameter). If i pass langauage like spanish then report should print in the spanish and vive versa.

Please help if you have any idea how to handle this issue.

Many many thanks in advance.

Regards
Anugrah

...
written by nitin a , January 04, 2012

Hi,

I m getting this error while running xml report o/p in excel

cn anybody help..




Error

java.sql.SQLException: No corresponding LOB data found : SELECT FILE_DATA, DBMS_LOB.GETLENGTH(FILE_DATA), FILE_NAME FROM XDO_LOBS WHERE LOB_TYPE = :1 AND APPLICATION_SHORT_NAME = :2 AND LOB_CODE = :3 AND LANGUAGE = :4 AND TERRITORY = :5 at oracle.apps.xdo.oa.schema.server.XdoLobsInputStream.(XdoLobsInputStream.java:105) at oracle.apps.xdo.oa.schema.server.LobHelper.getLob(LobHelper.java:873) at oracle.apps.xdo.oa.schema.server.LobHelper.getBlobDomain(LobHelper.java:90 at oracle.apps.xdo.oa.template.server.TemplatesAMImpl.processTemplate(TemplatesAMImpl.java:2056) 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:324) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:72 at oracle.apps.xdo.oa.template.webui.TemplateGeneralCO.previewTemplate(TemplateGeneralCO.java:735) at oracle.apps.xdo.oa.template.webui.TemplateGeneralCO.processRequest(TemplateGeneralCO.java:15 at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:581) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1134) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:937) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:904) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:937) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:904) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2297) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1710) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:501) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:422) at _oa__html._OA._jspService(_OA.java:8 at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119) at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267) at oracle.jsp.JspServlet.internalService(JspServlet.java:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet.java:58 at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162) at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187) at _oa__html._RF._jspService(_RF.java:102) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119) at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267) at oracle.jsp.JspServlet.internalService(JspServlet.java:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet.java:58 at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456) at org.apache.jserv.JServConnection.run(JServConnection.java:294) at java.lang.Thread.run(Thread.java:534)

...
written by RK , January 19, 2012

Excellent Article!!

Throwing message when report queries not return any records
written by Mohammadi , January 31, 2012

Hi,
We have to build one report which retrieves the invoices which has crossed their past due date. This report has to be in excel. We are planning to put this report in XML Pubnlisher designing template and data definition (.xdo file). We will be using bursting feature to send the report to mail to Distribution List. Now when the report query doesn't pull any records, the user should be thrown a message "Please refine your search criteria, the current search criteria doesn't pull up any records". Can you please let us know how to throw this message in case the data definition query doesn't fetch any records.

Thanks,
Mohammadi

XML tags
written by venu p , February 06, 2012

Please send me the xml tags what ever we are using in RTF file design.i searched in many portals but i didn't get that tags.

Regard's
venu

...
written by Mohammadi , February 07, 2012

I am not sure which tags you are looking for?

Thanks,
Mohammadi