# Oracle EBS Finance Tables Reference

> Source: https://netray.co/tools/oracle-ebs-finance-tables-reference
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Lookup of the base tables behind General Ledger, Payables, Receivables, Fixed Assets, Subledger Accounting and Purchasing, with the columns you join on.

## Category

oracle

## Erp

Oracle E-Business Suite

## Audience

- Oracle EBS developer
- Finance report writer
- Oracle apps DBA

## Tool

**Kind:** worksheet

**Mode:** reference

**Columns:**

#### Table

**Key:** table

**Type:** text

#### Module

**Key:** module

**Type:** text

#### What it holds

**Key:** holds

**Type:** text

#### Key columns to join on

**Key:** keys

**Type:** text

**Rows:**

**Table:** GL_LEDGERS

**Module:** GL

**Holds:** One row per ledger with currency, calendar and chart of accounts.

**Keys:** LEDGER_ID, CURRENCY_CODE, CHART_OF_ACCOUNTS_ID, PERIOD_SET_NAME

**Table:** GL_CODE_COMBINATIONS

**Module:** GL

**Holds:** Every account combination of the accounting flexfield.

**Keys:** CODE_COMBINATION_ID, CHART_OF_ACCOUNTS_ID, SEGMENT1 to SEGMENT30

**Table:** GL_PERIODS

**Module:** GL

**Holds:** Accounting calendar periods.

**Keys:** PERIOD_SET_NAME, PERIOD_NAME, START_DATE, END_DATE

**Table:** GL_PERIOD_STATUSES

**Module:** GL

**Holds:** Open or closed status of each period per application and ledger.

**Keys:** APPLICATION_ID, LEDGER_ID, PERIOD_NAME, CLOSING_STATUS

**Table:** GL_JE_BATCHES

**Module:** GL

**Holds:** Journal batches and their posting status.

**Keys:** JE_BATCH_ID, NAME, STATUS

**Table:** GL_JE_HEADERS

**Module:** GL

**Holds:** Journal entry headers: source, category, period, status.

**Keys:** JE_HEADER_ID, JE_BATCH_ID, LEDGER_ID, PERIOD_NAME, JE_SOURCE, JE_CATEGORY, STATUS

**Table:** GL_JE_LINES

**Module:** GL

**Holds:** Journal lines with debit and credit amounts.

**Keys:** JE_HEADER_ID, JE_LINE_NUM, CODE_COMBINATION_ID, ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR

**Table:** GL_BALANCES

**Module:** GL

**Holds:** Period balances by ledger, account, currency and balance type.

**Keys:** LEDGER_ID, CODE_COMBINATION_ID, CURRENCY_CODE, PERIOD_NAME, ACTUAL_FLAG

**Table:** GL_INTERFACE

**Module:** GL

**Holds:** Staging table for Journal Import.

**Keys:** STATUS, LEDGER_ID, USER_JE_SOURCE_NAME, ACCOUNTING_DATE, GROUP_ID

**Table:** GL_DAILY_RATES

**Module:** GL

**Holds:** Daily currency conversion rates.

**Keys:** FROM_CURRENCY, TO_CURRENCY, CONVERSION_DATE, CONVERSION_TYPE, CONVERSION_RATE

**Table:** GL_JE_SOURCES_TL

**Module:** GL

**Holds:** Journal source names and keys.

**Keys:** JE_SOURCE_NAME, USER_JE_SOURCE_NAME, LANGUAGE

**Table:** GL_JE_CATEGORIES_TL

**Module:** GL

**Holds:** Journal category names and keys.

**Keys:** JE_CATEGORY_NAME, USER_JE_CATEGORY_NAME, LANGUAGE

**Table:** AP_SUPPLIERS

**Module:** AP

**Holds:** Supplier header records.

**Keys:** VENDOR_ID, VENDOR_NAME, SEGMENT1 (supplier number)

**Table:** AP_SUPPLIER_SITES_ALL

**Module:** AP

**Holds:** Supplier sites per operating unit.

**Keys:** VENDOR_SITE_ID, VENDOR_ID, VENDOR_SITE_CODE, ORG_ID

**Table:** AP_INVOICES_ALL

**Module:** AP

**Holds:** Invoice headers.

**Keys:** INVOICE_ID, VENDOR_ID, INVOICE_NUM, INVOICE_AMOUNT, ORG_ID

**Table:** AP_INVOICE_LINES_ALL

**Module:** AP

**Holds:** Invoice lines.

**Keys:** INVOICE_ID, LINE_NUMBER, LINE_TYPE_LOOKUP_CODE

**Table:** AP_INVOICE_DISTRIBUTIONS_ALL

**Module:** AP

**Holds:** Accounting distributions for invoice lines.

**Keys:** INVOICE_DISTRIBUTION_ID, INVOICE_ID, DIST_CODE_COMBINATION_ID

**Table:** AP_PAYMENT_SCHEDULES_ALL

**Module:** AP

**Holds:** Due dates and amounts remaining per invoice.

