Search Results gl_ledger_norm_seg_vals




Overview
Explore in AI Chat

Overview

GL_LEDGER_NORM_SEG_VALS is a General Ledger table in the Oracle E-Business Suite GL schema that stores the set of valid balancing segment values (the "natural account" style normalizations applied to the balancing segment) associated with a specific ledger. In EBS 12.1.1 and 12.2.2, this table functions as a ledger-level validation and normalization registry, controlling which balancing segment values a ledger may use when posting journal entries and ensuring that only authorized legal-entity/balancing segment combinations are permitted.

From a Data Vault modeling perspective, the heuristic classification of this object is satellite-leaning. It carries descriptive attributes (status, start/end dates, segment value type) that embellish the parent ledger and legal-entity keys, rather than acting as an independent business hub or a pure many-to-many link. This classification is a modeling suggestion derived from the foreign-key structure and should not be treated as an authoritative Data Vault design.

Key Information Stored

The table is documented with 32 physical columns. The most consequential are:

Common Use Cases and Queries

The table is commonly queried to determine which balancing segment values are valid for a given ledger, to reconcile legal-entity assignments, and to investigate posting or journal import failures caused by invalid balancing segment values. A representative query joining to the ledger is:

  • SELECT n.SEGMENT_VALUE, n.STATUS_CODE, n.START_DATE, n.END_DATE FROM GL_LEDGER_NORM_SEG_VALS n, GL_LEDGERS l WHERE n.LEDGER_ID = l.LEDGER_ID AND l.LEDGER_ID = :ledger_id;
  • Filtering active rows only with WHERE STATUS_CODE = 'A' and enforcing the effective range via START_DATE/END_DATE for point-in-time reporting.
  • Tracing a row back to its originating concurrent request via the REQUEST_ID join to FND_CONCURRENT_REQUESTS for audit and troubleshooting.

Related Objects

  • GL_LEDGERS — parent ledger; joined on LEDGER_ID.
  • FV_LEGAL_ENTITIES — joined on LEGAL_ENTITY_ID.
  • FND_CONCURRENT_REQUESTS — joined on REQUEST_ID.
  • GL_LEDGER_SEGMENT_VALUES — references this table through PARENT_RECORD_ID, linking normalized values to individual segment values.