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 oracle soa suite?
what is the difference between credit memo and debit memo?...
What are Mandatory triggers to write in the block, which is created on view?
What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?
what is pay run id ?
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
how can we get odd numbered pages in output of a report
can we use anchor propery in XML reports?if yes?explain?
what r the objects u have to do in u experiance
What are the validations you don in .CTL file in inbound interface process?
where to define interorganization transaction charges and what are the different options?
What is function?