Search Results xtr_ap_source_other




Overview
Explore in AI Chat

Overview

APPS.XTR_AP_ORIG_TRX_V is a reporting view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that presents accounts payable invoice transactions in the form consumed by Oracle E-Business Tax (E-Business Tax / ETRM) and its associated tax reporting and integration flows. The view acts as a normalized, user-facing projection of AP invoice data, converting internal lookup codes into translatable display strings and pairing each invoice with its vendor, vendor site, operating unit, party, and payment schedule attributes. It is owned by the APPS schema and is referenced by ETRM components and by external reporting or data-extraction processes that need a consistent view of original invoice transactions for tax determination, reconciliation, and audit purposes.

The name and the decode logic confirm its role as the "original transaction" source for ETRM: the SOURCE column is mapped to the message keys XTR_AP_SOURCE_MANUAL and XTR_AP_SOURCE_OTHER when no displayed field is defined in AP_LOOKUP_CODES. This directly addresses the search term "xtr_ap_source_other", which is the message key used to represent non-manual invoice sources on the view.

Underlying Base Objects

The view is defined over the following documented base objects:

Only non-cancelled invoices (CANCELLED_DATE IS NULL) with a non-zero gross amount are returned.

Key Columns

  • INVOICE_ID, INVOICE_NUM, INVOICE_DATE — primary invoice identifiers.
  • PAYMENT_NUM, DUE_DATE, GROSS_AMOUNT — payment schedule detail derived from AP_PAYMENT_SCHEDULES_ALL.
  • SOURCE (decoded) — the invoice source, rendered either from ALK.DISPLAYED_FIELD or, when null, as XTR_AP_SOURCE_MANUAL or XTR_AP_SOURCE_OTHER.
  • INVOICE_TYPE_LOOKUP_CODE, ALC.DISPLAYED_FIELD — invoice type code and its display label.
  • ORG_ID, HOU.NAME — operating unit identifier and name.
  • VENDOR_ID, VENDOR_NAME, VENDOR_SITE_ID, VENDOR_SITE_CODE — supplier and site attributes.
  • PARTY_CODE — tax party code from XTR_PARTIES_V.
  • PAYMENT_CURRENCY_CODE — currency of the payment schedule amount.

Common Use Cases and Queries

Typical uses include ETRM tax reporting, reconciliation of AP invoice sources, and extracts feeding tax engines or data warehouses.

  • Listing invoices by source, including the XTR_AP_SOURCE_OTHER bucket.
  • Aggregating gross amounts by operating unit and party.
  • Extracting invoice and vendor detail for a given period.

Sample SQL:

SELECT invoice_num, vendor_name, source, gross_amount, due_date
FROM apps.xtr_ap_orig_trx_v
WHERE source = fnd_message.get_string('XTR','XTR_AP_SOURCE_OTHER');

SELECT org_id, party_code, SUM(gross_amount)
FROM apps.xtr_ap_orig_trx_v
WHERE invoice_date BETWEEN :p_start AND :p_end
GROUP BY org_id, party_code;