Unprocessed AP Invoice Interface Details

This query returns invoice header records from the Oracle Fusion Payables open interface table for invoices that are not yet processed. Oracle documents that AP_INVOICES_INTERFACE stores invoice header information for import into Payables base tables, and the Import Payables Invoices process creates invoices from these interface records.
categories  Finance Account Payable (AP)
back Back to Vault
xls Download Sample Report for Unprocessed AP Invoice Interface Details
SQL Download SQL Query for Unprocessed AP Invoice Interface Details

CSV SQL Query for Unprocessed AP Invoice Interface Details

Copy 
SELECT
    API.SOURCE                  AS Source,
    API.INVOICE_NUM             AS Invoice_Number,
    API.INVOICE_DATE            AS Invoice_Date,
    API.VENDOR_NAME             AS Vendor_Name,
    API.VENDOR_NUM              AS Vendor_Number,
    API.INVOICE_AMOUNT          AS Invoice_Amount,
    API.INVOICE_CURRENCY_CODE   AS Invoice_Currency_Code,
    NVL(HAOU.NAME, API.OPERATING_UNIT)
                                AS Operating_Unit_Name
FROM
    AP_INVOICES_INTERFACE       API,
    HR_ALL_ORGANIZATION_UNITS   HAOU
WHERE
        NVL(API.STATUS, '-1')   <> 'PROCESSED'
    AND HAOU.ORGANIZATION_ID (+)= API.ORG_ID

Unprocessed AP Invoice Interface Details in BI Connector

Try BI Connector  back
back Back to Vault

Can’t find the report you need?

Want to tweak one to fit your business logic?

Contact Sales
Banner