{"id":1411,"date":"2021-09-09T09:55:38","date_gmt":"2021-09-09T07:55:38","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1411"},"modified":"2021-09-09T09:57:04","modified_gmt":"2021-09-09T07:57:04","slug":"jak-wywolac-bi-publisher-concrurrent-request-z-odpowiednim-template-layout","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1411","title":{"rendered":"Jak wywo\u0142a\u0107 BI Publisher concrurrent request z odpowiednim template \/ layout"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p>Przed wywo\u0142aniem concurrenta trzeba uruchomic:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>FND_SUBMIT.ADD_LAYOUT<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Modify your PL\/SQL procedure to add a line similar to xml_layout:<\/p>\n\n\n\n<p><strong>1. First you must declare the variable<\/strong><\/p>\n\n\n\n<p>xml_layout boolean;<\/p>\n\n\n\n<p><strong>2. Then you must call the ADD_LAYOUT API prior&nbsp;to submitting your Concurrent Program.&nbsp;<\/strong><\/p>\n\n\n\n<p>xml_layout := FND_REQUEST.ADD_LAYOUT(&#8217;FND&#8217;,&#8217;FNDSCURS&#8217;,&#8217;en&#8217;,&#8217;US&#8217;,&#8217;PDF&#8217;);<br \/>req_id := FND_REQUEST.SUBMIT_REQUEST(&#8217;FND&#8217;,&#8217;FNDSCURS&#8217;,&#8217;FNDSUBMIT &#8211; Active Users<br \/>XML&#8217;);<\/p>\n\n\n\n<p><em>Note: The easiest way to find out the parameters for the ADD_LAYOUT API is to run the concurrent program from standard submission then check the OPP Manager log for the parameters after a successful submission.&nbsp;<\/em><\/p>\n\n\n\n<p>i.e. From $APPLCSF\/$APPLLOG\/FNDOPP10367.txt<\/p>\n\n\n\n<p>[5\/10\/05 12:08:13 PM] [10367:RT239207] Starting XML Publisher post-processing action.<br \/>[5\/10\/05 12:08:13 PM] [10367:RT239207]<br \/>Template code: FNDSCURS<br \/>Template app:&nbsp; FND<br \/>Language:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; en<br \/>Territory:&nbsp;&nbsp;&nbsp;&nbsp; US<br \/>Output type:&nbsp;&nbsp; PDF<br \/>[5\/10\/05 12:08:14 PM] [10367:RT239207] XML Publisher post-processing action complete.<br \/>[5\/10\/05 12:08:14 PM] [10367:RT239207] Completed post-processing actions for request 239207.<\/p>\n\n\n\n<p>The syntax of the ADD_LAYOUT is as follows:<\/p>\n\n\n\n<p>&nbsp; &#8212; Name<br \/>&nbsp; &#8212;&nbsp;&nbsp; add_layout<br \/>&nbsp; &#8212; Purpose<br \/>&nbsp; &#8212;&nbsp;&nbsp; Called before submission to add layout options for request output.<br \/>&nbsp; &#8212;<br \/>&nbsp; &#8212; Arguments<br \/>&nbsp; &#8212;&nbsp;&nbsp;&nbsp; Template_APPL_Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211; Template Application Short name.<br \/>&nbsp; &#8212;&nbsp;&nbsp;&nbsp; Template_code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211; Template code<br \/>&nbsp; &#8212;&nbsp;&nbsp;&nbsp; Template_Language&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211; Template File language (iso value)<br \/>&nbsp; &#8212;&nbsp;&nbsp;&nbsp; Template_Territory&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211; Template File Territory (iso value)<br \/>&nbsp; &#8212;&nbsp;&nbsp;&nbsp; Output Format&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211; Output Format<br \/>&nbsp; &#8212;<br \/>&nbsp; function add_layout (template_appl_name in varchar2,<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; template_code&nbsp;&nbsp;&nbsp;&nbsp; in varchar2,<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; template_language in varchar2,<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; template_territory in varchar2,<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; output_format&nbsp;&nbsp;&nbsp;&nbsp; in varchar2) return boolean;<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>How To Submit A Concurrent Request Set Using FND_SUBMIT.SUBMIT_PROGRAM (&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=SrDetailText&amp;sourceId=3-26864723491&amp;id=382791.1\" target=\"_blank\">Doc ID 382791.1<\/a>&nbsp;)<br \/><\/p>\n\n\n\n<p>How to Use FND_REQUEST.ADD_LAYOUT When Submitting a Concurrent Request Via a PL\/SQL Procedure? (&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=SrDetailText&amp;sourceId=3-26864723491&amp;id=308658.1\" target=\"_blank\">Doc ID 308658.1<\/a>&nbsp;)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Przed wywo\u0142aniem concurrenta trzeba uruchomic: FND_SUBMIT.ADD_LAYOUT<\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[54],"tags":[151,267,92],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1411"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1411"}],"version-history":[{"count":3,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1411\/revisions"}],"predecessor-version":[{"id":1414,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1411\/revisions\/1414"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}