Results for “gmf_invoice_distributions”

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

Overview

GMF_INVOICE_DISTRIBUTIONS is a supplementary table within the Oracle E-Business Suite Process Manufacturing Financials (GMF) module, owned by the GMF schema. Its documented purpose is to store invoice variance amounts for Actual Costing. In process manufacturing environments, purchase price variances (PPV), exchange rate variances (ERV), and related invoice-level adjustments must be captured at a granular distribution level so that actual costing calculations reflect the true cost of goods received and consumed. This table serves as the holding structure for those variances, linking invoice distribution lines to the cost components, items, warehouses, and legal entities against which the variance is calculated.

From a Data Vault modeling perspective, the metadata classifies GMF_INVOICE_DISTRIBUTIONS as a standalone entity. This heuristic suggests the table functions primarily as a satellite-like structure describing transactional variance detail, with its own surrogate key and no strong dependency chain into other hub or link constructs. Business consumers should treat it as a detail fact table of variance measurements rather than a core master entity.

Key Information Stored

The table contains 42 documented columns. The surrogate primary key is DISTRIBUTION_ID, enforced by the unique index GMF_INVOICE_DISTRIBUTIONS_PK. No alternate business-key unique index is documented beyond this primary key, so DISTRIBUTION_ID is the reliable join anchor.

The most significant columns include:

• INVOICE_DISTRIBUTION_ID — the external reference tying each row back to the originating invoice distribution.
• INVOICE_VARIANCE_TYPE — identifies the category of variance being recorded.
• ITEM_ID and INVENTORY_ITEM_ID — the item against which the variance applies.
• WHSE_CODE and ORGANIZATION_ID — the warehouse and inventory organization context.
• QUANTITY_INVOICED, QUANTITY_COSTED, and TOTAL_QUANTITY — the quantity basis for variance computation, with QUANTITY_UOM providing the unit of measure.
• UNIT_BASE_PRICE — the base unit price used in variance derivation.
• BASE_IPV_AMOUNT and IPV_AMOUNT — invoice price variance in base and transactional currency; BASE_IPV_ADJ_AMOUNT and IPV_ADJ_AMOUNT hold corresponding adjustments.
• BASE_ERV_AMOUNT, ERV_AMOUNT, BASE_ERV_ADJ_AMOUNT, and ERV_ADJ_AMOUNT — exchange rate variance amounts and adjustments.
• COST_TYPE_ID, COST_CMPNTCLS_ID, and COST_MTHD_CODE — the costing method, cost type, and component class that drive the Actual Costing logic.
• CALENDAR_CODE, PERIOD_CODE, and PERIOD_ID — the accounting period context.
• LEGAL_ENTITY_ID — the legal entity bearing the variance.
• ACCOUNTED_DATE, ACCOUNTED_FLAG, FINAL_POSTING_DATE, and GL_POSTED_IND — accounting and general ledger posting status.
• OUT_OF_PERIOD_IND — flags variances falling outside the expected accounting period.

Common Use Cases and Queries

Typical scenarios include reconciling invoice price and exchange rate variances to the general ledger, auditing Actual Costing results, and analyzing period-end variance exposure by item or warehouse.

• Variance detail for a given invoice distribution:

SELECT distribution_id, invoice_distribution_id, invoice_variance_type,
       ipv_amount, erv_amount, quantity_invoiced, quantity_costed
FROM   gmf.gmf_invoice_distributions
WHERE  invoice_distribution_id = :invoice_distribution_id;

• Period variance aggregation by cost type:

SELECT period_code, cost_type_id,
       SUM(ipv_amount) total_ipv, SUM(erv_amount) total_erv
FROM   gmf.gmf_invoice_distributions
WHERE  calendar_code = :calendar_code
GROUP  BY period_code, cost_type_id;

• Unposted variance identification:

SELECT distribution_id, legal_entity_id, base_ipv_amount, accounted_flag
FROM   gmf.gmf_invoice_distributions
WHERE  gl_posted_ind = 'N'
AND    out_of_period_ind = 'Y';

Related Objects

Integration points derive from documented foreign keys and expected costing context:

• CST_COST_TYPES — referenced via COST_TYPE_ID; defines the cost type under which the variance is calculated.
• FV_LEGAL_ENTITIES — referenced via LEGAL_ENTITY_ID; identifies the legal entity owning the variance.
• MTL_SYSTEM_ITEMS_B — resolved through ITEM_ID and INVENTORY_ITEM_ID for item attributes.
• MTL_PARAMETERS / ORG_ORGANIZATION_DEFINITIONS — resolved through ORGANIZATION_ID for organization context.
• AP_INVOICE_DISTRIBUTIONS_ALL — the external source of INVOICE_DISTRIBUTION_ID and the originating payable distribution.
• CST_COST_COMPONENTS — resolved through COST_CMPNTCLS_ID for cost component classification.
• GL_JE_LINES / GL_IMPORT_REFERENCES — downstream accounting destinations indicated by GL_POSTED_IND and ACCOUNTED_DATE.

Together these relationships allow the variance data in GMF_INVOICE_DISTRIBUTIONS to be traced from invoice capture through Actual Costing and into the general ledger.