Search Results ozf_ae_headers_all




Overview
Explore in AI Chat

Overview

The OZF_AE_HEADERS_ALL table is a core data object within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as the central repository for accounting header records, which are generated for every accounting event processed by the system. Each row in this table represents a distinct accounting header that groups related accounting entries (lines) for a specific financial transaction, such as a claim, accrual, or settlement. Its primary role is to serve as the parent structure in the accounting data model, ensuring transactional integrity and providing a high-level audit trail for all trade management-related accounting activities before detailed entries are posted to the general ledger.

Key Information Stored

The table's structure is designed to capture essential header-level attributes for accounting transactions. The primary key, AE_HEADER_ID, uniquely identifies each accounting header record. A critical foreign key column is ACCOUNTING_EVENT_ID, which links the header back to its source transaction in the OZF_ACCTNG_EVENTS_ALL table. While the provided metadata specifies these core identifiers, typical columns in such a header table would also include control information such as the LEDGER_ID, the accounting DATE, the JE_CATEGORY_NAME, the CURRENCY_CODE, and status flags indicating the posting status (e.g., 'U' for unposted, 'P' for posted). These fields collectively define the accounting context and validity period for the associated accounting lines.

Common Use Cases and Queries

This table is pivotal for reconciliation, auditing, and troubleshooting within the Trade Management accounting flow. Common operational and reporting scenarios include tracing the accounting impact of a specific marketing or trade promotion event, identifying unposted accounting entries for period-end close processes, and analyzing accounting entries by ledger or period. A typical query pattern joins this header table to its related lines and source event to provide a complete accounting audit trail. For example:

  • Identifying all accounting headers for a specific accounting event: SELECT * FROM ozf_ae_headers_all WHERE accounting_event_id = <event_id>;
  • Joining to lines to review full accounting entries: SELECT h.ae_header_id, h.accounting_date, l.code_combination_id, l.entered_dr, l.entered_cr FROM ozf_ae_headers_all h, ozf_ae_lines_all l WHERE h.ae_header_id = l.ae_header_id AND h.accounting_event_id = <event_id>;

Related Objects

The OZF_AE_HEADERS_ALL table is centrally positioned within the Trade Management accounting schema, with defined relationships to key transactional and sub-ledger tables. As per the documented metadata:

  • Parent Reference (Foreign Key): The table references OZF_ACCTNG_EVENTS_ALL via the ACCOUNTING_EVENT_ID column. This links every accounting header to its originating business event within Trade Management.
  • Child Reference (Primary Key): The table is referenced by OZF_AE_LINES_ALL via the AE_HEADER_ID column. This one-to-many relationship is fundamental, as each header record aggregates all detailed debit and credit accounting line items stored in the lines table.

This structure ensures that accounting data flows from the business event (OZF_ACCTNG_EVENTS_ALL) to the accounting header (OZF_AE_HEADERS_ALL) and finally to the detailed entries (OZF_AE_LINES_ALL), forming a complete and auditable sub-ledger.