Search Results ic_tran_cmp

Overview

The IC_TRAN_CMP table is a core data repository within the Oracle E-Business Suite Process Manufacturing (GMI) module, specifically for inventory management. It serves as the definitive historical record for completed inventory transactions. When a material movement, such as a receipt, issue, transfer, or adjustment, is finalized within the system, its transactional details are written to this table. Its role is critical for maintaining a permanent, auditable trail of all inventory activity, supporting functions like inventory valuation, traceability, reconciliation, and historical reporting. The table's status as VALID across both EBS 12.1.1 and 12.2.2 indicates its fundamental and unchanged role in the inventory architecture.

Key Information Stored

The table's primary key is the TRANS_ID, which uniquely identifies each completed transaction. As evidenced by its extensive foreign key relationships, IC_TRAN_CMP stores comprehensive context for each transaction. Key data points include identifiers for the item (ITEM_ID), specific lot (LOT_ID), warehouse (WHSE_CODE), and organization (ORGN_CODE, CO_CODE). It captures transaction quantities and units of measure (TRANS_UM, TRANS_UM2), reason codes (REASON_CODE), and document references (DOC_TYPE, TEXT_CODE). Quality control information, such as QC_GRADE, and the transaction's lot status (LOT_STATUS) are also recorded. This structure ensures each record links to master data across items, lots, organizations, and reference codes.

Common Use Cases and Queries

This table is primarily queried for historical analysis and regulatory reporting. Common use cases include generating inventory transaction history reports, supporting lot traceability (forward and backward), calculating period-end inventory balances, and auditing inventory movements. A typical query pattern involves joining IC_TRAN_CMP to master tables like IC_ITEM_MST and IC_LOTS_MST to produce readable reports.

• Sample Query for Transaction History:
  SELECT itc.trans_id, itc.trans_date, iim.item_no, ilm.lot_no, itc.trans_qty, itc.whse_code
  FROM gmi.ic_tran_cmp itc
  JOIN gmi.ic_item_mst iim ON itc.item_id = iim.item_id
  JOIN gmi.ic_lots_mst ilm ON itc.item_id = ilm.item_id AND itc.lot_id = ilm.lot_id
  WHERE itc.orgn_code = '&org_code'
  AND itc.trans_date BETWEEN :p_from_date AND :p_to_date
  ORDER BY itc.trans_date DESC;
• Data is typically inserted into this table by the GMI module's transaction completion logic and should not be manipulated directly.

Related Objects

IC_TRAN_CMP has a central relationship with numerous master and reference tables, as detailed in its foreign key constraints. Critical dependencies include:

• Master Data: IC_ITEM_MST(_B) (Items), IC_LOTS_MST (Lots), IC_WHSE_MST (Warehouses), SY_ORGN_MST(_B) (Organizations).
• Reference Data: SY_REAS_CDS(_B) (Reason Codes), SY_UOMS_MST (Units of Measure), GMD_GRADES_B/QC_GRAD_MST (Grades).
• Supporting Data: IC_LOTS_STS (Lot Status), SY_DOCS_MST (Document Types), IC_TEXT_HDR (Text).
• Dependent Object: The IC_STAT_RPT table references IC_TRAN_CMP via its TRANS_ID, indicating it is used for generating status or summary reports.