Search Results ic_item_cdt




Overview
Explore in AI Chat

Overview

The IC_ITEM_CDT table is a core data object within the Process Manufacturing Inventory (GMI) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master repository for scheduled physical inventory count dates. This table is fundamental to the cycle counting functionality, a critical inventory control process where specific items are counted at predetermined intervals to ensure perpetual inventory record accuracy. By maintaining the schedule for when specific items in specific warehouses are due to be counted, the IC_ITEM_CDT table enables systematic and proactive inventory management, directly supporting operational and financial auditing requirements.

Key Information Stored

The table's structure is designed to uniquely define a scheduled count event. Its primary key is the system-generated identifier, ITEM_CDT_ID. The business key, enforced by a unique constraint (IC_ITEM_CDT_U1), is a composite of several critical columns: WHSE_CODE (warehouse), ITEM_ID (item master identifier), SCHED_DT (the scheduled count date), CYCLE_TYPE, and CYCLE_ID. This combination ensures a unique schedule entry per item, warehouse, date, and counting cycle. Other important columns include TEXT_CODE, which links to descriptive text in the IC_TEXT_HDR table, allowing for additional notes or instructions related to the scheduled count.

Common Use Cases and Queries

The primary use case is generating count schedules and worklists for inventory personnel. A typical query would retrieve all scheduled counts for a given warehouse within a date range to plan daily counting activities. For example:

  • Retrieving Upcoming Schedules: SELECT whse_code, item_id, sched_dt FROM gmi.ic_item_cdt WHERE whse_code = :p_whse AND sched_dt BETWEEN SYSDATE AND SYSDATE+7 ORDER BY sched_dt;
  • Identifying Items for a Specific Cycle Count: Reports often join IC_ITEM_CDT with item master tables (like IC_ITEM_MST) to list item numbers and descriptions scheduled for a particular cycle (CYCLE_ID) on a specific date.
  • Data Maintenance: Administrators may run queries to identify or clean up obsolete or duplicate schedule entries based on item status or warehouse deactivation.

Related Objects

The IC_ITEM_CDT table has defined foreign key relationships with other key inventory tables, as documented in the ETRM metadata:

  • IC_WHSE_INV: The table references IC_WHSE_INV via the columns ITEM_ID and WHSE_CODE. This validates that a scheduled count is for a valid item-warehouse combination that exists in the on-hand inventory records.
  • IC_TEXT_HDR: The table references IC_TEXT_HDR via the column TEXT_CODE. This allows optional descriptive text (instructions, notes) to be associated with the count schedule.

These relationships are crucial for data integrity and for constructing comprehensive reports that combine schedule data with item details and inventory quantities.