
In this article i will explains the mandatory steps to be completed before submitting a concurrent program to generate XML Publisher / BI Publisher report using fnd_request.submit_request.
Error Message Received :
Issue Root Cause :
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;
Comments
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
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)
Thank s alot
yours, Nader
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.
Tha nks
Ram
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/S etting in the MS Word so that I could see the header & footer in the PDF?
Thanks in advance
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.Con currentRequest 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
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??
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.ad d_layout) as mentioned here. Now my process completed with a warning and I did not get any output. Log says:
"Post-pro cessing 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
SELECT L.FILE_DATA FILE_DATA,DBMS_ LOB.GETLENGTH(L .FILE_DATA) FILE_LENGTH, L.LANGUAGE LANGUAGE, L.TERRITORY TERRITORY, B.DEFAULT_LANGU AGE
DEFAULT_LANGUAG E, B.DEFAULT_TERRI TORY DEFAULT_TERRITO RY,B.TEMPLATE_T YPE_CODE TEMPLATE_TYPE_C ODE, B.USE_ALIAS_TAB LE USE_ALIAS_TABLE , B.START_DATE START_DATE, B.END_DATE END_DATE, B.TEMPLATE_STAT US TEMPLATE_STATUS , B.USE_ALIAS_TAB LE USE_ALIAS_TABLE , B.DS_APP_SHORT_ NAME DS_APP_SHORT_NA ME, B.DATA_SOURCE_C ODE DATA_SOURCE_COD E, L.LOB_TYPE LOB_TYPE
FROM XDO_LOBS L, XDO_TEMPLATES_B B
WHERE L.APPLICATION_S HORT_NAME= :1
AND L.LOB_CODE = :2
AND L.APPLICATION_S HORT_NAME = B.APPLICATION_S HORT_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_LANGU AGE AND L.TERRITORY= B.DEFAULT_TERRI TORY ))
Thanks,
Rag hu
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_R EPORT',
'en',
' US',
'PDF');
n _request_id := fnd_request.sub mit_request('XD O'
,'XDOBURSTRE P'
,NULL
,NULL
,FALSE
,p_reque st_id
,'Y'
);
E ND SubmitBursting;
thanks in advance
Best regards
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
Good work Prabhakar ,i was looking solution for this problem ... and you also showed how to trace the issue .
Let me know where the procedure should be used..... or how to use this...
Regar ds
Yram
Can anybody tell me what exectly is the problem
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.
Thank s,
Saritha
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
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
t he 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.
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
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
Solut ion :
Set the Template details for the concurrent program using the function Fnd_Request.add _layout() before calling the fnd_request.sub mit_request.;
function add_layout (template_appl_ name in varchar2,
template_code in varchar2,
template_langua ge in varchar2,
template_territ ory 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_R EPORT',
'en',
' US',
'PDF');
n _request_id := fnd_request.sub mit_request('XD O'
,'XDOBURSTRE P'
,NULL
,NULL
,FALSE
,p_reque st_id
,'Y'
);
E ND SubmitBursting;
plz le me know how can i create and apply function in application
PL z provide me solutuion itz urgent
Thnx in advance
ALI
burstin g program log file
---------- --------------- --------------
Preparing parameters
null output =/OEBDEV2P/inst /apps/OEBDEV2P_ nuhi201/logs/ap pl/conc/out/o56 144543.out
inpu tfilename =/OEBDEV2P/inst /apps/OEBDEV2P_ nuhi201/logs/ap pl/conc/out/o56 144542.out
Data XML File:/OEBDEV2P/ inst/apps/OEBDE V2P_nuhi201/log s/appl/conc/out /o56144542.out
Set Bursting parameters..
Te mp. Directory:/OEBD EV2P/apps/apps_ st/comn/temp
[1 10111_032417546 ][][STATEMENT] Oracle XML Parser version ::: Oracle XML Developers Kit 10.1.3.0.0 - Production
[110 111_032417556][ ][STATEMENT] setOAProperties called..
Bursting propertes.....
{user-variable: cp:territory=US , user-variable:c p:ReportRequest ID=56144542, user-variable:c p:language=en, user-variable:c p:responsibilit y=24195, user-variable.O A_MEDIA=http:// nuhi201.origine nergy.com.au:80 21/OA_MEDIA, burstng-source= EBS, user-variable:c p:DebugFlag=Y, user-variable:c p:parent_reques t_id=56144542, user-variable:c p:locale=en-US, user-variable:c p:user=SYSADMIN , user-variable:c p:application_s hort_name=XDO, user-variable:c p:request_id=56 144543, user-variable:c p:org_id=954, user-variable:c p:reportdescrip tion=Solar GL user notification, user-variable:c p:Dummy for Data Security=Y}
Sta rt bursting process..
Burst ing process complete..
Gene rating Bursting Status Report..
#NAME?
/OEBDEV2P/apps /apps_st/comn/t emp/110111_0324 17597/ENE_GL_NO TIF_2.pdf (No such file or directory (errno:2))
java .io.FileNotFoun dException: /OEBDEV2P/apps/ apps_st/comn/te mp/110111_03241 7597/ENE_GL_NOT IF_2.pdf (No such file or directory (errno:2))
at java.io.FileInp utStream.open(N ative Method)
at java.io.FileInp utStream.(FileI nputStream.java :106)
at java.io.FileInp utStream.(FileI nputStream.java :66)
at oracle.apps.xdo .oa.cp.JCP4XDOB urstingEngine.z ipOutputFiles(J CP4XDOBurstingE ngine.java:523)
at oracle.apps.xdo .oa.cp.JCP4XDOB urstingEngine.r unProgram(JCP4X DOBurstingEngin e.java:292)
at oracle.apps.fnd .cp.request.Run .main(Run.java: 157)
Were you able to resolve the issue. I am running into the same issue ? if so, can you please share the solution?
than ks,
Thank s,
Shehzad.
Thanks for sharing the solution.
But after giving the layout parameters also, I am having the same issue. we are on apps 11.5.10 and for I have downloaded BI Publisher Desktop 10.1.3.4.2, Is that the problem.
Can you please let me know what would be the version which is compatible with 11.5.10. Please help me with this as I am new to XML Publisher.
And also I want to add images in the output file so do we need to follow a different method for that to develop the rtf file.
Thanks in Advance.
Thank s,
Anusha
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.
•Nee d help to get the output for each column and also to speed up the time to get the report output.
RSS feed for comments to this post