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 |
How do u identity its name of report?
what are the difference between 11.5.7 and 11.5.9 in oracle apps
List the various types of value set.
What is multoorg and what is it's level or structure
In report we have to show two Layout? how it is and how we can see from where it?
In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.
10 Answers HCL, TCS,
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
what is the difference between %_all and %_f tables
what is the difference between varchar and varchar(2)?
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
how can we get odd numbered pages in output of a report