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 Difference between Auto Copy Journal and recurring journal?

0 Answers   Evo Tech,


Please let me know the various accounting entries in AP & AR for a layman. Like invoice posting, payment, offset entries, exchange fluctuation entries, i am preparing for an interview. PLEASE HELP

4 Answers   Oracle,


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  


Is it same primary ledger data and seconday ledger data should be same or differnt?explain

5 Answers   4i Apps,


While doing implementation,Client wants two use 2 Accounting methods for both Sandard Accrual method and Sandard Cash Method.So how we need to map or how need to provide solution.

1 Answers   Oracle,






What is the difference between Secondar ledger and Reporting Currency Ledger.

3 Answers   4i Apps,


What is ment by leased asset?

2 Answers   Chartered Accountant, Sierra Atlantica,


What's the difference between the "Payables Open Interface Import" Program and the "Payables Invoice Import" program?

2 Answers   AP, HCL, IBM, JK Technosoft, TCS,


Is Operating unit have branches in different location. I.e. same operating unit have One branch at Delhi and another one at Mumbai.

3 Answers   Aurobindo,


While you are in implemenation what are the u issues faced? tell me what some issues?

6 Answers   iFlex, TCS, Tesco,


In FA module..Once we added assets...we dont want depreciation few of assets.but other assets we will run dep monthly.So how we can stop dep for few assets.

2 Answers   4i Apps,


if you are not having a cashmanagement module how to reconcile or how to clear the transactions?

2 Answers   Genpact,


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)