Results for “loct_usage2”

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

Overview

GMI.IC_PERD_BAL is the Process Manufacturing Inventory table that stores inventory period balances. It captures the closing and activity position of warehouse stock — on-hand quantities, usage, yield, and value — for each item, lot, and location within a defined inventory period. The table is a core component of the Oracle E-Business Suite Process Manufacturing (OPM) inventory and cost accounting model, and is commonly referenced in period-end reconciliation, inventory valuation, and lot-level traceability reporting across both 12.1.1 and 12.2.2 environments.

Based on the heuristic Data Vault classification mined from its foreign key structure, IC_PERD_BAL is best modeled as a link table. It resolves many-to-many relationships between inventory periods, warehouses, items, lots, and locations, with the balance metrics acting as link-level payload. This classification is a modeling suggestion derived from the FK topology, not a physical implementation detail in EBS.

Key Information Stored

The table contains 26 documented columns. The most significant include:

• PERIOD_ID and WHSE_CODE — identify the inventory period and warehouse the balance belongs to; both are foreign-key participants referencing IC_WHSE_STS.
• ITEM_ID, LOT_ID, and LOCATION — the item, lot, and storage location dimensions of the balance record.
• FISCAL_YEAR and PERIOD — the accounting calendar period attributes used for reporting and reconciliation.
• LOCT_ONHAND, LOCT_USAGE, and LOCT_YIELD — location-level on-hand quantity, usage quantity, and yield values; secondary variants (…2) hold the corresponding secondary-unit-of-measure amounts.
• LOCT_VALUE — the inventory value held at the location for the period.
• LOT_STATUS and QCHOLD_RES_CODE — lot status and QC hold resource, supporting quality-holding logic.
• GL_POSTED_IND — indicates whether the period balance has been posted to the General Ledger.
• PERD_BAL_ID — surrogate identifier backed by unique index IC_PERD_BAL_U2.

The primary key is IC_PERD_BAL_PK (PERIOD_ID, WHSE_CODE, ITEM_ID, LOT_ID, LOCATION). Business-key candidates are defined by unique indexes IC_PERD_BAL_U1 (FISCAL_YEAR, PERIOD, WHSE_CODE, ITEM_ID, LOT_ID, LOCATION) and IC_PERD_BAL_U2 (PERD_BAL_ID).

Common Use Cases and Queries

Typical scenarios include period-end inventory valuation, on-hand quantity reconciliation between OPM and GL, yield/usage variance analysis, and lot status and QC-hold reporting. A representative query joining to warehouse period status might be:

• SELECT b.ITEM_ID, b.LOT_ID, b.LOCATION, b.LOCT_ONHAND, b.LOCT_VALUE FROM IC_PERD_BAL b WHERE b.WHSE_CODE = :whse AND b.PERIOD = :period;
• Filter on GL_POSTED_IND = 'N' to isolate unposted period balances.
• Join to IC_LOTS_MST on ITEM_ID and LOT_ID for lot master attributes.

Related Objects

• IC_LOTS_MST — joined on ITEM_ID (and LOT_ID) for lot master information.
• IC_LOTS_STS — joined on LOT_STATUS for lot status definitions.
• IC_WHSE_STS — joined on PERIOD_ID and WHSE_CODE for warehouse period status.
• QC_HRES_MST — joined on QCHOLD_RES_CODE for QC hold resource details.
• JAI_CMN_RG_PERIOD_BALS — referenced via PERIOD_BALANCE_ID for the India localization period balance linkage.