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

Charge Back Setups ?

0 Answers   BSS, L&T, TCS,


Explain about Localization (IND & US ) in Oracle Apps ?

0 Answers   KPIT,


Whether is it allowed for entering negative amount in Journal lines?

3 Answers  


i have studied oracle 11i finance courser at Oracle Universiyt at chennai. Now, i want some experience in same filed. If any have this chance, please inform to me

3 Answers  


In GL Journal entry can understand which level i.e. batch wise or individually.

3 Answers   Satyam,






If scenario I assigned default Mo operating unit and Mo security profile is b so what can able to see in operating unit in payable?

1 Answers   Deloitte,


What are all the standard interfaces in the GL,AP,AR,PO,OM and INV?

5 Answers   Infinite Computer Solutions, Oracle, TCS,


how to transfer the retained earning amount from curret year to next year? what is the path in apps financial

3 Answers   TCS,


Can journals imported from sub-ledger, if unposted, be modified?

3 Answers  


What Are The Important Reports In GL?

4 Answers   IBM,


Hi, as I have 8 yrs End User exp in Oracle 11i 3rd bak & now SAP (in GL, AP, & FA), how do recruiters consider me as they are asking for Implementation exp. How do I convince them. I have done Oracle 11i training in 2007 & cont studyin materials also. But plz help how do I draft my CV such a way that I will get a job.

3 Answers  


When we run a GL Reconciliation Report, we also see the void payments in that report. Even though i disable the option of Show Void payments, its appearing in the report.How do i proceed so that i dont see those void payments in the GL Reconciliation Report?

0 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)