what is the difference between multiorg views and multiorg
tables

Answers were Sorted based on User's Feedback



what is the difference between multiorg views and multiorg tables..

Answer / bhabna

Multi tables generally consists _all with their name.So all
the OU data can be shown through the table.

In Multi org view definition, enviroment is set in such a
way that user can see data respective to the OU which is
already set.

To set the enviroment for an OU user should execute the
following...

fnd_client_info.set_org_context('OU_Value');

so the basic difference is In table we can see all the data
irrespective of OU...But we can see the data for a specific
OU through view.

Is This Answer Correct ?    16 Yes 0 No

what is the difference between multiorg views and multiorg tables..

Answer / gyan

Multiorg table are those where they having org_id column and
_all in the table name and views which having org_id but
without _all in the table name

Is This Answer Correct ?    0 Yes 8 No

Post New Answer

More Oracle Apps Technical Interview Questions

How do u identity its name of report?

3 Answers  


what are the difference between 11.5.7 and 11.5.9 in oracle apps

4 Answers  


List the various types of value set.

0 Answers  


What is multoorg and what is it's level or structure

4 Answers   IBM,


In report we have to show two Layout? how it is and how we can see from where it?

3 Answers   IBM,






In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,


What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,


what is the difference between %_all and %_f tables

1 Answers  


what is the difference between varchar and varchar(2)?

4 Answers  


WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

4 Answers  


If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

5 Answers   Wipro,


how can we get odd numbered pages in output of a report

2 Answers   Infosys,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)