**Keys:** INVOICE_ID, PAYMENT_NUM, DUE_DATE, AMOUNT_REMAINING

**Table:** AP_HOLDS_ALL

**Module:** AP

**Holds:** Holds placed on invoices and their release.

**Keys:** INVOICE_ID, HOLD_LOOKUP_CODE, RELEASE_LOOKUP_CODE

**Table:** AP_CHECKS_ALL

**Module:** AP

**Holds:** Payments issued to suppliers.

**Keys:** CHECK_ID, CHECK_NUMBER, VENDOR_ID, AMOUNT

**Table:** AP_INVOICE_PAYMENTS_ALL

**Module:** AP

**Holds:** Link between invoices and payments.

**Keys:** INVOICE_ID, CHECK_ID

**Table:** AP_INVOICES_INTERFACE

**Module:** AP

**Holds:** Staging table for Payables Open Interface Import (invoice headers).

**Keys:** INVOICE_ID, INVOICE_NUM, VENDOR_NUM, SOURCE

**Table:** AP_INVOICE_LINES_INTERFACE

**Module:** AP

**Holds:** Staging table for invoice lines in the Open Interface.

**Keys:** INVOICE_ID, INVOICE_LINE_ID, AMOUNT

**Table:** AP_INTERFACE_REJECTIONS

**Module:** AP

**Holds:** Reasons records were rejected during Open Interface Import.

**Keys:** PARENT_TABLE, PARENT_ID, REJECT_LOOKUP_CODE

**Table:** RA_CUSTOMER_TRX_ALL

**Module:** AR

**Holds:** Receivables transaction headers: invoices, credit memos, debit memos.

**Keys:** CUSTOMER_TRX_ID, TRX_NUMBER, BILL_TO_CUSTOMER_ID, ORG_ID

**Table:** RA_CUSTOMER_TRX_LINES_ALL

**Module:** AR

**Holds:** Transaction lines.

**Keys:** CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, LINE_TYPE

**Table:** RA_CUST_TRX_LINE_GL_DIST_ALL

**Module:** AR

**Holds:** Accounting distributions for AR transactions.

**Keys:** CUST_TRX_LINE_GL_DIST_ID, CUSTOMER_TRX_ID, CODE_COMBINATION_ID

**Table:** AR_PAYMENT_SCHEDULES_ALL

**Module:** AR

**Holds:** Open items and amounts due remaining.

**Keys:** PAYMENT_SCHEDULE_ID, CUSTOMER_TRX_ID, AMOUNT_DUE_REMAINING, DUE_DATE

**Table:** AR_CASH_RECEIPTS_ALL

**Module:** AR

**Holds:** Customer receipts.

**Keys:** CASH_RECEIPT_ID, RECEIPT_NUMBER, AMOUNT

**Table:** AR_RECEIVABLE_APPLICATIONS_ALL

**Module:** AR

**Holds:** Applications of receipts to transactions.

**Keys:** RECEIVABLE_APPLICATION_ID, CASH_RECEIPT_ID, APPLIED_CUSTOMER_TRX_ID

**Table:** RA_INTERFACE_LINES_ALL

**Module:** AR

**Holds:** Staging table for AutoInvoice.

**Keys:** INTERFACE_LINE_CONTEXT, INTERFACE_LINE_ATTRIBUTE1, BATCH_SOURCE_NAME

**Table:** HZ_PARTIES

**Module:** TCA

**Holds:** Trading Community parties (customers, suppliers, people).

**Keys:** PARTY_ID, PARTY_NAME, PARTY_TYPE

**Table:** HZ_CUST_ACCOUNTS

**Module:** TCA

**Holds:** Customer accounts linked to parties.

**Keys:** CUST_ACCOUNT_ID, PARTY_ID, ACCOUNT_NUMBER

**Table:** FA_ADDITIONS_B

**Module:** FA

**Holds:** Asset master data.

**Keys:** ASSET_ID, ASSET_NUMBER, ASSET_CATEGORY_ID

**Table:** FA_BOOKS

**Module:** FA

**Holds:** Asset cost and depreciation attributes per book.

**Keys:** BOOK_TYPE_CODE, ASSET_ID, COST, DATE_PLACED_IN_SERVICE

**Table:** FA_DEPRN_SUMMARY

**Module:** FA

**Holds:** Depreciation totals per asset, book and period.

**Keys:** BOOK_TYPE_CODE, ASSET_ID, PERIOD_COUNTER

**Table:** XLA_TRANSACTION_ENTITIES

**Module:** SLA

**Holds:** Subledger transactions that have accounting.

**Keys:** ENTITY_ID, APPLICATION_ID, LEDGER_ID, SOURCE_ID_INT_1

**Table:** XLA_AE_HEADERS

**Module:** SLA

**Holds:** Subledger accounting entry headers and GL transfer status.

**Keys:** AE_HEADER_ID, APPLICATION_ID, LEDGER_ID, PERIOD_NAME, GL_TRANSFER_STATUS_CODE

