OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » some oracle 11i questions.

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

some oracle 11i questions. [message #111785]

Sun, 20 March 2005 02:51

sivaparam
Messages: 16
Registered: March 2005

Junior Member

Hi there,
Here is some oracle 11i questions.

1. How do I find the list of responsibility assigned to menu.
Just the table name will do ?

2. How many user is using the given menu ?
What is the table name to identify he above relations.

3. Relation between the menu and form. What is the table name maintain this relation.

Thanks in advance.
siva

Report message to a moderator

Re: some oracle 11i questions. [message #112964 is a reply to message #111785]

Wed, 30 March 2005 03:47

vikrams
Messages: 23
Registered: November 2000
Location: Dubai

Junior Member

Hi Siva,
These are nice questions Cool

Well here are the answers

1. How do I find the list of responsibility assigned to menu.
Just the table name will do ?

There are two views are involved in this case
1) FND_RESPONSIBILITY_VL
2) FND_MENUS_VL
First you have to find the menu_id of the menu from FND_MENUS_VL
Then you have to search in the FND_RESPONSIBILITY_VL with the condition of menu_id
The query goes like this

SELECT responsibility_name
FROM FND_RESPONSIBILITY_VL
WHERE menu_id = (SELECT menu_id
FROM FND_MENUS_VL
WHERE user_menu_name LIKE
'%MENU_NAME%')

2. How many user is using the given menu ?
What is the table name to identify he above relations.

The Table to identiy is FND_USER_RESP_GROUPS.
From this table, you can get the User_id and then map it with the FND_USER table to get the user name

3. Relation between the menu and form. What is the table name maintain this relation.

Can you please clarify what to you mean by menu and form?

Well hope so this will solve your queries.
Anyway if there are still any queries, feel free to ask.
I will try my level best to give you the answer Cool

Report message to a moderator

Re: some oracle 11i questions. [message #117690 is a reply to message #112964]

Thu, 28 April 2005 19:25

tarajkhan
Messages: 2
Registered: April 2005
Location: 1714 e harwell rd

Junior Member

Vikram,

I was searching form Oracle Apps Faq questions and came accross your answers. Without taking much of your time, Is their any place where I can find Oracle Apps Technical questions.

So far, I have search metalink, google and orafaq site, not much help.

Your suggestion/guidance is heartly appreciated.

Thanks for your time and effort

Report message to a moderator

Re: some oracle 11i questions. [message #190980 is a reply to message #117690]

Sun, 03 September 2006 18:15

atul_iiit
Messages: 55
Registered: August 2006

Member

Here you can find few more Oracle Apps Technical Questions for Apps DBA's

http://teachmeoracle.com/interview.html

Atul
http://becomeappsdba.blogspot.com

Report message to a moderator

Previous Topic:	Financial Interview quries
Next Topic:	How to do AP PO matching with multiples invoices (70% and 30%).

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 20:34:13 CST 2024