Results for “ozf_ae_headers_all_u1”
12 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OZF.OZF_AE_HEADERS_ALL is the header-level repository for General Ledger Accounting Event (AE) information within the Oracle Trade Management (OZF) application in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores one row per accounting event header, capturing the relationship between a trade management accounting event recorded in OZF_ACCTNG_EVENTS_ALL and the resulting set of accounting entries destined for subledger accounting and transfer to the General Ledger. In ETRM documentation the object is presented as an organization-stripped, multi-org aware table exposed through an operating-unit filtered view, so queries executed through the view return only rows belonging to the current operating unit while rows for other operating units are ignored.
The table resides in the APPS_TS_TX_DATA tablespace and is physically implemented with 46 documented columns. Its heuristic Data Vault classification is satellite-leaning: the object primarily stores descriptive and status attributes (accounting date, flags, error codes, period name) that change over time in response to processing events, keyed off the accounting event and header identifiers. This classification is a modeling suggestion derived from the foreign-key structure rather than an Oracle-declared architectural property.
Key Information Stored
The surrogate primary key is AE_HEADER_ID, which uniquely identifies each accounting event header via the OZF_AE_HEADERS_ALL_PK constraint and the OZF_AE_HEADERS_ALL_U1 unique index on the same column. A second unique index, OZF_AE_HEADERS_ALL_U2, covers ACCOUNTING_EVENT_ID together with SET_OF_BOOKS_ID and represents the principal business-key candidate: the combination of accounting event and ledger must be unique.
Among the most significant columns:
- AE_HEADER_ID — surrogate primary key of the header row.
- ACCOUNTING_EVENT_ID — foreign key to OZF_ACCTNG_EVENTS_ALL; the accounting event that generated this header.
- SET_OF_BOOKS_ID — the ledger for which the accounting entries are generated; part of the U2 business key.
- ACCOUNTING_DATE — the date relevant to the accounting event; indexed by NONUNIQUE indexes N2 and N3.
- PERIOD_NAME — the GL accounting period associated with the entries.
- AE_CATEGORY and AE_SEQUENCE_ID / AE_SEQUENCE_VALUE — event categorization and sequencing attributes.
- GL_TRANSFER_FLAG and GL_TRANSFER_RUN_ID — status and run identifier for the transfer of entries to the General Ledger; indexed by NONUNIQUE indexes N1 and N2 respectively.
- GL_TRANSFER_ERROR_CODE — error code recorded when the GL transfer fails.
- ACCOUNTING_ERROR_CODE — error code produced during accounting entry generation.
- CROSS_CURRENCY_FLAG and GL_REVERSAL_FLAG — flags controlling cross-currency treatment and GL reversal behaviour.
- ORG_ID — operating unit identifier driving the multi-org view filter.
- AE_HEADER_ID-adjacent standard WHO columns such as LAST_UPDATE_DATE, CREATED_BY, and PROGRAM_ID support auditing and concurrent program traceability.
- ATTRIBUTE1 through ATTRIBUTE15 and ATTRIBUTE_CATEGORY — the standard descriptive flexfield columns.
Common Use Cases and Queries
The table is typically queried to reconcile trade management accounting events with their General Ledger transfer status, to identify headers that failed accounting or transfer processing, and to report on accounting activity by period or operating unit.
A representative reconciliation query joins the header to its accounting event:
SELECT h.ae_header_id, h.accounting_event_id, h.accounting_date, h.period_name, h.gl_transfer_flag, h.gl_transfer_run_id FROM ozf_ae_headers_all h WHERE h.gl_transfer_flag IS NULL OR h.gl_transfer_error_code IS NOT NULL;SELECT h.ae_header_id, h.set_of_books_id, h.ae_category, h.accounting_error_code FROM ozf_ae_headers_all h WHERE h.accounting_event_id = :event_id;SELECT h.period_name, COUNT(*) FROM ozf_ae_headers_all h WHERE h.set_of_books_id = :sob_id GROUP BY h.period_name;
Reporting uses include ageing reports of untransferred entries by ACCOUNTING_DATE (leveraging indexes N2 and N3), error-resolution dashboards driven by ACCOUNTING_ERROR_CODE and GL_TRANSFER_ERROR_CODE, and period-close monitoring of the GL_TRANSFER_FLAG by run.
Related Objects
The most significant related objects, per the documented foreign-key relationships, are:
- OZF.OZF_ACCTNG_EVENTS_ALL — referenced by OZF_AE_HEADERS_ALL.ACCOUNTING_EVENT_ID; the parent accounting event table.
- OZF_AE_LINES_ALL — references OZF_AE_HEADERS_ALL.AE_HEADER_ID; the line-level accounting entries belonging to each header.
- FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID, governing functional security access to the row.
- The multi-org stripped view over OZF_AE_HEADERS_ALL, which applies the ORG_ID operating-unit filter.
- Concurrent programs and GL transfer processes keyed by GL_TRANSFER_RUN_ID that consume this table during subledger transfer.
-
This table stores all the account headers for every accounting event
-
This table stores all the account headers for every accounting event
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
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