what is the difference between multiorg views and multiorg
tables
Answers were Sorted based on User's Feedback
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 |
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 |
What is workflow?Explain with a example?
what is meant by Table space?
What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1
what is the difference between oracle 8i and 9i?
What is set function in sql .E.g.What is difference between union and union all
why do we validate the records while developing interface?
Tell me some errors names and number what u got while developing the reports?
in one report using two layout models.if yes how to do
Which module is not in multiorg
Where I can download D2K software?
how to find the custom directory in front end.
1 Answers IBM, Sierra Atlantica,
can we get profile values in report without using user exists is it possible how?