Find Request Group for Concurrent Programs
Written by Anil Passi   
Saturday, 23 December 2006
In this article, I would like to give you a quick trick to find "which request group should the concurrent program be added to"? Many a times, we create a new concurrent program following which we try to make that program available from a specific Menu under a specific responsibility.

 

I have created a concurrent program, and I now wish to know which request group must this program be added to?

 

Step 1. Ensure that profile option "Utilities:Diagnostics" is set to Yes at your user level.

Note:- This step can be skipped in case you have the apps password.

Step 2. Navigate to the responsibility from where you will submit the concurrent program.

Step 3. Navigate to the "Submit New Request" screen, where you will enter the name of the concurrent program to run.

Step 4. Now you must do examine using the help menu as shown below.

Step 5. In the block field, enter PARAMETER, and in the field name enter REQUEST_GROUP_CODE

Note down this value
Step 6. Now in the value field
enter REQUEST_GROUP_APPL_SHORT_NAME



Note down the two values from Step 5 and Step 6.

These will indicate the request group to which you must add your concurrent program.



Question: In the submit request screen, REQUEST_GROUP_CODE is blank??

In this case use the Request group specified in "Define Responsibility Screen"


The rule is :-

If request group code is being passed in as parameter to Submit Request form function, then use that request group. Or else use the request group at responsibility level.



 

NOTES:-

Why do I need both the request group code and the request group application?

Request group name and its application is a composite primary key, hence you need the application name. For example "All Reports" request group can be found under every possible application.

 

Where does this request group parameter come from?

This request group name and application are defined as parameters to the form functions.

 

Is this form function attached to submit request form?

Correct

 

If at the time of defining form function, we do not pass request group parameter, then request group from responsibility is used?

Correct, because request group specified against responsibility is the default request group.

 

 

Comments (19)add
...
written by Anil Passi , December 25, 2006
Hi Balla,

Glad this worked for you. However I need to know if you can see the screenshots or is that something visible just from my PC?

Thanks
anil
...
written by balkrishna , December 25, 2006
hellow sir ,
due to certain reasons screenshots are not available.please check it is there or it may be possible my system error.nice article and i have implemented it it works .
thanks and regards
balkrishna
...
written by Anil Passi , December 25, 2006
Hi Balla,

Glad this worked for you. However I need to know if you can see the screenshots or is that something visible just from my PC?

Thanks
anil
...
written by balkrishna , December 25, 2006
hellow sir ,
due to certain reasons screenshots are not available.please check it is there or it may be possible my system error.nice article and i have implemented it it works .
thanks and regards
balkrishna
...
written by Aman , December 26, 2006
Hi Balkrishna,

Its working for me. May be there is some problem with plugins or active-x with ur p.c. If not, install Mozilla and give it a try.

Thanks
Aman
...
written by Aman , December 26, 2006
Hi Balkrishna,

Its working for me. May be there is some problem with plugins or active-x with ur p.c. If not, install Mozilla and give it a try.

Thanks
Aman
...
written by Anil Passi , January 01, 2007
.
.
.
.
Hi Prasad

Please use fnd_request.submit_request. Do let us know in case you face any difficulty in submitting request in such manner.

Thanks,
Anil
...
written by prasad , January 01, 2007
How to submit concurrent program to back end
...
written by Anil Passi , January 01, 2007
.
.
.
.
Hi Prasad

Please use fnd_request.submit_request. Do let us know in case you face any difficulty in submitting request in such manner.

Thanks,
Anil
...
written by prasad , January 01, 2007
How to submit concurrent program to back end
...
written by Anil Passi , January 18, 2007
.
.
.
Hi Sandeep,
Glad you made a switch. The only advice I can give you is to keep working hard, and to read as much possible from as many places, and then form a picture relating all that you read in your mind.

Life will never be easy in Oracle Apps. And if your life does become easy in Oracle Apps, by then its time to learn new things in Oracle apps/fusion.

Thanks,
AniL Passi
...
written by Sandeep Somvanshi , January 18, 2007
Hello Anil,

I am very new to Oracle Apps and just 2 months back started learning Oracle Apps.

My previous 4 yrs of exp. was in Shell scripts, Sql, Pl/sql. Now i am switching to Oracle Apps and found your articles very useful.

Please guide me and give some valuable suggestions to make my life easier.

Thanks and regards,
Sandeep Somvanshi
...
written by Anil Passi , January 18, 2007
.
.
.
Hi Sandeep,
Glad you made a switch. The only advice I can give you is to keep working hard, and to read as much possible from as many places, and then form a picture relating all that you read in your mind.

Life will never be easy in Oracle Apps. And if your life does become easy in Oracle Apps, by then its time to learn new things in Oracle apps/fusion.

Thanks,
AniL Passi
...
written by Sandeep Somvanshi , January 18, 2007
Hello Anil,

I am very new to Oracle Apps and just 2 months back started learning Oracle Apps.

My previous 4 yrs of exp. was in Shell scripts, Sql, Pl/sql. Now i am switching to Oracle Apps and found your articles very useful.

Please guide me and give some valuable suggestions to make my life easier.

Thanks and regards,
Sandeep Somvanshi
...
written by seshadri , May 19, 2007
Hi Anil,

I cannot find the words to praise ur service to learners.Hope u will continue with the same type of articles and as well material in ur site.

I have a small doubt in this article:

When i was trying to enter REQUEST_GROUP_CODE in the Field column,it simply skipping out with out showing the value in the Value field.

Same problem with the REQUEST_GROUP_APPL_SHORT_NAME also.

Pls help me out.

Thanx in advance,


Regards,

Seshadri reddy.
...
written by seshadri , May 19, 2007
Hi Anil,

I cannot find the words to praise ur service to learners.Hope u will continue with the same type of articles and as well material in ur site.

I have a small doubt in this article:

When i was trying to enter REQUEST_GROUP_CODE in the Field column,it simply skipping out with out showing the value in the Value field.

Same problem with the REQUEST_GROUP_APPL_SHORT_NAME also.

Pls help me out.

Thanx in advance,


Regards,

Seshadri reddy.
...
written by RD , June 04, 2007
Hi,

Great site!!! Keep up the good work.

Could you please let me know the difference between Request group and request set?

Thanks
RD
...
written by ranganath , August 01, 2007
hi anil,
i am appreciating u for writting these apps concepts,but i have doubt
how can we find the request group for concurrent program from back end

thanks
ranganath.

...
written by Anil Passi , August 01, 2007
Hi Ranga

Please use the SQL below

SELECT fav.application_name || '---->' ||
frg.request_group_name
FROM fnd_application_vl fav, fnd_request_groups frg, fnd_request_group_units frgu
WHERE frgu.request_group_id = frg.request_group_id
AND frgu.request_unit_id = &conc_program_id
AND frgu.application_id = fav.application_id
/

Thanks
Anil Passi
You must be logged in to a comment. Please register if you do not have an account yet.

busy