Search Results gl_je_categories_tl




Overview
Explore in AI Chat

Overview

The GL_JE_CATEGORIES_TL table is a core translation table within the Oracle E-Business Suite General Ledger (GL) module, specifically for versions 12.1.1 and 12.2.2. It stores the translated names and descriptions for journal entry categories, which are user-defined classifications for grouping journal entries. These categories are fundamental for reporting, reconciliation, and controlling the posting of journals. The '_TL' suffix denotes it as a translatable table, adhering to Oracle's Multi-Language Support (MLS) architecture. This design separates language-specific text from the base data, allowing a single installation to support multiple languages concurrently. The table's primary role is to provide the language-specific labels for the journal categories defined in its base table, GL_JE_CATEGORIES_B.

Key Information Stored

The table's structure centers on pairing a journal category with a language code to store its localized representation. The primary key is a composite of JE_CATEGORY_NAME and LANGUAGE, ensuring a unique entry for each category in each supported language. While the full column list is not detailed in the provided metadata, a standard Oracle EBS translation table pattern includes key columns such as JE_CATEGORY_NAME (the key linking to the base table), LANGUAGE (the language code, e.g., 'US', 'F'), SOURCE_LANG (the original language of the record), DESCRIPTION (the translated description of the category), and LAST_UPDATE_LOGIN. The data enables the application to display category names appropriately based on the user's session language.

Common Use Cases and Queries

This table is primarily accessed indirectly by the application's user interface to display translated values. Common technical and reporting use cases include generating multi-language reports on journal entry classifications and troubleshooting data issues where category descriptions appear incorrectly for a given language. A typical query to retrieve all translations for a specific category, or to see all categories in a specific language, would join this table with its base table. For instance, to list all journal category names and descriptions for the French language, one might use:

  • SELECT tl.je_category_name, tl.description
  • FROM gl_je_categories_tl tl
  • WHERE tl.language = 'F';

Another common pattern is to join with GL_JE_HEADERS or GL_JE_LINES for reports that require the localized category description alongside journal details.

Related Objects

As indicated by the foreign key metadata, GL_JE_CATEGORIES_TL is a central reference point for several key tables. Its most significant relationship is with its base table, GL_JE_CATEGORIES_B, which holds the non-translatable attributes. Crucially, it is referenced extensively by the Fixed Assets module table FA_BOOK_CONTROLS, which uses specific journal categories (e.g., for depreciation, additions, retirements) to automate accounting entries. The provided metadata lists over a dozen foreign key columns from FA_BOOK_CONTROLS to this table. Within General Ledger, it is referenced by GL_BC_OPTION_DETAILS and GL_BC_PACKETS (related to Budgetary Control). The primary journal entry tables, GL_JE_HEADERS and GL_JE_BATCHES, also reference the journal category key, though their foreign keys typically point to the base table, with the application leveraging the TL table for display.