Search Results oe_header_acks




Overview
Explore in AI Chat

Overview

The OE_HEADER_ACKS table is a core data repository within the Oracle E-Business Suite (EBS) Order Management (ONT) module. It serves the critical function of storing transactional snapshots of order header information specifically for the purpose of customer acknowledgements. When an order is acknowledged, key header-level data is persisted in this table, creating a historical record of the terms, pricing, and parties as they were at the moment of acknowledgement. This is essential for audit trails, dispute resolution, and maintaining the integrity of the agreed-upon order details, independent of subsequent changes to the original order in the OE_ORDER_HEADERS_ALL table.

Key Information Stored

The table captures a comprehensive set of header attributes from the original sales order. While the specific column list is not detailed in the provided metadata, the extensive foreign key relationships reveal the categories of data stored. Key stored information includes references to the original order header (HEADER_ID), customer and site details (e.g., SHIP_TO_CUSTOMER_ID, SOLD_TO_ADDRESS_ID, INVOICE_CUSTOMER_ID), financial terms (PAYMENT_TERM_ID, CUSTOMER_PAYMENT_TERM_ID), pricing and revenue rules (ACCOUNTING_RULE_ID, INVOICING_RULE_ID), sales representative (SALESREP_ID), currency (TRANSACTIONAL_CURR_CODE), and operational details like the sold-from and ship-from organizations. This denormalized snapshot ensures the acknowledgement document reflects a precise point-in-time state.

Common Use Cases and Queries

Primary use cases involve auditing and reporting on acknowledged orders. Common queries include retrieving the acknowledgement snapshot for a specific order, comparing acknowledged terms to current order terms to identify changes, and generating reports for customer service on what was formally communicated to the customer. A typical SQL pattern joins this table to its related master data tables to produce a human-readable acknowledgement record.

SELECT oh.order_number, oha.acknowledgement_date,
       hca_sold.customer_name sold_to_customer,
       hz_party_sold.party_name sold_to_party_name,
       rt.name payment_terms
FROM ont.oe_header_acks oha,
     ont.oe_order_headers_all oh,
     hz_cust_accounts hca_sold,
     hz_parties hz_party_sold,
     ra_terms_b rt
WHERE oha.header_id = oh.header_id
  AND oha.ship_to_customer_id = hca_sold.cust_account_id(+)
  AND hca_sold.party_id = hz_party_sold.party_id(+)
  AND oha.payment_term_id = rt.term_id(+)
  AND oh.order_number = '<ORDER_NUMBER>';

Related Objects

OE_HEADER_ACKS maintains numerous foreign key relationships, integrating it deeply with the EBS data model. The most critical relationship is to the source order header via OE_ORDER_HEADERS_ALL (HEADER_ID). Other significant relationships include:

These relationships are essential for constructing complete acknowledgement reports by joining to these master tables.