Main Interface and Base Tables in Oracle Apps R12
A quick reference guide for key tables across major Oracle EBS modules.
Understanding Oracle Apps Tables
In Oracle E-Business Suite, data is stored in base tables, which are the final destination for transactional and setup data. To load data from external systems or other modules, Oracle uses interface tables. Data is first loaded into these temporary tables and then validated before being moved to the base tables. This guide provides a list of the most important interface and base tables for key modules.
GL (General Ledger)
Interface Tables
- gl_interface
- gl_budget_interface
Base Tables
- gl_je_batches
- gl_je_headers
- gl_je_lines
- gl_je_sources
- gl_je_categories
- gl_sets_of_books
- gl_daily_rates
- gl_balances
- gl_periods
- gl_period_sets
- gl_code_combinations
AR (Accounts Receivable)
Interface Tables
- ra_customers_interface_all
- ra_contact_phones_int_all
- ra_customer_profiles_int_all
- ra_interface_lines_all
- ra_interface_distributions_all
- ra_interface_salescredits_all
Base Tables
- hz_parties
- hz_cust_accounts
- hz_cust_acct_sites_all
- hz_cust_site_uses_all
- hz_party_sites
- hz_locations
- ra_customer_trx_all
- ra_customer_trx_lines_all
- ra_cust_trx_line_gl_dist_all
- ar_payment_schedules_all
OM (Order Management)
Interface Tables
- oe_headers_iface_all
- oe_lines_iface_all
- oe_actions_iface_all
Base Tables
- oe_order_headers_all
- oe_order_lines_all
- oe_order_sources
- oe_transaction_types_tl
- oe_transaction_types_all
INV (Inventory)
Interface Tables
- mtl_system_items_interface
- mtl_item_categories_interface
- mtl_item_revisions_interface
- mtl_interface_errors
Base Tables
- mtl_system_items_b
- mtl_system_items_tl
- mtl_item_locations
- mtl_item_categories
- mtl_item_revisions_b
- mtl_parameters
- hr_all_organization_units
- cst_item_costs
- qp_list_headers
PO (Purchasing)
Interface Tables
- po_requisitions_interface_all
- po_req_dist_interface_all
- po_headers_interface
- po_lines_interface
- po_distributions_interface
Base Tables
- po_requisition_headers_all
- po_requisition_lines_all
- po_req_distributions_all
- po_headers_all
- po_lines_all
- po_line_locations_all
- po_distributions_all
- po_vendors
- po_vendor_sites_all
- po_vendor_contacts
- po_action_history
AP (Accounts Payable)
Interface Tables
- ap_invoices_interface
- ap_invoice_lines_interface
Base Tables
- ap_invoices_all
- ap_invoice_distributions_all
- ap_payment_schedules_all
FA (Fixed Assets)
Interface Tables
- fa_inv_interface
- fa_production_interface
Base Tables
- fa_mass_additions
- fa_additions_b
- fa_additions_tl
- fa_books
- fa_deprn_summary
- fa_deprn_details
- fa_deprn_history
- fa_retirements
PA (Project Accounting)
Interface Tables
N/A
Base Tables
- pa_projects_all
- pa_tasks
- pa_expenditures_all
- pa_expenditure_items_all
- pa_budget_versions
- pa_resource_assignments
TCA (Trading Community Architecture)
Interface Tables
N/A
Base Tables
- hz_parties
- hz_cust_accounts
- hz_cust_acct_sites_all
- hz_cust_site_uses_all
- hz_party_sites
- hz_locations
- hz_customer_profiles
Workflow
Interface Tables
N/A
Base Tables
- wf_items
- wf_process_activities
- wf_item_activity_statuses
- wf_item_types_tl