Search Results ic_stat_rpt




Overview
Explore in AI Chat

Overview

The IC_STAT_RPT table is a core data object within the Process Manufacturing Inventory (GMI) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. As indicated by its description, it serves as the primary repository for Intrastat reporting data. Intrastat is the system for collecting statistics on the trade of goods between member states of the European Union. Therefore, this table is critical for organizations operating in the EU, as it stores the transactional details required to generate compliant statistical declarations for dispatches (exports) and arrivals (imports) of inventory items. Its role is to aggregate and hold relevant shipment and receipt information from inventory transactions for subsequent statutory reporting.

Key Information Stored

While the provided metadata does not list specific columns, the foreign key relationships define the essential links to other inventory entities. The table's primary function is to associate a specific inventory transaction (TRANS_ID) with its related item and lot details for statistical purposes. Key stored data points, inferred from these relationships, include the transaction identifier, item identifier, and lot identifier. This structure allows the system to tie a physical movement of goods, recorded in inventory transaction tables, to the master data about the item (from IC_ITEM_MST and IC_ITEM_MST_B) and its specific batch (from IC_LOTS_MST). The table likely also contains fields for statistical values, such as nature of transaction codes, delivery terms, mode of transport, and the declared fiscal value and net mass of the goods, which are standard requirements for Intrastat submissions.

Common Use Cases and Queries

The principal use case for the IC_STAT_RPT table is the generation of periodic Intrastat reports for submission to national statistical authorities. Data is typically populated into this table via a dedicated process or interface from completed inventory transactions that involve cross-border movement. Common reporting queries would join this table to its referenced masters to produce a detailed extract. A foundational SQL pattern would be:

  • SELECT isr.*, iim.item_no, ilm.lot_no, itc.trans_date, itc.trans_qty FROM gmi.ic_stat_rpt isr JOIN gmi.ic_item_mst iim ON isr.item_id = iim.item_id JOIN gmi.ic_lots_mst ilm ON isr.item_id = ilm.item_id AND isr.lot_id = ilm.lot_id JOIN gmi.ic_tran_cmp itc ON isr.trans_id = itc.trans_id WHERE itc.trans_date BETWEEN :p_start_date AND :p_end_date;

This extract would then be formatted according to national legal requirements, often involving further aggregation by partner country, commodity code, and transaction type.

Related Objects

The IC_STAT_RPT table has defined integration points with several key inventory tables, as shown in its foreign key constraints. It is directly linked to two transaction tables: IC_TRAN_CMP (completed transactions) and IC_TRAN_PND (pending transactions), via the TRANS_ID column. This indicates it can reference both finalized and in-process inventory movements. For item details, it references both IC_ITEM_MST_B (the base table) and IC_ITEM_MST. For lot-specific information, it is linked to IC_LOTS_MST using both ITEM_ID and LOT_ID. These relationships are fundamental, ensuring that the statistical report data is anchored to the official inventory records of items, lots, and material transactions within the Process Manufacturing system.