Search Results x_user_dim2_name

Overview

FEM_USER_DIM2_PKG is a PL/SQL package owned by APPS in Oracle E-Business Suite that supports the Enterprise Tax and Reporting Management (ETRM) module's user-defined dimension infrastructure. Specifically, it manages the second user-defined dimension, providing the data-access layer for records that define the characteristics, enabled status, and value-set associations of that dimension. User-defined dimensions in ETRM extend the standard dimensional model so organizations can classify transactions, balances, and reporting results according to attributes that are not provided by the delivered chart of accounts or standard accounting dimensions.

The package encapsulates all INSERT, UPDATE, LOCK, and DELETE operations against the base table. The presence of the X_USER_DIM2_NAME parameter, which users commonly search on, indicates that the package is the supported channel through which the human-readable dimension name is created, modified, and translated into additional languages.

Key Procedures and Functions

Six documented procedures comprise the public interface:

• INSERT_ROW — Creates a new user-dimension-2 record, accepting values for the value set, dimension group, display code, enabled and personal flags, read-only flag, user-dimension name, description, and audit columns.
• LOCK_ROW — Obtains a row-level lock on a user-dimension-2 record, ensuring that a subsequent update is based on current data and protecting against concurrent modification.
• UPDATE_ROW — Modifies an existing record, including the user-dimension name, description, and control flags, together with the standard WHO audit columns.
• DELETE_ROW — Removes a user-dimension-2 record.
• ADD_LANGUAGE — Maintains translation completeness by propagating missing-language rows into the translated table.
• TRANSLATE_ROW — Loads or updates translated values for the user-dimension name and description for a specific language.

Tables Accessed

The package operates against three documented tables. FEM_USER_DIM2_B is the base table that stores the user-dimension-2 definition; it receives the insert, update, and delete operations and supplies rows for locking. FEM_USER_DIM2_TL is the translated table, holding language-specific user-dimension names and descriptions; it is populated and maintained through the TRANSLATE_ROW and ADD_LANGUAGE procedures. FND_LANGUAGES is the installed-languages reference table used by ADD_LANGUAGE to determine which languages still require translation rows.

Usage Notes

FEM_USER_DIM2_PKG is normally invoked indirectly. ETRM configuration forms submit user-dimension changes that are routed through this package rather than issuing direct DML against the underlying tables. It is also referenced by four other packages within the application, indicating internal reuse for validation and translation processing. Custom integrations should call the API procedures rather than manipulating FEM_USER_DIM2_B and FEM_USER_DIM2_TL directly, because the package centralizes flag handling, audit column maintenance, and language synchronization. The header revision (120.1, dated 2005) reflects the long-standing stability of the object across the 12.1.1 and 12.2.2 releases.