Search Results ic_phys_cnt




Overview
Explore in AI Chat

Overview

The IC_PHYS_CNT table is a core data repository within the Oracle E-Business Suite Process Manufacturing (GMI) module. It serves as the primary transactional table for managing physical inventory and cycle count operations. Its role is to store detailed records for each counted item during an inventory audit, capturing the physical quantities found and the associated context, such as warehouse, lot, and location. This data is fundamental for reconciling system on-hand balances with actual physical stock, a critical process for inventory accuracy, financial reporting, and operational planning in a manufacturing environment.

Key Information Stored

The table's structure is designed to uniquely identify a specific count instance and record its results. As defined by its primary key (IC_PHYS_CNT_PK), each record is uniquely identified by a combination of: CYCLE_ID (the identifier for the counting cycle), COUNT_NO (the specific count sequence), ITEM_ID, WHSE_CODE, LOT_ID, and LOCATION. This granularity ensures tracking at the lowest inventory level. Beyond the key columns, the table holds critical transactional data such as the counted quantity, system quantity at the time of count, and any variance. The presence of foreign key columns like GRADE_CODE (linking to GMD_GRADES_B and QC_GRAD_MST), REASON_CODE (linking to SY_REAS_CDS_B), and TEXT_CODE (linking to IC_TEXT_HDR) indicates it also stores quality attributes, reasons for count adjustments, and descriptive text, respectively.

Common Use Cases and Queries

The primary use case is generating variance reports and executing inventory adjustments. A common query pattern involves joining IC_PHYS_CNT with item master tables (like IC_ITEM_MST_B) to analyze discrepancies between system and physical quantities for a specific cycle or warehouse. For example, a report to identify all significant variances might filter on the difference between the counted and system quantity columns. The data is also queried to review the history of counts for a specific lot or location, supporting root cause analysis for inventory inaccuracies. Sample SQL often selects key identifiers, item information, quantity fields, and the REASON_CODE to understand the context of any adjustments posted to inventory.

Related Objects

IC_PHYS_CNT is centrally connected to several key EBS objects, primarily through its foreign key constraints. It directly references master data and supporting tables: GMD_GRADES_B and QC_GRAD_MST for grade specifications, SY_REAS_CDS_B for standardized reason codes, and IC_TEXT_HDR for descriptive flexfield text. As a transactional table, it is likely referenced by various inventory reconciliation reports and interfaces. While not listed in the provided metadata, it is logically dependent on the item master (IC_ITEM_MST_B) and warehouse definitions, and its data is ultimately consumed by the inventory valuation and general ledger modules following adjustment postings.