Search Results gl_revaluations




Overview
Explore in AI Chat

Overview

The GL_REVALUATIONS table is a core data object within the Oracle E-Business Suite General Ledger (GL) module. It serves as the master repository for revaluation definitions. In Oracle EBS, the revaluation process is a critical periodic accounting function used to adjust the balances of foreign currency-denominated assets, liabilities, revenues, and expenses to reflect current exchange rates at the end of an accounting period. This table stores the configuration and control parameters that define how these revaluations are to be performed, ensuring financial statements remain accurate and compliant with accounting standards such as FASB 52 (ASC 830). Each record represents a unique, user-defined revaluation setup that can be executed repeatedly.

Key Information Stored

The table's primary key is REVALUATION_ID, which uniquely identifies each revaluation definition. Based on the provided metadata and standard implementation, other crucial columns include SET_OF_BOOKS_ID_11I, which links the definition to a specific ledger or set of books. The FROM_CURRENCY_CODE specifies the functional currency of the ledger for which the revaluation is run. The CONVERSION_RATE_TYPE column defines the type of exchange rate (e.g., Corporate, Spot) to be used for the revaluation calculations, referencing the GL_DAILY_CONVERSION_TYPES table. Additional columns typically found in this table, though not explicitly listed in the brief metadata, include parameters for the revaluation run date, posting options, gain/loss account defaults, and status indicators to control the processing workflow.

Common Use Cases and Queries

The primary use case is the execution and audit of the period-end foreign currency revaluation process. Administrators query this table to review existing setups before a run or to troubleshoot issues. Common SQL patterns include listing all active revaluations for a specific ledger or analyzing the configuration details. For example, a query to retrieve basic revaluation definitions for a ledger might be: SELECT REVALUATION_ID, NAME, FROM_CURRENCY_CODE, CONVERSION_RATE_TYPE FROM GL.GL_REVALUATIONS WHERE SET_OF_BOOKS_ID_11I = :ledger_id;. Reporting use cases often involve joining this table with GL_JE_HEADERS or GL_JE_LINES to trace posted revaluation journal entries back to their source definition, providing a clear audit trail for financial controls.

Related Objects

The GL_REVALUATIONS table has documented foreign key relationships with several other key GL tables, forming the core of the revaluation subsystem. As per the provided metadata:

  • GL_SETS_OF_BOOKS_11I: Joined via GL_REVALUATIONS.SET_OF_BOOKS_ID_11I. This links the revaluation definition to its target ledger.
  • FND_CURRENCIES: Joined via GL_REVALUATIONS.FROM_CURRENCY_CODE. This validates the functional currency code.
  • GL_DAILY_CONVERSION_TYPES: Joined via GL_REVALUATIONS.CONVERSION_RATE_TYPE. This defines the exchange rate type for the calculation.
  • GL_CODE_COMBINATIONS: Has a foreign key (REVALUATION_ID) referencing this table. This relationship allows specific accounts to be flagged or associated with a revaluation setup.
  • GL_REVAL_ACCOUNT_RANGES: Joined via GL_REVAL_ACCOUNT_RANGES.REVALUATION_ID. This child table stores the specific account ranges (e.g., asset and liability accounts) to be included in the revaluation run.
These relationships ensure data integrity and enable the complex process of generating revaluation journal entries.