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 is the period end process in AR.What is the reports required for peeriod process

1 Answers   Cognizant,


6. TDS accounting entry

1 Answers   ABC, Arihant,


As Supplier Header Information can share from another operating unit. Not Sites and other information...... but for a supplier if one OU(1) has made a prepayment..and other OU(2) of the same balancing segment has to make a payment to the same supplier..the prepayment available with that supplier is overlooked or not considered….is it true

1 Answers  


as a functional consultant what was your role in implementation project and supporting project?

1 Answers   IBM,


If the client is totally dependent on manual on Manual transactions then Is the auto-accounting rules Mandatory?

1 Answers  


Hi How to transfer the funds one bank to another bank. Ex: i am using bank called citi bank and i want make the paymeny immediately and my bank balance is 0.So i have another bank account called HDFC and now i wnt to transfer funds HDFC to CITI bank.is this possible in oracle applications? or when i defined MO i need to implement bank funds transfer moudle.Plz clarify my doubt?.

2 Answers   Oracle,


What is internal-external bank (account)? Suppliers bank account? Inernal-external sales order? In AP, do you settup each supplier with its own account or you just use your expense/charge account for all supplier.Whatif you want to know how much money you paid to a particular supplier?

2 Answers  


Can you end-date the SOB's in 11i or in R12 version?

5 Answers   Oracle,


What are the rules for translation?

2 Answers  


What is meant by third party payments?

0 Answers  


Is it possible to retire an asset in the same period it is added?

2 Answers  


How can we create FSG in another currency other than the currency which is associated with ledger?

1 Answers   Cap Gemini,


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)