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 to make Parameter as Mandatory?
please explain open interface import
where do u specify in org_id?
Do you know what are user profiles in apps. Any examples you can give?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
while doing the process of conversion if got any data error out what is the next step to reprocess
Can functions be overloaded ?
what is the difference between character mode,bitmap mode
2 Answers IBM, Sierra Atlantica,
Registering parametric report?
How to find which company will be conducted Oracle appa interview? Plz help me
where we can check the status of po.
what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference