XML Publisher Concurrent Program - XMLP
Written by Anil Passi   
Friday, 24 November 2006
In this article I have listed a step by step demo of XML Publisher as a Concurrent Program in Oracle Apps.

I think it is very important that you get a feel of XML Publisher, as this will become the reporting tool in Fusion [assuming XMLP can become as powerful as Oracle Report in the given time].

Before I explain the steps in details with screenshots, let me brief them:-
a.    Create a report and register it as Concurrent Program of type XML
b.    Build a Data Definition & XML Template using XML Publisher.
c.    Create a relation between XML Template & Concurrent Program.

Sounds simple, it is indeed, but devil lies in detail. Hence read the below carefully.
I have provided the source code with installation instructions for you to try this. Please note to try this you need 11.5.10 environment.

Now lets get into the details….Step by Step…..
1. Create a table xx_emp_demo and insert two records into it.
create table xx_managers ( manager_no integer, manager_name varchar2(200) ) ;
insert into xx_managers ( manager_no, manager_name ) values ( 1000, 'Anil Passi') ;
insert into xx_managers ( manager_no, manager_name ) values ( 1001, 'Martin') ;
commit;

2. Next you need a concurrent program that spit out an XML file to the output of the concurrent program. Such concurrent program can be of type SQL or PL/SQL or Oracle Report or any other supportable type, provided it can produce a XML output.
Hence in this case, we will develop a Report that has all the columns from table xx_managers
Create a plain default Oracle Report using wizard in Oracle Reports 6i.
This can be done using wizard with SQL “select * from xx_managers”

Image
Above picture shows the report output in Reports 6i preview

Do not change anything in DESFORMAT, as Concurrent Manager will take care of passing XML to this. Hence XML Publisher will be fed an XML output by the concurrent manager itself.
 
3. Add three user parameters P_CONC_REQUEST_ID,  P_RESPONSIBILITY_ID, P_USER_ID
Image
These parameters will make it possible to run a report as concurrent program.
Save the above RDF as XX_MANAGERS.rdf

4. FTP XX_MANAGERS.rdf  to $AR_TOP/reports/US
Silly it is, but for demo I will use standard Application [forgive me, but I am making it easier for you to run the source code].

5. Create Concurrent program executable for XMLP report, as if it is a normal report
Image


6. Create a concurrent program for the executable. Note that I have kept the shortname and the program name both as XX_MANAGERS.
IMPORTANT:- Note that format is XML
Image


7. Register this program with Receivables request group.
DECLARE
BEGIN
FND_PROGRAM.add_to_group
    (
     PROGRAM_SHORT_NAME  =>'XX_MANAGERS'
    ,PROGRAM_APPLICATION =>'AR'
    ,REQUEST_GROUP       => 'Receivables All'
    ,GROUP_APPLICATION   =>'AR'
    ) ;    
  commit;
exception
    when others then
           dbms_output.put_line('Object already exists');
END ;
/

8. Run the report and you will see an xml output appearing. Save the output as XX_MANAGERS_241106.xml on your computer. You will need to use menu /Tool/Copy to open this XML output in browser, and then save it as XX_MANAGERS_241106.xml on your PC.
Image


NOW THE TIME TO DO XML PUBLISHER BIT…

9. Install this XML Publisher Desktop software on your pc, ensuring that you have MS-Word installed(for this demo)
The XML Builder Desktop Patch for Word is Patch Number: 4561835
This software can be downloaded from
http://updates.oracle.com/download/4561835.html

This is a tool given by Oracle[Desktop XML Publisher] that will read any XML file, will create the fields automatically.


10. Open MS Word after installing as per step 9, and you will now see something similar to below in Microsoft Word

Now in MS Word, click on “Load XML Data” and select file XX_MANAGERS_241106.xml that was created in Step 8.
Image


Image



11. Now, click on Insert/Table Form
And then drag and drop “List G Manager No” within the template section and click on OK.
Image


Effectively by doing these steps, you have just created a Layout for the report in XML Publisher. The layout will look like this [as below].
Image


Save this MSWord file as MANAGER_XML_TEMPLATE.rtf

By clicking on Preview, you will see the output as below
Image

12. Now, lets do the real bit in attaching the Concurrent Program definition to XML
Publisher. Logon to responsibility “XML Publisher Administrator”.
Image

Click on “Data Definition” menu as above…so that we can create the XMLs source data Definition. Effectively we are saying that output of the Concurrent program becomes the data definition for XMLP.

Lets define the value in below fields
Name : XX_MANAGERS
Application : Receivables
Code : XX_MANAGERS  [Note: This is the short name of the Concurrent program]
Start Date : Leave it to default Sysdate
Click on “Apply”
Image


13. Now lets define a template as below for XML Publisher.

For doing so, click on Templates Tab. We need to create a Template for the data-definition of previous step.
Image


Name : XX_MANAGERS  [this is the name of the template]
Code : XX_MANAGERS  [short name of conc program]
Application : Receivables
Data Definition : XX_MANAGERS [the one that we created in prior step 12]
Start Date: : Leave this default.
Type : RTF
Click on browse and select the RTF file[MANAGER_XML_TEMPLATE.rtf] that you had saved in Step 11.
xmlp_A_14



Click on Apply, and you will get the below record.
Image


14. Navigate to “Receivables Manager” and submit report XX_MANAGERS.
Click on Output button to see the report as pasted below.
Image



Comments (117)add
...
written by kartikey , November 26, 2006
Hi Anil,
Thanks! I want to make a request that can plz make a article on how to make Audit trail reports or how to manage it.
thanks
...
written by Anil Passi , November 26, 2006
Hi Kartikey,

As per your request, I have now written an article on Audit Trail, which can be accessed from the link below.

http://oracle.anilpassi.com/audit-trail-in-oracle-apps-ebs.html

Please note that in any Audit Trail, the prime objective is to capture the changed data.
For reporting you can use a Discoverer report or an Oracle report, based on a SELECT statement on Audit tables.

Many thanks,
Anil Passi
...
written by kartikey , November 26, 2006
Hi Anil,
Thanks! I want to make a request that can plz make a article on how to make Audit trail reports or how to manage it.
thanks
...
written by Anil Passi , November 26, 2006
Hi Kartikey,

As per your request, I have now written an article on Audit Trail, which can be accessed from the link below.

http://oracle.anilpassi.com/audit-trail-in-oracle-apps-ebs.html

