Oracle Table Reference

AP_INVOICES_ALL

Invoice header — supplier, amount, invoice date, payment terms, currency.

AP_INVOICE_LINES_ALL

Invoice line detail — item/expense lines tied to a header.

AP_INVOICE_DISTRIBUTIONS_ALL

Accounting distributions generated from invoice lines for GL posting.

AP_PAYMENT_SCHEDULES_ALL

Scheduled payment installments for an invoice, including due dates and amounts remaining.

AP_INVOICE_PAYMENTS_ALL

Links invoices to the payments (checks/EFT) that settled them.

AP_HOLDS_ALL

Holds placed on an invoice (matching, tax, variance, etc.) that block payment/accounting.

AP_CHECKS_ALL

Payment (check/EFT) header issued to a supplier.

RA_CUSTOMER_TRX_ALL

AR transaction header — invoice, credit memo, or debit memo issued to a customer.

RA_CUSTOMER_TRX_LINES_ALL

Transaction line detail — revenue, tax, freight, and rounding lines.

RA_CUST_TRX_LINE_GL_DIST_ALL

GL distribution generated from transaction lines for accounting.

AR_CASH_RECEIPTS_ALL

Customer receipt header — amount received and receipt method.

AR_RECEIVABLE_APPLICATIONS_ALL

Links a cash receipt to the transaction(s) it pays, closing the AR balance.

GL_JE_HEADERS

Journal entry header — batch, ledger, period, source, status.

GL_JE_LINES

Journal entry line — account, debit/credit amount.

GL_CODE_COMBINATIONS

Chart of accounts code combinations — the valid account segment strings journals post to.

GL_BALANCES

Period-level actual/budget/encumbrance balances by code combination.

GL_PERIODS

Accounting period definitions and open/close status.

XLA_AE_HEADERS

Subledger accounting event header — the accounting entry generated from a subledger transaction, before/alongside its GL journal.

XLA_AE_LINES

Subledger accounting event line — the account and debit/credit amount for one accounting distribution.

FA_ADDITIONS_B

Asset header — description, category, and unique asset identifier.

FA_BOOKS

Assigns an asset to a depreciation book — cost, life, method, and in-service date for that book.

FA_DEPRECIATION_HISTORY

Depreciation expense recorded for an asset in a given period, by depreciation run.

CE_BANK_ACCOUNTS

Internal bank account definitions used for payments, receipts, and reconciliation.

CE_STATEMENT_HEADERS_ALL

Bank statement header — one row per statement loaded for reconciliation.

CE_STATEMENT_LINES

Individual bank statement line — one transaction to be matched/reconciled against a payment or receipt.

ZX_LINES

Tax line calculated by the tax engine for a transaction line — tax rate, amount, and jurisdiction.

ZX_TAXES_B

Tax definitions — the configured taxes (e.g. VAT, Sales Tax) available to be applied.

HZ_PARTIES

Trading Community Architecture (TCA) party master — the underlying person or organization, independent of any role (customer, supplier, contact) it plays.

HZ_RELATIONSHIPS

Generic party-to-party relationship — e.g. a person party related to an organization party as its contact.

HZ_ORG_CONTACTS

Specializes a HZ_RELATIONSHIPS row into a named contact for an organization party, carrying the contact's role attributes.

HZ_CONTACT_POINTS

Actual contact-method details (phone, email, etc.) for a party — this, not HZ_PARTY_SITES, is where phone/email actually live.

HZ_CUST_ACCOUNTS

Customer account — the transactable 'customer' entity AR and Order Management actually bill and ship to, layered on top of a TCA party.

HZ_PARTY_SITES

A physical site (address) tied to a party, independent of any specific customer account's use of it.

HZ_CUST_ACCT_SITES_ALL

Links a customer account to one of its party's sites, making that address usable for that specific account.

HZ_CUST_SITE_USES_ALL

The business-purpose assignment of an account site (Bill-To, Ship-To, etc.) — what AR and Order Management actually reference when defaulting an address onto a transaction.

AP_TERMS_B

Payment terms header — the named terms (e.g. 'Net 30', '2/10 Net 30') applied to invoices and POs.

AP_HOLD_CODES

Hold code setup — the definitions (name, type, postable flag) behind rows in AP_HOLDS_ALL.

AP_PAYMENT_HISTORY_ALL

Payment lifecycle events — creation, clearing, void and reissue rows for a payment, each separately accounted.

IBY_PAYMENTS_ALL

Oracle Payments — the actual payment created by a payment process request, before it becomes an AP check row.

IBY_DOCS_PAYABLE_ALL

