Results for “payables_invoice”

10 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view APPS.GMF_XLA_PAYABLES_INVOICES_V is a reporting and integration object within Oracle E-Business Suite Release 12.1.1 and 12.2.2, owned by the APPS schema. It exposes payables invoice distribution data that originates from the Process Manufacturing (GMF) costing and Subledger Accounting (XLA) extraction streams. The view consolidates header-level extraction records, invoice variance distributions, item and organization attributes, legal entity identification, and accounting period status into a single denormalized result set.

Its primary role is to present payables-invoice event data in a form suitable for subledger reporting, reconciliation, and downstream integration. Because the view filters strictly on EVENT_CLASS_CODE = 'PAYABLES_INVOICE', it surfaces only the extraction records associated with payables invoice events, together with the corresponding invoice price variance (IPV) and exchange rate variance (ERV) adjustments.

Underlying Base Objects

The view is defined over the following documented base objects:

  • GMF_XLA_EXTRACT_HEADERS (synonym) — supplies the transaction header, legal entity, ledger, valuation cost type, event class, quantity, and UOM data.
  • GMF_INVOICE_DISTRIBUTIONS (synonym) — supplies the distribution-level variance type and base adjustment amounts (IPV/ERV). Joined via distribution_id = transaction_id.
  • GMF_PERIOD_STATUSES (synonym) — supplies the calendar code, period code, and period status. Joined via period_id.
  • MTL_PARAMETERS (synonym) — supplies the organization code. Joined via organization_id.
  • MTL_SYSTEM_ITEMS_B_KFV (view) — supplies the item name, item description, and UOM codes. Joined via organization and inventory item identifiers.
  • XLE_ENTITY_PROFILES (synonym) — supplies the legal entity name. Joined via legal_entity_id.

The joins bind each extraction header to its organization, item, distribution, legal entity, and accounting period, ensuring a complete payables invoice variance picture.

Key Columns

Common Use Cases and Queries

This view is typically used to report invoice price and exchange rate variances by legal entity, ledger, item, or period, and to support reconciliation between Process Manufacturing costing and Subledger Accounting.

SELECT legal_entity_name, organization_code, item_name,
       period_code, variance_type, amount
FROM   apps.gmf_xla_payables_invoices_v
WHERE  period_code = :period
ORDER BY legal_entity_name, item_name;
SELECT variance_type, SUM(amount) total_amount
FROM   apps.gmf_xla_payables_invoices_v
WHERE  accounted_date BETWEEN :from_date AND :to_date
GROUP BY variance_type;

Typical scenarios include period-end variance analysis, open-period review where PERIOD_STATUS = 'Open', and auditing of payables invoice adjustments across legal entities and organizations.