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

57 comments:

John S. said...

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

Unknown said...


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

Unknown 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

Unknown 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

Unknown 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

Unknown 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...


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

Unknown 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

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

Unknown 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

Unknown 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

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

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

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

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

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.
Java Training 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

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

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

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

Unknown 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



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

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.

Anonymous 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 |

Jaweed Khan said...

Thanks For sharing Your information The Information Shared Is Very Valuable Please Keep updating Us Time Just Went On Redaing The Article Python Online Course Devops Online Course Data Science Online Course Aws Science Online Course

Ramya said...

Very nice blog and very intersting...
Digital Marketing Training

devika said...

Thanks for sharing this post.
great effort.

Mithun said...

The blog which you have shared here is absolutely fantasic and very nice to read hope everyone loves to do it.
SAP Training in Chennai

mean stack development training said...

Its just awesome information, I finally found in this blog,
Thank you for your valuable information.

mean stack development training

Big Data Hadoop training institutes said...

Your info is really amazing with impressive content..Excellent blog with informative concept. Really I feel happy to see this useful blog, Thanks for sharing such a nice blog..
If you are looking for any python Related information please visit our website Python Training In Bangalore page!

Corporate Training said...

Very interesting and useful information, thanks for sharing with us, keep up the good work!

Corporate Training

Mithun said...

Excellent SAP Blog with lots of useful informations.
SAP Training in Chennai | SAP Training Center in Chennai | SAP Training Institute in Chennai

Mithun said...

Excellent SAP Blog with lots of useful informations.
SAP Training in Chennai | SAP Training Center in Chennai | SAP Training Institute in Chennai

Training for IT and Software Courses said...

I am Here to Get Learn Good Stuff About SAP FICO Training, Thanks For Sharing
SAP FICO Training.SAP FICO training in bangalore

svrtechnologies said...

Thanks for Sharing Such an Informative Stuff...

amazon web services tutorial

Corporate Training said...

Very useful information, thanks for sharing with us, keep up the good work!

Recruitment Firm | Recruitment Consultants | RAMSOL
Corporate Training | Best Corporate Training | RAMSOL

svrtechnologies said...

This is so elegant and logical and clearly explained. Brilliantly goes through what could be a complex process and makes it obvious.

sap fi training
sap fico tutorial

Anand Shankar said...

Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained!

digital marketing blog, skartec's digital marketing blog, skartec digital marketing academy, skartec digital marketing, best seo service in chennai, best seo services in chennai,

Danishsingh said...

Thanks for sharing such a great blog Keep posting.
CRM software
online CRM software
CRM software
sales automation process
business directory

Shivaraj said...

I am glad to read that you come up with outstanding information that definitely allows me to share with others. Thank you for sharing this with us.


digital marketing course in hubli

Mithun said...

It's very Amazing to visit this sites...Thanks for all your valuable information's
Java training in chennai | Java training in annanagar | Java training in omr | Java training in porur | Java training in tambaram | Java training in velachery

Web Design Company said...

Very Useful Information, Thanks for Sharing with Us.

Ivap Apps | Web Design & Development Company

Devi said...

Awesome. I read this post so nice and very informative information...thanks for sharing. oracle training in chennai

radhika said...

Thank you for the time to publish this information very useful! I've been looking for books of this nature for a way too long. I'm just glad that I found yours. Looking forward for your next post. Thanks]]]]]



AWS training in Chennai

AWS Online Training in Chennai

AWS training in Bangalore

AWS training in Hyderabad

AWS training in Coimbatore

AWS training

SAP CRM Training in Chennai said...

pentaho Training In Chennai
MSBI Training In Chennai
Informatica mdm Training In Chennai
informatica Data Quality Training In Chennai
Informatica IICS Training In Chennai
Talend Training In Chennai
Power BI Training In Chennai
SAP BO Training In Chennai
Qlikview Training In Chennai

Amrita Bansal said...

Good Post! it was so good to read and useful to improve my knowledge as an updated one, keep blogging. After seeing your article I want to say that also a well-written article with some very good information which is very useful for the readers....thanks for sharing it and do share more posts like this.

Saleforce Training in Gurgaon
Saleforce Developer Training in Gurgaon
Salesforce lightning training in Gurgaon
Salesforce Einstein training in Gurgaon
Salesforce integration training in Gurgaon
Salesforce Marketing Cloud Training in Gurgaon

SixD Engineering Solutions Pvt Ltd said...

It's really a good blog kindly thank you for sharing this.

3D Scanning Services Near Me
3D Laser Scanning Targets
3D Scanning Reverse Engineering

Devi said...

Are you interested in doing Data Science Course in Chennai with a Certification Exam? Catch the best features of Data Science training courses with Infycle Technologies, the best Data Science Training & Placement institutes in and around Chennai. Infycle offers the best hands-on training to the students with the revised curriculum to enhance their knowledge. In addition to the Certification & Training, Infycle offers placement classes for personality tests, interview preparation, and mock interviews for clearing the interviews with the best records. To have all it in your hands, dial 7504633633 for a free demo from the expertsGrab Data Science Course in Chennai | Infycle Technologies

abankaigler said...

Caesars Casino & Resort - Dr. Md.
Caesars 상주 출장안마 Palace is located on the 평택 출장안마 waterfront in 인천광역 출장샵 a bustling casino city just steps from Harrah's New Orleans and the iconic Canal 의왕 출장샵 Street Experience 안성 출장마사지

Jain said...

A fantastic online journal This is the first time I've seen this blog, and it's incredible.
Digital marketing courses in Bangalore

Popular Mumbai Dabbawalas Case Study said...

Very useful information. I'll share with a few clients who using Oracle CRM.