Please note that in any Audit Trail, the prime objective is to capture the changed data.
For reporting you can use a Discoverer report or an Oracle report, based on a SELECT statement on Audit tables.

Many thanks,
Anil Passi
...
written by Khwaja , November 27, 2006
Hello Anil,

I found the solution for this. I was using Reports 9i and there the XML Prolog default value is

so i changed this to


this solved my problem..
:-)

You have written a very good tutorial.

Regards,
Khwaja
...
written by Khwaja , November 27, 2006
Hello Anil,

I am thankful to you for your tutorial.
I learned the basics now. I feel I can do further analysis easily.
Can you please give some tutorial like this for customizing self service applications.
Like adding an additional page or changing some fields in the existing selfservice application.

Regards,
Khwaja Hassan
...
written by Khwaja , November 27, 2006
Hello Anil,

I found the solution for this. I was using Reports 9i and there the XML Prolog default value is

so i changed this to


this solved my problem..
:-)

You have written a very good tutorial.

Regards,
Khwaja
...
written by Khwaja , November 27, 2006
Hello Anil,

I am thankful to you for your tutorial.
I learned the basics now. I feel I can do further analysis easily.
Can you please give some tutorial like this for customizing self service applications.
Like adding an additional page or changing some fields in the existing selfservice application.

Regards,
Khwaja Hassan
...
written by Anil Passi , November 28, 2006
Many thanks Kishore for sharing your experience on XMLP. I agree, the preview option is fantastic. It saves you the round trips of running the Concurrent Program repeatedly.
...
written by Anil Passi , November 28, 2006
Many thanks Kishore for sharing your experience on XMLP. I agree, the preview option is fantastic. It saves you the round trips of running the Concurrent Program repeatedly.
...
written by zoha , November 29, 2006
Hey Anil,
Beautiful site, i was wondering weather u could help me
1. In invoice report how would u print along with the line item description the lot # it came from and what quantity was shipped from the lot.
2. I have to make this report print using xml publisher but in different laguages im thinking miltiple templates attached to the same report in diff languages and accroding to territory any ideas how i can make this work??
would really appreciate the help!
thanx
...
written by zoha , November 29, 2006
Hey Anil,
Beautiful site, i was wondering weather u could help me
1. In invoice report how would u print along with the line item description the lot # it came from and what quantity was shipped from the lot.
2. I have to make this report print using xml publisher but in different laguages im thinking miltiple templates attached to the same report in diff languages and accroding to territory any ideas how i can make this work??
would really appreciate the help!
thanx
...
written by Anil Passi , November 30, 2006
Hi Zoha,
==>print along with the line item description the lot # it came from and what quantity was shipped from the lot.
Ans: Change the Report Data group query to include that information. Next using the XML Publisher tool, include those two additional fields. You should be able to join the Receivables Invoice Line to Original Sales Order and join that to Delivery lines and from there join to inventory to get lot number details.


==>report print using xml publisher but in different laguages im thinking miltiple templates
Ans: Indeed, you need to define two different RTF Templates. At the time of submission you can specify the language settings for the concurrent program.
NOTE: I think in receivables, it is possible to set the language against the customer bill to site. You may find that Oracle automatically works out the language the invoice needs to be printed in from the Customers Bill Site.

thanks,
anil passi
...
written by Anil Passi , November 30, 2006
Hi Zoha,
==>print along with the line item description the lot # it came from and what quantity was shipped from the lot.
Ans: Change the Report Data group query to include that information. Next using the XML Publisher tool, include those two additional fields. You should be able to join the Receivables Invoice Line to Original Sales Order and join that to Delivery lines and from there join to inventory to get lot number details.


==>report print using xml publisher but in different laguages im thinking miltiple templates
Ans: Indeed, you need to define two different RTF Templates. At the time of submission you can specify the language settings for the concurrent program.
NOTE: I think in receivables, it is possible to set the language against the customer bill to site. You may find that Oracle automatically works out the language the invoice needs to be printed in from the Customers Bill Site.

thanks,
anil passi
...
written by zoha , December 04, 2006
Hey Anil,
Thank you for the advice. For the line item lot number and shipping quantity for each item im using the follwing query

SELECT
rcta.trx_number,
ra_customer_trx_lines_all.description,
--ra_customer_trx_lines_all.
--nd.NAME Delivery#,
dd.shipped_quantity,
dd.lot_number
FROM
wsh_delivery_details dd,
wsh_delivery_assignments da,
wsh_new_deliveries nd,
ra_customer_trx_lines_all,
ra_customer_trx_all rcta
WHERE
rcta.CUSTOMER_TRX_ID = ra_customer_trx_lines_all.CUSTOMER_TRX_ID
and dd.INVENTORY_ITEM_ID = ra_customer_trx_lines_all.INVENTORY_ITEM_ID
AND da.delivery_id = nd.delivery_id
AND dd.delivery_detail_id = da.delivery_detail_id
AND dd.lot_number IS NOT NULL

but im not sure it is right can u suggest how i can correct it

thank you
...
written by zoha , December 04, 2006
Hey Anil,
Thank you for the advice. For the line item lot number and shipping quantity for each item im using the follwing query

SELECT
rcta.trx_number,
ra_customer_trx_lines_all.description,
--ra_customer_trx_lines_all.
--nd.NAME Delivery#,
dd.shipped_quantity,
dd.lot_number
FROM
wsh_delivery_details dd,
wsh_delivery_assignments da,
wsh_new_deliveries nd,
ra_customer_trx_lines_all,
ra_customer_trx_all rcta
WHERE
rcta.CUSTOMER_TRX_ID = ra_customer_trx_lines_all.CUSTOMER_TRX_ID
and dd.INVENTORY_ITEM_ID = ra_customer_trx_lines_all.INVENTORY_ITEM_ID
AND da.delivery_id = nd.delivery_id
AND dd.delivery_detail_id = da.delivery_detail_id
AND dd.lot_number IS NOT NULL

but im not sure it is right can u suggest how i can correct it

thank you
...
written by zoha , December 08, 2006
Hey Anil
Im using report builder 10g and ive come across the same error as khwaja when i run the report it says complete with warning and when i see diagnostics and click see xml it give me the samew error im not sure why but above i cant see the value for XML Prolog default value and what khwaja changed to to solve the problem do u have the value and can u post it thanking u again

zoha
...
written by zoha , December 08, 2006
Hey Anil
Im using report builder 10g and ive come across the same error as khwaja when i run the report it says complete with warning and when i see diagnostics and click see xml it give me the samew error im not sure why but above i cant see the value for XML Prolog default value and what khwaja changed to to solve the problem do u have the value and can u post it thanking u again

