Search Results expense_check_address_flag




Overview
Explore in AI Chat

Overview

AP_EXPENSE_REPORT_HEADERS_V is an Oracle Payables (AP) view owned by the APPS schema. It presents expense report header information and serves as the foundation for the Expense Report History feature in Oracle Internet Expenses (OIE). The view exposes a denormalized projection of expense report data, combining the underlying Payables expense report header records with derived attributes such as employee name, currency conversion details, and organizational context. Because it is a view rather than a base table, it provides read-only access to a curated set of columns suitable for inquiry screens, reporting, and integration logic that must reflect the current state of expense report submissions.

The view is a documented, VALID object in ETRM for both 12.1.1 and 12.2.2. Its primary role is to surface expense report history to end users and to support the OIE expense workflow, where submitted reports, their approval status, currency, and totals must be reconciled against Payment and Human Resources data.

Underlying Base Objects

The view is defined over a set of AP and shared objects. The principal base object is AP_EXPENSE_REPORT_HEADERS (exposed via an APPS synonym), from which the majority of columns—including DEFAULT_CURRENCY_CODE, ACCOUNTING_DATE, EXPENSE_REPORT_ID, TOTAL, and the ATTRIBUTE1–15 flexfield columns—are drawn. It also references AP_EXPENSE_REPORTS, AP_AWT_GROUPS (withholding tax groups), and FINANCIALS_SYSTEM_PARAMETERS.

Key Columns

The view carries a broad set of columns mapping directly to header attributes. For the user search term DEFAULT_CURRENCY_CODE, this column identifies the default currency for the expense report and is central to currency conversion behavior. It works alongside DEFAULT_EXCHANGE_DATE, DEFAULT_EXCHANGE_RATE, and DEFAULT_EXCHANGE_RATE_TYPE, which together define how foreign-currency expense lines are converted into the functional currency of the ledger.

Common Use Cases and Queries

Typical usage includes expense history inquiries in OIE, reconciliation reporting by operating unit, and identifying reports by default currency. A sample query filtering on the searched column is shown below.

  • Report expense reports by default currency and ledger.
  • Reconcile expense report totals against AP invoices.
  • Track rejected or held reports by employee.
  • Feed OIE Expense Report History and custom BI Publisher reports.

SELECT expense_report_id, invoice_num, employee_id, default_currency_code, total
FROM apps.ap_expense_report_headers_v
WHERE default_currency_code = 'USD'
  AND org_id = :p_org_id;

Because the object is a view, no DML is permitted; all maintenance must target the underlying base tables. This preserves data integrity while allowing flexible read access for reporting and integration.