Results for “ae_sequence_id”
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:
- AE_HEADER_ID — the surrogate primary key, enforced by index OZF_AE_HEADERS_ALL_PK.
- ACCOUNTING_EVENT_ID — foreign key to OZF_ACCTNG_EVENTS_ALL; combined with SET_OF_BOOKS_ID it forms the business-key candidate indexed by OZF_AE_HEADERS_ALL_U2.
- SET_OF_BOOKS_ID — identifies the ledger to which the accounting entries are posted.
- ACCOUNTING_DATE and PERIOD_NAME — define the GL date and accounting period for the event.
- AE_CATEGORY and AE_SEQUENCE_ID / AE_SEQUENCE_VALUE — classify and order the accounting event.
- GL_TRANSFER_FLAG, GL_TRANSFER_RUN_ID, and GL_TRANSFER_ERROR_CODE — govern and audit transfer to General Ledger (note the legacy misspelled GL_TRANSFAR_* variants also persist).
- GL_REVERSAL_FLAG and CROSS_CURRENCY_FLAG — control reversal behavior and cross-currency posting.
- ACCOUNTING_ERROR_CODE — captures validation failures during accounting.
- ORG_ID — the operating unit, enabling multi-org security.
- SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS for data access control.
- DESCRIPTION — free-text narrative for the accounting event.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the standard EBS descriptive flexfield columns.
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.
-
This table stores all the account headers for every accounting event
-
This table stores all the account headers for every accounting event
-
eTRM - OZF Tables and Views 12.2.2
OZF_XREF_MAP table created for SIebel TPM Integration
-
eTRM - OZF Tables and Views 12.1.1
Table to store the Market eligibilty for a Offer Worksheet