zoha
...
written by zoha , December 10, 2006
Hey Amit
Thanx a lot for ur help so far i just wanted to know is there a step by step guide as to how to set parameters when u register a report in apps i mean the user parameters we set in rdf file when we resgiter the report how do we set them i know it has somthing to do with tokens any help would be appreciated.
Thanx again in advance.

Zoha.
...
written by zoha , December 10, 2006
Hey Amit
Thanx a lot for ur help so far i just wanted to know is there a step by step guide as to how to set parameters when u register a report in apps i mean the user parameters we set in rdf file when we resgiter the report how do we set them i know it has somthing to do with tokens any help would be appreciated.
Thanx again in advance.

Zoha.
...
written by Anil Passi , December 11, 2006
Hi Zoha,

When you define a concurrent program, you get a button labeled parameters.
If you click on that button, you will then be able to define the parameter. The value that you enter in token field for RDF report must exactly match the name of the user parameter.

For PL/SQL concurrent programs you can leave the token field blank, as parameters defined in conc program are mapped sequentially to pl/sql procedure parameters.

Thanks,
A
...
written by Anil Passi , December 11, 2006
Hi Zoha,

When you define a concurrent program, you get a button labeled parameters.
If you click on that button, you will then be able to define the parameter. The value that you enter in token field for RDF report must exactly match the name of the user parameter.

For PL/SQL concurrent programs you can leave the token field blank, as parameters defined in conc program are mapped sequentially to pl/sql procedure parameters.

Thanks,
A
...
written by Anil Passi , December 12, 2006
Hi Shri,

Please click this link for the answer.
http://forums.oracle.com/forums/thread.jspa?threadID=451874&tstart=0

Thanks,
Anil Passi
...
written by Anil Passi , December 12, 2006
Hi Shri,

Please click this link for the answer.
http://forums.oracle.com/forums/thread.jspa?threadID=451874&tstart=0

Thanks,
Anil Passi
...
written by Anil Passi , January 02, 2007
.
.
.
.
Hi Santosh,

These parameters are mandatory for all the rdf reports that are run as Concurrent Programs.
Concurrent manager accesses these parameters, hence are mandatory. I think Oracle uses these parameters to set fnd_global.initialize for the new report session[not sure]
Thanks,
Anil Passi
.
.
.
...
written by Santhosh , January 02, 2007
Hi Anil,
One more doubt from me about XML Publisher. You have mentioned about three user parameters P_CONC_REQUEST_ID,P_RESPONSIBILITY_ID, P_USER_ID. Are these mandatory parameters? If so then what is the need for it?.I have created a concurrent program without these parameters and it is working fine? Could you please clarify me on this?

Regards
Santhosh
...
written by santhosh , January 02, 2007
Thanks Anil

Regards
Santhosh.
...
written by Anil Passi , January 02, 2007
.
.
.
.
Hi Santosh,

These parameters are mandatory for all the rdf reports that are run as Concurrent Programs.
Concurrent manager accesses these parameters, hence are mandatory. I think Oracle uses these parameters to set fnd_global.initialize for the new report session[not sure]
Thanks,
Anil Passi
.
.
.
...
written by Santhosh , January 02, 2007
Hi Anil,
One more doubt from me about XML Publisher. You have mentioned about three user parameters P_CONC_REQUEST_ID,P_RESPONSIBILITY_ID, P_USER_ID. Are these mandatory parameters? If so then what is the need for it?.I have created a concurrent program without these parameters and it is working fine? Could you please clarify me on this?

Regards
Santhosh
...
written by santhosh , January 02, 2007
Thanks Anil

Regards
Santhosh.
...
written by bhuvi , January 05, 2007
HI

Can you provide me some info on XMLP? I wanted to know the steps of converting an .rdf to xmlp report automatically using some java class.Pls revert back if you have any info on this.
Thanks
Bhuvi
...
written by Anil Passi , January 05, 2007
.
.
.
You can write scripts to use fnd_programs_pkg[or fnd_programs] API, such that existing reports definitions become XMLP.

But the format triggers of the RDF report will not work in XMLP. I think this migration will happen one by one basis

thanks
anil passi
...
written by bhuvi , January 05, 2007
HI

Can you provide me some info on XMLP? I wanted to know the steps of converting an .rdf to xmlp report automatically using some java class.Pls revert back if you have any info on this.
Thanks
Bhuvi
...
written by Anil Passi , January 05, 2007
.
.
.
You can write scripts to use fnd_programs_pkg[or fnd_programs] API, such that existing reports definitions become XMLP.

But the format triggers of the RDF report will not work in XMLP. I think this migration will happen one by one basis

thanks
anil passi
...
written by Anil Passi , January 16, 2007
Hi Bhuvi,

Are you saying that when you run the report, it does not produce XML output, and merely produces the plain text output?

Thanks,
Anil Passi
...
written by bhuvi , January 16, 2007
No anil,it produces xml output when i run conc prog. But 14th step u have mentioned is not clear for me,so pls can you provide screenshots or detailed step on how to submit.

14)Navigate to Receivables ManagerӔ and submit report XX_MANAGERS.
Click on Output button to see the report as pasted below.

here name of the report is SampleRep same name i have maintained for conc prg,data defn,datatemplate, So when i navigate to respective responsibility and try submitting request by giving SampleRep it picks up the conc prog only.But wheres the report or data definintion running???? pls rep ASAP.

Thanks.
...
written by Anil Passi , January 16, 2007
Hi Bhuvi,

Are you saying that when you run the report, it does not produce XML output, and merely produces the plain text output?

Thanks,
Anil Passi
...
written by bhuvi , January 16, 2007
No anil,it produces xml output when i run conc prog. But 14th step u have mentioned is not clear for me,so pls can you provide screenshots or detailed step on how to submit.

14)Navigate to Receivables ManagerӔ and submit report XX_MANAGERS.
Click on Output button to see the report as pasted below.

here name of the report is SampleRep same name i have maintained for conc prg,data defn,datatemplate, So when i navigate to respective responsibility and try submitting request by giving SampleRep it picks up the conc prog only.But wheres the report or data definintion running???? pls rep ASAP.

Thanks.
...
written by Anil Passi , January 19, 2007
.
.
.
Hi Agostino,

