Search Results ic_txn_request_headers




Overview
Explore in AI Chat

Overview

The IC_TXN_REQUEST_HEADERS table, owned by the GMI schema, is the header-level data object for Move Orders within the Oracle EBS Process Manufacturing Inventory module (GMI). A move order represents an internal inventory transfer request — moving material between subinventories, between organizations, or to a designated location — and IC_TXN_REQUEST_HEADERS acts as the controlling parent record that establishes the identity, type, source, and destination of each request. Each header row anchors a set of line-level detail records in IC_TXN_REQUEST_LINES, which carry the individual item and quantity instructions.

In Data Vault modeling terms, the mined foreign-key structure classifies this table as hub-leaning. This is a modeling suggestion: the two unique indexes on business keys (HEADER_ID and REQUEST_NUMBER/ORGANIZATION_ID) strongly indicate a natural business hub for move order headers, with descriptive attributes (dates, status, shipping attributes) suggesting satellite behavior around that hub. Physical layering depends on the warehouse design chosen.

Key Information Stored

The table carries 45 documented columns. The most operationally significant are:

Common Use Cases and Queries

Typical reporting scenarios include tracking open move orders by organization, reconciling completed transfers, and auditing status transitions. A representative query joins headers to lines:

  • List open move orders awaiting execution: SELECT HEADER_ID, REQUEST_NUMBER, ORGANIZATION_ID, HEADER_STATUS, DATE_REQUIRED FROM IC_TXN_REQUEST_HEADERS WHERE HEADER_STATUS < 'CLOSED'.
  • Detail a specific request: SELECT h.REQUEST_NUMBER, h.TRANSACTION_TYPE_ID, l.* FROM IC_TXN_REQUEST_HEADERS h JOIN IC_TXN_REQUEST_LINES l ON l.HEADER_ID = h.HEADER_ID WHERE h.REQUEST_NUMBER = :req.
  • Volume analysis by organization and type groupings.

Related Objects

The primary dependency is the line-level child table IC_TXN_REQUEST_LINES, joined on IC_TXN_REQUEST_LINES.HEADER_ID = IC_TXN_REQUEST_HEADERS.HEADER_ID. Transaction type and organization context reference inventory setup tables (MTL_TRANSACTION_TYPES, ORG_ORGANIZATION_DEFINITIONS). Location and account references link to shipping and GL tables. Move order processing is commonly driven through the inventory move order APIs and the GMI transaction execution programs.