Results for “ap_inv_aprvl_hist_u1”

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

Overview

AP.AP_INV_APRVL_HIST_ALL is a transactional table in the Oracle E-Business Suite Payables (AP) module that stores the approval and rejection history of each invoice processed through the Invoice Approval Workflow. Every time an invoice is routed for approval, the workflow inserts one record per approver assigned to review that invoice. The table therefore acts as an audit trail of approver responses and corresponds directly to the Invoice Approval History window in the Payables application. It is owned by the AP schema (FND Design Data: SQLAP.AP_INV_APRVL_HIST_ALL), resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and holds 21 documented columns in the 12.2.2 schema.

From a Data Vault modeling perspective, the heuristic classification supplied in the metadata is satellite-leaning. This reflects the table's role as a descriptive, event-driven record keyed to an invoice and an approval event, rather than as a pure hub or link. The suggestion is that INVOICE_ID and the approval history key function as the anchoring business keys, while the remaining attributes act as descriptive satellites capturing approver responses over time.

Key Information Stored

The table's surrogate primary key is APPROVAL_HISTORY_ID, a NUMBER(15) column that uniquely identifies each approval history row. This column is enforced by the unique index AP_INV_APRVL_HIST_U1, which the user searched for and which serves as the documented business-key candidate. A second index, AP_INV_APRVL_HIST_N1, is non-unique and defined on INVOICE_ID to support invoice-level lookups.

• INVOICE_ID — Foreign key to AP.AP_INVOICES_ALL; identifies the invoice under review.
• ITERATION — Count of times the invoice has passed through the Invoice Approval Workflow.
• RESPONSE — The approver's response (for example, approve or reject).
• APPROVER_ID — Identifier of the assigned approver.
• AMOUNT_APPROVED — Invoice amount at the time of the approver's response.
• APPROVER_COMMENTS — Free-text comments entered by the approver.
• NOTIFICATION_ORDER — Sequence in which notifications were sent to approvers.
• ORIG_SYSTEM — Originating system for the approver identifier.
• ITEM_CLASS — The AME (Approvals Management Engine) item class.
• ITEM_ID, LINE_NUMBER, HOLD_ID, HISTORY_TYPE — Supporting identifiers and categorization for the history record.
• ORG_ID — Organization identifier enabling multi-org (MOAC) security.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Note that APPROVER_NAME is retained for compatibility but is documented as no longer used.

Common Use Cases and Queries

Typical uses include auditing the approval chain for a specific invoice, reporting on approver turnaround, and reconstructing the sequence of responses for compliance purposes. A common query pattern retrieves the full approval trail for one invoice:

• Invoice approval trail: SELECT approval_history_id, invoice_id, iteration, response, approver_id, amount_approved, notification_order FROM ap_inv_aprvl_hist_all WHERE invoice_id = :invoice_id ORDER BY iteration, notification_order;
• Approver activity report: filter by APPROVER_ID and CREATION_DATE range to measure approval volume and latency.
• Rejection analysis: group by RESPONSE and ITEM_CLASS to identify rejection patterns by workflow or item class.
• Multi-org reporting: restrict by ORG_ID to honor MOAC security.

Related Objects

• AP.AP_INVOICES_ALL — Joined on INVOICE_ID; the parent invoice record referenced by the documented foreign key.
• AP_INVOICE_APPROVAL_HISTORY (window/form) — The UI that surfaces this table's data.
• AP_APPROVAL_HISTORY_API / Invoice Approval Workflow — The process that inserts rows into this table.
• FND_USER — Referenced by CREATED_BY and LAST_UPDATED_BY.
• FND_LOGINS — Referenced by LAST_UPDATE_LOGIN.
• AME_* tables — Related through ITEM_CLASS and ITEM_ID for Approvals Management Engine configuration.