Most likely you are correct. The last time I developed APPS reports were in 11.0.3 version. And I vaguely remember it was a good practice to define all these parameters, specifically for Multi-Org Reports, whereby we used to invoke SRW User Exit API to set the global context. I think the OrgId UserExit references all these parameters to set the context.

Thanks,
Anil Passi
...
written by agostino_neto , January 19, 2007
Thanks Anil.
I will try to reproduce it.
For user parameters P_CONC_REQUEST_ID,P_RESPONSIBILITY_ID, P_USER_ID.
I have always heard that only P_CONC_REQUEST_ID was mandatory to use SRW.
That said - I think there is no problem for declaring the three parameters.
...
written by Anil Passi , January 19, 2007
Hi Agostino,
Please could you email me the image that should be in Step 14. I will put that image onto this article in step14

Thanks,
Anil passi
...
written by Anil Passi , January 19, 2007
.
.
.
Hi Agostino,

Most likely you are correct. The last time I developed APPS reports were in 11.0.3 version. And I vaguely remember it was a good practice to define all these parameters, specifically for Multi-Org Reports, whereby we used to invoke SRW User Exit API to set the global context. I think the OrgId UserExit references all these parameters to set the context.

Thanks,
Anil Passi
...
written by agostino_neto , January 19, 2007
Thanks Anil.
I will try to reproduce it.
For user parameters P_CONC_REQUEST_ID,P_RESPONSIBILITY_ID, P_USER_ID.
I have always heard that only P_CONC_REQUEST_ID was mandatory to use SRW.
That said - I think there is no problem for declaring the three parameters.
...
written by Anil Passi , January 19, 2007
Hi Agostino,
Please could you email me the image that should be in Step 14. I will put that image onto this article in step14

Thanks,
Anil passi
...
written by Anil Passi , January 23, 2007
Hi Bismi

Good question, and a very demandig user you have got.

I suggest, you submit a concurrent request.In your preview screen, you will have a button of type SubmitForm. Hence when the button is clicked, you can write code in processFormRequest to submit a concurrent request of type XML Publisher.
Use class ConcurrentRequest, it has a method named SubmitRequest.

Thanks,
Anil Passi
...
written by bismi rahaman , January 23, 2007
Excellent article Anil! Do you also have an example on how to invoke XMLP from OA Framework Pages. In our requirement we have a custom OA pages wherein the customer wants to generate the report on the fly by clicking a preveiw button. I can generate the XML from VO but how do I pass this XML to a template to get the required PDF
Thanks
Bismi
...
written by Anil Passi , January 23, 2007
Hi Bismi

Good question, and a very demandig user you have got.

I suggest, you submit a concurrent request.In your preview screen, you will have a button of type SubmitForm. Hence when the button is clicked, you can write code in processFormRequest to submit a concurrent request of type XML Publisher.
Use class ConcurrentRequest, it has a method named SubmitRequest.

Thanks,
Anil Passi
...
written by bismi rahaman , January 23, 2007
Excellent article Anil! Do you also have an example on how to invoke XMLP from OA Framework Pages. In our requirement we have a custom OA pages wherein the customer wants to generate the report on the fly by clicking a preveiw button. I can generate the XML from VO but how do I pass this XML to a template to get the required PDF
Thanks
Bismi
...
written by Zoha , January 25, 2007
Hey Anil,
How r u? Just wanted to thank you again for this excellent site. Anil i had 2 questions
1. I developed shipping documents like packing slip and commercial invoices using the seeded report in xml publisher. Now oracle says running it as part of the shipping process is not possible because that functionality for xml publisher in in release 12. Is there anyway i can get my customized xml report to run as part of the ship confirm process?
2. What is the logic which is used by the packing slip and commercial invoice to select language to be printed in and how do we set the templates so that they automatically get selected.

Ur help is greatly appreciated

Zoha
...
written by Anil Passi , January 31, 2007
Hi Sateesh

SUM() will return 0. If you do not wish to see 0, then do a decode, as below
select decode(sum(),0,null,sum()) from dual

thanks
anil
...
written by Zoha , January 31, 2007
Hey Anil,
How r you? Thanx for all ur help till now. We have this situation in conversions we are setting the language in the charactersitic tab of each address of customers.
Now i Have say a packing slip and its in xml publisher i have registered 3 templates for this report using diff language and territory settings. Now when we run the report will it know which template to pick automatically based on the defination of the template and the language we set at the ship to level of the customer or do we have to manually select the correct language template from the LOV of templates registererd.....if thats the case how can we automaye this??

Zoha
...
written by Kiran , February 06, 2007
Thanks a ton Anil - blog was very helpful in getting me started.

I have a question though - am generating remittance advice using XMLP. My customer requires me to email the remittance advice as an attachment; and wants this done as a part of the concurrent program that generates remittance advice. Would you have any idea how to go about it?

PS: I did search the oracle forums, found a couple of topics on this matter - but no concrete answer was forthcoming.

Tia
KH
...
written by Anil Passi , February 07, 2007
Hi Kiran

have a look at http://oracle.anilpassi.com/se...kflow.html

You can use workflows to Email files as attachments.

Thanks,
Anil Passi
...
written by Rajeev , March 14, 2007
Hi Anil,

U r doing a awesome job.


I have a question that whether XML report will work with ver 11.5.9 or this feature will only be available in 11.5.10.

If it is possible to generate XML report then pls do let me know coz when i submitt the concurrent program and its gets completed successfully also it generates the output in text format, I have checked in the Concurrent program definition also its Output format is XML.

Thanks n Regards
Rajeev Kumar
...
written by Anirudh , March 19, 2007
Hii

I have a similar kind of report except that a notification has to be fired to every manager
in excel format the Concurrent program is running well and the O/p in concurrent requests is also in correct format but when the notification is sent to managers in the excel sheet i see only html tags and i dont know why

please help me out

Thanks

Anirudh
...
written by Anil Passi , March 22, 2007
Hi Kishore

Of course I remember you.

Thanks for sharing this. I have uploaded your data template at link http://www.anilpassi.com/apps/..._so_dt.xml

Thanks,
Anil
...
written by Srini , April 03, 2007
Hi Anil,
I followed following steps since I had rdf file:
1- Defined Concurrent Program with output as XML
2- Defined Data Definition with a code the same as concurrent program shortname
3- Added Concurrent program to a request group.
4- Ran the concurrent program, request output will be in XML format.
5- Save this file to your desktop
6- Built RTF Template Layout
7- Defined xml template and associated the data definition and load XML template rtf file.
8 - Run the report again. it should be published using the template.

