Search Results gl_je_sources_pk

Overview

GL_JE_SOURCES_TL is the translation-enabled (TL) table within the Oracle General Ledger schema that stores journal entry sources and their language-specific descriptive text. In Oracle E-Business Suite 12.1.1 and 12.2.2, journal entry sources identify the origin or business process responsible for a journal entry — for example, Payables, Receivables, Inventory, or manual entry. These source values drive journal validation, edit rules, approval behavior, and reference requirements during the import and posting cycle.

The table is documented as VALID in the GL schema, with a description of "Journal entry sources." Its primary key is GL_JE_SOURCES_PK, composed of JE_SOURCE_NAME and LANGUAGE. Because the row count in the physical schema is 23 columns and the table name carries the _TL suffix, it functions as the language-dependent companion to the base GL_JE_SOURCES definition. From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone, meaning it has no mined foreign-key dependencies to other tables; in practice it can be modeled as a satellite attached to a JE_SOURCE_NAME-based hub, with LANGUAGE acting as an additional descriptive attribute.

Key Information Stored

The primary key is the composite GL_JE_SOURCES_PK (JE_SOURCE_NAME, LANGUAGE), which uniquely identifies each translated source name row per language. Business-key candidates are also enforced through three unique indexes: GL_JE_SOURCES_TL_U1 (JE_SOURCE_NAME, LANGUAGE, ZD_EDITION_NAME), GL_JE_SOURCES_TL_U2 (USER_JE_SOURCE_NAME, LANGUAGE, ZD_EDITION_NAME), and GL_JE_SOURCES_TL_U3 (JE_SOURCE_KEY, LANGUAGE, ZD_EDITION_NAME). The most important columns include:

• JE_SOURCE_NAME — the internal identifier for the journal entry source; a primary-key and unique-index component.
• LANGUAGE — the language code for the translated text; the second primary-key component.
• USER_JE_SOURCE_NAME — the user-facing display name of the source shown in forms and reports.
• JE_SOURCE_KEY — the seeded key used to identify standard Oracle-delivered sources.
• SOURCE_LANG — the source language from which the translation derives.
• DESCRIPTION — free-text description of the journal entry source.
• JOURNAL_REFERENCE_FLAG — indicates whether a journal reference must be supplied for entries from this source.
• JOURNAL_APPROVAL_FLAG — controls whether journal approval is required for this source.
• OVERRIDE_EDITS_FLAG — determines whether journal edit failures may be overridden.
• EFFECTIVE_DATE_RULE_CODE — the rule governing how the effective date is derived for entries from this source.
• IMPORT_USING_KEY_FLAG — indicates whether the source key is used during import.
• ZD_EDITION_NAME — the editioning column supporting online patching in 12.2.x.
• ATTRIBUTE1–ATTRIBUTE5 and CONTEXT — the standard descriptive flexfield segments.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard audit columns.

Common Use Cases and Queries

Developers and functional consultants query this table to resolve source names for reporting, to validate import configurations, and to diagnose posting or approval behavior. A typical lookup retrieves the user-facing name for a given source and language:

• SELECT user_je_source_name, description FROM gl.gl_je_sources_tl WHERE je_source_name = :source AND language = USERENV('LANG');
• Reporting joins to GL_JE_HEADERS to label journal batches by source.
• Auditing which sources require journal approval or references, using JOURNAL_APPROVAL_FLAG and JOURNAL_REFERENCE_FLAG.

Related Objects

Because the metadata identifies this object as standalone, relationships are largely logical rather than enforced foreign keys. The most significant related objects include:

• GL_JE_SOURCES — the base table; joins on JE_SOURCE_NAME.
• GL_JE_HEADERS — references the source used by each journal batch via JE_SOURCE.
• GL_JE_BATCHES — inherits the source used to create batches.
• GL_JE_LINES — indirectly linked through the parent header's source.
• GL_IMPORT_REFERENCES — maps imported subledger data to source identifiers.
• GL_JE_SOURCES_VL — the translated view exposing language-specific source names.