Search Results trans_flag




Overview
Explore in AI Chat

Overview

The IC_ADJS_JNL table is a core transactional table within the Process Manufacturing Inventory (GMI) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the detailed journal for inventory adjustment transactions, recording the specific line-item details for any material quantity or status changes made within the process manufacturing inventory system. As a journal table, it provides a granular, auditable record of adjustments, which is critical for inventory accuracy, cost management, and compliance reporting. Its existence under the GMI schema highlights its primary role in supporting the specialized requirements of process industries, such as lot and grade tracking.

Key Information Stored

The table's primary key, IC_ADJS_JNL_PK, is composed of the columns TRANS_TYPE, TRANS_FLAG, DOC_ID, and DOC_LINE, which together uniquely identify each adjustment journal line. Based on the provided foreign key relationships, the table stores detailed information linking each adjustment to fundamental master data. Key columns include ITEM_ID (linking to IC_ITEM_MST), LOT_ID (linking to IC_LOTS_MST), WHSE_CODE (linking to IC_WHSE_MST), and QC_GRADE (linking to GMD_GRADES_B and QC_GRAD_MST). It also holds organizational context via CO_CODE and ORGN_CODE (linking to SY_ORGN_MST), documents the REASON_CODE for the adjustment, and records the unit of measure (ITEM_UM, ITEM_UM2) for the adjusted quantity. The JOURNAL_ID column links the detail lines to a header record in the IC_JRNL_MST table.

Common Use Cases and Queries

The primary use case is auditing and reporting on inventory adjustments. Analysts query this table to investigate inventory variances, track adjustment reasons, and reconcile physical counts to system quantities. Common SQL patterns involve joining to master tables to make the data human-readable. For example, a query to list recent adjustments for a specific item would join IC_ADJS_JNL to IC_ITEM_MST_B for the item number and SY_REAS_CDS_B for the reason description. Another critical use case is supporting period-end close processes, where finance teams may run queries to summarize adjustment values by cost element or subinventory. Performance reports often aggregate data from this table by reason code or warehouse to identify trends in inventory accuracy issues.

Related Objects

IC_ADJS_JNL has extensive relationships with other EBS objects, as evidenced by its numerous foreign keys. It is directly tied to the journal header via IC_JRNL_MST. Its core inventory relationships are with item master (IC_ITEM_MST, IC_ITEM_MST_B), lot master (IC_LOTS_MST), lot status (IC_LOTS_STS), and warehouse master (IC_WHSE_MST). For process manufacturing specifics, it links to grade masters (GMD_GRADES_B, QC_GRAD_MST). It also integrates with shared EBS foundations: organization (SY_ORGN_MST), unit of measure (SY_UOMS_MST), reason codes (SY_REAS_CDS), and the document system (SY_DOCS_MST via TRANS_TYPE). This network of relationships ensures data integrity and enables comprehensive reporting across modules.