Search Results ap_expense_reports




Overview
Explore in AI Chat

Overview

AP.AP_EXPENSE_REPORTS_ALL is the header-level definition table for expense report templates in Oracle Payables. Each row represents a template that users select from a list of values when entering an expense report, and the table corresponds directly to the header region of the Expense Report Templates window in the E-Business Suite forms interface. In Oracle EBS 12.1.1 and 12.2.2, this object is owned by the AP schema, carries FND Design Data identifier SQLAP.AP_EXPENSE_REPORTS_ALL, and resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10. Because the table governs the template selection and defaulting behavior used during expense report entry, it sits at the center of the Oracle Payables and Oracle Self-Service Expenses configuration model.

Mined from its foreign key structure, the table exhibits a hub-leaning Data Vault classification. This is a modeling suggestion rather than a physical constraint: EXPENSE_REPORT_ID behaves as a durable business key referenced by multiple dependent tables, which is characteristic of a hub entity in a dimensional or Data Vault style model.

Key Information Stored

The physical schema in 12.2.2 documents thirteen columns. The most significant are:

Common Use Cases and Queries

Typical reporting and validation scenarios include listing the active, web-enabled templates available to a given operating unit, auditing template changes, and confirming the default parameter assigned to each template. A representative query joining the parameter table is:

  • SELECT h.expense_report_id, h.report_type, h.description, h.web_enabled_flag FROM ap.ap_expense_reports_all h WHERE h.org_id = :org_id AND h.inactive_date IS NULL ORDER BY h.report_type;
  • SELECT h.report_type, p.expense_param_name FROM ap.ap_expense_reports_all h, ap.ap_expense_report_params_all p WHERE h.default_parameter_id = p.expense_report_param_id;

Because the header tables depend on the template row, these queries are also useful before deleting or end-dating a template to confirm that no expense report headers or system parameter defaults still reference it.

Related Objects

The following objects reference AP_EXPENSE_REPORTS_ALL or are referenced by it through documented foreign keys:

  • AP_EXPENSE_REPORT_PARAMS_ALL — references EXPENSE_REPORT_ID and is itself referenced by DEFAULT_PARAMETER_ID.
  • AP_EXPENSE_REPORT_HEADERS_ALL — transaction-level expense report headers pointing to the template via EXPENSE_REPORT_ID.
  • AP_SYSTEM_PARAMETERS_ALL — holds the system-level default expense report template through EXPENSE_REPORT_ID.
  • AP_AUD_QUEUES — audit queue entries referencing EXPENSE_REPORT_ID.

Together these objects form the expense template configuration and transaction chain within Oracle Payables.