Friday, January 18, 2008

List all concurrent requests in Oracle

Use the following query to list all the concurrent requests in Oracle which are in errored or error status.

Modify the query to get the reports that you want

select a.request_id,a.request_date,b.user_concurrent_program_name, a.requested_by,a.responsibility_application_id, a.responsibility_id,
a.completion_text, a.logfile_name from FND_CONCURRENT_REQUESTS a, FND_CONCURRENT_PROGRAMS_TL b where a.concurrent_program_id=b.concurrent_program_id
and  a.status_code='E' and a.request_date > to_date('13-jan-2008','DD-MON-YYYY') order by a.request_date desc

60 comments:

John S. said...

Good piece of information. Will pass on to some clients who use Oracle CRM.

Daniel Joseph said...


SAP Training Visit Us,
Success factor training in chennai | sap training in chennai | sap training in chennai | Workday training in chennai

Jhon said...

Thanks for sharing this Information blog. Recently I have completed Oracle Training Courses in Bangalore at a leading Company. It's really useful for me to make a bright Future career. Visit Us, Oracle Training in Bangalore

Aamala Ahona said...

All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates.


Peridot Systems Chennai Contact Number

Camellia Canan said...

Wow! I Agree.. It was the best article , actually you have posted something new compared to others, because I read many articles related to this topic but I only get impressed with your post only, keep posting. Thanks..


SAP training in Chennai

Priya Tamil said...

Another great blog . Great tips, and awesome way to get exert tips from everyone,Thank goodness someone is promoting quality content.everything is very well about your blog information.
informatica

Nainika Joseph said...

I read this content really awesome.You provided another one great article.I hope this information may change my business carrier.I can remember these things whenever taking the decision.


SAP FICO training in Chennai

Ridhima said...

Thanks for the good words! Really appreciated. Great post. I’ve been commenting a lot on a few blogs recently, but I hadn’t thought about my approach until you brought it up.

SEO training in Adyar

Ridhima said...


All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates.


Java training in Adyar

Ridhima said...

That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.


PHP training in Adyar

Ridhima said...


I read your articles very excellent and the i agree our all points because all is very good information provided this through in the post. It is very helpful for me. Keep blogging like this. Thanks.

Hadoop training in adyar

Camellia Canan said...


First is to thank you for all this informative posts you give us for free; i bet all of us are happy.
Such a great idea of yours! You have been a big help for me. Thanks a lot. more post for interesting topic. Great!

SAP training in Chennai

Maani kamili said...

I’m sincerely suggesting your blog to all my friends… I’ve changed myself in many thing after reading your blog… Thanks and keep going.

Digital marketing company in Chennai

Suseela Susiee said...




Great and useful article. Creating content regularly is very tough. Your points are motivated me to move on.


SEO Company in Chennai

informatica online training in hyderabad said...

Thanku for sharing this posts..
Informatica training, in the recent times has acquired a wide scope of popularity amongst the youngsters at the forefront of their career.
Informatica online training in hyderabad

Aashi siva said...

Someone essentially lend a hand to make severely posts I would state. That is the very first time I frequented your website page and thus far? I surprised with the analysis you made to create this particular submit incredible. Fantastic job!

Online Training in Chennai

Giri Mani 2 said...

Great... Excellent sharing.. This is very helpful for beginers. Read that provide me more enthusiastic. This helps me get a more knowledge about this topic. Thanks for this.
Email Marketing Chennai Adyar

Sathya G said...

i for more technical information from your blog and i worked it superb outcome i got keep update more information with us. wish you to go more levels.
Digital Marketing Services in Chennai

Aasha said...

I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.


SEO Company in Chennai | SEO Services in Chennai

Giri Mani 2 said...

This blog explains the details of most popular technological details. This helps to learn about what are all the different method is there. And the working methods all of that are explained here. Informative blog.
Email Marketing Chennai

Shalini said...

I keep on reading your blog post.. This was still amazing. Thanks a lot for sharing this unique informative post with us.. I really enjoyed by reading your blog post

SMO Services Chennai

Abiya Carol said...

Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.

Branding Services in Chennai

Abiya Carol said...

Great site for these post and i am seeing the most of contents have useful for my Carrier.Thanks to such a useful information.Any information are commands like to share him.

