tag:blogger.com,1999:blog-31331079.post8484308245491290693..comments2024-03-16T18:58:49.294+13:00Comments on In Depth Apps - Oracle eBusiness Suite - Gareth Roberts: Fake It - masquerade one BIP concurrent program as another for testing purposesGareth Robertshttp://www.blogger.com/profile/06953577059981917424noreply@blogger.comBlogger19125tag:blogger.com,1999:blog-31331079.post-31166468544648803932013-01-18T00:51:43.103+13:002013-01-18T00:51:43.103+13:00Hi,
Previously I was facing this problam, but now ...Hi,<br />Previously I was facing this problam, but now it got fixed. My Program sucessfully generating the PDF output of statement report.<br /><br />Requirment: Need "Statement Generation Program" output in PDF.<br /><br />Solution: You have to do below staps.<br />------------------------------<br />1. make a PL/SQL Package:-<br /><br />create or replace package XXV8_XMLP_PKG AUTHID CURRENT_USER AS<br /> function submit_request_xmlp(p_code in varchar2, p_request_id in number)<br /> return number;<br />end XXV8_XMLP_PKG;<br /><br /><br />create or replace package body XXV8_XMLP_PKG AS<br /> function submit_request_xmlp(p_code in varchar2, p_request_id in number)<br /> return number is<br /> l_req_id number := 0;<br /> begin<br /> if p_code = 'ARXSGPO' then<br /> l_req_id := FND_REQUEST.SUBMIT_REQUEST('XDO',<br /> 'XDOREPPB',<br /> NULL,<br /> NULL,<br /> FALSE,<br /> 'N',<br /> p_request_id,<br /> 222, -- Receivables<br /> 'ARXSGPO', -- Statement Generate<br /> 'en-US', -- English<br /> 'N',<br /> 'RTF',<br /> 'PDF');<br /> end if;<br /> return l_req_id;<br /> end submit_request_xmlp;<br /><br />end XXV8_XMLP_PKG;<br />------------------------------<br />2. Add the below code in "ARXSGPO" report (after report trigger).<br /><br />declare<br /> v_req_id number := 0;<br /> begin<br /> v_req_id := xxv8_xmlp_pkg.submit_request_xmlp('ARXSGPO',:p_conc_request_id);<br /> if v_req_id > 0 then<br /> srw.message(20002, 'Submitted request_id ' || v_req_id);<br /> commit;<br /> else<br /> srw.message(20002, 'Failed to submit request');<br /> end if;<br /> end; <br />------------------------------<br />3. Create the TEMPLATE and Data Definition in BI Publisher.<br /><br />Code: ARXSGPO<br />Template: ARXSGP<br />Data Definition: ARXSGP<br />Upload 'UTF-8'en-us'CLE_F_ARCUSBALSL.rtf'<br />(If u dont have this .rtf then U can download it from 'http://vis1213.solutionbeacon.net' and upload the same on your system).<br />------------------------------<br />Run your Statement Generation program.<br /><br />Rgds,<br />Sanjeev KumarUnknownhttps://www.blogger.com/profile/16663639884926638831noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-34871646243514817632009-06-02T20:14:08.185+12:002009-06-02T20:14:08.185+12:00Hi Sangeeth,
Update the config xml file $CONTEXT_...Hi Sangeeth,<br /><br />Update the config xml file $CONTEXT_FILE and run autoconfig, then restart processes.<br /><br />Regards,<br />GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-89506544144830352342009-06-02T20:03:46.223+12:002009-06-02T20:03:46.223+12:00Hi Gareth,
Thanks for your reply. I am able to fin...Hi Gareth,<br />Thanks for your reply. I am able to find the X server as you mentioned in your reply. Is there anyways to point this to another server?<br />Kindly let me know the details.<br />Thanks...Unknownhttps://www.blogger.com/profile/09091163572408995641noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-15195621942006303552009-06-02T09:22:49.325+12:002009-06-02T09:22:49.325+12:00Hi Sangeeth,
No graphs is due to no X Server. Mak...Hi Sangeeth,<br /><br />No graphs is due to no X Server. Make sure you have an X Server running on your EBS Concurrent Processing Server. You can see what the concurrent manager thinks the X Server is by running concurrent request "Prints environment variables" from System Administrator responsibility and specify variable "DISPLAY".<br /><br />Regards,<br />GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-19061284468353471892009-06-01T23:24:30.307+12:002009-06-01T23:24:30.307+12:00Hi, I am a beginner in XML publisher. I tried crea...Hi, I am a beginner in XML publisher. I tried creating MS Word template with charts (pie chart and bar Chart). In preview, the charts are displayed perfectly but when I try to register as a concurrent program, all the elements (tables, chart specification etc.,) are displayed EXCEPTthe charts which are NOT displayed in the output. Tried many options, but in vain.Unknownhttps://www.blogger.com/profile/09091163572408995641noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-75951882974595576752008-07-08T16:13:00.000+12:002008-07-08T16:13:00.000+12:00Hi Manu,Haven't worked through a solution, but if ...Hi Manu,<BR/>Haven't worked through a solution, but if you need it to be automated perhaps a request set might help with a Reprint job after the first?<BR/>Otherwise you might want to try a Forms Personalization?<BR/>GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-15506634758216550782008-07-08T04:20:00.000+12:002008-07-08T04:20:00.000+12:00Hi Gareth,I found your posts very valuable, I have...Hi Gareth,<BR/>I found your posts very valuable, I have one question.<BR/>How can I print output of a conc prog to TWO diffrent printers automatically. <BR/><BR/>Print options would have only one printer defaulting automaticaly, second printer needs to be added manually. <BR/><BR/>Thanks<BR/>ManuUnknownhttps://www.blogger.com/profile/10830780984078308252noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-91962115407035894112008-02-01T20:36:00.000+13:002008-02-01T20:36:00.000+13:00Hi Gareth,I have requirement to develop xml report...Hi Gareth,<BR/><BR/>I have requirement to develop xml reports using pdf template.<BR/><BR/>what are the pre-request to start the development in pdf template?.<BR/>And also if u have any best posted formus for developing template in pdf please give your advice<BR/><BR/>with regards<BR/>prabuPraburamhttps://www.blogger.com/profile/06666146909049216537noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-48605485072685937432008-01-24T23:23:00.000+13:002008-01-24T23:23:00.000+13:00Hi Prabu,Take a look at this post for a solution t...Hi Prabu,<BR/><BR/>Take a look at this post for a solution to your Statements XML Publisher output problem.<BR/><A HREF="http://garethroberts.blogspot.com/2008/01/beautiful-statements-in-1-easy-step.html" REL="nofollow">Easy 1 Step Statements</A><BR/><BR/>GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-29811154179134499072008-01-18T22:47:00.000+13:002008-01-18T22:47:00.000+13:00Hi Garneth,Yes i have included all the parameters ...Hi Garneth,<BR/><BR/>Yes i have included all the parameters for the Fnd_request.submit_request and the coding is not showing any error now in the after report trigger- ARXSGPO(Print Statement ).But after the Statement Generator Program completed,the calling child program XML Report Publisher is not running automatically in the request,so i am not able to view the output.<BR/><BR/>Here the coding which i have included in the after report trigger<BR/>function AfterReport return boolean is<BR/>v_set_layout_option boolean; <BR/>v_conc_request_id number;<BR/>v_printer_name varchar2(100);<BR/>v_printer boolean;<BR/>begin<BR/>v_set_layout_option := fnd_request.add_layout('AR','Print Statement Temp','en','US','PDF');<BR/>begin<BR/>select printer_name <BR/>into v_printer_name<BR/>from fnd_concurrent_programs<BR/>where CONCURRENT_PROGRAM_NAME = 'ARXSGPO';<BR/><BR/>exception<BR/>when others then<BR/>null;<BR/>end; <BR/>if v_printer_name is not null then<BR/>v_printer := fnd_request.set_print_options(v_printer_name,<BR/>null,<BR/>1, -- no of copies<BR/>TRUE,<BR/>'N');<BR/>end if;<BR/><BR/>-- CALLING THE CHILD REPORT USING FND_REQUEST<BR/>v_conc_request_id := FND_REQUEST.SUBMIT_REQUEST(application => 'XDO' -- Application Short name <BR/>, program => 'XDOREPPB'--Concurrent Program Application Short Name<BR/>,description => null, <BR/>start_time => TO_CHAR(SYSDATE, 'DD-MON-YY HH:MI:SS'), <BR/>sub_request => FALSE<BR/>,argument1 => NULL,<BR/>argument2 => NULL,<BR/>argument3 => NULL,<BR/>argument4 => NULL,<BR/>argument5 => NULL,<BR/>argument6 => NULL,<BR/>argument7 => NULL,<BR/>argument8 => NULL,<BR/>argument9 => NULL,<BR/>argument10 => NULL,<BR/>argument11 => NULL,<BR/>argument12 => NULL,<BR/>argument13 => NULL,<BR/>argument14 => NULL,<BR/>argument15 => NULL,<BR/>argument16 => NULL,<BR/>argument17 => NULL,<BR/>argument18 => NULL,<BR/>argument19 => NULL,<BR/>argument20 => NULL,<BR/>argument21 => NULL,<BR/>argument22 => NULL,<BR/>argument23 => NULL,<BR/>argument24 => NULL,<BR/>argument25 => NULL,<BR/>argument26 => NULL,<BR/>argument27 => NULL,<BR/>argument28 => NULL,<BR/>argument29 => NULL,<BR/>argument30 => NULL,<BR/>argument31 => NULL,<BR/>argument32 => NULL,<BR/>argument33 => NULL,<BR/>argument34 => NULL,<BR/>argument35 => NULL,<BR/>argument36 => NULL,<BR/>argument37 => NULL,<BR/>argument38 => NULL,<BR/>argument39 => NULL,<BR/>argument40 => NULL,<BR/>argument41 => NULL,<BR/>argument42 => NULL,<BR/>argument43 => NULL,<BR/>argument44 => NULL,<BR/>argument45 => NULL,<BR/>argument46 => NULL,<BR/>argument47 => NULL,<BR/>argument48 => NULL,<BR/>argument49 => NULL,<BR/>argument50 => NULL,<BR/>argument51 => NULL,<BR/>argument52 => NULL,<BR/>argument53 => NULL,<BR/>argument54 => NULL,<BR/>argument55 => NULL,<BR/>argument56 => NULL,<BR/>argument57 => NULL,<BR/>argument58 => NULL,<BR/>argument59 => NULL,<BR/>argument60 => NULL,<BR/>argument61 => NULL,<BR/>argument62 => NULL,<BR/>argument63 => NULL,<BR/>argument64 => NULL,<BR/>argument65 => NULL,<BR/>argument66 => NULL,<BR/>argument67 => NULL,<BR/>argument68 => NULL,<BR/>argument69 => NULL,<BR/>argument70 => NULL,<BR/>argument71 => NULL,<BR/>argument72 => NULL,<BR/>argument73 => NULL,<BR/>argument74 => NULL,<BR/>argument75 => NULL,<BR/>argument76 => NULL,<BR/>argument77 => NULL,<BR/>argument78 => NULL,<BR/>argument79 => NULL,<BR/>argument80 => NULL,<BR/>argument81 => NULL,<BR/>argument82 => NULL,<BR/>argument83 => NULL,<BR/>argument84 => NULL,<BR/>argument85 => NULL,<BR/>argument86 => NULL,<BR/>argument87 => NULL,<BR/>argument88 => NULL,<BR/>argument89 => NULL,<BR/>argument90 => NULL,<BR/>argument91 => NULL,<BR/>argument92 => NULL,<BR/>argument93 => NULL,<BR/>argument94 => NULL,<BR/>argument95 => NULL,<BR/>argument96 => NULL,<BR/>argument97 => NULL,<BR/>argument98 => NULL,<BR/>argument99 => NULL,<BR/>argument100 => NULL);<BR/>commit;<BR/>SRW.USER_EXIT('FND SRWEXIT'); <BR/>return (TRUE);<BR/>end; <BR/><BR/>please advice me where exactly i am doing wrong.<BR/><BR/>regards<BR/>prabuPraburamhttps://www.blogger.com/profile/06666146909049216537noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-31380644343112679172008-01-12T15:11:00.000+13:002008-01-12T15:11:00.000+13:00Hi Prabu,Oracle Reports PL/SQL isn't 100% like ser...Hi Prabu,<BR/><BR/>Oracle Reports PL/SQL isn't 100% like serverside PL/SQL. Make sure you put all 100 parameters to fnd_request.submit_request (null for all the parameters you are not using).<BR/>See:<BR/><A HREF="http://forums.oracle.com/forums/thread.jspa?threadID=377564" REL="nofollow">this forum post</A><BR/>GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-20318074755993872712008-01-09T02:27:00.000+13:002008-01-09T02:27:00.000+13:00Hi Gareth,I have got this error when i run the sam...Hi Gareth,<BR/><BR/>I have got this error when i run the same fnd_submit.request code in the ARXSGPO(Print Statement ) -after report trigger.<BR/>error 707 <BR/>unsupported construct or internal error[2601]<BR/><BR/>Following code in the after report trigger<BR/><BR/>function AfterReport return boolean is<BR/>v_set_layout_option boolean; <BR/>v_conc_request_id number;<BR/>v_printer_name varchar2(100);<BR/>v_printer boolean;<BR/>begin<BR/>v_set_layout_option := fnd_request.add_layout('RECEIVABLES','ARXSGPO','en','US','PDF');<BR/>begin<BR/>select printer_name <BR/>into v_printer_name<BR/>from fnd_concurrent_programs<BR/>where CONCURRENT_PROGRAM_NAME = 'ARXSGPO';<BR/>exception<BR/>when others then<BR/>null;<BR/>end; <BR/><BR/>if v_printer_name is not null then<BR/>v_printer := fnd_request.set_print_options(v_printer_name,<BR/>null,<BR/>1, -- no of copies<BR/>TRUE,<BR/>'N');<BR/>end if;<BR/>-- CALLING THE CHILD REPORT USING FND_REQUEST<BR/>v_conc_request_id := FND_REQUEST.SUBMIT_REQUEST( application => 'Receivables', <BR/>program => 'ARXSGPO', <BR/>description => null, <BR/>start_time => TO_CHAR(SYSDATE, 'DD-MON-YY HH:MI:SS'), <BR/>sub_request => FALSE<BR/>);<BR/>commit;<BR/>SRW.USER_EXIT('FND SRWEXIT'); <BR/>return (TRUE);<BR/>end; <BR/><BR/><BR/>welcoming your advice<BR/>PrabuPraburamhttps://www.blogger.com/profile/06666146909049216537noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-91881672882582015802008-01-08T10:09:00.000+13:002008-01-08T10:09:00.000+13:00Hi again Prabu,Automated solution for applying lay...Hi again Prabu,<BR/>Automated solution for applying layout or calling XML Report Publisher for Statements (and Dunning Letters) can be achieved by customization see:<BR/><A HREF="http://forums.oracle.com/forums/thread.jspa?threadID=441570" REL="nofollow">this forum</A><BR/><BR/>Regards,<BR/>GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-7446464602768912442008-01-08T10:01:00.000+13:002008-01-08T10:01:00.000+13:00Hi Prabu,Run the "XML Report Publisher" concurrent...Hi Prabu,<BR/><BR/>Run the "XML Report Publisher" concurrent request and specify the Report Request (Request ID) of the Print Statements program (the XML output you mention).<BR/><BR/>For reference:<BR/>http://forums.oracle.com/forums/thread.jspa?threadID=597509&tstart=-1<BR/><BR/>Regards,<BR/>GarethGarethhttps://www.blogger.com/profile/00473876747556400447noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-59927542317229649002008-01-08T03:16:00.000+13:002008-01-08T03:16:00.000+13:00Hi Gareth,I have issue in the AR Print Statement R...Hi Gareth,<BR/>I have issue in the AR Print Statement Report <BR/>(N)Receivables.HyC_USA_AR.Print: Statement<BR/>This Statement has contains two set of Programs as like parent and child which runs once the statement printed.<BR/>Parent Conc. Request : Print Statement(ARXSGPO) - Executable Output Type : RDF <BR/>Child Conc. Request : "Statement Generator Program(ARXSGP)" - Executable Output Type <BR/>:Spawned<BR/><BR/>I have set the output type as XML and given the exact short name of Parent Program in the <BR/>XML Publisher Data Defination Code and also template(RTF) attached in the XML Publisher Template, I have tried this same for the child conc. program too. But it shows the output only in XML Format. I can say that Mapping the short name with the XML Publisher is not working for this Print Statement Report. <BR/><BR/>welcoming your advice!...<BR/><BR/>Regards<BR/>PrabuPraburamhttps://www.blogger.com/profile/06666146909049216537noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-68135939778732677082007-09-21T13:59:00.000+12:002007-09-21T13:59:00.000+12:00Hi,Good question - can't see the solution to delet...Hi,<BR/>Good question - can't see the solution to delete template or data definition (or change Code). Any got any ideas?<BR/>GarethGareth Robertshttps://www.blogger.com/profile/06953577059981917424noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-47743706404039086332007-09-20T07:32:00.000+12:002007-09-20T07:32:00.000+12:00You said:>Setup a AR Statement Data > Definition a...You said:<BR/>>Setup a AR Statement Data <BR/>> Definition and Template.<BR/><BR/>After setting this up. Is any method to Delete the template with Data defintion?<BR/><BR/>Thank you.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31331079.post-87005501036629033052007-08-08T10:59:00.000+12:002007-08-08T10:59:00.000+12:00Hi Subraya,The graphs present in my friends BIP Te...Hi Subraya,<BR/>The graphs present in my friends BIP Template weren't being displayed in the RTF / PDF output on his system, but were working fine for me. So template builder was fine, but runtime under eBusiness Suite wasn't. It turned out that the X Server (vncserver, Xvfb or similar) on his server wasn't running and so the graphs weren't being generated or rendered.Gareth Robertshttps://www.blogger.com/profile/06953577059981917424noreply@blogger.comtag:blogger.com,1999:blog-31331079.post-51908588630869345122007-08-08T05:59:00.000+12:002007-08-08T05:59:00.000+12:00Gareth Nice blog. I have been a frequent reader. ...Gareth<BR/> Nice blog. I have been a frequent reader. <BR/><BR/>Just curious as to why you would'nt just use Template Builder tool to test the template and xml instead of this "slipping in your friends template" since the test was to see if the template and xml are working in unison well.<BR/><BR/>Subraya Mallya<BR/>http://blog.foyopa.comSubraya Mallyahttps://www.blogger.com/profile/18307472550767181650noreply@blogger.com