Search Results ic_cycl_dtl




Overview
Explore in AI Chat

Overview

The IC_CYCL_DTL table is a core data object within the Process Manufacturing Inventory (GMI) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as the detailed transaction table for cycle count activities. While the header table (IC_CYCL_HDR) defines a cycle count, this detail table stores the specific inventory items, lots, and locations that are scheduled to be counted or have been counted. Its primary role is to maintain the granular line-level data necessary for executing, tracking, and reconciling physical inventory counts against system perpetual inventory records, a critical process for inventory accuracy and financial control in a process manufacturing environment.

Key Information Stored

The table's structure is designed to uniquely identify each count line and link it to master data. Its primary key columns define the specific counting instance: CYCLE_ID (link to the header), ITEM_ID, WHSE_CODE, LOT_ID, LOCATION, and COUNT_NO. Other significant columns, while not listed in the provided metadata, typically include fields for recording counted quantities (e.g., CYCLE_QTY), system on-hand quantities at the time of count (e.g., ONHAND_QTY), variance calculations, count status indicators (e.g., counted, approved, adjusted), and user identifiers for who performed the count. The foreign key constraints explicitly documented enforce referential integrity with the cycle count header (IC_CYCL_HDR) and the lot master (IC_LOTS_MST).

Common Use Cases and Queries

This table is central to cycle count operations. Common use cases include generating pick lists for counters, reviewing count variances before approval, and analyzing count history for specific items or locations. A typical reporting query might join IC_CYCL_DTL to IC_CYCL_HDR for header information and to IC_ITEM_MST for item descriptions to create a count schedule or variance report.

  • Sample Query for Pending Counts: SELECT d.cycle_id, d.item_id, i.item_no, d.lot_id, d.location, d.whse_code FROM gmi.ic_cycl_dtl d, gmi.ic_item_mst i WHERE d.item_id = i.item_id AND d.cycle_id = '&CYCLE_ID' AND d.count_status IS NULL;
  • Sample Query for Variance Analysis: SELECT d.item_id, d.lot_id, d.location, d.onhand_qty, d.cycle_qty, (d.cycle_qty - d.onhand_qty) variance FROM gmi.ic_cycl_dtl d WHERE d.cycle_id = '&CYCLE_ID' AND d.count_status = 'COUNTED';

Related Objects

IC_CYCL_DTL has defined dependencies within the GMI schema. As per the metadata, it is directly linked via foreign keys to two primary tables:

  • IC_CYCL_HDR: The parent header table that defines the cycle count parameters (e.g., date, status, warehouse).
  • IC_LOTS_MST: The lot master table, ensuring that counted lots are valid.

It also has an implicit relationship with IC_ITEM_MST (Item Master) via the ITEM_ID column, and is likely referenced by various GMI cycle count forms, reports, and inventory reconciliation programs that process count details for approval and adjustment postings to inventory balances.