Search Results ic_cycl_msc




Overview
Explore in AI Chat

Overview

The IC_CYCL_MSC table is a core data object within the Oracle E-Business Suite Process Manufacturing Inventory (GMI) module. It serves as a transactional repository for items that are manually added to a cycle count, supplementing the primary list of items generated by the system's ABC analysis. This table is essential for enabling flexible and comprehensive physical inventory counts, allowing users to include specific items outside the automated selection criteria. Its existence directly supports the accuracy and completeness of inventory valuation and reconciliation processes in a manufacturing environment.

Key Information Stored

The table's structure is designed to link manually added items to a specific cycle count header and classify them appropriately. Its primary key, CYCL_MSC_ID, uniquely identifies each record. The composite unique key (CYCLE_ID, ENTRY_TYPE, ITEM_ID, ABC_CODE) ensures no duplicate entries for a given combination. Critical foreign key columns include CYCLE_ID, which references the IC_CYCL_HDR table to define the parent count, and ITEM_ID, which links to the item master tables (IC_ITEM_MST_B and IC_ITEM_MST) to identify the specific inventory item. The ENTRY_TYPE and ABC_CODE fields classify the nature of the addition and the item's ABC ranking, while TEXT_CODE can store associated descriptive notes via a link to the IC_TEXT_HDR table.

Common Use Cases and Queries

The primary use case is reviewing or auditing the list of items manually included in a specific cycle count. A common query retrieves all manually added items for a given cycle, joining to the item master for descriptions. This is vital for count sheet preparation and process verification.

  • Sample Query: SELECT msc.*, mst.item_no, mst.item_desc FROM gmi.ic_cycl_msc msc JOIN gmi.ic_item_mst mst ON msc.item_id = mst.item_id WHERE msc.cycle_id = :cycle_id ORDER BY msc.abc_code;
  • Reporting: Reports often aggregate manually added items by ABC code to analyze count strategy coverage or identify trends in user-added exceptions.
  • Data Integrity: Queries are used to validate that all ITEM_ID values in IC_CYCL_MSC have corresponding active records in the item master, ensuring referential integrity.

Related Objects

IC_CYCL_MSC is centrally connected to several key GMI tables. It is a direct child of the IC_CYCL_HDR table, which defines the cycle count header. Its fundamental relationship is with the item master, through both IC_ITEM_MST_B (base) and IC_ITEM_MST. For storing descriptive text, it references the IC_TEXT_HDR table via the TEXT_CODE column. In a typical data flow, items from this table are consolidated with system-generated items for the final count list, impacting subsequent count entry and variance tables in the cycle counting process.