Search Results ax_distrib_headers_u1

Overview

AX.AX_DISTRIB_HEADERS is a transactional configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the AX schema. It stores the distribution headers that define a translation scheme, capturing the mapping between source columns and target header columns in a multi-step data translation pipeline. Each row represents a single distribution header belonging to a specific translation scheme, and the table records the distribution header number within that scheme, the header column it populates, the query chain used to source data, and the source table and column from which values are drawn.

From a dimensional modeling perspective, the metadata's heuristic Data Vault classification is satellite-leaning. This table behaves as a descriptive satellite attached to the translation scheme hub (AX_TRANS_SCHEMES) rather than an independent hub or a pure link, because it carries attribute detail—such as HEADER_COLUMN, QUERY_CHAIN_NAME, SOURCE_TABLE, and SOURCE_COLUMN—keyed to a parent scheme. This classification should be treated as a modeling suggestion, not a definitive architectural mandate.

Key Information Stored

The table's physical structure consists of 13 documented columns. The most significant are:

• SET_OF_BOOKS_ID (NUMBER): The set of books identifier, part of the composite primary key and a foreign key to AX_TRANS_SCHEMES.
• APPLICATION_ID (NUMBER): The application identifier, part of the primary key and a foreign key to AX_QUERY_CHAINS.
• TRANSLATION_SCHEME (VARCHAR2 30): The translation scheme name to which the header belongs.
• HEADER_NUMBER (NUMBER): The distribution header number within the translation scheme.
• HEADER_COLUMN (VARCHAR2 30): The name of the target header column that this distribution header populates.
• QUERY_CHAIN_NAME (VARCHAR2 30): The query chain used to retrieve source data.
• SOURCE_TABLE (VARCHAR2 30): The query chain table supplying the source value.
• SOURCE_COLUMN (VARCHAR2 30): The specific column within the source table.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN (DATE/NUMBER): Standard Who audit columns tracking record creation and modification.

The composite surrogate primary key is AX_DISTRIB_HEADERS_PK (SET_OF_BOOKS_ID, APPLICATION_ID, TRANSLATION_SCHEME, HEADER_NUMBER). The unique index AX_DISTRIB_HEADERS_U1 enforces the same column set, making it the documented business-key candidate. A secondary nonunique index, AX_DISTRIB_HEADERS_N1, covers APPLICATION_ID and QUERY_CHAIN_NAME to accelerate lookup by query chain.

Common Use Cases and Queries

Typical reporting and diagnostic scenarios center on auditing translation schemes, validating source-to-target mappings, and tracing which query chains feed particular header columns. A common query joins distribution headers to their translation schemes to list all mappings for a given scheme:

• Retrieve all headers for a scheme: SELECT HEADER_NUMBER, HEADER_COLUMN, QUERY_CHAIN_NAME, SOURCE_TABLE, SOURCE_COLUMN FROM AX.AX_DISTRIB_HEADERS WHERE SET_OF_BOOKS_ID = :p_sob AND TRANSLATION_SCHEME = :p_scheme ORDER BY HEADER_NUMBER;
• Identify headers sharing a query chain: SELECT * FROM AX.AX_DISTRIB_HEADERS WHERE APPLICATION_ID = :p_app AND QUERY_CHAIN_NAME = :p_chain;
• Trace dependent conditions: join to AX_CONDITIONS on the four key columns to see which conditions constrain a header.

Because AX_DISTRIB_HEADERS_N1 covers APPLICATION_ID and QUERY_CHAIN_NAME, queries filtering by query chain perform efficiently. The audit columns support change-tracking and compliance reporting.

Related Objects

The following objects are most significant in relation to AX.AX_DISTRIB_HEADERS, based on documented foreign key and reference relationships:

• AX_TRANS_SCHEMES: Parent table referenced by SET_OF_BOOKS_ID; defines the translation scheme owning each distribution header.
• AX_QUERY_CHAINS: Referenced by APPLICATION_ID; defines the query chains that source column values.
• AX_CONDITIONS: Child table referencing AX_DISTRIB_HEADERS on (SET_OF_BOOKS_ID, APPLICATION_ID, TRANSLATION_SCHEME, HEADER_NUMBER); stores conditions governing header behavior.

Together these objects form the translation scheme configuration model, with AX_DISTRIB_HEADERS serving as the central mapping detail between schemes, query chains, and conditions.