Search Results source_dsp

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:

• AP_INVOICES_INTERFACE (SYNONYM) — the primary source of all invoice staging columns.
• AP_INVOICES_UTILITY_PKG — supplies GET_INTERFACE_PO_NUMBER, used to derive the PO_NUMBER column from the raw PO_NUMBER attribute for the operating unit in ORG_ID.
• AP_LOOKUP_CODES and FND_LOOKUPS — resolve DISPLAYED_FIELD values for invoice type, status, and source descriptors.
• GL_DAILY_CONVERSION_TYPES — provides USER_CONVERSION_TYPE for the stored exchange rate type.
• AP_TERMS, PO_VENDORS, PO_VENDOR_SITES, FND_DOC_SEQUENCE_CATEGORIES — supply terms name, vendor name, vendor site, and document category name.
• IBY_DELIVERY_CHANNELS_VL, IBY_EXT_BANK_ACCOUNTS_V, IBY_PAYMENT_METHODS_VL, IBY_PAYMENT_REASONS_VL — Payments-related lookups referenced by the definition.
• AP_AWT_GROUPS, FND_GLOBAL, MO_GLOBAL_SERVER — supporting objects referenced by the definition.

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

Key Columns

Important columns include:

• ROWID — row identifier of the underlying interface record.
• INVOICE_ID, INVOICE_NUM, INVOICE_AMOUNT, INVOICE_CURRENCY_CODE, INVOICE_DATE, INVOICE_TYPE_LOOKUP_CODE, INVOICE_TYPE — core invoice attributes and resolved type display.
• WORKFLOW_FLAG — controls workflow eligibility and submission; a primary diagnostic column.
• STATUS, STATUS_DSP — interface processing status and its display value.
• SOURCE, SOURCE_DSP, GROUP_ID, REQUEST_ID — origin and load-batch identifiers for traceability.
• VENDOR_ID, VENDOR_NAME, VENDOR_SITE_ID, TERMS_ID, AT.NAME — supplier and terms context.
• PO_NUMBER and SEGMENT1 — derived and raw purchase order references.
• EXCHANGE_RATE, EXCHANGE_RATE_TYPE, EXCHANGE_DATE, USER_CONVERSION_TYPE — currency conversion detail.
• GL_DATE, ACCTS_PAY_CODE_COMBINATION_ID, PAY_GROUP_LOOKUP_CODE, VOUCHER_NUM, DOC_CATEGORY_CODE, DOC_CATEGORY_NAME, EXCLUSIVE_PAYMENT_FLAG, AWT_GROUP_ID.
• ATTRIBUTE1–15, ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1–20, GLOBAL_ATTRIBUTE_CATEGORY.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

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.