OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » How to Find function/form for given responsibility

Home » Applications » Oracle Fusion Apps & E-Business Suite » How to Find function/form for given responsibility

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

How to Find function/form for given responsibility [message #270549]

Thu, 27 September 2007 08:25

mujjbur
Messages: 13
Registered: August 2007

Junior Member

Hi Members/Experts,

This is muzibur rahman. I am a new member of OraFAQ Forum.I need a request from you all.

I have list of Responsibility Names.

I want to find the Functions and Form Names in which those responsibilities are attached to.

Please help me in this regard. Please provide me the Script if possible.

Regards,

Muzibur Rahman

Report message to a moderator

Re: How to Find function/form for given responsibility [message #270579 is a reply to message #270549]

Thu, 27 September 2007 10:55

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

Senior Member

You should search the forum first.

By
Vamsi

Report message to a moderator

Re: How to Find function/form for given responsibility [message #271846 is a reply to message #270579]

Wed, 03 October 2007 02:50

mujjbur
Messages: 13
Registered: August 2007

Junior Member

Vamsi,

I have searched the forum, i didnt get any such solutions for this. Kindly help me in this regard.

By
Muzibur

Report message to a moderator

Re: How to Find function/form for given responsibility [message #272015 is a reply to message #271846]

Wed, 03 October 2007 11:46

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

Senior Member

Did you check my link, which I have posted above?

By
Vamsi

Report message to a moderator

Re: How to Find function/form for given responsibility [message #273977 is a reply to message #272015]

Fri, 12 October 2007 08:57

mujjbur
Messages: 13
Registered: August 2007

Junior Member

Vamsi,

I have checked your link. I am getting so many other necessary information. But i am not getting the exact thing what i want. Please post the query. My work is about to escalate now. Please help me.

Regards,

Muzibur.

Report message to a moderator

Re: How to Find function/form for given responsibility [message #273979 is a reply to message #273977]

Fri, 12 October 2007 09:16

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

Senior Member

Quote:

I am getting so many other necessary information

necessary or unnecessary? If it is necessary, what is your problem?

Quote:

But i am not getting the exact thing what i want.

What do you want exactly?

Quote:

My work is about to escalate now.

What did you do till now? Post your query.

By
Vamsi

Report message to a moderator

Re: How to Find function/form for given responsibility [message #274340 is a reply to message #273979]

Mon, 15 October 2007 11:56

altasen.com
Messages: 38
Registered: November 2005

Member

Hi,

indeed in the link the second post does give a nice query. Unfortunately Oracle does not give a standard Report for this. Just run the query and give it a try.

Roel
http://www.altasen.com Oracle Application Books

Report message to a moderator

Re: How to Find function/form for given responsibility [message #274591 is a reply to message #273979]

Tue, 16 October 2007 09:07

mujjbur
Messages: 13
Registered: August 2007

Junior Member

Hi Vamsi,

I am herewith posting the query

SELECT FFF.FUNCTION_NAME, FF.FORM_NAME, FR.RESPONSIBILITY_NAME
FROM FND_RESPONSIBILITY_VL FR, FND_MENU_ENTRIES_VL FME,
FND_FORM_FUNCTIONS_VL FFF, FND_FORM_VL FF
WHERE FR.MENU_ID = FME.MENU_ID
AND FME.MENU_ID = FME.SUB_MENU_ID
AND FME.FUNCTION_ID = FFF.FUNCTION_ID
AND FFF.FORM_ID = FF.FORM_ID
AND FR.RESPONSIBILITY_NAME = '&RESP_NAME'

Please help me in this query.

Please modify the query if required and post your query.

Thanks & Regards,

Muzibur

Report message to a moderator

Re: How to Find function/form for given responsibility [message #274929 is a reply to message #274591]

Wed, 17 October 2007 14:04

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

Senior Member

Can't you change your code, which is in your other post, to get the desired?
Removing the tables fnd_user and fnd_user_resp_groups and the condition on form_name and putting on responsibility_name will work for you.

By
Vamsi

Report message to a moderator

Previous Topic:	invoices onhold report
Next Topic:	any additional interfaces

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 03:09:44 CDT 2024