Search Results ic_perd_bal




Overview
Explore in AI Chat

Overview

The IC_PERD_BAL table is a core data repository within the Oracle E-Business Suite Process Manufacturing (GMI) module. It is owned by the GMI schema and is responsible for storing summarized inventory period balances. Its primary role is to support period-end inventory valuation and reporting by maintaining a snapshot of on-hand quantities and values for items, lots, and locations at the close of each accounting period. This table is fundamental to the financial integrity of inventory management, enabling reconciliation between perpetual inventory records and general ledger balances.

Key Information Stored

The table's structure is designed to uniquely identify an inventory balance record through its primary keys and to store associated transactional totals. The primary keys, defined in IC_PERD_BAL_PK and IC_PERD_BAL_U1, enforce uniqueness based on period, warehouse, item, lot, and location. While the specific quantity and value columns are not detailed in the provided metadata, tables of this nature typically contain columns for period-beginning and period-ending quantities, total receipts, total issues, and total adjustments, often broken down by cost elements. Key foreign key relationships, as documented, link to master and status tables for validation: IC_LOTS_MST (item/lot definition), IC_LOTS_STS (lot status), IC_WHSE_STS (warehouse/period status), and QC_HRES_MST (quality hold reason).

Common Use Cases and Queries

This table is central to period-end closing procedures and financial reporting. Common operational and analytical queries include generating period-end inventory valuation reports, analyzing inventory turnover by item or warehouse, and reconciling inventory sub-ledger to the general ledger. A typical query pattern involves joining IC_PERD_BAL with item and lot master tables to produce a detailed valuation report for a specific fiscal period.

  • Sample Query for Period Balances: SELECT ipb.whse_code, ipb.item_id, ipb.lot_id, ilm.item_no, SUM(ipb.period_end_qty) FROM gmi.ic_perd_bal ipb JOIN gmi.ic_item_mst ilm ON ipb.item_id = ilm.item_id WHERE ipb.fiscal_year = 2024 AND ipb.period = 3 GROUP BY ipb.whse_code, ipb.item_id, ipb.lot_id, ilm.item_no;
  • Use Case: Running the "Period Close" process in Process Manufacturing populates this table. Subsequent inventory valuation reports and the "Transfer to GL" process rely heavily on the balances stored here.

Related Objects

IC_PERD_BAL is integral to the Process Manufacturing inventory schema and has defined relationships with several key tables, as per the provided foreign key metadata.

  • Master Data Tables: IC_LOTS_MST (provides item and lot master data) and QC_HRES_MST (provides quality hold reason codes).
  • Status Tables: IC_LOTS_STS (lot status) and IC_WHSE_STS (warehouse period status, controlling period closes).
  • Transactional Tables: While not listed in the metadata, this summary table is populated from detailed transaction tables like IC_TRAN_PND and IC_TRAN_CMP during period-end processing.
  • Reporting Views: Various inventory valuation and period analysis reports within Oracle EBS are built upon queries against IC_PERD_BAL.