Results for “gl_translation_tracking”

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

Overview

GL_TRANSLATION_TRACKING is a General Ledger (GL) table in the Oracle E-Business Suite 12.1.1 and 12.2.2 schemas. It records the history of foreign currency translation activity performed against a ledger and its balancing segment values. Oracle General Ledger uses this information to determine which periods have already been translated for a given target currency, budget version, and posting context (actual versus budget, average versus period-end rates), thereby avoiding redundant translation runs and supporting incremental translation processing.

Each row represents the translation state for a specific combination of ledger, balancing segment value, target currency, translation method flag, and budget version. The tracked period attributes describe the boundary periods for translation completeness. From a dimensional modelling perspective, the heuristic Data Vault classification for this object is a link, since it primarily resolves relationships between ledgers, currencies, budget versions, and balancing segment values rather than acting as an independent business event hub.

Key Information Stored

The documented primary key is GL_TRANSLATION_TRACKING_PK, composed of LEDGER_ID, BAL_SEG_VALUE, TARGET_CURRENCY, AVERAGE_TRANSLATION_FLAG, and ACTUAL_FLAG. This composite key is a natural/business identifier rather than a single surrogate sequence, and an additional unique index GL_TRANSLATION_TRACKING_U1 exists on LEDGER_ID, BAL_SEG_VALUE, TARGET_CURRENCY, AVERAGE_TRANSLATION_FLAG, and TARGET_BUDGET_VERSION_ID. The most significant columns include:

• LEDGER_ID — identifies the ledger (sets of books) being tracked; foreign key to GL_SETS_OF_BOOKS_11I.
• BAL_SEG_VALUE — the balancing segment value for which translation state is maintained.
• TARGET_CURRENCY — the translation target currency; foreign key to FND_CURRENCIES.
• AVERAGE_TRANSLATION_FLAG — indicates whether average rate translation is being tracked versus period-end rate translation.
• ACTUAL_FLAG — distinguishes actual balances from budget balances.
• TARGET_BUDGET_VERSION_ID — the budget version applicable when translating budget data; foreign key to GL_BUDGET_VERSIONS.
• EARLIEST_EVER_PERIOD_NAME, EARLIEST_EVER_PERIOD_NUM, EARLIEST_EVER_PERIOD_YEAR — the earliest period ever translated.
• EARLIEST_NEVER_PERIOD_NAME, EARLIEST_NEVER_PERIOD_NUM, EARLIEST_NEVER_PERIOD_YEAR — the earliest period not yet translated.
• FIRST_OUTDATED_PERIOD_NAME, FIRST_OUTDATED_EFF_PERIOD_NUM — the first period whose translation has become stale and requires rerun.
• LAST_UPDATE_DATE, LAST_UPDATED_BY — standard audit columns recording who last modified the row and when.

Common Use Cases and Queries

Typical objectives include auditing translation coverage, identifying ledgers with outstanding or outdated periods, and troubleshooting translation program behaviour (for example, whether translation is being skipped as already complete). A representative query lists tracking rows for a ledger and currency:

• SELECT ledger_id, bal_seg_value, target_currency, actual_flag, earliest_never_period_name, first_outdated_period_name FROM gl_translation_tracking WHERE ledger_id = :ledger_id AND target_currency = :currency;
• Identify outstanding translations: filter rows where EARLIEST_NEVER_PERIOD_NAME or FIRST_OUTDATED_PERIOD_NAME is populated.
• Join to GL_SETS_OF_BOOKS_11I to translate LEDGER_ID into a ledger name for reporting.
• Correlate with GL_BUDGET_VERSIONS where ACTUAL_FLAG indicates budget translation.

Related Objects

• GL_SETS_OF_BOOKS_11I — joined on GL_TRANSLATION_TRACKING.LEDGER_ID.
• FND_CURRENCIES — joined on GL_TRANSLATION_TRACKING.TARGET_CURRENCY.
• GL_BUDGET_VERSIONS — joined on GL_TRANSLATION_TRACKING.TARGET_BUDGET_VERSION_ID.
• GL_BALANCES and GL_PERIOD_STATUSES — logically related for translation scope and period validation.
• GL_TRANSLATION_TRACKING_PK / GL_TRANSLATION_TRACKING_U1 indexes — enforcing uniqueness for translation state.