Search Results mtl_per_close_dtls




Overview
Explore in AI Chat

Overview

MTL_PER_CLOSE_DTLS is an Inventory (INV) module table that stores Inventory Period Close Details. It resides in the INV schema and holds a VALID status in EBS 12.1.1 and 12.2.2. During the inventory accounting period close process, Oracle Inventory evaluates on-hand balances and cost information to produce period-end valuation snapshots. This table persists those snapshots at a granular level — by organization, accounting period, cost group, inventory item, and subinventory — capturing the ending quantity and ending unit cost that drove the period close valuation. It is a transactional/aggregate fact table recording the outcome of the close calculation for each valuation dimension.

Under a heuristic Data Vault classification mined from the foreign-key structure, this table is modeled as standalone. A modeling suggestion would place it as a satellite-like fact capturing a point-in-time valuation snapshot, with no distinct parent hub referenced through inbound foreign keys; the grain is defined entirely by its own composite key columns.

Key Information Stored

The physical schema documents 14 columns. The most important columns are:

The surrogate/business key is defined by the primary key MTL_PER_CLOSE_DTLS_PK1, composed of ORGANIZATION_ID, ACCT_PERIOD_ID, COST_GROUP_ID, INVENTORY_ITEM_ID, and SECONDARY_INVENTORY. The unique index MTL_PER_CLOSE_DTLS_U1 carries the identical column list, confirming this composite as the business-key candidate that enforces one valuation row per organization, period, cost group, item, and subinventory.

Common Use Cases and Queries

The primary use case is period-end inventory valuation reporting: reconciling on-hand quantities and costs as computed at close, feeding subledger and general ledger valuation, and supporting audit trails for cost adjustments. Analysts join to the accounting period and organization dimension tables to present human-readable results.

A typical query pattern retrieves valuation detail for a specific organization and period:

  • SELECT organization_id, acct_period_id, inventory_item_id, secondary_inventory, period_end_quantity, period_end_unit_cost FROM mtl_per_close_dtls.
  • Filter by ORGANIZATION_ID and ACCT_PERIOD_ID to isolate a single close run.
  • Join ORGANIZATION_ID to MTL_PARAMETERS and ACCT_PERIOD_ID to ORG_ACCT_PERIODS for descriptive labels.
  • Aggregate PERIOD_END_QUANTITY and (PERIOD_END_QUANTITY × PERIOD_END_UNIT_COST) to derive total period-end valuation by cost group.
  • Join INVENTORY_ITEM_ID to MTL_SYSTEM_ITEMS_B for item descriptions and categories.

Reconciliation workbooks compare MTL_PER_CLOSE_DTLS totals against perpetual on-hand (MTL_ONHAND_QUANTITIES) and cost tables to validate the close.

Related Objects

  • FND_LOGINS — referenced via LOGIN_ID, identifying the session that generated the row.
  • ORG_ACCT_PERIODS — the accounting period master, joined on ACCT_PERIOD_ID (ACCT_PERIOD_ID).
  • MTL_PARAMETERS — organization definition, joined on ORGANIZATION_ID.
  • MTL_SYSTEM_ITEMS_B — item master, joined on INVENTORY_ITEM_ID.
  • MTL_COST_GROUPS — cost group definition, joined on COST_GROUP_ID.
  • MTL_SECONDARY_INVENTORIES — subinventory master, joined on SECONDARY_INVENTORY and ORGANIZATION_ID.
  • MTL_ONHAND_QUANTITIES and MTL_CST_ITEM_COSTS — used in reconciliation against the period-close snapshot.
  • Period Close concurrent programs in the INV application populate this table during the close process.