Documents payable — one row per invoice selected into a payment, carrying the paid amount and discount taken.

IBY_EXT_BANK_ACCOUNTS

External bank accounts — supplier (and customer) bank account details used for electronic payments and receipts.

AR_PAYMENT_SCHEDULES_ALL

Open receivables balances — one row per transaction or receipt with original and remaining amount due.

AR_ADJUSTMENTS_ALL

Receivables adjustments — write-offs and manual changes to an invoice's outstanding balance.

AR_DISTRIBUTIONS_ALL

Receivables accounting distributions for receipts, adjustments and miscellaneous transactions (not invoices).

RA_CUSTOMER_TRX_TYPES_ALL

Transaction type setup — controls whether a transaction class posts to GL, opens a receivable, and its default accounts.

AR_CASH_RECEIPT_HISTORY_ALL

Receipt state history — the CONFIRMED / REMITTED / CLEARED / REVERSED steps a receipt passes through, each accounted.

HZ_CUSTOMER_PROFILES

Credit profile for a customer account or site — credit hold, collector, profile class and payment terms.

GL_LEDGERS

Ledger definitions — chart of accounts, currency, calendar and accounting method for a ledger.

GL_JE_BATCHES

Journal batches — the container a set of journals is entered, posted and reversed in.

GL_IMPORT_REFERENCES

Drill-down bridge — links each imported GL journal line back to the subledger transaction that created it.

GL_DAILY_RATES

Daily currency conversion rates by rate type — used to convert entered amounts to ledger currency.

GL_PERIOD_STATUSES

Period open/close status per ledger and application — controls whether a subledger or GL can post to a period.

GL_INTERFACE

Journal import staging table — external and FBDI journal lines wait here for the Import Journals process.

FA_CATEGORIES_B

Asset category setup — the category flexfield combinations that drive default accounts and depreciation rules.

FA_DISTRIBUTION_HISTORY

Where an asset is assigned over time — expense account, location and employee, with effective date ranges.

FA_TRANSACTION_HEADERS

Every asset transaction — addition, cost/units adjustment, transfer, reclass, retirement and reinstatement.

FA_ADJUSTMENTS

The accounting effect of an asset transaction — cost, reserve, expense and CIP rows with debit/credit and account.

FA_RETIREMENTS

Asset retirements — full and partial retirements with cost retired, proceeds of sale and cost of removal.

CE_STATEMENT_RECONCILS_ALL

Reconciliation links — connects a bank statement line to the payment, receipt or journal it clears.

CE_TRANSACTION_CODES

Bank transaction code mapping — translates the codes on an imported statement into a transaction type.

ZX_RATES_B

Tax rate definitions — the percentage (or quantity) rate for a tax, status and jurisdiction, with effective dates.

ZX_JURISDICTIONS_B

Tax jurisdictions — the geographic area a tax applies in (state, county, city), tied to a TCA geography.

ZX_REGIMES_B

