Search Results xla_ae_segment_values_pk

Overview

XLA_AE_SEGMENT_VALUES is a Subledger Accounting (XLA) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the balancing segment and management segment values associated with a subledger journal entry. Subledger Accounting creates accounting entries in the XLA_AE_HEADERS and XLA_AE_LINES tables, and the segment values that drive the balancing and management segment context for each header are persisted in this table. The object resides in the XLA schema and holds the resolved segment values that the accounting engine determines during journal entry creation, rather than recomputing them at query time.

From a dimensional modeling perspective, the metadata's heuristic Data Vault classification is standalone. Because the table carries its own foreign key relationship (UPG_BATCH_ID to XLA_UPG_BATCHES) and is anchored by a composite primary key, it may be treated as a satellite-like structure attached to the journal entry header, recording descriptive segment context rather than acting as a pure hub or link.

Key Information Stored

The table is deliberately narrow — only five documented columns — and each carries a specific role:

• AE_HEADER_ID — The identifier of the subledger journal entry header. This is the anchor that ties every row to a specific accounting entry in XLA_AE_HEADERS.
• SEGMENT_TYPE_CODE — Indicates whether the stored value represents the balancing segment or the management segment context for the entry.
• SEGMENT_VALUE — The actual segment value (for example, a balancing segment value such as a company or legal entity code) associated with the header.
• AE_LINES_COUNT — A count of accounting lines associated with the header at the time the segment value row is written.
• UPG_BATCH_ID — The upgrade batch identifier, used during data migration or upgrade processing; it references XLA_UPG_BATCHES.

The physical key is XLA_AE_SEGMENT_VALUES_PK, comprising AE_HEADER_ID, SEGMENT_TYPE_CODE, and SEGMENT_VALUE. The unique index XLA_AE_SEGMENT_VALUES_U1 covers the same three columns, making it the business-key candidate for a given header and segment type. The distinguishing column set effectively enumerates the balancing or management segment combinations applicable to each journal entry.

Common Use Cases and Queries

Typical uses center on reconciling and reporting balancing segment behavior for subledger journals. Analysts join this table to XLA_AE_HEADERS to resolve the segment values behind an accounting entry, or to filter entries by balancing segment value during period-end close.

• Balancing segment lookup: Retrieve all segment values for a header using SELECT segment_type_code, segment_value FROM xla.xla_ae_segment_values WHERE ae_header_id = :header_id.
• Segment-based journal reporting: Join to XLA_AE_HEADERS and XLA_AE_LINES to produce line-level reports enriched with the resolved balancing segment value.
• Line-count validation: Compare AE_LINES_COUNT against the actual count in XLA_AE_LINES to detect discrepancies after data fixes or upgrades.
• Upgrade reconciliation: Join UPG_BATCH_ID to XLA_UPG_BATCHES to audit which segment value rows were produced during a specific upgrade batch.

These patterns support subledger-to-GL reconciliation, management segment analysis, and troubleshooting of entries whose segment derivation appears inconsistent.

Related Objects

The table participates in a small but tightly coupled set of XLA objects:

• XLA_AE_HEADERS — Parent of this table via AE_HEADER_ID; supplies journal entry header context.
• XLA_AE_LINES — Joined via AE_HEADER_ID to attach segment values to accounting lines.
• XLA_UPG_BATCHES — Referenced by UPG_BATCH_ID; tracks upgrade batch processing.
• XLA_AE_SEGMENT_VALUES_PK — Primary key constraint enforcing header, segment type, and value uniqueness.
• XLA_AE_SEGMENT_VALUES_U1 — Unique index supporting the same business-key candidate columns.

Because the classification is standalone, most dependencies flow outward from this table to the header and upgrade entities rather than from child objects referencing it.