Apps To Fusion

Very Useful Information
written by Naresh Babu , August 27, 2008

Hi Prabhakar,

I appreciate your effort in bringing out this article.I have faced this issue earlier..i struggled for couple of days and found work around.But this is solution seems to be straight forward and will implement in my next report.Once again keep the good work going.

Have a nice time.

Regards,
Naresh

Good Work
written by Nader , August 27, 2008

hi;
Thanks alof of this nice information, i faced this problem bfore and i solved it by applying some patch, anyway i have faced another problem now in xml publisher, when you make template with RTF type then you try to run report for that template it will come PDF,how can u make it a default to be RTF not going to upon completetion options and change it from there.(in other way, i want the output format for my report to be as template type by default)

Thanks alot

yours, Nader

XML Publisher
written by Ram Shankar , September 11, 2008

hi,
Iam new to XML Publisher, and wud like to know how to create or design a template. Also, pls help me how to generate report in Excel or PDF using XML Publisher.

Thanks
Ram

Header & Footer in RTF using MS Word 2007
written by Rama Krishna Mateti , September 18, 2008

Hi,

This is Rama Krishna Mateti.
How r u doing?

I have developed an RTF template and I inserted Header and Footer in the template.
When I test with the sample XML data for the template I could not able to see the Header and Footer such as Logo, Page Number...etc in the PDF but I could see
the Output in PDF when I run the same template and input XML file in the other Computer.
When I uploaded the template and register it with Oracle Apps I could succesfully see the Header and Footer report along with Output in the PDF File.
Could you tell me do I need to make any modifications/Setting in the MS Word so that I could see the header & footer in the PDF?
Thanks in advance

OAF: same problem exists, but the solution is the same as listed here
written by Danny Parrish , October 15, 2008

Thank you for posting a solution to this problem. I had just come across this error today, and I was able to fix it due to your post.
Just a fyi, but the same problem occurs when submitting a request through OA Framework. The fix is the same that is listed here. oracle.apps.fnd.cp.request.ConcurrentRequest class, there is a method called "addLayout" that uses the same parameters above. I invoked that method before submitting the request, and I was able to view my XML template with no issues... Thanks again!

Danny

Submitting XML request and the output not displayed
written by Jacob C , January 08, 2009

Thank you. This articale helped me.

Very helpful
written by V Jayamohan , February 03, 2009

Thanks a lot

Call Bursitng Program only when the Report generates any data
written by Siddharth , February 22, 2009

Hi Prabhakar,

In the After Report Trigger of the RDF, we call the Bursting Program to split the xml file.
Is there any way that If there is no data generated by the RDF Report, then do not call the Bursting Program??

Analyst
written by Raghu26 , February 25, 2009

Hi,
I'm facing the same problem. First I got the message "Unable to find published output for this request", then I added the layout (fnd_request.add_layout) as mentioned here. Now my process completed with a warning and I did not get any output. Log says:
"Post-processing of request 2331741 failed at 25-FEB-2009 12:19:53 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details."
How can I solve this problem?

Thanks for all your effort.
-Raghu

...
written by Raghu26 , February 25, 2009

I guess I figured the reason why I was getting the above error message. I looked into the manager log and found that application was running the below query. When I ran the query in toad, it was returning 0 rows. Then I found that Template_Application_Name is case sensisitive, I gave the name as 'XYZApps' in my program but in the table (XDO_LOBS) it was 'XYZAPPS'. It's really very strange because we setup our application name as 'XYZApps' only. I don't know why it's expecting completely in capital letters. Anyway, I was able to resolve my problem. Thanks for this wonderful site.

