Search Results journal_id




Overview
Explore in AI Chat

Overview

The IC_JRNL_MST table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMI) module, specifically for Inventory management. It functions as the journal master header table, serving as the primary repository for high-level transactional metadata. Each record in this table represents a distinct inventory journal, which documents and controls a batch of related inventory transactions, such as adjustments, transfers, or cycle count entries. Its role is to provide a controlled, auditable header for grouping detailed line-level transactions, ensuring data integrity and facilitating period-end processing and reconciliation within the manufacturing inventory system.

Key Information Stored

The table stores essential header-level attributes for an inventory journal. The primary identifier is the system-generated JOURNAL_ID, which uniquely defines the journal header. The business-facing key is the combination of JOURNAL_NO (the journal number) and ORGN_CODE (the organization code), which together provide a unique identifier for user reference and reporting. Other critical columns typically include STATUS for tracking the journal's lifecycle (e.g., New, Posted), JOURNAL_DATE, a DESCRIPTION, and a TEXT_CODE that links to descriptive text in the IC_TEXT_HDR table. The ORGN_CODE column establishes the organizational context for all transactions within the journal.

Common Use Cases and Queries

This table is central to inventory transaction auditing, reporting, and troubleshooting. A common use case is tracing the approval and posting status of inventory adjustments. Analysts frequently query this table to list all journals for a specific organization within a date range or to find details for a particular journal number. Sample SQL patterns include joining to related transaction tables for comprehensive reporting.

  • Retrieving journal headers by organization and date:
    SELECT journal_id, journal_no, journal_date, status FROM gmi.ic_jrnl_mst WHERE orgn_code = 'M1' AND TRUNC(journal_date) = :p_date;
  • Finding unposted journals for review:
    SELECT * FROM gmi.ic_jrnl_mst WHERE status NOT IN ('POSTED') AND orgn_code = :org;
  • Joining to detail tables (like IC_ADJS_JNL) to report on all adjustments within a journal:
    SELECT h.journal_no, h.description, d.* FROM gmi.ic_jrnl_mst h, gmi.ic_adjs_jnl d WHERE h.journal_id = d.journal_id AND h.journal_no = 'JRNL-1001';

Related Objects

IC_JRNL_MST is a pivotal table with several key relationships. It is directly referenced by detail transaction tables, most notably IC_ADJS_JNL, which stores adjustment line items linked via JOURNAL_ID. For descriptive text, it references the IC_TEXT_HDR table through the TEXT_CODE foreign key. Furthermore, it maintains referential integrity with the organization master tables, SY_ORGN_MST and SY_ORGN_MST_B, via the ORGN_CODE column. These relationships ensure that every journal is associated with a valid operating unit and that its detailed transactions are properly anchored to a master header record.