Search Results ax_distrib_headers_pk

Overview

The AX.AX_DISTRIB_HEADERS table belongs to the Global Accounting Engine (AX) product within Oracle E-Business Suite, a module responsible for generating accounting entries for subledger transactions and for performing cross-instance and cross-ledger translation. Within that architecture, AX_DISTRIB_HEADERS stores the distribution headers of translation schemes: the definitional metadata that describes how a source transaction column is mapped, filtered, and routed to a destination column when an accounting distribution is derived. It is definitional configuration rather than transactional fact data, and its rows change only when a translation scheme is configured or revised.

Mined from its foreign key topology, the object carries a satellite-leaning Data Vault classification. This is a modeling suggestion rather than a documented Oracle attribute. The table's key structure is dominated by descriptive attributes — HEADER_COLUMN, SOURCE_TABLE, SOURCE_COLUMN, and QUERY_CHAIN_NAME — that qualify a parent translation scheme. Its dependency on AX_TRANS_SCHEMES supplies the parent business context, and its connection to AX_QUERY_CHAINS supplies the filtering mechanism. Because the header descriptor itself is the subject of the row, a satellite placed on the translation-scheme hub is the more natural representation than a pure link table, although the query-chain association introduces an implicit link-like dimension.

Key Information Stored

The table is documented with thirteen columns in the 12.2.2 physical schema. The composite primary key, AX_DISTRIB_HEADERS_PK, is composed of SET_OF_BOOKS_ID, APPLICATION_ID, TRANSLATION_SCHEME, and HEADER_NUMBER. A separate unique index, AX_DISTRIB_HEADERS_U1, carries the identical column list, confirming this composite as the business-key candidate. In this scheme, HEADER_NUMBER functions as the ordinal identifier that sequences headers within a given translation scheme, while SET_OF_BOOKS_ID, APPLICATION_ID, and TRANSLATION_SCHEME together establish the owning configuration context.

• SET_OF_BOOKS_ID — the ledger for which the translation scheme is defined; also a foreign key to AX_TRANS_SCHEMES.
• APPLICATION_ID — the owning application of the translation scheme; participates in the foreign keys to both AX_TRANS_SCHEMES and AX_QUERY_CHAINS.
• TRANSLATION_SCHEME — the named translation scheme to which this header belongs.
• HEADER_NUMBER — the sequential header identifier within the translation scheme.
• HEADER_COLUMN — the target column populated by the header during distribution generation.
• SOURCE_TABLE and SOURCE_COLUMN — the source object and column from which values are drawn.
• QUERY_CHAIN_NAME — the query chain applied to restrict which source rows qualify; foreign keyed to AX_QUERY_CHAINS.APPLICATION_ID.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns recording who created and last maintained the configuration row.

Common Use Cases and Queries

Typical interactions are diagnostic and migration-oriented rather than high-volume transaction reporting. Investigators reconciling a translation scheme will list all headers for a scheme in sequence, and administrators auditing definitions will trace each header back to its source table and query chain. A representative query follows:

• Retrieve header definitions for a ledger and scheme: SELECT header_number, header_column, source_table, source_column, query_chain_name FROM ax.ax_distrib_headers WHERE set_of_books_id = :p_sob AND application_id = :p_app AND translation_scheme = :p_scheme ORDER BY header_number;
• Resolve the filter applied to a header by joining to the query chain table on APPLICATION_ID and QUERY_CHAIN_NAME.
• Identify all headers sourcing from a particular table and column, useful when a source schema is being changed, by filtering on SOURCE_TABLE.
• Audit configuration drift by comparing LAST_UPDATE_DATE and LAST_UPDATED_BY across environments.

Related Objects

The following objects are directly bound to AX_DISTRIB_HEADERS through documented foreign key relationships and are the most significant for navigation and impact analysis.

• AX_TRANS_SCHEMES — the parent object holding translation scheme definitions; joined on SET_OF_BOOKS_ID, APPLICATION_ID, and TRANSLATION_SCHEME.
• AX_QUERY_CHAINS — supplies the query chain referenced by QUERY_CHAIN_NAME and APPLICATION_ID, defining row-level filters.
• AX_CONDITIONS — the principal dependent child; it references this table on SET_OF_BOOKS_ID, APPLICATION_ID, TRANSLATION_SCHEME, and HEADER_NUMBER. Because a header in practice carries associated conditions, this is the first table to inspect when reconstructing a scheme's full logic.
• AX_DISTRIB_HEADERS_PK and AX_DISTRIB_HEADERS_U1 — the primary key constraint and unique index enforcing the composite business key.

Deleting or renumbering a header has a cascading definitional impact on AX_CONDITIONS, so schema changes should be staged and validated against those dependent rows before being promoted across environments.