In the result, I was not able to find some of the fields like Item Number and some of the formula columns.

Please let me know anything else I need to do?

Thanks in Advance!!
Srini.
...
written by umesh , April 30, 2007
hi Anil,
This is a wonderful article it helped me lot. My requirement is i want ouput in EXCEL through Application directly can we use XML publisher since it can give ouput in EXCEL.. if yes then how? Because i can get ouput only in PDF format only.

I will be very greatful if u can help me out.

thanks
Umesh
...
written by Anil Passi , April 30, 2007
Generating an excel is very straightforward. Have a look at article http://oracle.anilpassi.com/te...-apps.html

And search for text excel within it

Thanks,
Anil Passi
...
written by Subhamay , May 03, 2007
Hi Anil,
Thanks for your excellent work!!Can you write an article to show how to incorporate Flexfield Data in the XML Publisher reports.

Thanks,
Subhamay
...
written by Srini , May 14, 2007
Hi Friends,
It was nice to see such a good examples about XML Publisher.
I am currently facing one problem.
My report contains multiple Queries and are linked thru data link.
When I generate XML Output from the reports I am not getting the underlaying data from the other queries which are linked to the main query.

Thanks in Advance.
Srinivas
meetvass@gmail.com
...
written by Sai , May 20, 2007
Hi Anil,

Certianly the great effort you made to make the things easy for a developer.For me,the things were really exciting upto step-14.
But while running the report finally(as per step-14),i have the following error log.

Please advice as it is really difficult for me now to track the things.

Error Log
+------------- 1) PUBLISH -------------+
Beginning post-processing of request 9382219 on node OADEVDB03 at 20-MAY-2007 00:21:57.
Post-processing of request 9382219 failed at 20-MAY-2007 00:23:57 with the error message:
The Output Post-processor is running but has not picked up this request.
No further attempts will be made to post-process this request, and the request will be marked
with Warning status.
Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.
+--------------------------------------+

-Sai
...
written by shekar , June 01, 2007
Hi anil,
Thanks for your excellent work!!Can you write an article to show how to generate a report with parameters. what i want to say is suppose i want to generate a report by taking the inputs from user.The inputs are like starting date and ending date . And want to display the report with in those dates.
I will be very greatful if u can help me out.
thanks,
shekar.
...
written by Anil Passi , June 05, 2007
Hi Darshan

Many thanks for sharing this info.

Regards,
Anil Passi
...
written by someshwar , June 06, 2007
how to submit XML publisher through back end with parameters. I mean using any package or procedure.
...
written by Gayatri Jayaraman , June 13, 2007
Hi Anil,
Im trying to develop a report which will display chart of accounts ,its entity,branches and Cost Center. The report is developed using xml publisher. The problem is beacuse of the data volume im unable to write the xml data directly to the output file and if i break the data into manegable chunks to be written, the program takes a long time to complete.

Can you pls Help me?

Thanks & Regards,
Gayatri Jayaraman
...
written by Tony , June 18, 2007
Hi Anil,

I am not sure what happened, the next day the XMLP report was running fine without any modifications.

Anyway thank you for your reply, As by now i developed a couple of XML reports and trying out differant things

Thank You
Tony
...
written by sourav , June 19, 2007
Hi Anil,
I did all the above steps, but when finally when i ran the report i got the xml output rather than the templete output,so please help me in this.
Regards
Sourav
...
written by Anil Passi , June 22, 2007
Hi Amit

Not sure what you mean.Parameter for report registered as conc program are exactly the same as that for any other normal report which is registered as concurrent program.

Parameters can be passed in exactly the same manner as that for Oracle Reports

Thanks,
Anil
...
written by Tony , June 27, 2007
Hi Anil,

I developed an XML report, now i want to edit the rdf query, what are the steps to be done so that the changes will get reflected

Thanks
Tony
...
written by Anil Passi , June 27, 2007
Hi Tony, if you have simply modified the whereclause then no change is needed for XMLP

However if you have changed the structure of the results i.e. the output, then you have to reflect those changes into the template too.

Thanks,
Anil Passi
...
written by Kiran , June 27, 2007
Hi Anil,

Colud you please explain about the conversion XML to XLS format. I need some code on this XML to excel format.

Thanks,
Kiran.
...
written by Anil Passi , June 27, 2007
Hi Kiran

I think this link http://oracle.anilpassi.com/ho...nt-re.html answers your question about excel.

Thanks,
Anil Passi
...
written by tony , June 28, 2007
Hi Anil,

I am getting one problem in the header and footer section.
How to recreate the problem
----------------------------
1. create a word template which has 3 pages
2. Insert some header and footer
3. now the same header is coming in all the 3 pages in the template
4. the report is just text feilds(ie fetching no xml data)

The Problem
-----------------
The header and footer is coming only in alternate pages ie in page 1 and 3, while running from SRS

Steps taken to solve this
------------------------
In Words Page setup-Layout Tab--Header and footer section-- differant odd and even =is not checked
differant first page = is not checked

Thank you for the Patience
Tony
XML Report Doubt
written by Tony , July 03, 2007
1. Header and Footer is coming only in Odd Pages(The checkbox for odd or even pages is not ticked)
2. How to get Excel report without the White background
...
written by spriha , July 05, 2007
Hi,
can we use xml publisher without the support of APPS & also can we generate multiple reports with XML publisher? if yes it would be nice if u give the method.

Thanks
Spriha
...
written by Venu , July 05, 2007
Hi Anil

You are doing a great job in explaining things in a simple manner.
I am also receiving the same error which is reported by Sai. Request you to address it.
/* ERROR */
------------- 1) PUBLISH -------------
Beginning post-processing of request 1515874 on node UACIN006 at 05-JUL-2007 15:47:37.
Post-processing of request 1515874 failed at 05-JUL-2007 15:52:37 with the error message:
The Output Post-processor is running but has not picked up this request.
No further attempts will be made to post-process this request, and the request will be marked
with Warning status.
Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.
/* ERROR */


Thanks and Regards
Venu
...
written by Anil Passi , July 05, 2007
Hi Venu


Check with your DBA's if OPP is up and running.
Output Post Processor(OPP) is a Conc Manager itself that processes the output of the XMLP enabled concurrent program.
This manager must be up and running. Bounce your Concurrent Manager and ensure OPP is runnning.

