Results for “gl_revaluations”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GL_REVALUATIONS is the General Ledger definition table that stores the user-defined revaluation configurations used to restate foreign-currency-denominated balances into the ledger's functional currency. In Oracle EBS 12.1.1 and 12.2.2, revaluation is a period-end process that adjusts account balances for exchange-rate movements; each row in this table represents one named revaluation definition that controls the source currency, rate selection, account ranges, gain/loss account assignment, and posting behavior applied during execution. The object is owned by the GL schema and is documented with 95 columns in the ETRM 12.2.2 physical schema, with a status of VALID.

From a dimensional-modelling perspective, the mined foreign-key structure suggests a satellite-leaning classification: the table is largely descriptive and hangs off an owning parent rather than acting as an independent hub. Most columns are attributes describing how a revaluation behaves, such as currency options, rate selection, and gain/loss segment assignments, which is characteristic of satellite behaviour. It is best treated as a configuration satellite anchored to the set of books (ledger) as its principal parent, rather than as a transactional fact.

Key Information Stored

The surrogate primary key is REVALUATION_ID, enforced by the unique index GL_REVALUATIONS_PK. A second unique index, GL_REVALUATIONS_U2 on (SET_OF_BOOKS_ID_11I, NAME), is the documented business-key candidate: a revaluation name must be unique within its ledger.

• NAME — the user-visible revaluation definition name.
• SET_OF_BOOKS_ID_11I — the ledger (set of books) this revaluation belongs to.
• FROM_CURRENCY_CODE / FROM_CURRENCY_OPTION_CODE / FROM_PRIMARY_CURRENCY_FLAG — the foreign currency to revalue and whether an explicit code or primary-currency criterion selects it.
• CONVERSION_RATE_TYPE / CONVERSION_RATE_OPTION_CODE / REVALUATION_RATE — the rate source, rate-selection mode, and a spot rate override where applicable.
• RANGE_MODE_FLAG — indicates whether account selection uses ranges or a defined mode.
• AUTOMATIC_POST_FLAG — controls whether the resulting journal entry is posted automatically.
• GAIN_SEGMENT1..30 / LOSS_SEGMENT1..30 — the gain and loss account combinations, stored as individual segment values across up to 30 segments.
• CHART_OF_ACCOUNTS_ID / SECURITY_FLAG / CONTEXT — chart of accounts context, security enforcement, and descriptive-flexfield context.
• DESCRIPTION and the ATTRIBUTE1..15 columns — free-text description and descriptive-flexfield attributes.
• Audit columns CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical reporting and troubleshooting scenarios include listing all revaluations for a ledger, exporting gain/loss account assignments, and auditing which definitions post automatically. A frequent pattern joins the definition to its account ranges for completeness.

• List active definitions per ledger: SELECT revaluation_id, name, from_currency_code, automatic_post_flag FROM gl_revaluations WHERE set_of_books_id_11i = :ledger_id;
• Audit gain/loss accounts using the documented segment columns: SELECT name, gain_segment1, loss_segment1 FROM gl_revaluations WHERE revaluation_id = :id;
• Find ranges: SELECT r.revaluation_id, r.* FROM gl_reval_account_ranges r WHERE r.revaluation_id = :id;
• Trace generated balances: join GL_CODE_COMBINATIONS on REVALUATION_ID to identify combinations that resulted from a revaluation run.
• Resolve the rate source by joining conversion_rate_type to GL_DAILY_CONVERSION_TYPES.

Related Objects

• GL_SETS_OF_BOOKS_11I — parent ledger via SET_OF_BOOKS_ID_11I.
• FND_CURRENCIES — validates FROM_CURRENCY_CODE.
• GL_DAILY_CONVERSION_TYPES — resolves CONVERSION_RATE_TYPE.
• GL_REVAL_ACCOUNT_RANGES — child table holding account ranges, joined on REVALUATION_ID.
• GL_CODE_COMBINATIONS — references REVALUATION_ID through its own REVALUATION_ID column.
• GL_MGT_SEG_UPGRADE_H — referenced through CHART_OF_ACCOUNTS_ID.

The table is maintained through the revaluation definition forms rather than being written directly by client code.