Results for “accounted_date”

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

Overview

GMF_XLA_PAYABLES_INVOICES_V is a reporting view owned by the APPS schema within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite. It consolidates payables invoice cost data extracted from the Process Manufacturing subledger accounting stream into a single denormalized structure suitable for reporting and downstream integration. The view filters the underlying extraction header table exclusively to rows where EVENT_CLASS_CODE equals 'PAYABLES_INVOICE', so it functions as a specialized lens over the broader GMF_XLA_EXTRACT_HEADERS data set rather than as a general purpose accounting extract.

The view is defined with STATUS VALID and is documented for both Oracle EBS 12.1.1 and 12.2.2. Its principal value lies in pre-resolving code values into descriptive text: the PERIOD_STATUS column is translated from the single-character codes held in the period status table into the readable values OPEN, FROZEN, and CLOSED, and the variance type column is decoded into named categories such as INVOICE PRICE VARIANCE and EXCHANGE RATE VARIANCE. This makes the view directly consumable by operational reports and by extracts that feed external costing or reconciliation processes without requiring the consumer to know the internal lookup codes.

Underlying Base Objects

The view text joins six documented objects. GMF_XLA_EXTRACT_HEADERS (EH) supplies the core transaction identity, legal entity, ledger, valuation cost type, event class, transaction quantity, and unit of measure. GMF_INVOICE_DISTRIBUTIONS (GID) supplies the accounted date, the period identifier, and the invoice variance type and base adjustment amounts. GMF_PERIOD_STATUSES (GPS) supplies the calendar code, period code, and the period status that is decoded into the PERIOD_STATUS column. XLE_ENTITY_PROFILES (LE) provides the legal entity name. MTL_PARAMETERS (MP) provides the organization code. MTL_SYSTEM_ITEMS_B_KFV, a key flexfield view over the item master, provides item name, item description, and the primary and secondary unit of measure codes.

Join conditions are imposed on organization, inventory item, distribution to transaction, legal entity, and period identifier, with the additional constant restriction on event class code. Because the view references the key flexfield view for items, it exposes the concatenated or descriptive item identifier rather than raw segment columns, though the ETRM column listing records ITEM_NAME as a discrete exposed column.

Key Columns

• LEGAL_ENTITY_ID, LEDGER_ID — Accounting entity and ledger context for the extracted transaction.
• TRANSACTION_ID — Links the row back to the invoice distribution identified in GMF_INVOICE_DISTRIBUTIONS.
• EVENT_CLASS_CODE — Restricted to 'PAYABLES_INVOICE' for all rows returned by the view.
• CALENDAR_CODE, PERIOD_CODE — Accounting calendar and period in which the distribution was accounted.
• PERIOD_STATUS — Decoded from GPS.PERIOD_STATUS: 'O' becomes OPEN, 'F' becomes FROZEN, and 'C' becomes CLOSED. This column is the attribute commonly referenced when users need to identify whether the relevant accounting period remains open or has been frozen or closed.
• ACCOUNTED_DATE — The date on which the transaction was accounted.
• PRIMARY_QUANTITY, TRANSACTION_UOM — Quantity and unit of measure at which the transaction was extracted.
• AMOUNT — Decoded from the invoice variance type: types 1 and 3 return BASE_IPV_ADJ_AMOUNT, while types 2 and 4 return BASE_ERV_ADJ_AMOUNT.
• VARIANCE_TYPE — Descriptive label for the variance: INVOICE PRICE VARIANCE, EXCHANGE RATE VARIANCE, TAX INVOICE PRICE VARIANCE, or TAX EXCHANGE RATE VARIANCE.

Common Use Cases and Queries

The view is typically used to report invoice price and exchange rate variances booked against process manufacturing receipts and to reconcile those variances against the general ledger by period. A frequent requirement is to identify payables invoice variances falling in periods that have not yet been closed, which is precisely where the PERIOD_STATUS column is useful.

Typical query patterns include:

• Listing open-period payables invoice variances: SELECT PERIOD_CODE, VARIANCE_TYPE, SUM(AMOUNT) FROM GMF_XLA_PAYABLES_INVOICES_V WHERE PERIOD_STATUS = 'OPEN' GROUP BY PERIOD_CODE, VARIANCE_TYPE.
• Auditing frozen periods pending closure: SELECT DISTINCT CALENDAR_CODE, PERIOD_CODE FROM GMF_XLA_PAYABLES_INVOICES_V WHERE PERIOD_STATUS = 'FROZEN'.
• Item-level variance analysis joining on ITEM_NAME and ORGANIZATION_CODE to attribute variance to a specific product and organization.
• Extracting closed-period data for external reconciliation by filtering on PERIOD_STATUS = 'CLOSED' and ACCOUNTED_DATE.

Because PERIOD_STATUS is a decoded character value rather than a code, report parameters should compare against the uppercase literals OPEN, FROZEN, or CLOSED. Consumers should also note that the view returns only rows whose event class is PAYABLES_INVOICE, so it cannot be used to report other GMF subledger event classes.