Results for “ae_sequence_value”

12 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OZF_AE_HEADERS_ALL is the header-level accounting table within the Oracle Trade Management (OZF) module. It stores one record for each accounting event, capturing the accounting header information that governs how a Trade Management transaction is posted to the General Ledger. In Oracle EBS 12.1.1 and 12.2.2, this table acts as the central accounting repository for accruals, settlements, and other Trade Management financial events, with detailed accounting distributions maintained one level down in OZF_AE_LINES_ALL.

From a Data Vault modeling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table carries descriptive and transactional attributes (accounting date, period name, transfer flags) while pointing outward to OZF_ACCTNG_EVENTS_ALL via ACCOUNTING_EVENT_ID, which functions as the parent event hub. The presence of standard EBS who-columns (CREATED_BY, LAST_UPDATED_BY, and related audit fields) reinforces its satellite nature, holding context that changes over time rather than defining core business entities.

Key Information Stored

The table contains 46 columns, of which the most operationally significant are:

Common Use Cases and Queries

Typical reporting scenarios include reconciling Trade Management accruals to GL, diagnosing transfer failures, and auditing accounting periods. A frequent query joins headers to lines to reconstruct full distributions:

  • Identify unposted events: SELECT AE_HEADER_ID, ACCOUNTING_DATE FROM OZF_AE_HEADERS_ALL WHERE GL_TRANSFER_FLAG = 'N';
  • Trace a transfer run: filter on GL_TRANSFER_RUN_ID to list all headers in a given GL transfer batch.
  • Error triage: query rows where ACCOUNTING_ERROR_CODE or GL_TRANSFER_ERROR_CODE is not null.
  • Period close reporting: aggregate by PERIOD_NAME and SET_OF_BOOKS_ID.

Developers commonly extract rows by ACCOUNTING_EVENT_ID when integrating with subledger accounting or custom reconciliation programs.

Related Objects

  • OZF_ACCTNG_EVENTS_ALL — parent table joined on ACCOUNTING_EVENT_ID.
  • OZF_AE_LINES_ALL — child table referencing this table via AE_HEADER_ID; holds line-level distributions.
  • FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID for access control.
  • GL_JE_HEADERS / GL_JE_LINES — downstream GL journals created from transferred Trade Management accounting.
  • OZF_AE_HEADERS_ALL_PK and unique indexes OZF_AE_HEADERS_ALL_U1 (AE_HEADER_ID) and OZF_AE_HEADERS_ALL_U2 (ACCOUNTING_EVENT_ID, SET_OF_BOOKS_ID) — enforce integrity and support key lookups.