Results for “intransit_primary_quantity”

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

Overview

GMF_PERIOD_BALANCES_GT is a temporary staging table owned by the GMF schema and used by Oracle Process Manufacturing Financials (OPM Financials) in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to hold period inventory balances for process organizations, serving as an intermediate work area during period-end balance compilation, costing, and transfer to permanent inventory valuation tables. The "_GT" suffix reflects the Global Temporary Table convention common throughout EBS; physical rows are typically scoped to the session that populates them, so the table functions as transient working storage rather than a persistent ledger.

Because the table is populated by OPM period-close and costing concurrent programs, its contents are meaningful only within the context of a specific run. Its columns are heavily denormalized across the inventory dimensions (period, organization, cost group, item, lot, and locator), which allows downstream processes to aggregate valuation results without repeated joins. The ETRM metadata notes that this object is not part of the persistent Data Vault population. A heuristic Data Vault classification based on the mined FK structure yields standalone, meaning the table does not participate in the conformed hub/link/satellite model and should be treated strictly as a transient staging or interface structure.

Key Information Stored

The table carries 14 documented columns. The most important include:

• ACCT_PERIOD_ID — the accounting period to which the balance snapshot belongs; the principal temporal driver of the record.
• ORGANIZATION_ID — the process organization whose inventory is being valued.
• COST_GROUP_ID — the cost group used to classify items for costing; documented as a foreign key to CST_COST_GROUPS.
• INVENTORY_ITEM_ID — the item being valued.
• SUBINVENTORY_CODE and LOCATOR_ID — the physical storage location details.
• LOT_NUMBER — the lot or batch identifier, essential for process manufacturing lot-level valuation.
• PRIMARY_QUANTITY and SECONDARY_QUANTITY — on-hand quantities in the primary and secondary units of measure.
• INTRANSIT_PRIMARY_QUANTITY and INTRANSIT_SECONDARY_QUANTITY — in-transit quantities tracked separately from on-hand.
• ACCOUNTED_VALUE and INTRANSIT_ACCOUNTED_VALUE — the corresponding monetary valuations.
• SOURCE_TYPE_ID — identifies the origin of the balance record.

The documented metadata identifies no surrogate primary key column and no unique indexes; the table's grain is the combination of period, organization, cost group, item, lot, subinventory, and locator. No single-column surrogate key is documented, so consumers should treat the full dimensional list as the business-key candidate rather than relying on a synthetic identifier.

Common Use Cases and Queries

Typical scenarios include period-close verification, valuation reconciliation, and diagnostic reporting during cost rollup. A common query retrieves balances for a specific period and organization:

• SELECT ACCT_PERIOD_ID, ORGANIZATION_ID, COST_GROUP_ID, INVENTORY_ITEM_ID, LOT_NUMBER, PRIMARY_QUANTITY, ACCOUNTED_VALUE FROM GMF.GMF_PERIOD_BALANCES_GT WHERE ACCT_PERIOD_ID = :period AND ORGANIZATION_ID = :org;
• Aggregating accounted value by cost group: SELECT COST_GROUP_ID, SUM(ACCOUNTED_VALUE) FROM GMF.GMF_PERIOD_BALANCES_GT GROUP BY COST_GROUP_ID;
• Reconciling on-hand versus in-transit: comparing PRIMARY_QUANTITY with INTRANSIT_PRIMARY_QUANTITY per item and lot.

Because it is a temporary table, contents exist only while the populating session is active; reporting tools should capture or persist results if retention is required.

Related Objects

The documented FK relationship links GMF_PERIOD_BALANCES_GT.COST_GROUP_ID to CST_COST_GROUPS. Other significant dependencies, based on the inventory dimensions present, include:

• CST_COST_GROUPS — cost group definition, joined on COST_GROUP_ID.
• GL_PERIODS / ORG_ACCT_PERIODS — accounting period definition, joined on ACCT_PERIOD_ID.
• MTL_SYSTEM_ITEMS_B — item master, joined on INVENTORY_ITEM_ID.
• MTL_ITEM_LOCATIONS — locator definition, joined on LOCATOR_ID.
• ORG_ORGANIZATION_DEFINITIONS — organization details, joined on ORGANIZATION_ID.
• GMF_PERIOD_BALANCES — the permanent counterpart populated after successful staging.
• CST_PERIOD_CLOSE_SUMMARY — period-close summary records that consume the aggregated balances.