Can anyone tell me why in some tables in AR , AP, GL modules they r using int

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

Question Posted / sumesh

2 Answers
13658 Views
Accenture, I also Faced
E-Mail Answers

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 is use of auto copy button in general ledger l recurring journal and where its effects in the real time process

2 Answers IBM,

purchasing and payables done at what level? means operating unit level or SOB level?

4 Answers Cognizant,

I have defined the system options,Receivable activity for REFUND in AR.And now i am getting fallowing error while creating REFUND in Receipt. ---------An unexpected error -6502 has occurred. An alert has been sent to the system administrator. ORA-01403 no data found---------

2 Answers

What are the types of receipts?

9 Answers Godrej, IBM, TCS,

R there any setups to change the source while entering Journals manually? The defaulted one is manual and the box is greyed out, how can i change the source?

1 Answers Pfizer,

what are the jvs effcted in ptp cycle?

2 Answers Satyam,

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

1 Answers Oracle,

Can you translate the balances of SOB in GBP currencies into multiple currencies or only in one different currency?

1 Answers

What is the difference between 11I AND R12?

2 Answers

Can somebody provide me the various or atleast most frequent issues a support consultant deal with?

2 Answers Wipro,

I am working with AP after creating the transaction in AP I am unable to creating the Accounting. The system is showing this message " Online account could not be created for this transaction. Please submit the create accounting concurrent program with the report parameter set to detail to determine the problem"

5 Answers Polaris,

What kind of budgets have you worked on?

0 Answers

For more Oracle Apps Financial Interview Questions Click Here