Skip to the content.

AP 1099 Payments – 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

1099 Payments report showing payments made to 1099 reportable suppliers. This is the Blitz Report equivalent of the Oracle standard 1099 Payments Report (APXTRRVT).

The report lists suppliers from the 1099 tape data (vendors processed for 1099 reporting) along with their payment totals within the specified date range.

Key features:

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, CGST Rate, SGST Rate, IGST Rate, GST Supplier Registration No, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code.

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

Reporting Option, From Payment Date, To Payment Date, Tax Reporting Entity, Supplier Name, Income Tax Region, Federal Reportable Only, Query Driver

Oracle EBS Tables Used

ap_invoice_payments_all, ap_reporting_entities_all, ap_supplier_sites_all, ap_1099_tape_data

Report Categories

Enginatics, R12 only

AP Invoices and Lines, AP Suppliers, AP Invoices and Lines 11i, AP Supplier Upload, GL Account Analysis (Drilldown) (with inventory and WIP), GL Account Analysis

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 1099 Payments 28-Dec-2025 142614.xlsx
Blitz Report™ XML Import AP_1099_Payments.xml
SQL Source AP 1099 Payments.sql
Full Report on Enginatics www.enginatics.com/reports/ap-1099-payments/

Case Study & Technical Analysis: AP 1099 Payments

Executive Summary

The AP 1099 Payments report lists the payments made to 1099 reportable suppliers within a payment date range, grouped by supplier, tax reporting site, tax ID and 1099 income tax type. It is the Blitz Report equivalent of the Oracle standard 1099 Payments Report (APXTRRVT). Accounts payable staff and tax reporting teams use it to reconcile the amounts paid to each 1099 vendor before the year-end 1099 filing, and to separate gross reportable amounts from backup withholding. The report runs in Excel through Blitz Report.

Business Challenge

The Solution

Technical Architecture (High Level)

Primary Tables

Logical Relationships

  1. AP_REPORTING_ENTITIES_ALL joins to AP_REPORTING_ENTITY_LINES_ALL on the tax entity, then to the operating unit and ledger.
  2. The balancing segment is matched to the distribution code combination (INV) or to the bank account asset code combination (PAY).
  3. AP_SUPPLIERS joins to the 1099 vendor list and to the single selected row from AP_SUPPLIER_SITES_ALL.
  4. Invoices join to their distributions and payments, and each payment joins to AP_CHECKS_ALL and then to the bank account.
  5. Detail rows are aggregated by supplier, supplier number, tax reporting site, tax ID, income tax type and region.

Parameters & Filtering

Performance & Optimization

FAQ

Q: How is backup withholding reported in the AP 1099 Payments report? A: Distributions typed MISC4 populate the Withheld Amount column as a positive value, and their payment amount is negated, so Payment Amount shows the net reportable figure.

Q: Why does a voided check not appear in the 1099 payment totals? A: Payments whose check void date falls within the From and To Payment Date range are excluded by the condition on AP_CHECKS_ALL.VOID_DATE.

Q: How does the report choose the tax reporting site for a supplier? A: It ranks the supplier’s sites with an analytic function, placing the site flagged as tax reporting site first and otherwise the alphabetically first site, and keeps only the top row.


© Enginatics GmbH