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 are the Import Programs We need to run after creating Interface table for all modules
what is meant by boilerplates?
where do u specify in org_id?
If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?
Which is the best website to learn Oracle Apps?
what is pl/sql table and pl/sql records? what is the use of that?
what is the difference between procedure and function
If there is any issue then whom do you report.(this is imp question for every interview)
Where we can write a PL/SQL code in report triggers?
In which table or database definition we can find the link of organization and operation units.
How relation will be made between modules in oracle financial?
I want to print output in portrait style?where i have to change the settings?