Can anyone tell me why in some tables in AR , AP, GL modules
they r using int_all after every table

Answers were Sorted based on User's Feedback



Can anyone tell me why in some tables in AR , AP, GL modules they r using int_all after every table..

Answer / srini

_all will represent the multiorg tables

Is This Answer Correct ?    5 Yes 1 No

Can anyone tell me why in some tables in AR , AP, GL modules they r using int_all after every table..

Answer / sugam ghosh

All _all tables are having org_id column by which you can
extract all information kept in that table for a particular
org.
For example, in PO_HEADERS_ALL table if you wish to extract
all header level information of all POs created for org 89,
you just have to run,

select * from PO_HEADERS_ALL where org_id=89;

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Oracle Apps Financial Interview Questions

What do you mean by controlling buyers workload?

2 Answers   ABC, Oracle,


What is a Payable Document?

6 Answers   HCL, IBM, Oracle, TCS,


What are the steps involved in connecting reporting set of books to primany set of books. How to translate from Functional to Reporting currncy every month or daily?

2 Answers  


Hi Friends i Completed my M.Com in 2007 From Osmania University I learn Oracle Financials. Can i get the job offers as a fresher? I have only year exp. in C.A. Firm so can i get the job? Plz send me suggistions. Thanks Dear friends.

3 Answers  


what are the accounting entries which get effected in order to cash cycle

8 Answers   Cognizant, Oracle, TCS, Wipro,






what are the key flex fields in oracle payables?

2 Answers   IBM,


What is Interest Invoice and how it can be created?

3 Answers   HCL, IBM, TCS,


What is the difference between SR

1 Answers   WIP,


what is aim methodology?explain me in detail? what is ur role in it ? in which phases u involved

4 Answers   Cap Gemini, Satyam,


Describe the key configuration decisions you would need to undertake when implementing the cash management module?

1 Answers   Wipro,


There is employee X and employee Y (who is supervisor of X); when Y submits expenses how will the system ensures that this should not go to X even if he has the approval authority.

2 Answers  


What are the key flexifields avilable in Oracle General ledger?

7 Answers   Oracle,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)