Search Results ic_tran_pnd

Overview

The IC_TRAN_PND table is a core data structure within the Process Manufacturing Inventory (GMI) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a staging or holding table for pending inventory transactions. Its primary role is to temporarily store transaction data—such as material issues, receipts, transfers, and adjustments—before these transactions are validated, processed, and posted to permanent inventory tables. This intermediary step is critical for ensuring data integrity, allowing for error checking, and supporting complex process manufacturing workflows where transactions may be initiated from various sources like production, quality, or cost management.

Key Information Stored

The table's primary key is the TRANS_ID column, which uniquely identifies each pending transaction record. Based on its extensive foreign key relationships, the table stores comprehensive details about each pending transaction. Key data points include the item identifier (ITEM_ID), lot information (LOT_ID, LOT_STATUS, QC_GRADE), warehouse location (WHSE_CODE), and organizational context (CO_CODE, ORGN_CODE). It also captures transaction quantities and units of measure (TRANS_UM, TRANS_UM2), reason codes (REASON_CODE), document references (DOC_TYPE, TEXT_CODE), and other control attributes necessary for subsequent processing and validation against master data.

Common Use Cases and Queries

A primary use case is troubleshooting transaction processing failures or delays. Developers and functional consultants often query this table to identify transactions stuck in a pending state. A common diagnostic query involves joining with item and lot master tables to get a readable list of pending entries:

• SELECT itp.trans_id, itp.doc_id, iim.item_no, ilm.lot_no, itp.trans_qty, itp.trans_um FROM gmi.ic_tran_pnd itp JOIN gmi.ic_item_mst iim ON itp.item_id = iim.item_id LEFT JOIN gmi.ic_lots_mst ilm ON itp.item_id = ilm.item_id AND itp.lot_id = ilm.lot_id WHERE itp.delete_mark = 0;

Another critical scenario is data cleanup or manual intervention, where administrators may need to delete or correct erroneous pending transactions before restarting a transaction processor. Reporting on pending transaction volumes by warehouse or item is also a common operational need.

Related Objects

As indicated by its foreign keys, IC_TRAN_PND has strong dependencies on numerous master data tables, including IC_ITEM_MST(B) for items, IC_LOTS_MST for lots, IC_WHSE_MST for warehouses, and SY_ORGN_MST(B) for organizations. It is referenced by the IC_STAT_RPT table, suggesting its role in status reporting. The table is intrinsically linked to the transaction processing engine of the GMI module. While not listed in the provided metadata, it is typically populated by various inventory transaction interfaces and processed by dedicated concurrent programs or APIs that validate and transfer its records to final transaction history tables, such as IC_TRAN_CMP.