Search Results sy_orgn_mst_b




Overview
Explore in AI Chat

Overview

The IC_TRAN_ARC table is a core data repository within the Oracle E-Business Suite Process Manufacturing (GMI) module. It functions as the permanent archive for all completed inventory transactions. While operational transaction tables manage current and in-process movements, IC_TRAN_ARC stores the historical record, providing a critical audit trail for inventory activity, cost history, and compliance reporting. Its existence is essential for maintaining system performance by allowing the purging of live transaction tables while preserving vital historical data for financial reconciliation, traceability, and long-term analysis in a manufacturing environment.

Key Information Stored

The table's primary key is TRANS_ID, which uniquely identifies each archived transaction record. As indicated by its extensive foreign key relationships, the table stores a comprehensive set of attributes describing each transaction. Key data points include the item identifier (ITEM_ID), warehouse (WHSE_CODE) and location (LOCATION), lot information (LOT_ID, LOT_STATUS), and transaction quantities and units of measure (TRANS_UM, TRANS_UM2). It also captures organizational context (CO_CODE, ORGN_CODE), document references (DOC_TYPE), reason codes (REASON_CODE), quality grades (QC_GRADE), and associated text notes (TEXT_CODE). This structure encapsulates the complete "who, what, when, where, and why" of every inventory movement.

Common Use Cases and Queries

Primary use cases revolve around historical reporting and audit. Common queries include generating transaction history reports for specific items or lots, analyzing inventory movements for cost accounting periods, and supporting regulatory traceability (e.g., lot genealogy). A typical pattern is joining IC_TRAN_ARC to master tables for descriptive information. For example, to report archived transactions for an item, one might use:

  • SELECT ita.trans_id, ita.trans_date, ita.lot_id, ita.trans_qty, iim.item_no
  • FROM gmi.ic_tran_arc ita
  • JOIN gmi.ic_item_mst iim ON ita.item_id = iim.item_id
  • WHERE iim.item_no = '<ITEM_NUMBER>'
  • ORDER BY ita.trans_date DESC;

Another critical use is reconciling inventory balances over time by summarizing transaction quantities by item, lot, and warehouse from this archive.

Related Objects

IC_TRAN_ARC is centrally connected to numerous master and transactional entities. As per the metadata, its primary foreign keys link to core GMI and foundation tables: IC_ITEM_MST(_B) for items, IC_LOTS_MST for lots, IC_WHSE_MST and IC_LOCT_MST for warehouse and location data, and SY_ORGN_MST(_B) for organization context. It also references SY_UOMS_MST for units of measure, SY_REAS_CDS(_B) for reason codes, and QC_GRAD_MST/GMD_GRADES_B for quality grades. This table is the historical counterpart to the active transaction tables (such as IC_TRAN_PND, IC_TRAN_CMP) within the GMI transaction processing flow. Data is typically moved into IC_TRAN_ARC via the module's archival or purge programs.