Search Results check_unique_user_name

Overview

GL_JE_SOURCES_PKG is an Oracle E-Business Suite PL/SQL package that resides in the APPS schema and encapsulates the validation and maintenance logic for the GL_JE_SOURCES entity, which defines the journal entry sources available to General Ledger. A journal entry source identifies the origin of a journal entry — for example Manual, Recurring, or subledger-derived sources — and each source carries a hidden identifier (je_source_name), a user-facing display name (user_je_source_name), a key, and assorted attributes such as the effective date rule, frozen source flag, and journal approval flag. The package is classified as OTHER in the ETRM documentation, meaning it is a supporting validation/maintenance package rather than a public business API. The user search term "check_unique_user_name" corresponds directly to the CHECK_UNIQUE_USER_NAME procedure, whose purpose is to verify that a displayed journal entry source name is unique before it is committed to the database.

Key Procedures and Functions

• SELECT_COLUMNS — Retrieves the user-facing source name and related attributes (effective date rule code, frozen source flag, journal approval flag) for a given je_source_name.
• CHECK_UNIQUE_NAME — Validates that the internal je_source_name (hidden identifier) is unique.
• CHECK_UNIQUE_USER_NAME — Validates that the user_je_source_name (displayed name) is unique. This is the procedure relevant to the user's search.
• CHECK_UNIQUE_KEY — Validates that the je_source_key value is unique.
• GET_UNIQUE_ID — Obtains a unique identifier for a new source record.
• IS_SLA_SOURCE — Determines whether a source is a Subledger Accounting (SLA) source.
• INSERT_ROW — Inserts a new GL_JE_SOURCES record.
• UPDATE_ROW — Updates an existing source record.
• LOCK_ROW — Acquires a lock on a source row to support concurrency control.
• DELETE_ROW — Removes a source record.
• LOAD_ROW — Loads a source row, typically used during data migration or concurrent processing.
• TRANSLATE_ROW — Creates or updates translated (TL) rows for a source.
• ADD_LANGUAGE — Adds language-specific rows for a newly installed or enabled language.

Tables Accessed

• GL_JE_SOURCES — The base table holding journal entry source definitions.
• GL_JE_SOURCES_TL — The translation table storing the user_je_source_name per language, referenced by CHECK_UNIQUE_USER_NAME, TRANSLATE_ROW, and ADD_LANGUAGE.
• GL_JE_SOURCES_S — The sequence/identifier shadow table used for unique ID generation.
• GL_JE_HEADERS_S — Referenced to support consistency between sources and posted journal headers.
• FND_LANGUAGES — Consulted to determine installed languages for translation and language-addition routines.
• XLA_SUBLEDGERS — Used by IS_SLA_SOURCE to determine whether a source originates from Subledger Accounting.
• DUAL — Used for scalar lookups and validation queries.

Usage Notes

GL_JE_SOURCES_PKG is typically invoked from the General Ledger Journal Sources setup form, where CHECK_UNIQUE_USER_NAME and CHECK_UNIQUE_NAME are fired during user entry to prevent duplicate source definitions. The insert, update, lock, and delete routines support the same form's DML operations, while LOAD_ROW, TRANSLATE_ROW, and ADD_LANGUAGE are exercised by concurrent programs and language installation utilities. Because the package is not a public API and is classified as OTHER, custom code should generally avoid calling it directly; instead, source definitions should be maintained through the supported setup forms or the appropriate open interfaces. The package is referenced by four other packages, reflecting its role as a shared validation dependency within the General Ledger codebase for Oracle EBS 12.1.1 and 12.2.2.