Search Results ic_cycl_adt_u1

Overview

The IC_CYCL_ADT table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMI) module. It serves as the primary repository for cycle count audit details. In inventory management, a cycle count is a periodic audit of a subset of inventory items to verify record accuracy and reconcile discrepancies. This table stores the granular, line-level transaction data generated during the execution and review of these cycle counts. Its role is critical for maintaining inventory integrity, supporting the reconciliation process, and providing an audit trail for count adjustments within Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table is structured to capture detailed information for each counted inventory lot or sublot. Its composite primary keys, IC_CYCL_ADT_PK (CYCLE_ID, SEQ_NO) and IC_CYCL_ADT_U1 (SEQ_NO, CYCLE_ID, ITEM_ID, WHSE_CODE, LOCATION, LOT_NO, SUBLOT_NO), enforce uniqueness for the count header and the specific counted item location, respectively. Key columns include identifiers for the cycle count header (CYCLE_ID) and line sequence (SEQ_NO), the specific inventory item (ITEM_ID), and its precise location defined by warehouse (WHSE_CODE), location, lot (LOT_NO), and sublot (SUBLOT_NO). The table also stores unit of measure information (UOM1, UOM2), linked to SY_UOMS_MST, and a document type (DOC_TYPE) linked to SY_DOCS_MST, which categorizes the count transaction.

Common Use Cases and Queries

The primary use case is querying detailed audit lines for a specific cycle count to review discrepancies before approval. A common reporting query retrieves all count lines for a cycle where the system quantity differs from the physically counted quantity, highlighting potential issues. For example:

• Identifying significant variances for a count batch: SELECT item_id, lot_no, location, system_qty, count_qty FROM gmi.ic_cycl_adt WHERE cycle_id = :p_cycle_id AND (system_qty - count_qty) != 0;
• Generating a cycle count audit trail report by joining with the count header table (IC_CYCL_MST) to include header description and status.
• Supporting the reconciliation process by providing the source data used to generate adjustment transactions in the inventory transaction interface.

Related Objects

IC_CYCL_ADT is centrally connected to several key GMI inventory tables. It is a child table of the cycle count header, IC_CYCL_MST, via the CYCLE_ID. The foreign key relationships documented in the metadata show its dependency on common system control tables: SY_DOCS_MST for document types and SY_UOMS_MST for units of measure. It is directly related to the core inventory master tables, such as IC_ITEM_MST (for ITEM_ID) and IC_LOCT_INV (for on-hand balances at the lot/sublot location level). Data from this table typically flows into inventory transaction tables (e.g., IC_TRAN_PND) when count variances are posted as adjustments.