Home » Applications » Oracle Fusion Apps & E-Business Suite » SQL Script to get see the dates of a scheduled concurrent request (Oracle Application 11i)
SQL Script to get see the dates of a scheduled concurrent request [message #307776] Wed, 19 March 2008 18:53 Go to next message
anikdatta
Messages: 16
Registered: October 2005
Junior Member
Hi Guys,

I have scheduled a concurrent program on 9, 18 , 26 and 27 day of the month, can you help me to get a script where I can see these dates from backend.

Input : Concurrent Program Name,
Output : 9
18
26
27

It's urgent .. Please help.....

Thanks & Regards,
Anik
Re: SQL Script to get see the dates of a scheduled concurrent request [message #307801 is a reply to message #307776] Thu, 20 March 2008 00:39 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Maybe you can tell us how you scheduled these programs.

By the way, we actually do not care if it is urgent. (Forum rules clearly state that you should not mention such things) Don't you think everyone thinks his/her post is urgent?
Re: SQL Script to get see the dates of a scheduled concurrent request [message #307807 is a reply to message #307776] Thu, 20 March 2008 00:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't Multipost.

Regards
Michel
Re: SQL Script to get see the dates of a scheduled concurrent request [message #307928 is a reply to message #307807] Thu, 20 March 2008 07:02 Go to previous message
Dhruva
Messages: 9
Registered: August 2007
Junior Member
all concurrent requests logged into table
fnd_concurrent_requests

check RESUBMIT_INTERVAL and RESUBMIT_INTERVAL_UNIT_CODE columns.
Previous Topic: value sets
Next Topic: Query to display menus, submenus & functions attached to responsibilities
Goto Forum:
  


Current Time: Fri Jun 28 23:38:46 CDT 2024