Search Results cst_ae_headers




Overview
Explore in AI Chat

Overview

The CST_AE_HEADERS table is a core data structure within the Bills of Material (BOM) product of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the primary header table for storing and managing periodic accounting distributions. This table is fundamental to the periodic costing and accounting processes, particularly for activities like closing inventory and work in process (WIP) periods. It acts as a parent record, grouping detailed accounting line distributions (stored in CST_AE_LINES) that are generated for inventory, WIP, and receiving transactions during period-end processing. Each header record represents a distinct accounting event batch, ensuring transactional integrity and providing a consolidated audit trail for cost postings to the General Ledger.

Key Information Stored

The table's primary key is AE_HEADER_ID, a unique identifier for each accounting distribution header. Its structure is defined by critical foreign key relationships that contextualize the accounting event. Key columns include SET_OF_BOOKS_ID, linking to the GL_SETS_OF_BOOKS table to define the ledger. The ACCOUNTING_EVENT_ID column references source transaction tables (MTL_MATERIAL_TRANSACTIONS, WIP_TRANSACTIONS, RCV_TRANSACTIONS) to tie the accounting distribution back to the original inventory movement. For periodic costing, the COST_TYPE_ID and PERIOD_ID columns are essential, linking to CST_COST_TYPES and CST_PAC_PERIODS respectively, to define the cost set and accounting period being closed. The ORGANIZATION_ID and LEGAL_ENTITY_ID columns anchor the distribution to the specific inventory organization and its associated legal entity for financial reporting.

Common Use Cases and Queries

The primary use case is troubleshooting and auditing period-end cost accounting flows. Analysts query this table to verify that accounting distributions were created, to investigate discrepancies between transaction costs and posted amounts, or to trace the impact of a specific transaction through the accounting engine. A common diagnostic query joins CST_AE_HEADERS with CST_AE_LINES and the source transaction table to review distributions for a specific period or event.

  • Sample Query: To find accounting headers for a specific organization and period:
    SELECT csh.ae_header_id, csh.period_id, csh.accounting_event_id, csh.cost_type_id, COUNT(cl.line_id) num_lines FROM bom.cst_ae_headers csh, bom.cst_ae_lines cl WHERE csh.ae_header_id = cl.ae_header_id AND csh.organization_id = 123 AND csh.period_id = 1001 GROUP BY csh.ae_header_id, csh.period_id, csh.accounting_event_id, csh.cost_type_id;
  • This data is also critical for custom reports that detail the journal entries generated by the inventory accounting process before they are transferred to the General Ledger.

Related Objects

CST_AE_HEADERS is central to a network of related objects. Its most direct child is the CST_AE_LINES table, which holds the detailed debit and credit entries linked via the AE_HEADER_ID foreign key. As indicated by its foreign keys, it draws context from master data tables like GL_SETS_OF_BOOKS, CST_COST_TYPES, CST_PAC_PERIODS, MTL_PARAMETERS, and HR_ALL_ORGANIZATION_UNITS. Crucially, it references transactional source tables—MTL_MATERIAL_TRANSACTIONS, WIP_TRANSACTIONS, and RCV_TRANSACTIONS—via the ACCOUNTING_EVENT_ID column, creating the essential link between physical/material transactions and their financial accounting consequences.