Results for “maximum_amount_to_apply”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_EXPENSE_REPORT_HEADERS_ALL is the core Oracle Payables table that stores header-level information for employee expense reports in Oracle E-Business Suite 12.1.1 and 12.2.2. Owned by the AP schema and classified as VALID, the table acts as the central anchor for the expense report lifecycle, from submission through manager approval, audit, accounting, and finally payment via an invoice in AP_INVOICES_ALL. Because expense reports ultimately create payables invoices, this table sits at the intersection of the Payables and Internet Expenses (OIE) flows.

From a dimensional modeling perspective, the heuristic Data Vault classification derived from its foreign key structure is satellite-leaning. This means the table is best understood as a descriptive attribute container surrounding a business key (the expense report), rather than a pure hub or link. The unique index AP_EXPENSE_REPORT_HEADERS_U1 on REPORT_HEADER_ID supports its interpretation as a business-key-bearing satellite.

Key Information Stored

The table contains 116 documented columns. The most operationally significant include:

• REPORT_HEADER_ID — the surrogate primary key (AP_EXPENSE_REPORT_HEADERS_PK) and sole column of the unique index U1; the true business/technical key for the header.
• EXPENSE_REPORT_ID — foreign key to AP_EXPENSE_REPORTS_ALL, tying the header to its parent report definition and template.
• EMPLOYEE_ID — the reporting employee, referencing PSB_EMPLOYEES; also EMPLOYEE_CCID for the employee liability account.
• WEEK_END_DATE / REPORT_FILING_NUMBER / REPORT_SUBMITTED_DATE — reporting period and filing identity for the expense report.
• VOUCHNO / INVOICE_NUM — the resulting AP invoice linkage into AP_INVOICES_ALL.
• TOTAL — the header expense total used in reconciliation and approval routing.
• VENDOR_ID / VENDOR_SITE_ID — payee supplier for the reimbursement, from PO_VENDORS and PO_VENDOR_SITES_ALL.
• ACCTS_PAY_CODE_COMBINATION_ID / SET_OF_BOOKS_ID — accounting flexfield and ledger context (GL_CODE_COMBINATIONS, GL_SETS_OF_BOOKS_11I).
• HOLD_LOOKUP_CODE — current hold applied to the report (AP_HOLD_CODES).
• WORKFLOW_APPROVED_FLAG / EXPENSE_STATUS_CODE / EXPENSE_CURRENT_APPROVER_ID / OVERRIDE_APPROVER_ID — approval workflow state.
• AUDIT_CODE / LAST_AUDITED_BY / RETURN_REASON_CODE — audit trail and return-to-employee outcomes.
• DEFAULT_CURRENCY_CODE / DEFAULT_EXCHANGE_RATE_TYPE / PAYMENT_CURRENCY_CODE — currency and conversion metadata.
• REQUEST_ID — the concurrent request that generated or last touched the row.

Common Use Cases and Queries

Typical scenarios include expense report reconciliation to AP invoices, approval and hold status reporting, audit dashboards, and expense analytics by employee or cost center.

• Join the header to AP_EXPENSE_REPORT_LINES_ALL on REPORT_HEADER_ID to obtain line-level expense detail.
• Join to AP_INVOICES_ALL on VOUCHNO or ADVANCE_INVOICE_TO_APPLY to trace reimbursement invoices and applied advances.
• Filter on HOLD_LOOKUP_CODE or EXPENSE_STATUS_CODE for pending approvals and held reports.
• Query SET_OF_BOOKS_ID for ledger-specific reporting.

A representative pattern:

• SELECT h.REPORT_HEADER_ID, h.EMPLOYEE_ID, h.TOTAL, h.VOUCHNO, h.EXPENSE_STATUS_CODE FROM AP_EXPENSE_REPORT_HEADERS_ALL h WHERE h.SET_OF_BOOKS_ID = :ledger AND h.WEEK_END_DATE BETWEEN :from AND :to;

Related Objects

Dependency and reference relationships documented in the ETRM metadata include:

• AP_EXPENSE_REPORT_LINES_ALL — child detail lines via REPORT_HEADER_ID.
• AP_EXP_REPORT_DISTS_ALL — accounting distributions for the report via REPORT_HEADER_ID.
• AP_INVOICES_ALL — the payables invoice created for reimbursement and any advance invoices (ADVANCE_INVOICE_TO_APPLY, VOUCHNO).
• AP_EXPENSE_REPORTS_ALL — the parent report/template referenced by EXPENSE_REPORT_ID.
• PO_VENDORS / PO_VENDOR_SITES_ALL — supplier and site for the payee.
• GL_CODE_COMBINATIONS — employee and payables accounts (EMPLOYEE_CCID, ACCTS_PAY_CODE_COMBINATION_ID).
• FND_USER / FND_CONCURRENT_REQUESTS — auditing approver and concurrent process linkage.
• AP_CREDIT_CARD_TRXNS_ALL and AP_AUD_AUDIT_REASONS — referencing tables via REPORT_HEADER_ID.