Branding Services in Chennai

Rekhila said...

This content creates a new hope and inspiration with in me. Thanks for sharing article like this. The way you have stated everything above is quite awesome. Keep blogging like this. Thanks.
ROI Services in Chennai

Jeffy said...


I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.

App Store optimization Services Chennai

jaya Pk said...

There are lots of information about latest technology and how to get trained in them, like this have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies. By the way you are running a great blog. Thanks for sharing this.
Hadoop training in chennai

hadoop training in hyderabad said...

Concurrent list in oracle nice posts..
Hadoop training in hyderabad.All the basic and get the full knowledge of hadoop.
hadoop training in hyderabad

Maha Ravi said...

nice blog too informative. looking and reading your points its so impressive. doing more blog like this. i really appreciated doing like this.

Sharepoint Training in Chennai

Akshayhaasini said...



wow great,nowadays this type of blog id more important and informative technology,it was more impressive to read ,which helps to design more in effective ways

Java training in chennai

Geetha said...

Great information shared in this blog. Helps in gaining concepts about new information and concepts.Awsome information provided.Very useful for the beginners.
SEO training in Chennai

Saki R said...

this is really too useful and have more ideas from yours. keep sharing many techniques. eagerly waiting for your new blog and useful information. keep doing more.
Java Training in Chennai

Maha Ravi said...

this is really too useful and have more ideas from yours. keep sharing many techniques. eagerly waiting for your new blog and useful information. keep doing more.
Sharepoint Training in Chennai

Priya Sethuraman said...

Truely a very good article on how to handle the future technology. After reading your post,thanks for taking the time to discuss this, I feel happy about and I love learning more about this topic. keep sharing your information regularly for my future reference. This content creates a new hope and inspiration with in me. Thanks for sharing article like this. The way you have stated everything above is quite awesome. Keep blogging like this. Thanks.
Hadoop Training in Chennai
Hadoop Training
Best Hadoop Training in Chennai
Best Hadoop Training Institute in Chennai

Geetha said...

very useful information provided in this blog. concepts were explained in a detailed manner. Keep giving these types of information.
SEO training in Chennai

Anonymous said...

Hi,

Your Business Can Succeed With Email Marketing

The truth is that when it comes to marketing, most studies have shown that email marketing does better than other marketing methods
It is best to think of email marketing just as any other marketing method like Oracle CRM Email Lists and Database

Shalini said...


Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
Digital Marketing Company in India

vinayangadi said...

Nice article
Thanks for sharing the informative blog.

Best training institute in bangalore

vinay kumar said...

Great post.
It really helped me to learn something new. So thanks.

Best Linux training institute in Bangalore

Akshay kumar said...

Awesome resources!
Thanks for sharing such good article. This is really helpful.

praveen said...

Nice Post
It really helpful to every IT student. keep it up this good work

suraj said...

I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.

Best Angular js training institute in bangalore

Jeffy said...

Thank you for sharing such a nice and interesting blog with us. Hope it might be much useful for us. keep on updating...!!
seo company in india
digital marketing company in india

Arun kumar said...

A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article. I am learning a lot from you.

microsoft training institute in Bangalore

Jeffy said...

Thank you for sharing such a nice and interesting blog with us. Hope it might be much useful for us. keep on updating...!!
seo company in india
digital marketing company in india

Jeffy said...

Thank you for sharing such a nice and interesting blog with us. Hope it might be much useful for us. keep on updating...!!
seo company in india
digital marketing company in india
seo company in chennai
digital marketing company in chennai

Shalini said...

Thank you for sharing such a nice and interesting blog with us. Hope it might be much useful for us. keep on updating...!!
seo company in india
digital marketing company in india
seo company in chennai
digital marketing company in chennai

Anu said...

Being new to the blogging world I feel like there is still so much to learn. Your tips helped to clarify a few things for me as well as giving..
iOS Training in Chennai
Android Training in Chennai
php Training in Chennai

dhivya priya said...

This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
Isoft Innovations Facebook

Jessica George said...

These provided information was really so nice,thanks for giving that post and the more skills to develop after refer that post. Your articles really impressed for me,because of all information so nice.


