Search Results ic_xfer_mst




Overview
Explore in AI Chat

Overview

The IC_XFER_MST table is the central master table for inventory transfer transactions within Oracle E-Business Suite Process Manufacturing (GMI) inventory. It serves as the primary record for tracking the movement of items between warehouses or organizations, capturing the header-level information for each transfer. This table is fundamental to the inventory logistics and material flow processes in Oracle EBS 12.1.1 and 12.2.2, ensuring data integrity for inter-warehouse and inter-organization transfers. Its design supports complex manufacturing environments where precise lot and status control is required.

Key Information Stored

The table stores the core attributes defining an inventory transfer. As indicated by its primary keys, each record is uniquely identified by either a system-generated TRANSFER_ID or a business key combination of TRANSFER_BATCH, ORGN_CODE, and TRANSFER_NO. Critical columns include ITEM_ID for the transferred item, LOT_ID for specific lot tracking, and FROM_WAREHOUSE and TO_WAREHOUSE to define the movement path. The table also holds reason codes for key actions (RELEASE_REASON_CODE, RECEIVE_REASON_CODE, CANCEL_REASON_CODE), associated unit of measure codes (RELEASE_UOM1, RELEASE_UOM2), and a TEXT_CODE for linking descriptive notes. The ORGN_CODE ties the transaction to a specific operating unit.

Common Use Cases and Queries

This table is central to inquiries and reports on transfer order history, status, and traceability. Common operational scenarios include tracking open transfers, analyzing transfer reasons, and reconciling inventory movements. A typical query to retrieve basic transfer header information would join to related master tables:

  • SELECT x.transfer_no, x.transfer_batch, i.item_no, wf.whse_code as from_whse, wt.whse_code as to_whse, x.lot_id FROM gmi.ic_xfer_mst x, gmi.ic_item_mst i, gmi.ic_whse_mst wf, gmi.ic_whse_mst wt WHERE x.item_id = i.item_id AND x.from_warehouse = wf.whse_code AND x.to_warehouse = wt.whse_code AND x.orgn_code = :p_org;
  • Reporting on transfer activity by reason code or analyzing transfer cycle times from release to receipt.
  • Troubleshooting and audit processes that require tracing the complete history of a specific lot's movement across warehouses.

Related Objects

IC_XFER_MST has extensive relationships with other GMI and foundation tables, as shown in its foreign key constraints. Key dependencies include: