Search Results po_recv_hst




Overview
Explore in AI Chat

Overview

The PO_RECV_HST table is a core audit trail table within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as a historical ledger, capturing a complete record of quantity and price modifications made to purchase order receipt and return lines. Its primary role is to provide a non-repudiable audit trail for changes in material receipt transactions, which is critical for inventory accuracy, cost accounting, and compliance. By storing each change as a sequential record, it enables users to reconstruct the history of a receipt from its initial creation through any subsequent adjustments.

Key Information Stored

The table's structure is designed to uniquely identify each audit entry and capture the specifics of the change. The primary key is a composite of RECV_ID (the receipt header identifier), RECV_LINE_ID (the receipt line identifier), RECV_SEQ_NO (a sequence number for the change event), and SUB_EVENT_TYPE (classifying the nature of the transaction). Key transactional columns include quantity and price fields, along with unit of measure references (PRICE_UM). The SUB_EVENT_TYPE column is a critical foreign key to GL_SEVT_MST (Sub-Event Master), which categorizes the financial or logistical event, such as a receipt, return, or correction. Other significant foreign keys link to the warehouse (TO_WHSE referencing IC_WHSE_MST) and descriptive flexfields (TEXT_CODE referencing PO_TEXT_HDR).

Common Use Cases and Queries

A primary use case is investigating receipt history for discrepancy resolution or audit purposes. Analysts can trace all adjustments to a specific receipt line. Another common scenario is generating reports for period-end reconciliation between procurement and inventory accounts, leveraging the SUB_EVENT_TYPE for financial classification. Sample queries often involve joining to receipt and purchase order tables to get a full transactional picture.

  • Audit Trail for a Receipt Line: SELECT recv_seq_no, sub_event_type, quantity, price FROM gml.po_recv_hst WHERE recv_id = :p_recv_id AND recv_line_id = :p_recv_line_id ORDER BY recv_seq_no;
  • Reconciling Receipt Events: Queries frequently join PO_RECV_HST to PO_RECV_LINES and GL_SEVT_MST to report on all financial events impacting inventory for a given period.

Related Objects

PO_RECV_HST is centrally connected to several key EBS tables. It is a child table of receipt line details, typically linking back to a table like PO_RECV_LINES via RECV_ID and RECV_LINE_ID. Its foreign key relationships, as documented, are essential for data integrity and reporting:

  • GL_SEVT_MST: Provides the meaning and accounting context for the SUB_EVENT_TYPE.
  • IC_WHSE_MST: Validates the warehouse (TO_WHSE) involved in the transaction.
  • SY_UOMS_MST: Defines the unit of measure for the price.
  • PO_TEXT_HDR: Stores descriptive flexfield text associated with the transaction.

This table is integral to the "Receiving" and "Inventory" transaction flows within Process Manufacturing, and its data is foundational for related inventory (GINV) and cost management interfaces.