Login
Register

Home

Trainings

Fusion

R12

Blogs

Contact Us

Blogs
  • Register

Oracle Gold Partners, training schedule is listed here designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

User Rating: 4 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Inactive
 
The XML Publisher(XMLP / BI Publisher ) requires a Template layout and Data XML to generate the report in
PDF, EXCEL, RTF or HTML format .The Data XML can be generated from Oracle Report, OA Framework and Data Template.
Using this approach, you can develop BI Publisher reports in Oracle EBS, without having to develop an RDF report.
You can specify an SQL Statement in an XML file, and results of that SQL Statement are published as XMLP Output.

In this article lets understand the usage of Data Template with a small demo. In the next article we will discuss in detail the Data Template XML Schema.
The data template is the XML document whose elements communicate the following information to the data engine.
  • Data Query : The SQL query with bind parameter specifying the data to be fetched.
  • Bind Parameters : Definition of each bind parameter defined in the query.
  • Data Structure : Definition of the Output XML Structure.
  • Data Triggers : Triggers that should be executed before or after the data query execution. Triggers are used to either do initialization or do some post query operation.

Hence Data Template is the means by which we inform the data engine to fetch the data of our interest. Apart from the these , data template also contains other elements. To make our example simple and easy to understand, lets deal with the above 4 elements.

Sample Data template :

XML Publisher Data Template Architecture

The Data engine execute the Data template to generate the Data XML file . The Data XML file is then merged with the Template layout by the XMLP engine to generate the XMLP
Report.

Lets try to build a sample XMLP report to display Employee Details. The Following are the steps involved

Step 1: Design the Data Template XML File.
Step 2: Create the Data Definition in XML Publisher and associate it with Data Template
Step 3: Define a Concurrent Program to generate the Data XML File.
Step 4: Define the RTF Template using the Generated Data XML.
Step 5: Registering the Template with XML Publisher
Step 6: Execute the concurrent program to generate the PDF report.

Step 1 : Design the Data Template XML File.

This Data Template selects the employee details from the EMP table. The select query specifies the columns of interest. It uses a bind parameter to filter the employees of a particular department.

For each bind parameter in the query , we need to define a Parameter. In this case we have defined p_DeptNo parameter.

In the data structure element, we have defined the output XML structure. He we map the columns in the select query with the data xml elements.

Step 2 : Create the Data Definition in XML Publisher and associate it with Data Template

Using Responsibility: XML Publisher Administrator --> Home --> Data Definitions --> Create Data Definition


Screen 1 : Enter the data definition Details and click on Apply. Note down the Code. The code should be used as the short name of the concurrent program.


Screen 2: Click on the "Add File" button against the "Data Template" Label.

Screen 3: Upload the Data Template XML file and Click on Apply.

Screen 4 : The Data Template is associated to the Data Definition..


Step 3: Define a Concurrent Program to generate the Data XML File.

Using Responsibility System Administrator --> Concurrent : Program --> Define.


Screen 1: Define a Concurrent Program With executable = XDODTEXE and Output Format = XML.

Screen 2: For each parameter in the Data Template, define a parameter in the concurrent program. The Data Template parameter name should match the concurrent program parameter token.
Screen 3: Associate the Concurrent Program to a request group.




Screen 4 : Execute the concurrent program "Employee Details Data Template Demo"and click on the output button get the Data XML. Save the XML file. We will use it to generate the RTF Template.

Step 4: Define the RTF Template using the Generated Data XML.
Install the Oracle XML Publisher Desktop available via patch 5887917. Open the Microsoft word. You should be able to see the following menus and toolbars.
Using the menu Data -> Load XML Data... , load the XML File generated from Jdeveloper
If the XML files gets loaded successfully, then you should get the below confirmation.


Using the Table Wizard as below to create the 'Table Report Format' with all the columns of EMP.
The Table Report Format Template should be like

Step 5: Registering the Template with XML Publisher

Responsibility: XML Publisher Administrator --> Home --> Templates --> Create Template.
Enter the Template Name and other details. The Data Definition should be the data definition defined in the above steps. Click on the apply button


