Search Results ap_invoices_interface_v




Overview
Explore in AI Chat

Overview

AP_INVOICES_INTERFACE_V is a Payables (AP) reporting and integration view owned by the APPS schema. It presents a denormalized read image of the AP_INVOICES_INTERFACE staging table, joining in lookup display values, vendor and vendor site names, terms, document sequence categories, and currency conversion types so that consumers do not need to resolve these themselves. Its principal role is to support inquiry, extraction, and diagnostic reporting against invoices that have been loaded into the Payables Open Interface but not yet validated and transferred into the permanent AP_INVOICES_ALL tables.

For users searching on the WORKFLOW_FLAG column, this view is the correct access point: WORKFLOW_FLAG is exposed directly on the view and is used by the Payables Invoice Workflow and the Invoice Validation process to control whether an interfaced invoice is eligible for submission through the approval workflow. It is commonly queried to detect invoices that failed to reach the workflow, that remain pending, or that were deliberately excluded from workflow processing.

Underlying Base Objects

The view text selects primarily from the AP_INVOICES_INTERFACE synonym, aliased AII, and derives ROWID from that table. Its documentation lists the following referenced base objects:

Because the view is defined over the interface table, its contents are transient and typically purged after successful validation.

Key Columns

Important columns include:

The column set is identical across 12.1.1 and 12.2.2; no Online Patching or schema differences alter the view definition between the two releases.

Common Use Cases and Queries

Typical uses include identifying invoices that did not enter workflow, auditing load batches, and extracting staging data for reconciliation. Representative queries:

  • Find invoices blocked from workflow: SELECT invoice_num, status, workflow_flag FROM ap.ap_invoices_interface_v WHERE workflow_flag IS NULL OR workflow_flag = 'N';
  • Trace a load batch: SELECT invoice_num, source, group_id, request_id, status_dsp FROM ap.ap_invoices_interface_v WHERE group_id = :group_id ORDER BY invoice_num;
  • Vendor-level staging review: SELECT vendor_name, invoice_num, invoice_amount, invoice_currency_code, status_dsp FROM ap.ap_invoices_interface_v WHERE vendor_id = :vendor_id;

Queries should be scoped by ORG_ID and GROUP_ID where applicable, and run in the APPS schema or a synonym owner to resolve the full join graph.