{"id":1199,"date":"2016-01-15T08:42:03","date_gmt":"2016-01-15T06:42:03","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1199"},"modified":"2016-01-15T08:44:25","modified_gmt":"2016-01-15T06:44:25","slug":"tabele-powiazane-z-zleceniami-wspolbieznymi-cm","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1199","title":{"rendered":"Tabele powi\u0105zane z zleceniami wsp\u00f3\u0142bie\u017cnymi (CM)"},"content":{"rendered":"<p>Concurrent Request Log:<\/p>\n<pre lang=\"PLSQL\">\r\nselect logfile_name from fnd_concurrent_requests where request_id = <request_id>;\r\n<\/request_id><\/pre>\n<p>Concurrent Output file:<\/p>\n<pre lang=\"PLSQL\">\r\nselect outfile_name from fnd_concurrent_requests where request_id = <request_id>;\r\n<\/request_id><\/pre>\n<p>Concurrent Manager Worker Log:<\/p>\n<pre lang=\"PLSQL\">\r\nselect logfile_name from fnd_concurrent_processes where concurrent_process_id=(select controlling_manager\r\nfrom fnd_concurrent_requests where request_id=<reqid>);\r\n<\/reqid><\/pre>\n<p>Which Manager ran the request?<\/p>\n<pre lang=\"PLSQL\">\r\nselect concurrent_queue_name, user_concurrent_queue_name from fnd_concurrent_queues_tl\r\nwhere concurrent_queue_id = (select concurrent_queue_id from fnd_concurrent_processes\r\nwhere concurrent_process_id=(select controlling_manager from fnd_concurrent_requests where request_id= <request id>));\r\n<\/request><\/pre>\n<p>XML publisher output  (example: pdf)<\/p>\n<pre lang=\"PLSQL\">\r\nselect * from  fnd_conc_req_outputs\r\n<\/pre>\n<p>OS output.<\/p>\n<pre lang=\"PLSQL\">\r\n$APPLCSF\/$APPLOUT\/{REPORTNAME}_{REQUEST_ID}_{COUNT}.PDF|RTF|EXCEL|HTML\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Concurrent Request Log: select logfile_name from fnd_concurrent_requests where request_id = ; Concurrent Output file: select outfile_name from fnd_concurrent_requests where request_id = ; Concurrent Manager Worker Log: select logfile_name from fnd_concurrent_processes where concurrent_process_id=(select controlling_manager from fnd_concurrent_requests where request_id=); Which Manager ran &hellip; <a href=\"https:\/\/oracle.malin.pl\/?p=1199\">Czytaj dalej <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[203],"tags":[],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1199"}],"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\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1199"}],"version-history":[{"count":3,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1199\/revisions"}],"predecessor-version":[{"id":1202,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1199\/revisions\/1202"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}