OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » The list of concurrents that are in "Scheduled" Phase or status.

Home » Applications » Oracle Fusion Apps & E-Business Suite » The list of concurrents that are in "Scheduled" Phase or status. (Apps,12.1.3, i386 GNU/Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

The list of concurrents that are in "Scheduled" Phase or status. [message #543305]

Tue, 14 February 2012 01:33

ashishjoy
Messages: 2
Registered: February 2012
Location: Chennai

Junior Member

Hi All,

I need an urgent help on the following:

I need a query to find the details of:-

1.The list of concurrents that are in "Scheduled" Phase or status.

2.The point is that i also need the description of the definition of the same, and its respective parameters.

For Example:

Id: 1
Name: Concurrent A
Schedule info: To be run every 10 minutes
Parameters info:
Parameter a: Defines de compnay
Parameter b: Defines de date range
Parameter c: Defines the quantity

Thanks,
Ashish

Report message to a moderator

Re: The list of concurrents that are in "Scheduled" Phase or status. [message #543408 is a reply to message #543305]

Tue, 14 February 2012 11:20

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Try join the following tables/views.
fnd_concurrent_requests
fnd_concurrent_programs_vl
fnd_descr_flex_col_usage_vl

By
Vamsi

Report message to a moderator

Re: The list of concurrents that are in "Scheduled" Phase or status. [message #543525 is a reply to message #543408]

Wed, 15 February 2012 02:26

ashishjoy
Messages: 2
Registered: February 2012
Location: Chennai

Junior Member

Thanks Vamsi, But can u get it as a query for me if possible . At least from your sources please.

Report message to a moderator

Re: The list of concurrents that are in "Scheduled" Phase or status. [message #544058 is a reply to message #543525]

Sun, 19 February 2012 15:13

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Quote:

But can u get it as a query for me if possible

No.
Give me yours. I'll try to correct it.

By the way, request_id can be found in fnd_concurrent_requests.
You may filter on phase or status.
Concurrent program name is from fnd_concurrent_programs_vl by linking concurrent_program_id.
Parameters can be found in fnd_descr_flex_col_usage_vl, by considering descriptive_flexfield_name as concurrent_program_short_name prefixed with "$SRS$." (without quotes).

By
Vamsi

Report message to a moderator

Previous Topic:	how to approach above task
Next Topic:	Forms personalization (merged 5)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 06:00:58 CDT 2025