Also, run this SQL
SELECT FND_PROFILE.VALUE('CONC_PP_RESPONSE_TIMEOUT') FROM DUAL;

Set this profile to a value of say 1200, and then bounce conc manager

Full name of this profile option is "Concurrent:OPP Response Timeout"

Thanks,
Anil Passi

...
written by dpsh2k , July 13, 2007
Anil,
First of all I would like to thank you for this wonderful site. Its very educational to me. Learning a lot from here.

I have a question on XML Publisher. Can you give me some input on how to print XML PDF report straight from concurrent manager. Currently after running the report we need to open up in PDF reader and then send to the printer. Can you shed some light on this.

Thanks,
Deepak
...
written by Anil Passi , July 14, 2007
Hi Deepak,

It should be possible to print the output directly from concurrent manager, if print copies at the time of submission is greater than 0.
You haven't mentioned of any error in log file when print copies is more than 0.
Two important metalink notes are 316447.1 and 338990.1

Try to Submit the request to print with the "PDF Publisher" print style and with number of copies to 1 or more.

There is a metalink note[338990.1] titled "How To Print XML Publisher PDF Reports Via The Concurrent Manager?"
Please get your DBAs to implement this note.

If your patching level is lower than 11.5.10 CU4 then raise an SR, as you also might need an additional patch to get this to work.

Thanks,
Anil Passi
...
written by vvrpavan , August 23, 2007
Hi Anil,

We are trying to print some text every alternate page on the xml report, can you please suggest any better way.

Thanks

Pavan
...
written by Alaka , August 27, 2007
Hi, Anil...
Can you give me a description about Entity Objects in Oracle Apps. It is better if it is with an example..
Thanks...
...
written by Rakesh Sreenivasa , August 31, 2007
Hi Anil,

Can we associate single short_name to multiple templates/data definitions. If Yes, does the user gets prompted on which format of Output is required. Please let me know.
...
written by Anil Passi , September 01, 2007
Hi Rakesh

Yes, that should be possible. You can attach as many formats as required to a concurrent program

Thanks,
Anil Passi
...
written by cavaya , September 06, 2007
Hi Anil,

i read some of your articles about oracle i feel this one of the correct blog to get awareness on the subject.

currently i am working on xml publisher and facing following problem while i am going to register template in template window:

My RTF template works fine in preview mode in Word (using XML publisher desk top tool). I go to upload it via XML Publisher Adminstator and I get a screen that just says "You have encountered an unexpected error. Please contact the System Administrator for assistance."

The only option i have to Log out. Is there a way to validate my template to know what could possibly be wrong with it?

thanks,
sai krishna

...
written by Simardeep Bedi , September 07, 2007
Hi Friends,

I am not sure whether this topic has been discussed or not. I am facing a problem in attaching multiple templates to the same concurrent request. Please let me know whether it is possible or not. As per requirement, I need to attach 2 different templates to one concurrent request (APXPBFEL). When I try to create the data definition or template, I get the error "You entered a duplicate data definition. Please change the Name, Code and/or Application and reapply". Can I not attach more than one template to the same request of the same application? Please let me know.

Thanks,
Simar

...
written by Rakesh Sreenivasa , September 12, 2007
I need to change the format of the PO Delivery date generated from Standard generation of PO.



Future -- 2007-08-10T11:46:06 0000 (Post Modify)

Present -- 2007-08-10T11:46:06 00:00 (Present)



How do i go about modifying and what should i modify , please let me know .

...
written by Mahdev R. , September 19, 2007
Hi Anil,
I tried the above tutorial, but couldn't get see anything in the output. I've done exactly the way you have explained. Secondly under the XML Publisher Administration at our site I couldn't see the Administration Tab as shown in your screen shots. Do I need to add that tab and do something in there?

Can you please help ?

Thanks
Mahdev

...
written by Ritu , September 19, 2007
Hi Anil
Please can you come up with an article for generating XML Publisher reports from OAF? The VO I have for my page generates an XML output which I would want to feed to the XMLP. This is urgent.

Ritu
...
written by rash , September 24, 2007
Hi Santosh/Anil

As per Santosh's Question You have mentioned about three user parameters P_CONC_REQUEST_ID,P_RESPONSIBILITY_ID, P_USER_ID. Are these mandatory parameters?As per my thinking n knowledge when ever u use srw.USER_EXIT ('FND SRWINIT') or FND SRWEXIT then u need to define p_conc_request_id as a parameter to the report.Other wise its not neccessary to define P_CONC_REQUEST_ID,P_RESPONSIBILITY_ID, P_USER_ID otherwise no need to declare P_CONC_REQUEST_ID,P_RESPONSIBILITY_ID, P_USER_ID these parameters.Moreover report will run fine wthout P_CONC_REQUEST_ID parameters too.

Correct me if i m wrong

Regards,
Rashmi
...
written by Anil Passi , September 24, 2007
Hi Rashmi

You have hit the nail on its head, your explanation is correct.

Thanks,
Anil Passi
...
written by Ravinder YAdav , September 28, 2007
Hi Anil,
I create the report in BI PUBLISHER. How I register this report in E business suit
Thanks
Ravinder
...
written by Ravinder YAdav , September 28, 2007
Hi Anil,
I create the report in BI PUBLISHER. How I register this report in E business suit
Thanks
Ravinder
Header and Footer printing only on odd pages
written by Ifath , October 09, 2007
Hi Anil,
i have tried the slution given above, by Tony for this problem... but i still cant see the header and footer on even pages in the report output... i can see the header and footer in the even pages of the template but not in the output... my first page consists of summary data of the report and details data starts from the second page. so, i have given a page break before detail data starts. is there a connection between this page break and the problem that i am facing?? plz help...

Regards,
Ifath smilies/sad.gif
Regarding Xml Publisher
written by srrp , October 11, 2007
Hi Anil

Thanks for giving this type of Artical.
This Artical helped me very well.

My Requirement is I need to call the xml publisher rtf/pdf template from the custom form
My custom form is having one push button, if i press that push button it has to display the XML PUBLISHER REPORT TEMPLATE OUTPUT.

Please explain me clearly its urgent

Thanks
Raja.

Re: Regarding Xml Publisher
written by Milan , October 30, 2007
Hi Raja,

Use FND_REQUEST.SUBMIT_REQUEST to call the concurrent program. And this CP will have XMLP report attached as output.

