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 are the modules covered under oracle finance

6 Answers   IBM,


How to refund for a customer who returns goods and wants a refund for $600 in R12 In above scenarios customer does not want Credit Memo or On- Account Credit, he wants refund check . and as we know we do not issue check from AR. How can we issue Check from AP and how offsetting is done for the same in R12

1 Answers   IBM, iGate,


How many key flexfield in Receivables ?

5 Answers   Accenture,


SLA usage ans how to define setups?

0 Answers   IBM, CNO,


tell me the ap period end process

3 Answers   IBM,






To implement AP from scratch-what is the process?

5 Answers   Rolta,


why we have to reverse the journal entries after Revaluation?is it mandatory if why?

1 Answers   Oracle,


On what different real time issues you worked while doing P2P cycle implementation?

0 Answers   Cap Gemini,


While assigning the security by book in oracle assets..i am unable ot get the asset org in security profile form.This asset org was already defined in org description window.

0 Answers   TCS,


What are the different Payments documents ?

3 Answers   FIC,


Hi all, I have setup my AP and created 3 invoice batches which as seen validated yet when i try to make payment i get the following error"APP-SQL - 10006: the date you entered is not an open accounting period." I have opened the calendar for that month yet it giving me this error. Any help will be appreciated.

4 Answers   IBM,


what is the difference between Revaluation and Translation? what are the steps in GL?

2 Answers   Syntel,






Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (503)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (774)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (82)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (138)
  • 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 (13)