Step 6 : Execute the concurrent program to
generate the PDF report.

Open the concurrent program for submission and click on the option button to specify the XML Publisher Template defined in the previous step and Output type to be used. The options specified once gets stored . Hence if open the option window again, the template name and the output type will be available. Click ok button and run the concurrent program. When the program completes. Click on the Output button to see the PDF report.









Prabhakar Somanathan

Overall Rating (0)

0 out of 5 stars

People in this conversation

  • Guest - hari

    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

    Short URL:
  • The XDODTEXE is a seed Executable which is provided by oracle when u install XML publisher 5.6.3 or BI Publisher. Hence u need not create a executable. The should be available by

    Short URL:
  • Guest - Ashok rayapudi

    Hi,

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

    Short URL:
  • Guest - hari

    Hi Anil,

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

    Short URL:
  • Guest - Senthilkumar J

    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

    Short URL:
  • Hi Hari,
    This feature is available in XML Publisher/BI Publisher 5.6.3 and above

    Cheers,
    Prabhakar.S

    Short URL:
  • Guest - ved prakash

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

    thanks
    Ved

    Short URL:
  • Guest - kishore Ryali

    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.

    Short URL:
  • Guest - ruhu

    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.IndexOutOfBoundsException: 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)

    Short URL:
  • Guest - ruhu

    Short URL:
  • Guest - Sumit Modi

    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....................

    Short URL:
  • Guest - ruhu

    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.

    Short URL:
  • Guest - ruhu

    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

    Short URL:
  • Guest - ruhu

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

    Thanks,
    Ruhu

    Short URL:
  • Guest - Anil Passi

    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

    Short URL:
  • Guest - ruhu

    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.

    Short URL:
  • Guest - ved prakash

    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

    Short URL:
  • Guest - ramkumar1981

    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

    Short URL:
  • The FNDLOAD utility is used to upload and download the data definition and Data template created via XML Publisher Administrator responsibility.
    The XDOLoader utility is used to upload and download the physical files (RTF, PDF, XSL-FO, XML, and XSD).

    Use the following commands to
    1) Download all the data definitions and corresponding templates in an instance.
    FNDLOAD apps/apps_pwd@db 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct
    targetldtfile.ldt XDO_DS_DEFINITIONS

    2) Download all the data definitions and the corresponding Templates in a specific product.
    FNDLOAD apps/apps_pwd@db 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct
    targetldtfile.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXX

    3) Download a particular data definitions and its corresponding Templates.
    FNDLOAD apps/apps_pwd@db 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct
    targetldtfile.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXX DATA_SOURCE_CODE=EMP DD

    4) Upload the data definitions and its corresponding Templates to an instance.
    FNDLOAD apps/apps_pwd@db 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct
    targetldtfile.ldt

    XDOLOADER :
    To download the RTF template and other files use
    java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
    -DB_USERNAME \
    -DB_PASSWORD \
    -JDBC_CONNECTION \
    -LOB_TYPE \
    -APPS_SHORT_NAME \
    -LOB_CODE \
    -LANGUAGE \
    -TERRITORY \
    -LOG_FILE

    Use the below command to upload the rft template and other files
    java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
    -DB_USERNAME \
    -DB_PASSWORD \
    -JDBC_CONNECTION \
    -LOB_TYPE \
    -APPS_SHORT_NAME \
    -LOB_CODE \
    -LANGUAGE \
    -TERRITORY \
    -XDO_FILE_TYPE \
    -NLS_LANG \
    -FILE_CONTENT_TYPE \
    -FILE_NAME \
    -OWNER \
    -CUSTOM_MODE [FORCE|NOFORCE] \
    -LOG_FILE

    I will prepare an article on this with sample by end of this week.

    Hope this helps you at this moment.

    Cheers,
    Prabhakar.S

    Short URL:
  • Guest - Rajesh211983

    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

    Short URL:
  • Hi,

    You need to upload the xml file to the Data definition. Please see the data definition creation part.
    There is no need to create executable. Oracle provides XDODTEXE named executable that u need to use.

    Thanks,
    Prabhakar.S

    Short URL:
  • Guest - Rajesh.badsha

    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

    Short URL:
  • Guest - Sameer Darbha

    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

    Short URL:
  • Guest - sivaiah gowni

    hi hari

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

    thanks & regards

    siva g

    Short URL:
  • Guest - Mitzi

    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

    Short URL:
  • Guest - joe

    good explination

    Short URL:
  • Guest - Ratan24

    Good Article, Thanks a lot, :)

    Short URL:
  • Guest - Raju Kakarlapudi

    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

    Short URL:
  • Guest - Shireen

    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,

    Short URL:
  • Guest - Sandeep_KG

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

    Thanks,
    Sandeep

    Short URL:
  • Guest - Sergey

    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

    Short URL:
  • Guest - nirav shah

    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 : niravshah.cs@gmail.com

    Short URL:
  • Guest - Gollu

    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

    Short URL:
  • 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.

    Short URL:
  • Guest - Pam

    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

    Short URL:
  • Guest - HemaTri

    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,

    Short URL:
  • Guest - Madan Mohan

    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

    Short URL:
  • Guest - sheena

    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.

    Short URL:
  • Guest - Rahman

    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?

    Short URL:
  • Guest - sheena

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

    Sheena

    Short URL:
  • Guest - tmilowski

    All looks good but how do I enable bursting?

    Short URL:
  • Guest - Pratul

    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

    Short URL:
  • Guest - seo company

    Excellent!!

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

    Short URL:
  • Guest - George Joseph

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

    Short URL:
  • Guest - Chithambaram Perumal

    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

    Short URL:
  • Guest - Stephen Campbell

    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

    Short URL:
  • Guest - Anil@maverick

    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

    Short URL:
  • Guest - DJ

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

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

    flower delivery
    flower delivery glasgow

    Short URL:
  • Guest - Artigg

    This is called [url=www.merchantgategallery.co.uk]fine arts[/url] of Apps programming...thanks for sharing

    Short URL:
  • Guest - Joe

    Very nice article and site.

    Thanks for sharing your oracle knowledge.



    flower delivery

    Short URL:
  • Guest - jithender goud

    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

    Short URL:
  • Guest - mohan12

    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

    Short URL:
  • Guest - Thomas_isc

    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
    thomas_isc@yahoo.com :)

    Short URL:
  • Guest - Anil-

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

    Short URL:
  • Guest - jack_saji

    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

    Short URL:
  • Guest - sheena

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

    Thanks

    Short URL:
  • Guest - Varun Mittal1

    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.

    Short URL:
  • Guest - sheena

    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

    Short URL:
  • Guest - Varun Mittal1

    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.

    Short URL:
  • Guest - Neena

    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 .Error:Pls conatct system administrator.
    After deleting only I'm not able to create data defination.Any help ?????

    Short URL:
  • Guest - Sheena Sidhu

    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..

    Short URL:
  • Guest - HST

    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

    Short URL:
  • Guest - HST

    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

    Short URL:
  • Guest - sheena

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

    HTH
    Sheena

    Short URL:
  • Guest - jack_saji

    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

    Short URL:
  • Guest - Sheena Sidhu

    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

    Short URL:
  • Guest - Sarfraz R Ramay

    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:658)
    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

    Short URL:
  • Guest - Sarfraz R Ramay

    [img]
    ?xml version="1.0" encoding="WINDOWS-1252"?>













    [/img]

    Short URL:
  • Guest - Sheena Sidhu

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

    Short URL:
  • Guest - jean carlos

    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:3458)
    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.

    Short URL:
  • Guest - Sarfraz

    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.

    Short URL:
  • Guest - Sheena Sidhu

    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/index.php/forum/viewthread/831/#1726

    Short URL:
  • Guest - Anil80

    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

    Short URL:
  • Guest - milwell

    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.

    Short URL:
  • Guest - DD

    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.

    Short URL:
  • Guest - Beena

    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

    Short URL:
  • Guest - K

    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

    Short URL:
  • Guest - Sheena Sidhu

    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

    Short URL:
  • Guest - V123

    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

    Short URL:
  • Guest - 4future

    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.

    Short URL:
  • Guest - Amity Scott

    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

    Short URL:
  • Guest - Ashish Raj

    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.

    Short URL:
  • Guest - Hemant Daiya

    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

    Short URL:
  • Guest - Derrick

    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

    Short URL:
  • Guest - anupam_shiv

    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.

    Short URL:
  • Guest - Róbert Temesi

    Hi Prabhakar,

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

    Short URL:
  • Guest - henry

    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

    Short URL:
  • Guest - Kiranmayi

    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.

    Short URL:
  • Guest - kerrycsc

    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?

    Short URL:
  • Guest - Sheena Sidhu

    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...

    Short URL:
  • Guest - None123

    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

    Short URL:
  • Guest - Sheena Sidhu

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

    Short URL:
  • Guest - Nivedita

    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

    Short URL:
  • Guest - Venkatraman

    Thanks! you saved my Day

    ;D

    Venkat

    Short URL:
  • Guest - Kausik

    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

    Short URL:
  • Guest - Roy Meron

    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?

    Short URL:
  • Guest - rsyed

    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.

    Short URL:
  • Guest - Bhushan Shinde

    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 Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\config\xdoconfig.xml
    Font Dir: C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word onts
    Run XDO Start
    Template: C:\Documents and Settings\uswmad80\Desktop\Activity_Sort_Solution_Options\Option 1\BIP_Loss Report123.rtf
    RTFProcessor setLocale: en-us
    FOProcessor setData: C:\Documents and Settings\uswmad80\Desktop\Activity_Sort_Solution_Options\Option 1\BIP 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

    Short URL:
  • Guest - Bal

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

    Short URL:
  • Guest - Jusuf-I

    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.

    Short URL:
  • Guest - rajeshkumar

    hi freinds...

    Short URL:
  • Guest - rajeshkumar

    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

    Short URL:
  • Guest - Anugrah

    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

    Short URL:
  • Guest - nitin a

    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:908) 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:728) at oracle.apps.xdo.oa.template.webui.TemplateGeneralCO.previewTemplate(TemplateGeneralCO.java:735) at oracle.apps.xdo.oa.template.webui.TemplateGeneralCO.processRequest(TemplateGeneralCO.java:158) 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:88) 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:588) 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:588) 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)

    Short URL:
  • Guest - RK

    Excellent Article!!

    Short URL:
  • Guest - Mohammadi

    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

    Short URL:
  • Guest - venu p

    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

    Short URL:
  • Guest - Mohammadi

    I am not sure which tags you are looking for?

    Thanks,
    Mohammadi

    Short URL:
  • Guest - Abel Rosas

    Hi, I read your article and it's great, good for that.
    I have a question about the Data Template, I want to know if it is possible to put a if condition at the XML - output structure ( dataStructure ).
    I read that i can use XSD, but i'm not so sure about it.
    Can you tell me a little bite about it and I will appreciate if you show how to do it.
    Thank so much for you help

    Short URL:
  • Guest - Gadiraju

    Thanks for the wonderful articles.
    Can we use pl/sql packages and develop BI publisher reports?
    Reason is we have couple of complicated rdf reports(some 17queries in it) which we want to rewrite and publish using BIPublisher.
    What is the best way to do?

    Appreciate your help!!
    Srujana

    Short URL:
  • Guest - Raviraj's

    Hi Prabhakar,

    I have done One report as Data Template,
    Here the problem is when we run the Report in the xml output '' is shown as >
    and '&' as & like this.

    But In XSL formatting the html tags we require < and > insted of &lt; and &gt;

    Can you please suggest me how can we handle the issue.
    Can we restrict the decoding of < to &lt; ?
    Can we handle the tags like &ltUL&gt ,&ltP&gt; in XSL Formatting?

    Can you Please help me on this as early as possible. I am working on this report morethan a month.

    Short URL:
  • Guest - Sumit B.

    hi,
    Greatfull thanks to shared study doc.
    you did use sql query with xml code at template file.
    I analyse, without XML language isn't possible.
    is it mandatory to learn/understand xml language to every oracle developer?

    Thanks,
    Sumit B

    Short URL:
  • Guest - prasadbabu

    could you please forward the documents to prasad.dwh09@gmail.com
    Thanks in Advance

    Short URL:
  • Guest - Kamalakar

    Hi,

    When report main query fetches zero records my Bursting control file is erroed out.
    For Email adrres and etc Email related fileds I am using another group. Pls help me out.
    I am not getting email with report attachment..

    Thanks,
    KAmalakar

    Short URL:
  • Guest - vijay oraapps

    Greatefull artical because I didn't know that how to customize for the same execution method. Request you to pls one thing that if i create new report for the same execution method then we shall use same executable (XDODTEXE). Sorry don't mind because I have not much experience.


    Thanks,
    Vijay

    Short URL:
  • Guest - Tanu

    I am getting issue while generating the XML output in Bi pib.
    •When I run it on SQL developer, I am getting the actual output.
    •But when I run it on BI publisher, I am getting some selected columns value only
    •Also, it will take around 18 min to run in SQL developer and around 40-50 mins to run in BI publisher.
    •Need help to get the output for each column and also to speed up the time to get the report output.

    Short URL:
  • Guest - yassine

    Hi, i would like to thank you for your great effort.

    my issue is that im unable see the page sreenshots

    thx,
    yassine

    Short URL:
  • Guest - user729369821

    Useless article unless you resolve the hosting issues you're having with whoever seems to be loading your pictures.

    Short URL:
  • My family members all the time say that I am wasting my time here at net, but I know I am <br />getting knowledge daily by reading thes nice articles or reviews.

    Short URL:
  • Article writing is also a excitement, if you know after that you can write <br />or else it is difficult to write.

    Short URL:
  • Guest - Vimal Iyer

    Hi Gurus<br /><br />I have a query on XML report. I am using RTF template and wanted to bring in a field which is not available during the >Insert >Field. How do I bring a column which is not there in the list (the window contains the fields). Can any gurus help...which is a real need to my knowlledge<br /><br />Regds<br /><br />Vimal

    Short URL:
  • Guest - Unknown

    Hi,<br />When running the program I am gettingnullpointer exception :<br />Calling XDO Data Engine...<br />java.lang.NullPointerException<br />at oracle.apps.xdo.oa.util.DataTemplate.getDataTemplate(DataTemplate.java:379)<br />at oracle.apps.xdo.oa.util.DataTemplate.(DataTemplate.java:226)<br />at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:283)<br />at oracle.apps.fnd.cp.request.Run.main(Run.java:157)<br /><br />Thanks,<br />Kausik
    <br /><br />Hi,<br /><br />I was getting this error too. When I debugged I found that the applications with which I registered the Data definition and concurrent propgram, were different. The application should be same 'Internal Controls Manager' for the conc prog, data definition and template definition.<br /><br />Regards,<br />Radhika

    Short URL:
  • Guest - Nandhakumar

    :P_INVOICE_NO is my bind Variable.<br />will it be fetch data in RTF?

    Short URL:
  • Guest - Tony

    Pics no showing

    Short URL:
  • Guest - Krishna11

    Pics are not visible

    Short URL:
  • Guest - Lakshman

    how can I handle exception block in EML publisher reports ?

    Short URL:
  • Guest - rahul3899

    data is not showing in output but it is in XML(diagnostics). only a single row is coming as in output.

    Short URL:
  • Guest - rahul3899

    Hii<br /><br />While developing report the data is not showing in output properly but it is showing in XML(diagnostics). Only a single row is coming as in output. <br /><br />Why it is happening?? Help me guys.

    Short URL:

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Jul 2016  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
    

Enquire For Training

Related Items