HTH,
Milan
handling formula column in xml publisher report, without using rdf .
written by ratnesh pandey , November 13, 2007
hi anil,
its always nice to see your article and learn from.
i have one xml publisher report and i am still worried abt how to handle formula column in xml publisher report ,if ur using data defination file and template in xml data administrator.
please let me know ....its very important for me ...also i want to know how to change currency in words (need to handle in xml publisher report).iknow how to handle it through rdf formula column .i want to know how to handle in data defination file for xml reports.
thanks in advance....
regards
Ratnesh
Shell Script
written by prabhakarreddy , November 20, 2007
Hi Anil,
I want need information on Unix with ShellScript ,here as a Apps Technical consultant how much knowledge require on that.plse could u share some information.

Regards
Prabhakar
How can I print the parameters value in the RTF template.
written by I.K.Srinivas , November 22, 2007
Hi Anil

PLease suggest me, how to print the parameter values in the XML publisher report.
Comment
written by saleema , November 22, 2007
Extremely Informative and clear. Thank you. smilies/smiley.gif
How to Customize standard XML Templates(R12i)
written by rajeshkoripalli , November 27, 2007
Hi anil,


U r atricles are very informative, thanks for ur continous support.

I would like to know how can we a custom field to an Standard XML Template.
Thanks!!
written by Subhash , December 01, 2007
Thanks a Ton for this information!! smilies/smiley.gif
XMLP Dynamic Template
written by gjagesh , December 12, 2007
Hi Anil,
Is there any way in XMLP to create dynamic template. according to the SQL query the template should create.
my requirement is having many sql scripts run from one concurrent request ...needs to show the output using XMLP
Please suggest me any work around.
Thanks in Advance...
XML Publisher
written by SLakshmi , January 20, 2008
Hi Anil I am working on AP Payments check format.
Our requirement is to print the invoices on a pre-printed stationary.
We have to print the invoices on this page and page below we are going to have the check.
if the invoies are less than 10,it is priting on the first page and check is also printing on the first page.this is as per our requirement it is coming correctly.
But the problem is when ever there is invoies over flowing mean more than some 30,then the check is moving to the second page but this should not happen,
our requirement is when ever there is a over flow of the invoices it shold print half on the first page and check also sholud be printed on the first page the over flowing records should goto the second page and check should not print on the second page we have to show some void statement in place of the check.
this is our requirement and we are facing problem only with the over flowing invoices.
Please help me in this as soon as possible.

Thanks in Advance

XML format error
written by Kate , February 05, 2008
Hi Anil ,
I have some question , how can I fix this one?

I have performed all that you suggested and more thing I also
run script (cmclean.sql) but it still not work.
---Error/
Beginning post-processing of request 1045407 on node MATHERP at 05-FEB-2008 08:32:30.
Post-processing of request 1045407 failed at 05-FEB-2008 08:34:30 with the error message:
The Output Post-processor is running but has not picked up this request.
No further attempts will be made to post-process this request, and the request will be marked
with Warning status.
Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary. smilies/sad.gif

Thank you so much.
...
written by Anil Passi , February 05, 2008
You will find the solution in Metalink Note:352518.1
Excerpt from that note is below.....
Applies to:
Oracle XML Publisher - Version: 11.5.1 to 11.5.10
Oracle Application Object Library - Version: 11.5.1 to 11.5.10
This problem can occur on any platform.
Executable: XDOREPPB - Generate PDF from XML output and given template
Concurrent Manager: Output Post Processor Output Post Processor
Symptoms
A concurrent request fails to complete due to a timeout caused by the Concurrent Processing integration with XML Publisher
functionality (Patch 3435480). Two possible errors can occur, but never at the same time:

Error Message A (CONC-PP NO RESPONSE):

The Output Post Processor is running but has not picked up this request.

No further attempts will be made to post-process this request, and the request will be marked

with Warning status.

Setting the profile option 'Concurrent: OPP Response Timeout' to a higher value may be necessary.


Error Message B (CONC-PP TIMEOUT):

The concurrent manager has timed out waiting for the Output Post Processor to finish this request.


Check that there are enough Output Post Processor service processes running.

More information may be found in the service process logfile.

Cause
Cause A
The Concurrent Manager process generates the XML data file. Upon completion it will trigger the Output Post Processor in order to merge the XML data file and the template which was selected on the Submit Request form.

The number of Concurrent Requests that the Output Post Processor can handle in parallel depends upon:
- the number of Processes
- the number of Threads Per Process

The default values are 2 Processes and 5 Threads Per Process so a total of 10 reports can be processed in parallel.

In case there are other Concurrent Requests running which have already invoked the OPP then it might happen that no additional requests can be picked up for a period of time. The pending request will be picked up as soon as one of the running jobs completes.

By default a timeout will occur if it takes longer then 120 seconds (2 min.) for the Output Post Processor to pick up the request from the Concurrent Manager process. In that case, the Concurrent Request will complete with status Warning and the Request log file will contain Error Message A (see above).

Cause B
Once the Output Post Processor picks up the request, the XML Publisher engine is invoked to generate the final output file. The time that this takes will depends on various elements such as:
- size of the XML Data File
- complexity of the template
- performance of the server
- ....

By default a timeout will occur if it takes longer then 300 seconds (5 min.) for the XML Publisher engine to generate the output file. The Concurrent Request will complete with status Warning and the Request log file will contain Error Message B.
Solution

There are 2 new profiles options that can be used to control the timeouts. Depending on the error message, one of the following solutions needs to be implemented.

Profile Option : Concurrent:OPP Response Timeout
Internal Name : CONC_PP_RESPONSE_TIMEOUT
Description : Specifies the amount of time a manager waits for OPP to respond to its request for post processing.

Profile Option : Concurrent:OPP Process Timeout
Internal Name : CONC_PP_PROCESS_TIMEOUT
Description : Specifies the amount of time the manager waits for the OPP to actually process the request.

Note: The profile options are available as of $FND_TOP/patch/115/sql/AFCPOPRB.pls 115.3 and are included in Patch 4125550 11.5.10 CU2 for ATG Product family.

Solution A
Option 1: Increase the value (in seconds) for the profile option 'Concurrent:OPP Response Timeout'.
Option 2: Increase the number of processes or threads (or both) of the OPP via Oracle Applications Manager (see Note 291792.1 for the detailed instructions)
If Option 2 is taken, remember to stop and restart the OPP for the change to be implemented.

Solution B
Increase the value (in seconds) for the profile option 'Concurrent:OPP Process Timeout'.

Workaround
The timeouts can also be altered directly in the package AFCPOPRB.pls :