SELECT L.FILE_DATA FILE_DATA,DBMS_LOB.GETLENGTH(L.FILE_DATA) FILE_LENGTH, L.LANGUAGE LANGUAGE, L.TERRITORY TERRITORY, B.DEFAULT_LANGUAGE
DEFAULT_LANGUAGE, B.DEFAULT_TERRITORY DEFAULT_TERRITORY,B.TEMPLATE_TYPE_CODE TEMPLATE_TYPE_CODE, B.USE_ALIAS_TABLE USE_ALIAS_TABLE, B.START_DATE START_DATE, B.END_DATE END_DATE, B.TEMPLATE_STATUS TEMPLATE_STATUS, B.USE_ALIAS_TABLE USE_ALIAS_TABLE, B.DS_APP_SHORT_NAME DS_APP_SHORT_NAME, B.DATA_SOURCE_CODE DATA_SOURCE_CODE, L.LOB_TYPE LOB_TYPE
FROM XDO_LOBS L, XDO_TEMPLATES_B B
WHERE L.APPLICATION_SHORT_NAME= :1
AND L.LOB_CODE = :2
AND L.APPLICATION_SHORT_NAME = B.APPLICATION_SHORT_NAME
AND L.LOB_CODE = B.TEMPLATE_CODE
AND (L.LOB_TYPE = 'TEMPLATE' OR L.LOB_TYPE = 'MLS_TEMPLATE')
AND ( (L.LANGUAGE = :3 AND L.TERRITORY = :4) OR (L.LANGUAGE = :5 AND L.TERRITORY = :6) OR (L.LANGUAGE= B.DEFAULT_LANGUAGE AND L.TERRITORY= B.DEFAULT_TERRITORY ))

Thanks,
Raghu

...
written by Me , March 27, 2009

Hi ,
Can anyone tell me how should i run the procedure in this sample because i dont understand it
:
PROCEDURE SubmitBursting(p_request_id IN INTEGER) AS
n_request_id NUMBER;
lay boolean ;
BEGIN

lay := fnd_request.add_layout('XDO',
'BURST_STATUS_REPORT',
'en',
'US',
'PDF');

n_request_id := fnd_request.submit_request('XDO'
,'XDOBURSTREP'
,NULL
,NULL
,FALSE
,p_request_id
,'Y'
);
END SubmitBursting;

thanks in advance
Best regards

Patch-- XML Publisher Adding Layout 11i Apps
written by Sauravbh Sharma , March 27, 2009

l_assign_layout := FND_REQUEST.ADD_LAYOUT('xxsmfg','XXSMFG_LABEL_PRN_GRP1','en',' US ','PDF');

This Code is not adding the Layout when i submit the Conc Prog .....Through PKG

Kindly let me know which Patch to be applied as mentioned above .... by Nader

Thanks

...
written by Shivakumar , April 27, 2009

Hi ,
Good work Prabhakar ,i was looking solution for this problem ... and you also showed how to trace the issue .

...
written by yram , May 04, 2009

Hi

Let me know where the procedure should be used..... or how to use this...


Regards
Yram

rajrajak
written by raj rajak , September 17, 2009

I have a oracle report attached with a .rtf in oracle apps 11i. when i run the report,it completes with a warning(post processing failed).bt when i download the XML file it looks fine.when i upload the xml file in data definition,the preview(excel) looks file.
Can anybody tell me what exectly is the problem

Layout Selection
written by --Saritha , October 07, 2009

All,

From the discussions I understood and experienced that there is no way to select a layout for XML Publisher using After Report Trigger automatically.
Only way is to write a pl/sql wrapper around the layout selection criteria and call the program using it.

Please confirm.

Thanks,
Saritha

Template missing when using Request Set
written by Anitha Rajakumar , November 02, 2009

Hi,

I'm facing an issue with the BI reports. It is required to include the BI Conc Prog. in a request set. The program completes with warning.
On analysis, I found out that the template is not being defaulted just as mentioned above.

Can you Plz let me know how to fix this issue?

Thanks,
Anitha

Need Urgent Help on XML publisher
written by ksat , March 04, 2010

Hi all,

In a request set, in that there are 2 concurrent Progrmas 2 Reports are defined.

1st report report report to get the PDF format layout XML Template is defined.
But it is not taking the Template.
If we run the same report as a single request then it is taking the Template and working fine,
But as a request it is not taking the XML template.
and
the secound one is the Standard report, in this the Layout is XML template is defined.it is working fine.

i am unable to get the Solution.

Unable to get excel output when submited the request
written by murali77 , February 22, 2011

