Search Results po_dist_dtl




Overview
Explore in AI Chat

Overview

The PO_DIST_DTL table is a core transactional table within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module for versions 12.1.1 and 12.2.2. It serves as the detailed repository for General Ledger (GL) accounting distributions generated from procurement and inventory receipt activities. Specifically, it captures the financial accounting entries (debits and credits) associated with purchase orders and stock receipt transactions. This table is fundamental for ensuring that all material costs are properly accounted for and posted to the correct GL accounts, forming a critical link between the procurement/inventory and financial accounting subsystems.

Key Information Stored

The table stores detailed distribution lines that define the financial impact of a transaction. Its primary key is a composite of DOC_TYPE, DOC_ID, LINE_ID, RECV_SEQ_NO, and SEQ_NO, which uniquely identifies each accounting distribution line. Key columns include identifiers for the source document (DOC_TYPE, DOC_ID), the associated item (ITEM_ID), and the quantity and unit of measure (QUANTITY_UM). Crucially, it holds the accounting dimensions: the specific GL account (ACCT_ID), the ledger (LEDGER_CODE), the accounting unit (ACCTG_UNIT_ID), and the transaction and base currencies (CURRENCY_TRANS, CURRENCY_BASE). The AQUI_COST_ID links to the procurement cost type, and the CO_CODE identifies the company organization.

Common Use Cases and Queries

This table is central to financial reporting, account reconciliation, and audit trails for procurement costs. A common use case is tracing the GL distributions for a specific purchase order receipt to verify costs have been accrued correctly. Analysts often query this table to analyze procurement spending by account, ledger, or item. A typical reporting query would join PO_DIST_DTL to document and item master tables to produce a detailed cost distribution report.

  • Sample Query: To find all GL distributions for a specific purchase order document:
    SELECT d.*, m.ITEM_CODE
    FROM GML.PO_DIST_DTL d,
    GML.IC_ITEM_MST m
    WHERE d.DOC_TYPE = 'PO'
    AND d.DOC_ID = :p_po_id
    AND d.ITEM_ID = m.ITEM_ID(+);
  • Audit Trail: The table provides a complete audit of which GL accounts were charged for inventory receipts, supporting period-end closing and cost variance analysis.

Related Objects

PO_DIST_DTL has extensive relationships with master and transactional tables across financials, inventory, and procurement modules, as indicated by its foreign keys. Primary related objects include:

These relationships enforce data integrity and ensure that distributions are based on valid, configured setup data.