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 the difference between BPA AND Contract.
what is difference between procedure and function
What is INBOUND and OUT BOUND? (Different types of interfaces)
17 Answers Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,
What are triggers?
What is Summary columns?
What are the validations you don in .CTL file in inbound interface process?
we have clients in different countries, we can run report in different places, if i want to display particular language,country,currency everything displays for that country how?
do you know is it possible to run the interface without using oracle apps?
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?
explain p2p cycle? what are the tables used for this?
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
how can develope the po variance and po summary report? with tables mandatory columns and query please?