Search Results po_acceptances

Overview

The PO_ACCEPTANCES table is a core transactional data store within the Oracle E-Business Suite Purchasing (PO) module. It serves as the central repository for recording formal acceptance actions performed on purchase order shipments. This table is critical for tracking procurement lifecycle events, particularly for documenting supplier or buyer acknowledgment of receipt and agreement to the terms of a specific shipment line. Its data is essential for audit trails, compliance reporting, and understanding the fulfillment status of purchased goods and services.

Key Information Stored

The table's primary key is ACCEPTANCE_ID, which uniquely identifies each acceptance record. As indicated by its foreign key relationships, the table is fundamentally linked to three primary purchasing documents: the purchase order header (PO_HEADERS_ALL via PO_HEADER_ID), the blanket release (PO_RELEASES_ALL via PO_RELEASE_ID), and, most granularly, the specific shipment line (PO_LINE_LOCATIONS_ALL via PO_LINE_LOCATION_ID). While the provided metadata does not list all columns, typical data stored includes the acceptance date, the party who performed the acceptance (e.g., supplier or buyer), the acceptance type (e.g., preliminary, final), the quantity accepted, and references to related documents or communications.

Common Use Cases and Queries

A primary use case is generating reports on supplier performance and order fulfillment timelines. Analysts query this table to determine the lag between shipment receipt and formal acceptance. Another critical use is supporting audit inquiries by providing a complete history of acceptance actions for a given purchase order. Common SQL patterns involve joining PO_ACCEPTANCES to PO_LINE_LOCATIONS_ALL and PO_HEADERS_ALL to retrieve acceptance details alongside order and item information.

• Sample Query Pattern: Selecting acceptance records for a specific PO number requires joining through PO_HEADERS_ALL. For example: SELECT pha.segment1 AS po_number, pla.line_location_id, pa.acceptance_date, pa.accepted_quantity FROM po_acceptances pa, po_headers_all pha, po_line_locations_all pla WHERE pa.po_header_id = pha.po_header_id AND pa.po_line_location_id = pla.line_location_id AND pha.segment1 = '<PO_NUMBER>';
• Reporting Use Case: Creating a report showing all shipments pending formal acceptance by comparing accepted quantities in PO_ACCEPTANCES against quantities received and billed in related tables.

Related Objects

As defined by its foreign keys, PO_ACCEPTANCES has direct dependencies on three major purchasing base tables:

• PO_HEADERS_ALL: Links the acceptance to the overarching purchase order.
• PO_RELEASES_ALL: Links the acceptance to a specific blanket purchase agreement release.
• PO_LINE_LOCATIONS_ALL: Provides the most precise link to the specific shipment line being accepted. This is often the most critical relationship for transactional reporting.

In practice, data from this table is also surfaced through various Purchasing inquiry forms and is integral to the logic within the PO APIs and the Purchasing documents open interface tables.