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
- LEGAL_ENTITY_ID / LEGAL_ENTITY_NAME — the legal entity owning the transaction.
- LEDGER_ID — the ledger context for accounting.
- TRANSACTION_ID — the extraction/transaction identifier.
- VALUATION_COST_TYPE_ID / VALUATION_COST_TYPE — the costing basis for the transaction.
- EVENT_CLASS_CODE — fixed to 'PAYABLES_INVOICE'.
- ITEM_NAME / ITEM_DESCRIPTION / ORGANIZATION_CODE — item and organization descriptors.
- ACCOUNTED_DATE — the accounting date of the distribution.
- PRIMARY_QUANTITY / TRANSACTION_UOM / PRIMARY_UOM_CODE / SECONDARY_UOM_CODE — quantity and UOM data.
- CALENDAR_CODE / PERIOD_CODE / PERIOD_STATUS — accounting period context, with status decoded to Open, Frozen, or Closed.
- AMOUNT / VARIANCE_TYPE — decoded variance amount and type: Invoice Price Variance, Exchange Rate Variance, Tax Invoice Price Variance, or Tax Exchange Rate Variance, based on
INVOICE_VARIANCE_TYPE.
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.
-
View for SLA ADR sources from Payable Invoices
APPS.GMF_XLA_PAYABLES_INVOICES_V·↳ GMF_INVOICE_DISTRIBUTIONS·↳ GMF_PERIOD_STATUSES·↳ GMF_XLA_EXTRACT_HEADERS·Explore GMF module →
-
APPS.GMF_XLA_PAYABLES_INVOICES_V·↳ GMF_INVOICE_DISTRIBUTIONS·↳ GMF_PERIOD_STATUSES·↳ GMF_XLA_EXTRACT_HEADERS·Explore GMF module →