AP Invoice Audit Listing – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Payables · all Payables reports

Overview

Imported Oracle standard ‘Invoice Audit Listing’ report Application: Payables Source: Invoice Audit Listing Short Name: APXINLST

When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, GST TAN No, CGST Amount, SGST Amount, IGST Amount, CESS Amount, Custom Amount, Unclassified Tax Amount, Non-Recoverable GST, Taxable Value, HSN SAC Code, CGST Rate, SGST Rate, IGST Rate, CESS Rate, CGST Recoverable, CGST Non-Recoverable, SGST Recoverable, SGST Non-Recoverable, IGST Recoverable, IGST Non-Recoverable, Reverse Charge Flag, Place of Supply, Ship From State.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Operating Unit, Minimum Invoice Amount, Begin Invoice Date, Invoice Type

Oracle EBS Tables Used

hr_all_organization_units_vl, ap_invoices_all, ap_suppliers, hz_parties

Report Categories

Enginatics, R12 only

CAC AP Accrual IR ISO Match Analysis, INL Landed Cost Estimated vs Actual, GL Account Analysis (Drilldown) (with inventory and WIP), AP Invoice on Hold, GL Account Distribution Analysis, AP Suppliers, AP Invoices and Lines, GL Account Analysis, AP Supplier Upload

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output AP Invoice Audit Listing 03-Jan-2022 100708.xlsx
Blitz Report™ XML Import AP_Invoice_Audit_Listing.xml
SQL Source AP Invoice Audit Listing.sql
Full Report on Enginatics www.enginatics.com/reports/ap-invoice-audit-listing/

Case Study & Technical Analysis: AP Invoice Audit Listing

1. Executive Summary

Business Problem

Maintaining the integrity of the Accounts Payable process is crucial for preventing fraud, duplicate payments, and data entry errors. Organizations often struggle with:

Solution Overview

The AP Invoice Audit Listing is a direct import of the standard Oracle “Invoice Audit Listing” report. It provides a detailed register of invoices entered within a specific period, highlighting potential issues and serving as a primary source for AP auditing.

Key Benefits

2. Functional Analysis

Report Purpose

This report lists invoices entered in the system, providing a snapshot of the AP liability. It is often used to verify that all physical invoices received have been correctly entered into Oracle Payables.

Key Metrics & Data Points

Intended Audience

3. Technical Analysis

Source Tables

The report is based on the standard Oracle report APXINLST and queries the core AP tables:

Critical Logic

Performance Considerations

4. Implementation Guide

Setup Instructions

  1. Deploy SQL: Use the provided SQL to create the report in Blitz Report.
  2. Parameters:
    • Operating Unit: Mandatory for multi-org environments.
    • Begin Invoice Date: To define the audit period.
    • Minimum Invoice Amount: Optional filter to focus on high-value transactions.
    • Invoice Type: To filter for specific types like ‘Standard’ or ‘Credit Memo’.

Usage Scenarios

5. Frequently Asked Questions (FAQ)

Q: Is this different from the “Invoice Register”?

A: Yes, the Invoice Register is typically more detailed, showing line items and distributions. The Audit Listing is often more focused on the header level for a quick scan of entered invoices.

Q: Can I see who approved the invoice?

A: This specific report focuses on entry and audit details. For approval history, the “AP Invoice Approval Status” report is more appropriate.

Q: Does it show cancelled invoices?

A: It depends on the parameters and the specific SQL implementation, but standard audit listings often include all invoices to ensure a complete sequence check.

© Enginatics GmbH