Search Results gl_reval_account_ranges




Overview
Explore in AI Chat

Overview

The GL_REVAL_ACCOUNT_RANGES table is a core transactional table within the Oracle E-Business Suite General Ledger (GL) module, specifically for versions 12.1.1 and 12.2.2. It serves a critical function in the foreign currency revaluation process. This table stores the defined ranges of accounting flexfield segments that determine which specific accounts are subject to periodic revaluation. Its primary role is to act as a child configuration table to the GL_REVALUATIONS table, allowing financial administrators to precisely control which asset, liability, revenue, and expense accounts are revalued to reflect current exchange rates, thereby ensuring accurate financial reporting.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond the foreign key, the table's purpose and name imply a standard structure for defining segment ranges. Based on its function, the table typically contains columns to store the low and high values for each segment of the accounting flexfield (e.g., Company, Cost Center, Account) within a specified range. The most critical column, as documented, is REVALUATION_ID. This foreign key column links each account range record directly to its parent revaluation definition in the GL_REVALUATIONS table, establishing a one-to-many relationship. Other columns would logically include identifiers for the chart of accounts and the specific segment number being defined.

Common Use Cases and Queries

The primary use case is the setup and execution of the revaluation process. Before running revaluation, users define revaluation criteria in the GL_REVALUATIONS form, where they specify account ranges using this underlying table. A common reporting need is to audit which accounts are included in a specific revaluation run. A sample query to retrieve all account ranges for a given revaluation name would be:

  • SELECT gar.* FROM gl_reval_account_ranges gar, gl_revaluations gr WHERE gar.revaluation_id = gr.revaluation_id AND gr.name = 'MONTHLY_EURO_REVAL';

Another practical scenario involves troubleshooting revaluation results by verifying if a particular account segment value falls within any defined range for an active revaluation.

Related Objects

The table has a direct and documented foreign key relationship, making it a key component in the revaluation data model.

  • GL_REVALUATIONS: This is the primary parent table. The relationship is defined by the foreign key column GL_REVAL_ACCOUNT_RANGES.REVALUATION_ID referencing the GL_REVALUATIONS table. Every account range must be associated with a single, pre-defined revaluation setup.

This relationship ensures data integrity, as account ranges cannot exist without a parent revaluation definition. The revaluation process itself likely references this table to identify target accounts during its execution.