SEO Company in India|Digital Marketing Company in Chennai



Jagna Co Kalani said...

I have read your blog its very attractive and impressive. I like it your blog.

Digital Marketing Company in Chennai Digital Marketing Agency

Shalini said...


Really Good blog post about concurrent lists in oracle.provided a helpful information.I hope that you will post more updates like this.
Digital marketing company in Chennai

Abitha Chetna said...

The blog gave me idea about components of Python.They explained in effective manner.Thanks for sharing it. Keep sharing more blogs.

Python Training in Chennai

rohit pal said...

Webtrackker is one only IT company who will provide you best class training with real time working on marketing from last 4 to 8 Years Experience Employee. We make you like a strong technically sound employee with our best class training.


WEBTRACKKER TECHNOLOGY (P) LTD.
C - 67, sector- 63, Noida, India.
F -1 Sector 3 (Near Sector 16 metro station) Noida, India.
+91 - 8802820025
0120-433-0760



Best SAS Training Institute in delhi

SAS Training in Delhi

SAS Training center in Delhi

Best Sap Training Institute in delhi

Best Sap Training center in delhi


Sap Training in delhi

Best Software Testing Training Institute in delhi

Software Testing Training in delhi

Software Testing Training center in delhi


Best Salesforce Training Institute in delhi


Salesforce Training in delhi

Salesforce Training center in delhi

Best Python Training Institute in delhi

Python Training in delhi

Best Python Training center in delhi

Best Android Training Institute In delhi

Android Training In delhi

best Android Training center In delhi

svr said...

Quite interesting post,Thanks for sharing the information.Keep updating good stuff...
sap abap programming training

3D ANIMATION TRANING IN NOIDA said...


3d Animation Course training Classes

Best institute for 3d Animation and Multimedia

Best institute for 3d Animation Course training Classes in Noida- webtrackker Is providing the 3d Animation and Multimedia training in noida with 100% placement supports. for more call - 8802820025.

3D Animation Training in Noida

Company Address:

Webtrackker Technology

C- 67, Sector- 63, Noida

Phone: 01204330760, 8802820025

Email: info@webtrackker.com

Website: http://webtrackker.com/Best-institute-3dAnimation-Multimedia-Course-training-Classes-in-Noida.php


Our courses:
3D Animation and Multimedia Training in Noida.
3d Multimedia Institute in Noida.
Animation and Multimedia Training in Noida.
Animation and Multimedia Training institute in Noida .
Multimedia Training institute in Noida.
Multimedia Training classes in Noida.
3D Animation Training in Noida.
3D Animation Training institute in Noida.

cara menggugurkan hamil said...

just information we only provide information for those who need it
A. cara agar cepat hamil setelah selesai haid
B. cara agar cepat hamil
C. cara alami untuk segera mendapat kehamilan
D. makanan dan minuman agar cepat hamil
E. masa subur biar cepat hamil
F. panduan agar cepat hamil

jagatsingh said...

Webtrackker Technology is IT Company and also providing the Solidwork
training in Noida at running project by the real time working trainers.
If you are looking for the Best Solidwork training institute in Noida
then you can contact to webtrackker technology.
Webtrackker Technology
C- 67, Sector- 63 (Noida)
Phone: 0120-4330760, 8802820025
8802820025
Solidwork training institute in Noida

obat telat bulan said...

thanks for sharing 082210743003

Obat Aborsi

Obat Telat Bulan

Obat Penggugur

Jual Obat aborsi terbaik

Obat Aborsi Termurah

Obat Aborsi Terpercaya

Obat Aborsi terbaik


jual Obat aborsi termanjur

jual obat aborsi asli

jual obat telat bulan

jual obat aborsi



obat telat bulan

obat telat bulan asli

klinik obat telat bulan

obat telat bulan terbaik

amsa leka said...

Hey, Wow all the posts are very informative for the people who visit this site. Good work! We also have a Website. Please feel free to visit our site. project management courses in chennai |pmp training class in chennai | pmp training fee | project management training certification | project management training in chennai | project management certification online |

S Happy said...

Nice post. It is really interesting. Thanks for sharing.
Hotels in Tuticorin, Hotels in Thoothukudi, Best Hotel in Tuticorin