Results for “gl_posted_ind”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PM_HIST_HDR is a production history header table owned by the GME (Process Manufacturing Process Execution) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It records header-level production history events generated as batches move through the process manufacturing lifecycle, capturing status transitions and warehouse reassignments. In practice, PM_HIST_HDR functions as a transactional history ledger that preserves a record of what changed on a batch, when, and under which concurrent program or request. Data Vault modeling suggests classifying this table as satellite-leaning, with its primary key (EVENT_ID) behaving as a link to production history detail rather than a true business hub key.

Key Information Stored

The table contains 16 documented columns. The most significant are listed below.

The documented primary key is EVENT_ID. The metadata does not identify a separate unique business-key index, so BATCH_ID combined with status and audit attributes serves as the practical business identifier.

Common Use Cases and Queries

Typical uses include batch status transition audits, WIP warehouse movement reporting, GL posting reconciliation, and concurrent program traceability.

  • Batch status history: SELECT h.BATCH_ID, h.ORIG_STATUS, h.NEW_STATUS, h.CREATION_DATE FROM GME.PM_HIST_HDR h WHERE h.BATCH_ID = :batch_id ORDER BY h.CREATION_DATE;
  • Warehouse movement analysis: join ORIG_WIP_WHSE and NEW_WIP_WHSE to IC_WHSE_MST to describe warehouse transfers.
  • Unposted GL transactions: SELECT * FROM GME.PM_HIST_HDR WHERE GL_POSTED_IND = 'N';
  • Concurrent program audit: filter on REQUEST_ID, PROGRAM_ID, or PROGRAM_APPLICATION_ID to trace which job produced each history row.

Related Objects

  • PM_BTCH_HDR — Joined on PM_HIST_HDR.BATCH_ID = PM_BTCH_HDR.BATCH_ID; the parent batch header.
  • IC_WHSE_MST — Joined twice, via ORIG_WIP_WHSE and NEW_WIP_WHSE, for warehouse lookups.
  • PC_TRAN_PND — References PM_HIST_HDR via EVENT_ID (PC_TRAN_PND.EVENT_ID → PM_HIST_HDR.EVENT_ID), linking pending transactions to history events.

Together these relationships position PM_HIST_HDR as the central header record for production history events within Process Manufacturing Process Execution.