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 |
wht is the use of Xml reports over reports6i?
What is a value set? List its various types.
how can we get odd numbered pages in output of a report
How does accounting occured in Expense Reporting?
wht r the basetables of customer interface?
After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?
How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?
What is the most critical part which you had faced in your project ?
1 Answers LG, Satyam, Tech Mahindra,
what are the difference between 11.5.7 and 11.5.9 in oracle apps
what is organization id
What are the benefits of using soa architecture?
Can 2 functions have same name & input parameters but differ only by return datatype ?