Search Results ic_cycl_hdr




Overview
Explore in AI Chat

Overview

The IC_CYCL_HDR table is a core data object within the Oracle E-Business Suite Process Manufacturing Inventory (GMI) module. It serves as the primary repository for cycle count header information, which defines and controls the physical inventory counting process for a specific warehouse. A cycle count is a systematic, recurring audit of inventory stock, and this table establishes the master definition for each counting event, including its organizational scope, identification, and source. Its existence is critical for maintaining accurate inventory records, supporting financial reconciliation, and ensuring operational integrity within a manufacturing or distribution environment.

Key Information Stored

The table's structure is designed to uniquely identify and describe each cycle counting initiative. The primary identifier is the system-generated CYCLE_ID. However, business logic often relies on the composite unique key consisting of ORGN_CODE (organization), CYCLE_NO (a user-defined cycle number), and CYCLE_SOURCE. The WHSE_CODE column explicitly defines the warehouse being counted. Other typical columns, inferred from standard practice, would include status flags (e.g., pending, in-process, completed), creation and last update dates, and a TEXT_CODE foreign key linking to the IC_TEXT_HDR table for storing descriptive notes or instructions related to the cycle count.

Common Use Cases and Queries

This table is central to cycle count execution and reporting. Common operational scenarios include generating a list of all active cycle counts for a warehouse, validating count headers before processing details, and auditing count completion. A frequent reporting query would join IC_CYCL_HDR to organizational and warehouse master tables to provide a comprehensive view. For example:

  • Identifying all cycle counts for a specific organization: SELECT cycle_no, whse_code, status FROM gmi.ic_cycl_hdr WHERE orgn_code = :p_org_code;
  • Joining to detail lines to analyze count progress: SELECT h.cycle_no, h.whse_code, COUNT(d.item_id) total_lines, COUNT(CASE WHEN d.count_qty IS NOT NULL THEN 1 END) counted_lines FROM gmi.ic_cycl_hdr h JOIN gmi.ic_cycl_dtl d ON h.cycle_id = d.cycle_id WHERE h.status = 'INPROCESS' GROUP BY h.cycle_no, h.whse_code;

Related Objects

IC_CYCL_HDR sits at the apex of the cycle count data model. It has defined foreign key relationships to several master tables: SY_ORGN_MST and SY_ORGN_MST_B for the organization, and IC_WHSE_MST for the warehouse. It is also referenced by key transactional tables. The IC_CYCL_DTL table holds the specific inventory items scheduled for counting within a given header. The IC_CYCL_MSC table likely stores miscellaneous or adjustment data related to the count. Furthermore, it links to IC_TEXT_HDR for descriptive text, enabling flexible storage of count instructions or comments.