**Table:** XLA_AE_LINES

**Module:** SLA

**Holds:** Subledger accounting entry lines.

**Keys:** AE_HEADER_ID, AE_LINE_NUM, CODE_COMBINATION_ID, ACCOUNTED_DR, ACCOUNTED_CR

**Table:** PO_HEADERS_ALL

**Module:** PO

**Holds:** Purchase order headers.

**Keys:** PO_HEADER_ID, SEGMENT1 (PO number), VENDOR_ID, ORG_ID

**Table:** PO_LINES_ALL

**Module:** PO

**Holds:** Purchase order lines.

**Keys:** PO_LINE_ID, PO_HEADER_ID, LINE_NUM, ITEM_ID

**Table:** PO_DISTRIBUTIONS_ALL

**Module:** PO

**Holds:** PO accounting distributions.

**Keys:** PO_DISTRIBUTION_ID, PO_HEADER_ID, CODE_COMBINATION_ID

**Table:** RCV_TRANSACTIONS

**Module:** PO

**Holds:** Receiving transactions against POs.

**Keys:** TRANSACTION_ID, PO_HEADER_ID, TRANSACTION_TYPE

**Notes:** Columns listed are the ones most reports join on, not the full column list. Release 12 tables ending in _ALL hold data for every operating unit, so filter on ORG_ID or query the MO-secured synonym without _ALL after setting the MO context. Confirm against the Oracle eTRM for your exact release.

## Content

**Intro:** Writing a finance report or reconciliation in EBS starts with knowing which table holds what. This list maps the core GL, AP, AR, FA, SLA and PO tables to what they store and the columns you join on.

**Sections:**

#### How to use the table

**Body:** Search by module code (GL, AP, AR) to see one subledger at a time, or by a word such as 'interface' to find staging tables. Use the key columns as your join path. A typical trace starts at GL_JE_LINES, joins to GL_JE_HEADERS on JE_HEADER_ID, then follows the subledger link through GL_IMPORT_REFERENCES to XLA_AE_LINES and the source transaction.

**Bullets:**

- Filter by module to focus a reconciliation
- Look for 'interface' to find staging and rejection tables
- Export to Excel as a data dictionary for your team

#### The Release 12 data flow

**Body:** In Release 12, subledgers no longer post straight to GL. Payables, Receivables, Fixed Assets and Purchasing create accounting through Subledger Accounting, stored in XLA_AE_HEADERS and XLA_AE_LINES. The Transfer to GL step moves those entries into GL_INTERFACE, and Journal Import turns them into journals in GL_JE_HEADERS and GL_JE_LINES. GL_TRANSFER_STATUS_CODE on XLA_AE_HEADERS tells you whether an entry has reached the GL.

#### Multi-org and _ALL tables

**Body:** Tables ending in _ALL hold rows for all operating units. A query against AP_INVOICES_ALL without an ORG_ID filter returns every operating unit, which is a common reason finance totals do not match a screen. Either filter on ORG_ID, or initialize the apps context with a responsibility and use the secured synonym AP_INVOICES, which applies the MO policy for you.

#### Common mistakes

**Body:** Direct updates to these tables are unsupported and can corrupt accounting. Use them for reading and for reconciliations, and use the public APIs and open interfaces to change data. Another frequent issue is joining GL_BALANCES without the ACTUAL_FLAG and currency filters, which mixes budgets, encumbrances and foreign currency amounts.

**Cta:** Netray can put a read-only natural language layer over your EBS finance tables so analysts ask for a trial balance or an unposted journal list without writing SQL.

**Faq:**

#### Which table holds journal lines in Oracle EBS?

**Answer:** GL_JE_LINES holds journal lines. Join to GL_JE_HEADERS on JE_HEADER_ID for period, source and status, and to GL_CODE_COMBINATIONS on CODE_COMBINATION_ID for the account segments.

#### What is the difference between AP_INVOICES_ALL and AP_INVOICES?

**Answer:** AP_INVOICES_ALL is the base table with data for all operating units. AP_INVOICES is a synonym or view that applies multi-org security for the current context. Use the _ALL table with an ORG_ID filter when running outside an initialized session.

#### How do I know whether a subledger entry reached the GL?

**Answer:** Check GL_TRANSFER_STATUS_CODE on XLA_AE_HEADERS. Entries not yet transferred need the Transfer Journal Entries to GL program. Then confirm Journal Import has created journals from the GL_INTERFACE rows.

#### Can I update these tables with SQL?

**Answer:** No. Oracle does not support direct updates to base tables, and doing so can break accounting integrity and support. Use the standard forms, open interfaces, and published APIs, and keep SQL for reading and reconciliation.

## Search terms

oracle ebs gl tables, oracle apps ap tables list, ap_invoices_all columns, gl_je_lines table, oracle ebs ar tables, oracle ebs finance data model, xla_ae_headers gl_transfer_status_code, oracle apps table names for reports

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json