Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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,


1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function

2 Answers   Zensar,


Which is the best website to learn Oracle Apps?

2 Answers  


how to find the custom directory in front end.

1 Answers   IBM, Sierra Atlantica,


How to make Parameter as Mandatory?

2 Answers  


please send me forms, xml pulisher questions,answers

0 Answers   Zensar,


Can u define exceptions twice in same block?

3 Answers  


Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,


What is the difference between base table and multi-org table?

3 Answers   Infosys,


Who information?s?

2 Answers  


Is soa a part of oracle fusion middleware?

0 Answers  


How many phases of implementation and what are those.

2 Answers   Accenture,


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)