Search Results pm_hist_hdr




Overview
Explore in AI Chat

Overview

The PM_HIST_HDR table is a core data object within the Oracle E-Business Suite Process Manufacturing (GME) module. It functions as the primary production history header table, serving as a central repository for recording and tracking significant transactional events related to batch production. Its role is to provide a historical audit trail for batch operations, capturing the state and context of a batch at the moment a material transaction or status change is posted. This table is essential for traceability, cost accounting, and performance analysis within Process Manufacturing Process Execution.

Key Information Stored

The table's structure is designed to anchor a batch's historical record. The primary key, EVENT_ID, uniquely identifies each historical event. Critical foreign key relationships define the table's context: BATCH_ID links the event to a specific production batch in the PM_BTCH_HDR table. The ORIG_WIP_WHSE and NEW_WIP_WHSE columns, referencing the IC_WHSE_MST table, track warehouse transfers for work-in-process (WIP) material. While the provided metadata does not list all columns, typical data stored includes timestamps of the event, the type of transaction performed, the user responsible, and references to associated material transaction documents, forming a complete header record for subsequent detailed history lines.

Common Use Cases and Queries

This table is fundamental for generating production history and audit reports. Common use cases include tracing the complete lifecycle of a batch, investigating material movements, and supporting period-end close processes. A typical query pattern joins PM_HIST_HDR to batch and transaction detail tables to reconstruct production events.

  • Batch History Report: SELECT hdr.EVENT_ID, hdr.BATCH_ID, bh.BATCH_NO, hdr.EVENT_DATE FROM GME.PM_HIST_HDR hdr, GME.PM_BTCH_HDR bh WHERE hdr.BATCH_ID = bh.BATCH_ID ORDER BY hdr.EVENT_DATE;
  • WIP Warehouse Transfers: Queries filtering on ORIG_WIP_WHSE and NEW_WIP_WHSE to analyze internal batch material movements.
  • Transaction Investigation: Joining to PC_TRAN_PND or related detail tables via EVENT_ID to diagnose posting errors or validate completed transactions.

Related Objects

PM_HIST_HDR is a central node in the Process Manufacturing schema with several key dependencies, as indicated by its foreign keys.

  • PM_BTCH_HDR: The primary parent table, providing the batch master record for each EVENT_ID.
  • IC_WHSE_MST: Referenced twice to validate the original and new warehouse codes for WIP transfers.
  • PC_TRAN_PND: Has a foreign key relationship where PC_TRAN_PND.EVENT_ID references PM_HIST_HDR.EVENT_ID, linking pending cost transactions to a historical event.
  • PM_HIST_DTL: While not listed in the provided metadata, this detail table almost certainly exists, linked by EVENT_ID, to store line-level material, resource, and by-product transactions for each header event.