-- Default timeout values for waiting on a response to a request (seconds)
TIMEOUT1 constant number := 120;
TIMEOUT2 constant number := 300;
TIMEOUT1 and TIMEOUT2 corresponds to respectively OPP Response Timeout (solution A) and OPP Process Timeout (solution B).

...
written by Kate , February 13, 2008
Hi Anil

Now the problem has been gone.

Thank you so much!!
Modify PO Output for Communication program
written by Madhu Goyal , February 13, 2008
If i have to add a field in PO output which is not available in data definition say
requester's phone number which is coming from PER_PHONES table. Then please explain the steps to modify concurrent job for this program and as well as steps to generate data definition for this program.

This program's sounce code is java and output is PDF AND getting published by XML
PUBLISHER.
I searched this topic on internet and everybody just explaining how to modify template and i need information on java concurrent programs and its data defintion
How to mail XMLP report as attachment using shell
written by Akash Jain , February 18, 2008
Hi,
I want to mail the XMLP report as attachment via unix shell.
The problem is that it seems to me that XMLP displays the report by combining the XML and the Pdf file dyanmically.Now when i am trying to mail XML file i can see the data in the XML format and not the way as it looks in document.

Also i read in a blog in this page that the solution to this is the use of Workflows.But in workflow also i am facing the same problem as above .the data in the attachment is in the XML format.

Please help me with this.

Thanks,
Akash
Migration of apcheck pring from 11.5.7(RDF) to Rel 12 (XML Publsiher)
written by sivakumar , February 21, 2008
We are migrating customized AP Check print report from RDF in 11.5.7 to R12 XML Publisher report. We have 18 reports to convert.
I have followed
http://oracle.anilpassi.com/xml-publisher-concurrent-program-xmlp-2.html

link to do the same.
I am facing the follwoing issue.
I am getting empty output after did all the changes as per the ablove link
But only modification i did is, as in R12 we ahve separate top for Payments. But we dont have Report folder under IBY_TOP. So I am keeping my RDF report in AP_TOP and I have created executable under ap_top then Program under Payment_top. Remaining are same.
But I am not getting the output.

Pl. let me know, what I did is same or how to proceed
this is very urgent. so expecting the reply at the earliest

Data Defintion not linking with RDF Concurrent Program Short Name
written by Kamesh , February 21, 2008
Hi,
I am involved in an upgrade project.
In 11.5.7 they have custom payment formats and we need to upgrade those to R12.
In R12,XML report is mandatory for check/paymnt formats.

So i thought of designing an RTF file and link with Data Definition.
So that i need not create again data definition logic.

I have done the same,but while running i am not getting the output.
The thing is that the data definition is not getting mapped with the RDF report short name.

I have done as follows,

1)Defined executable in 'Payables; application and the reason is in Payments top(IBY),there
is no reports folder.and the Execution type is Oracle Reports and gave the custom rdf name
2)Defined concurrent program registration in 'Payments' application.Because i need to map the
concurrent program short name to Payments application
3)Created Datadefinition in Payments application with Data Definition code as 'Short name' of
concurrent program
4)Created Template definition linking with the Data definitin defined above.

But i am not getting the output exactly .The Data definition is not getting mapped exactly.
Kindly help if you have any suggestion.

Thanks and Regards,
Kamesh
XML Report publisher
written by Bismit Pratap Singh , February 22, 2008
Hi,
Can anyone just tell me, is there standard Concurrent prg known as "XML REPORT PUBLISHER" and how it's linkage with data definition of XML publisher. What's the concept of this above concurrent prg name and how we will use it.

Need the response ASAP as i am going to develop that type of reports.

Regards
Bismit
DBMS_XMLGEN
written by Janel Hansen , March 14, 2008
Hello Anil,
I am trying to create xml output for a concurrent request, bypassing the report piece altogether. Are you familiar with the DBMS_XMLGEN package?

I have gotten so far as to be able to run my procedure and see the output in TOAD using dbms_output.put_line, but I can't seem to quite get the right link to convert this to Oracle Apps output.

I have a concurrent request setup to output XML.
This calls a procedure to return to the output file.
So far, all I am getting returned is 'XML document must have a top level element.'

Here is the relevant code...

ctx DBMS_XMLGEN.ctxHandle; -- vars to convert SQL output to xml
xml clob;
xmlc varchar2(4000);
off integer := 1;
len integer := 4000;
i number := 0;
rc_data sys_refcursor;

begin
-- this calls simple open cursor for sql statement, returns rows
rc_data := fa10022_data(P_BOOK_TYPE_CODE
, P_STATE
, v_BEG_DATE_EFFECTIVE
, v_END_DATE_EFFECTIVE
, P_BEG_ASSET_ACCT
, P_END_ASSET_ACCT
, v_depr_per_ctr);

ctx := dbms_xmlgen.newContext(rc_data);

dbms_xmlgen.setRowsetTag(ctx, 'XXFA10022');

dbms_xmlgen.setRowTag(ctx, 'G_DATA');

xml := dbms_xmlgen.getXml(Ctx);

i := dbms_xmlgen.getNumRowsProcessed(ctx);

dbms_xmlgen.closeContext(Ctx);

apps.fnd_file.put_line(apps.fnd_file.output, xml);

I was also following this link...
http://www.appsassociates.com/products/Generation_XML_PLSQL.pdf

any suggestions?

Thanks!!
Janel
XML Report
written by Kate , March 17, 2008
Hi Anil,

I try to create XML report but it got error and I log TARS ,later matalink suggest me to change header in XML data file but I don't know to change because I cannot copy file ,it shows error and I want to change to
only , Could you pls tell me how to do?
By the way do you know path that contain XML data file in database?

Thank you

Kate
XML report
written by Kate , March 17, 2008

The error
and I want to change only

Thank you

Kate
XML Report
written by Kate , March 17, 2008
Hi Anil ,

That question that I asked you before ,current I already fixed it. But I still got some question I have created report paramter but why it did not work because after I run the report ,all data come out even input paramter depend on customer name.

Could you pls explain more about report paramter that concern with XML report template.

Thank you

Kate

Passing Parameter from report to the XML
written by Shweta Tiwari , March 20, 2008
Hi ,
In the report (RDf )I have user parameter which are getting populated when the report fires.I want to display the Value of the parameters in the O/P (Either the XML O/p or the Output of the XML Publisher).How can i acheive this?
You must be logged in to a comment. Please register if you do not have an account yet.

busy