Search Results ap_inv_aprvl_hist_all




Overview
Explore in AI Chat

Overview

AP_INV_APRVL_HIST_ALL is an Oracle Payables application table owned by the AP schema that stores the complete approval and rejection audit trail for invoices processed through the Oracle Invoice Approval Workflow (IAW). Each time an invoice is routed for approval, the workflow engine inserts one row for every approver assigned to review that invoice, capturing the approver's identity, the amount approved, the approver's response, and any comments supplied during the review. Because the table stores the transactional outcome of each approval event rather than the invoice itself, it functions as the historical record of the approval lifecycle.

From a dimensional modeling perspective, the table's foreign key structure suggests a satellite-leaning classification. The single documented foreign key, INVOICE_ID referencing AP_INVOICES_ALL, identifies the parent business entity, while the descriptive attributes (approver, response, comments, amount) are event-scoped and change over time. Designers building a Data Vault model may therefore treat AP_INV_APRVL_HIST_ALL as a satellite hanging off an AP_INVOICES_ALL hub, with the approval history rows representing discrete state changes rather than a standalone hub or link.

Key Information Stored

The table contains 21 documented columns. The most significant include:

  • APPROVAL_HISTORY_ID — the surrogate primary key, enforced by unique index AP_INV_APRVL_HIST_U1. This is the technical identifier for each approval event.
  • INVOICE_ID — the foreign key to AP_INVOICES_ALL, linking the history row to the invoice under review. This is the primary business join column.
  • ITERATION — tracks successive passes through the approval process, allowing multiple rounds of review per invoice.
  • RESPONSE — the approver's action, such as approve, reject, or reassign.
  • APPROVER_ID and APPROVER_NAME — the system identifier and display name of the assigned approver.
  • AMOUNT_APPROVED — the monetary amount the approver authorized at that step.
  • APPROVER_COMMENTS — free-text remarks captured from the approver.
  • NOTIFICATION_ORDER — the sequence in which approvers were notified.
  • HISTORY_TYPE — categorizes the history record (for example, approval versus rejection activity).
  • HOLD_ID and LINE_NUMBER — contextual references to holds or invoice lines associated with the approval.
  • ORG_ID — the operating unit, supporting multi-org data security.
  • ORIG_SYSTEM and ITEM_ID — identify the originating system and item for externally sourced approvals.
  • CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Payables administrators and auditors routinely query this table to reconstruct who approved an invoice, in what order, and with what comments. A typical query joins to AP_INVOICES_ALL to return invoice number and vendor alongside approver details:

  • Approval audit reports — SELECT h.INVOICE_ID, h.APPROVER_NAME, h.RESPONSE, h.AMOUNT_APPROVED, h.CREATION_DATE FROM AP_INV_APRVL_HIST_ALL h WHERE h.INVOICE_ID = :invoice_id ORDER BY h.ITERATION, h.NOTIFICATION_ORDER;
  • Approval cycle-time analysis — comparing CREATION_DATE across ITERATION values to measure elapsed approval time.
  • Rejection trend reporting — filtering on RESPONSE and HISTORY_TYPE to quantify rejected invoices.
  • Reconciliation of authorized amounts — summing AMOUNT_APPROVED against the invoice total in AP_INVOICES_ALL.
  • Workflow troubleshooting — inspecting NOTIFICATION_ORDER and ITERATION where invoices appear stalled.

Related Objects

The table's relationships center on the invoice entity and the workflow infrastructure:

  • AP_INVOICES_ALL — the parent table; join on INVOICE_ID = AP_INVOICES_ALL.INVOICE_ID.
  • AP_INVOICE_LINES_ALL — provides line-level detail for approvals referencing LINE_NUMBER.
  • AP_HOLDS_ALL — relates through HOLD_ID for hold-driven approvals.
  • FND_USER — resolves APPROVER_ID to a valid application user.
  • WF_ITEM_ACTIVITY_STATUSES / WF_NOTIFICATIONS — the Workflow runtime tables that generate the notification records summarized here.
  • AP_INV_APRVL_HIST_ALL — is commonly exposed through custom views and Oracle Payables invoice inquiry forms.