how to get request group name

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
keshavkovela
Posts: 19
Joined: Sun May 07, 2006 7:16 am
Location: India

how to get request group name

Post by keshavkovela »

Hi gurus,

Report registeration in apps, i know only inforation about executable name. from this executable , i got program name . Then how to know request group name.

Any help on this highly appreciated


thanks
keshav
Atif
Posts: 54
Joined: Mon Apr 03, 2006 4:22 am
Location: Pakistan

Post by Atif »

Request groups are associated with responsibility.Query the responsibility on which u want the report to be avaialble.from the Request group block copy the name of request group.Then go to
Security->Responsibility->Request.Paste the name of Request group copied from responsibility,Add the name of report under request.
Atif
keshavkovela
Posts: 19
Joined: Sun May 07, 2006 7:16 am
Location: India

Post by keshavkovela »

Atif,


The report is already added to request group. I know only the module name . I need to know the request group. Is there any way to get the request group?

thanks
keshav
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

May be the following query will help you, (modify it as per your requirements)

topic.asp?TOPIC_ID=334
seenujanu
Posts: 6
Joined: Sat Sep 02, 2006 8:56 am
Location: India

Post by seenujanu »

Hai Fri

Another way to get the Request Group Name is

If u Know the Module Name we can get the Request GroupName
Through FrontEnd
Goto Security ->Resposibility ->Define

Query it .u will get the RGName

Regards

seenu
ahmadbilal
Posts: 615
Joined: Mon Sep 18, 2006 1:32 am
Location: United Arab Emirates
Contact:

Post by ahmadbilal »

Check It Out this show you request groupn name APPLICATION NAME

Select G.REQUEST_GROUP_NAME, C.USER_CONCURRENT_PROGRAM_NAME, A.APPLICATION_NAME,
G.APPLICATION_ID, G.REQUEST_GROUP_ID, U.UNIT_APPLICATION_ID, U.REQUEST_UNIT_ID
From FND_REQUEST_GROUPS G, FND_REQUEST_GROUP_UNITS U,
FND_APPLICATION_TL A, FND_CONCURRENT_PROGRAMS_TL C
Where G.REQUEST_GROUP_ID = U.REQUEST_GROUP_ID
And U.UNIT_APPLICATION_ID = A.APPLICATION_ID
And U.REQUEST_UNIT_ID = C.CONCURRENT_PROGRAM_ID
--And G.REQUEST_GROUP_ID=1146
Order By C.USER_CONCURRENT_PROGRAM_NAME,A.APPLICATION_NAME, G.REQUEST_GROUP_ID
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 9 guests