Hi,

I have an issue. i want to generate excel output . for that i have created data template and layout template and concurrent program everything is fine. When i submit the concurrent program request, request completed successfully. but unable to get excel output. when i click on output tab screen just blinks but not getting excel output.

can any one help me on this.


Thanks
Murali

Request Set Optiond Not Shown template name, template language,format...
written by Syed Muhammad Ali , March 09, 2011

In a request set, in that there are 2 Reports are defined.

1st report to get the EXCEL format layout XML Template is defined.
But it is not taking the Template.
If we run the same report as a single request then it is taking the Template and working fine,
But as a request it is not taking the XML template.
and
the secound one is the same isuue


you suggest the solution

Solution :

Set the Template details for the concurrent program using the function Fnd_Request.add_layout() before calling the fnd_request.submit_request.;

function add_layout (template_appl_name in varchar2,
template_code in varchar2,
template_language in varchar2,
template_territory in varchar2,
output_format in varchar2) return boolean is
Example Code :
PROCEDURE SubmitBursting(p_request_id IN INTEGER) AS
n_request_id NUMBER;
lay boolean ;
BEGIN

lay := fnd_request.add_layout('XDO',
'BURST_STATUS_REPORT',
'en',
'US',
'PDF');

n_request_id := fnd_request.submit_request('XDO'
,'XDOBURSTREP'
,NULL
,NULL
,FALSE
,p_request_id
,'Y'
);
END SubmitBursting;


plz le me know how can i create and apply function in application

PLz provide me solutuion itz urgent

Thnx in advance

ALI

bursting program error (file not found error)
written by marsi45 , November 01, 2011

I am getting the below error while running the bursting program (xdoburstrep) for a request. Please help me out. I have uploaded the template in the given path. still it is showing the same error.

bursting program log file
---------------------------------------
Preparing parameters
null output =/OEBDEV2P/inst/apps/OEBDEV2P_nuhi201/logs/appl/conc/out/o56144543.out
inputfilename =/OEBDEV2P/inst/apps/OEBDEV2P_nuhi201/logs/appl/conc/out/o56144542.out
Data XML File:/OEBDEV2P/inst/apps/OEBDEV2P_nuhi201/logs/appl/conc/out/o56144542.out
Set Bursting parameters..
Temp. Directory:/OEBDEV2P/apps/apps_st/comn/temp
[110111_032417546][][STATEMENT] Oracle XML Parser version ::: Oracle XML Developers Kit 10.1.3.0.0 - Production
[110111_032417556][][STATEMENT] setOAProperties called..
Bursting propertes.....
{user-variable:cp:territory=US, user-variable:cp:ReportRequestID=56144542, user-variable:cp:language=en, user-variable:cp:responsibility=24195, user-variable.OA_MEDIA=http://nuhi201.originenergy.com.au:8021/OA_MEDIA, burstng-source=EBS, user-variable:cpebugFlag=Y, user-variable:cp:parent_request_id=56144542, user-variable:cp:locale=en-US, user-variable:cp:user=SYSADMIN, user-variable:cp:application_short_name=XDO, user-variable:cp:request_id=56144543, user-variable:cprg_id=954, user-variable:cp:reportdescription=Solar GL user notification, user-variable:cpummy for Data Security=Y}
Start bursting process..
Bursting process complete..
Generating Bursting Status Report..
#NAME?
/OEBDEV2P/apps/apps_st/comn/temp/110111_032417597/ENE_GL_NOTIF_2.pdf (No such file or directory (errno:2))
java.io.FileNotFoundException: /OEBDEV2P/apps/apps_st/comn/temp/110111_032417597/ENE_GL_NOTIF_2.pdf (No such file or directory (errno:2))
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(FileInputStream.java:106)
at java.io.FileInputStream.(FileInputStream.java:66)
at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.zipOutputFiles(JCP4XDOBurstingEngine.java:523)
at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:292)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

(No such file or directory (errno:2))
written by Apps11i , January 10, 2012

Hey Maris,

Were you able to resolve the issue. I am running into the same issue ? if so, can you please share the solution?

thanks,