Home » Applications » Oracle Fusion Apps & E-Business Suite » some oracle 11i questions.
some oracle 11i questions. [message #111785] Sun, 20 March 2005 02:51 Go to next message
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
icon3.gif  Re: some oracle 11i questions. [message #112964 is a reply to message #111785] Wed, 30 March 2005 03:47 Go to previous messageGo to next message
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

Re: some oracle 11i questions. [message #117690 is a reply to message #112964] Thu, 28 April 2005 19:25 Go to previous messageGo to next message
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
Re: some oracle 11i questions. [message #190980 is a reply to message #117690] Sun, 03 September 2006 18:15 Go to previous message
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
Previous Topic: Financial Interview quries
Next Topic: How to do AP PO matching with multiples invoices (70% and 30%).
Goto Forum:
  


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