Tax regimes — the top-level set of tax rules for a country or economic zone (e.g. a country's VAT regime).

XLA_TRANSACTION_ENTITIES

The subledger 'entity' a set of accounting events belongs to — e.g. one AP invoice or one AR receipt.

XLA_EVENTS

Accounting events — the business events a subledger raises for accounting (e.g. 'Invoice Validated', 'Payment Cleared').

XLA_DISTRIBUTION_LINKS

Links a subledger transaction distribution (e.g. an AP invoice distribution) to the SLA journal line it produced.

HZ_LOCATIONS

Physical addresses in TCA — the raw address rows that party sites and customer sites point to.

HZ_GEOGRAPHIES

Geography master — the hierarchy of countries, states, counties, cities and postal codes used for address validation and tax.

HZ_ORGANIZATION_PROFILES

Organization party profile — date-effective descriptive attributes of an organization party (legal name, DUNS, size).

PO_REQUISITION_HEADERS_ALL

Requisition header — preparer, requisitioning BU, status.

PO_REQUISITION_LINES_ALL

Requisition line — item, quantity, need-by date, destination.

PO_HEADERS_ALL

Purchase order header — supplier, PO type, status.

PO_LINES_ALL

PO line — item, quantity, unit price.

PO_DISTRIBUTIONS_ALL

PO distribution — charge account and quantity ordered per accounting distribution.

RCV_SHIPMENT_HEADERS

Receipt header — supplier shipment received against one or more POs.

RCV_SHIPMENT_LINES

Receipt line — item and quantity received against a PO line.

POZ_SUPPLIERS

Supplier (vendor) header — the master record for a company or individual that Procurement and Payables transact with.

POZ_SUPPLIER_SITES_ALL_M

Supplier site — a specific address and purpose (ordering, pay/remit-to, RFQ) for a supplier; purchase orders and invoices reference a site, not just the supplier header.

PO_LINE_LOCATIONS_ALL

PO schedules (shipments) — the delivery-level detail: ship-to, need-by date, quantity, price and match option.

PO_RELEASES_ALL

Blanket and planned PO releases — an individual order placed against a blanket purchase agreement.

PO_REQ_DISTRIBUTIONS_ALL

Requisition distributions — the accounting split of a requisition line across code combinations and projects.

PO_ACTION_HISTORY

Approval and action audit trail for purchasing documents — submit, approve, reject, forward, cancel per document.

PO_VENDORS

Supplier master (EBS) — supplier name, number, type and payment defaults. Fusion uses POZ_SUPPLIERS.

RCV_TRANSACTIONS

Receiving transactions — RECEIVE, DELIVER, RETURN TO VENDOR, CORRECT and inspection rows against a PO shipment.

RCV_TRANSACTIONS_INTERFACE

Receiving open interface — ASNs and receipts staged for the Receiving Transaction Processor.

DOO_HEADERS_ALL

Sales order header — customer, order type, business unit, order status.

DOO_LINES_ALL

Sales order line — item, quantity, and requested schedule for a header.

DOO_FULFILL_LINES_ALL

Fulfillment line tracking the orchestration/fulfillment status of a sales order line (scheduling, reservation, shipping, invoicing).

WSH_NEW_DELIVERIES

Delivery header grouping one or more lines for pick/ship confirm.

WSH_DELIVERY_DETAILS

Delivery line — item and quantity being picked/shipped, linked back to the order fulfillment line.

WSH_DELIVERY_ASSIGNMENTS

Links a delivery detail (line) to the delivery it's currently grouped into.

WSH_TRIPS

Trip header — a transportation run (e.g. one truck's route) that one or more deliveries are planned onto.

WSH_TRIP_STOPS

A stop (pickup or dropoff location) on a trip — deliveries are planned onto a stop, not the trip directly.

EGP_SYSTEM_ITEMS_B

Item master — one row per item per organization, with attributes like item type, status, and UOM.

MTL_ONHAND_QUANTITIES_DETAIL

Current on-hand quantity for an item by subinventory/locator.

MTL_SECONDARY_INVENTORIES

Subinventory definition — a named storage area within an inventory organization (e.g. Stores, Staging, Damaged, Finished Goods) that on-hand quantity and transactions are tracked against.

MTL_ITEM_LOCATIONS

Locator definition — a specific row/rack/bin (or other physical subdivision) within a subinventory, used where locator control tracks inventory at that granularity.

MTL_MATERIAL_TRANSACTIONS

Historical log of every inventory transaction (receipt, issue, transfer, adjustment) that moved or changed on-hand quantity.

MTL_PARAMETERS

Inventory organization definition and parameters.

MTL_TRANSACTION_TYPES

Lookup of predefined inventory transaction types (Miscellaneous Issue, Miscellaneous Receipt, Subinventory Transfer, etc.) that classify each row on MTL_MATERIAL_TRANSACTIONS.

MTL_LOT_NUMBERS

Lot definition for a lot-controlled item — one row per lot number, with expiration and grade attributes where applicable.

MTL_SERIAL_NUMBERS

Serial number definition and current status/location for a serial-controlled item — one row per physical unit.

WIP_ENTITIES

Work order (discrete job) identity — number, type, and the item it produces.

WIP_DISCRETE_JOBS

Discrete job header — quantities, dates, and status for a work order.

CST_ITEM_COST_DETAILS

Current cost of an item by cost element (material, overhead, etc.) and cost level, within a cost organization/book.

CST_LAYER_COST_DETAILS

Perpetual (average/FIFO) cost layer detail — the quantity/cost layers a perpetual costing method maintains as receipts and issues consume them.

CST_AE_HEADERS

Cost accounting distribution header — the accounting entry Cost Accounting generates from a costed inventory/WIP transaction, ahead of its GL journal.

CST_AE_LINES

Cost accounting distribution line — the account and debit/credit amount for one cost accounting distribution.

MTL_SYSTEM_ITEMS_B

Item master (EBS) — one row per item per inventory organization, with primary UOM, item type and control flags.

MTL_ITEM_CATEGORIES

Item ↔ category assignments — which category an item falls into within each category set.

MTL_CATEGORIES_B

Category definitions — the category flexfield combinations items are classified with.

MTL_RESERVATIONS

Reservations — hard links between a supply (on-hand, PO, WIP) and a demand (sales order, WIP component).

MTL_SUPPLY

Inbound supply picture — open purchase orders, requisitions, intransit shipments and WIP jobs feeding stock.

MTL_TXN_REQUEST_HEADERS

Move order headers — a request to move material between subinventories or issue it to an account / job.

MTL_TXN_REQUEST_LINES

Move order lines — item, quantity, source and destination subinventory, and the line's allocation / transact status.

WSH_DELIVERY_LEGS

Delivery legs — one row per pickup/drop-off stop pair a delivery travels through on its trip.

OE_ORDER_HEADERS_ALL

Sales order headers (EBS) — customer, order type, currency and workflow status for an order. Fusion uses DOO_HEADERS_ALL.

OE_ORDER_LINES_ALL

Sales order lines (EBS) — item, ordered quantity, ship-from org, pricing and per-line workflow status.

OE_TRANSACTION_TYPES_ALL

Order and line transaction types (EBS) — the workflow, defaulting rules and category for an order or line.

OE_PRICE_ADJUSTMENTS

Price adjustments (EBS) — discounts, surcharges and promotions applied to an order or line by the pricing engine.

WIP_OPERATIONS

Routing operations on a job — the sequence of steps a discrete job passes through, with quantities at each.

WIP_REQUIREMENT_OPERATIONS

Component (material) requirements for a job — what item is needed at which operation, and how much is issued.

WIP_MOVE_TRANSACTIONS

Move transactions — the record of assemblies moving between operations and intraoperation steps (queue → run → to move).

BOM_STRUCTURES_B

Bill of material header — links an assembly item to its component structure in an organization.

BOM_COMPONENTS_B

Bill of material component lines — each child item, its per-assembly quantity and effective date range.

BOM_OPERATIONAL_ROUTINGS

Routing header — links an assembly item to the sequence of operations used to make it in an organization.

PJF_PROJECTS_ALL_B

Project definitions — number, type, owning organization, dates and status.

PJF_PROJECTS_ALL_TL

Translated (multi-language) project name and description.

PJF_PROJECT_TYPES_B

Project type setup — controls burdening, capitalization, billing and class of each project.

PJF_PROJ_ELEMENTS_B

Work breakdown structure elements — the tasks (and financial task rollups) under a project.

PJF_PROJECT_PARTIES

Project team members and their project roles (project manager, team member, customer, etc.).

PJF_EXP_TYPES_B

Expenditure type setup — the cost classification (labor, supplies, travel) on every project transaction.

PJC_EXPENDITURES_ALL

Expenditure batch header — groups expenditure items entered together (timecards, expense reports, misc).

PJC_EXP_ITEMS_ALL

Costed expenditure items — one row per project transaction with quantity, raw cost and burdened cost.

PJC_COST_DIST_LINES_ALL

Accounting distribution lines for an expenditure item — the debits and credits sent to Subledger Accounting.

PJC_TXN_XFACE_ALL_B

Transaction import interface — third-party and external costs staged for Import Costs to bring into PPM.

PJO_PLAN_VERSIONS_B

Budget and forecast plan versions for a project — one current baselined version per plan type.

PJO_PLANNING_ELEMENTS

Budget/forecast planning elements — a planned amount at a task + resource (RBS) intersection.

PJO_PLAN_LINES

Period-level planned amounts for a planning element — quantity, raw cost, burdened cost and revenue by period.

PJB_INVOICE_HEADERS_ALL

Project contract invoice headers — draft and released invoices generated from billing events and rate-based work.

PJB_INVOICE_LINES_ALL

Project invoice lines — amount by contract line / task, transferred to Receivables as AR invoice lines.

PJB_BILL_TRANSACTIONS

Billing transactions — the revenue and invoice amounts recognized from expenditure items and events.

PER_ALL_PEOPLE_F

Person records — one date-effective row set per person, holding person number and identifiers.

PER_PERSONS

Non-date-effective person base row — the stable PERSON_ID ↔ PARTY_ID link and person number.

PER_PERSON_NAMES_F

Person names — date-effective, one row per name type (GLOBAL, LEGAL, etc.).

PER_ALL_ASSIGNMENTS_M

Employment assignments — job, grade, position, department, payroll and status, date-effective per person.

PER_PERIODS_OF_SERVICE

Work relationship periods — hire date, termination date and legal employer for each period of service.

PER_PERSON_TYPES

Person type setup — maps a user person type (e.g. 'Employee', 'Retiree') to a system person type.

PER_JOBS_F

Job definitions — date-effective jobs referenced by assignments and positions.

PER_GRADES_F

Grade definitions — date-effective grades, optionally with grade rates / steps.

HR_ALL_POSITIONS_F

Position definitions — date-effective positions with their job, department, grade and headcount.

HR_ALL_ORGANIZATION_UNITS_F

Organizations — date-effective base rows for departments, legal entities, business units and divisions.

HR_ORGANIZATION_UNITS_F_TL

Translated organization names — join to resolve the display name of a department or business unit.

HR_LOCATIONS_ALL

Work locations — address and identifying details for a physical site used by organizations and assignments.

PER_ASSIGNMENT_SUPERVISORS_F

Manager relationships per assignment — supports multiple manager types (line, project, functional).

PER_ASSIGNMENT_STATUS_TYPES

Assignment status setup — maps a user status (e.g. 'Active - Payroll Eligible') to a HR/payroll system status.

PER_EMAIL_ADDRESSES

Person email addresses — one row per email type (work, home) per person.

PER_PHONES

Person phone numbers — date-ranged, one row per phone type (work, mobile, home).

PER_NATIONAL_IDENTIFIERS

National identifiers — government-issued IDs (SSN, NI number, etc.) per person and country.

PAY_ALL_PAYROLLS_F

Payroll definitions — a payroll's period type, calendar and default payment method.

PAY_PAYROLL_REL_GROUPS_DN

Payroll relationships — the person ↔ payroll statutory unit link that payroll results are calculated against.

PAY_PAYROLL_ACTIONS

Payroll process runs — one row per submitted payroll process (calculate, prepayments, archive, etc.).

PAY_PAYROLL_REL_ACTIONS

Per-person payroll processing rows — the result of a payroll action for one payroll relationship.

PAY_RUN_RESULTS

Element run results — one row per element processed for a person in a payroll run.

PAY_RUN_RESULT_VALUES

Run result values — the numeric results (Pay Value, Hours, Rate) behind each element run result.

PAY_ELEMENT_TYPES_F

Element definitions — earnings, deductions and information elements, with their classification.

PAY_ELEMENT_ENTRIES_F

Element entries — an element assigned to a person / assignment, driving what payroll picks up each period.

FND_LOOKUP_TYPES_B

Lookup type headers — the code list definitions (e.g. YES_NO, INVOICE_TYPE) that group lookup values.

FND_LOOKUP_VALUES

Lookup values — the code, meaning and description rows behind every lookup type, per language.

FND_FLEX_VALUE_SETS

Value set definitions — validation type, format and security for a list of values used by flexfields.

FND_FLEX_VALUES_B

Flexfield / value set values — the individual valid values (e.g. cost centre codes) and their enabled state.

FND_FLEX_VALUES_TL

Translated flexfield value descriptions — join to show a readable label for a segment value.

FND_ID_FLEX_SEGMENTS

Key flexfield segment definitions — the segments of a KFF structure (e.g. the GL Accounting Flexfield) and their value sets.

FND_DESCR_FLEX_COLUMN_USAGES

Descriptive flexfield (DFF) segment definitions — which ATTRIBUTE column each context's segment maps to.

FND_DOCUMENTS

Attachment document registry — one row per uploaded file, URL or short text attachment.

FND_ATTACHED_DOCUMENTS

Links an attachment to a specific business record via entity name and primary key values.

FND_CURRENCIES

Currency definitions — ISO code, precision, minimum accountable unit and enabled state.

FND_TERRITORIES

Country / territory definitions — ISO territory code, description and default currency.

FND_LANGUAGES

Language registry — the installed and available NLS languages that drive _TL table rows.

FND_CONCURRENT_PROGRAMS

Concurrent program definitions — the executable, parameters and defaults for a submittable process.

FND_CONCURRENT_REQUESTS

Concurrent request instances — every submitted job with its phase, status, parameters and timing.

FND_PROFILE_OPTION_VALUES

Profile option values set at site, application, responsibility or user level.

ESS_REQUEST_HISTORY

Fusion scheduled process (ESS) request history — one row per job submission with state and timing.

ESS_REQUEST_PROPERTY

Name/value properties of an ESS request — submission parameters, submitting user, and internal flags.

FND_SETID_SETS_B

Reference data sets (SetID) — the sets that partition shared setup data such as payment terms and units of measure.

FND_USER

Application user accounts — login, linked person, and start/end dates. The root of EBS security.

FND_RESPONSIBILITY_TL

Responsibilities — the named access bundle (menu + data group + request group) a user signs in under.

FND_USER_RESP_GROUPS

User ↔ responsibility assignments — which responsibilities each user holds and for what date range.