tag:blogger.com,1999:blog-3012634532552193483.post1235144915298089363..comments2024-02-24T08:49:51.254+05:30Comments on All About Oracle Applications.....: SQL Query to Find Scheduled Concurrent Programs in SystemSagar Kumbharhttp://www.blogger.com/profile/08401364295101089487noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-3012634532552193483.post-90890540039893036702021-04-28T12:14:34.926+05:302021-04-28T12:14:34.926+05:30great effort thank you great effort thank you Rafeeuddin Shaikhttps://www.blogger.com/profile/05829940807517240082noreply@blogger.comtag:blogger.com,1999:blog-3012634532552193483.post-61282267450006895842020-11-05T17:02:44.789+05:302020-11-05T17:02:44.789+05:30Thanks for queryThanks for queryAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3012634532552193483.post-76403629484315251272020-02-14T12:50:30.818+05:302020-02-14T12:50:30.818+05:30Yes.. indeed a great effect..!!Yes.. indeed a great effect..!!Yakubhttps://www.blogger.com/profile/02464530740815847729noreply@blogger.comtag:blogger.com,1999:blog-3012634532552193483.post-37050243879678641312018-10-05T16:09:09.851+05:302018-10-05T16:09:09.851+05:30Hi Sagar,
how can we find the actual jobs that ar...Hi Sagar,<br /><br />how can we find the actual jobs that are running behind the concurrent programs. Also is it possible to schedule a job for different ORG Units? If yes, is it possible to find which job is running for which ORG ID?Anonymoushttps://www.blogger.com/profile/16007357445907892129noreply@blogger.comtag:blogger.com,1999:blog-3012634532552193483.post-86982068081208264042018-05-20T13:02:40.377+05:302018-05-20T13:02:40.377+05:30Hi Sagar,
Thank you for your query. It is very hel...Hi Sagar,<br />Thank you for your query. It is very helpful.<br />One minor improvement: for environments that have multiple languages installed you need to add these 3 conditions to avoid duplicate rows:<br /> AND fcpt.LANGUAGE = 'US'<br /> and fpst.language = 'US'<br /> and frt.language = 'US'<br /><br />Regards,<br />IulianAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3012634532552193483.post-51586597683199926372018-03-05T21:40:17.285+05:302018-03-05T21:40:17.285+05:30Hi Sagar,
Your queries are very helpful. I just w...Hi Sagar,<br /><br />Your queries are very helpful. I just want to thank you for your efforts and most of all for sharing it others.<br /><br />Feroze ParkehAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3012634532552193483.post-82291413597282270702018-01-05T01:47:20.920+05:302018-01-05T01:47:20.920+05:30Can we download the scheduled concurrent requests ...Can we download the scheduled concurrent requests before refresh and upload after the refresh.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3012634532552193483.post-68220160394820591042017-05-24T15:31:37.309+05:302017-05-24T15:31:37.309+05:30P refers to Pending, that means the Concurrent is ...P refers to Pending, that means the Concurrent is scheduled, but has not been executed.Anonymoushttps://www.blogger.com/profile/09312046196085808556noreply@blogger.comtag:blogger.com,1999:blog-3012634532552193483.post-75378918354333774382017-04-19T16:05:41.558+05:302017-04-19T16:05:41.558+05:30The query has the following condition AND fcr.phas...The query has the following condition AND fcr.phase_code = 'P'<br /><br />Does this mean any concurrent request which does not have phase code 'P' is not scheduled concurrent programme?Leshan Amarasenahttps://www.blogger.com/profile/01978256125903829255noreply@blogger.comtag:blogger.com,1999:blog-3012634532552193483.post-43395771894432822232017-01-02T00:35:42.208+05:302017-01-02T00:35:42.208+05:30Hi,
Please check whether you have access to all ...Hi, <br /><br />Please check whether you have access to all the tables given the above query if not add "apps." before the table name for which you do not have access and try to re run the query.<br /> fnd_user fu<br /> , fnd_concurrent_programs fcp<br /> , fnd_concurrent_programs_tl fcpt<br /> , fnd_printer_styles_tl fpst<br /> , fnd_conc_release_classes fcrc<br /> , fnd_responsibility_tl frt<br /> , fnd_lookups flMadhavi Paletihttps://www.blogger.com/profile/14106849387919421362noreply@blogger.comtag:blogger.com,1999:blog-3012634532552193483.post-38137478189457107532016-11-15T00:24:26.433+05:302016-11-15T00:24:26.433+05:30Hi Sagar,
I ran the query, however it produced no ...Hi Sagar,<br />I ran the query, however it produced no records though we have some scheduled programs in our system. <br /><br />Could you please helpRahul Morehttps://www.blogger.com/profile/09439586538331166733noreply@blogger.comtag:blogger.com,1999:blog-3012634532552193483.post-44333538910165045822016-09-09T23:03:25.373+05:302016-09-09T23:03:25.373+05:30Thanks for the SQL!Thanks for the SQL!shashankhttps://www.blogger.com/profile/10117143199469636104noreply@blogger.comtag:blogger.com,1999:blog-3012634532552193483.post-32675373134415219142016-07-11T12:26:25.139+05:302016-07-11T12:26:25.139+05:30This comment has been removed by the author.kiranbaburamisettyhttps://www.blogger.com/profile/05863551447633898684noreply@blogger.com