Search Results x_value_set_id

Overview

APPS.FEM_USER_DIM3_PKG is a PL/SQL package belonging to the Oracle Enterprise Taxation and Regulatory Management (ETRM) / Enterprise Performance Foundation (FEM) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The package provides the lowest-level Data Definition Language (DML) application programming interface for the FEM_USER_DIM3 entity, which represents a user-defined dimension (commonly referred to as "User Dimension 3") used within the Enterprise Performance Foundation dimensional model. Business users, typically financial analysts and administrators, configure user-defined dimensions to extend the standard analytic dimension set so that management reporting, allocations, and profitability analysis can be enriched with organization-specific attributes.

The package encapsulates all Create, Read (lock), Update, Delete, and translation operations against that entity, ensuring that object version numbers, audit columns, and language-dependent descriptions are maintained consistently. Because the "x_value_set_id" column is a foreign-key-style attribute of the table, the package exposes the value set identifier on every row-level operation, allowing the caller to associate the user-defined dimension with a specific Oracle value set (FND value set) that governs the valid members of the dimension.

Key Procedures and Functions

• INSERT_ROW — Creates a new row in the FEM_USER_DIM3 base table and its translated table. It accepts the full set of attributes including the value set identifier, dimension group, display code, enabled flag, personal flag, read-only flag, name, description, and standard WHO audit columns.
• LOCK_ROW — Acquires a lock on an existing row identified by the combination of user dimension identifier and value set identifier, verifying the object version number. This supports optimistic concurrency control in the form-of-the-block UI.
• UPDATE_ROW — Modifies an existing row, updating the descriptive attributes, flags, and audit columns while preserving the value set association.
• DELETE_ROW — Removes a row from the base and translated tables using the user dimension identifier and value set identifier.
• ADD_LANGUAGE — Propagates missing language rows into the translation table, ensuring every defined language in FND_LANGUAGES has a translated record for the entity.
• TRANSLATE_ROW — Updates the translated name and description for a specific user dimension language row, typically invoked from the translation maintenance UI.

Tables Accessed

• FEM_USER_DIM3_B — The base table storing the primary, language-independent attributes of the user-defined dimension, including the value set identifier, dimension group, flags, and name.
• FEM_USER_DIM3_TL — The translation table holding the language-specific name and description values, managed by ADD_LANGUAGE and TRANSLATE_ROW.
• FND_LANGUAGES — The Oracle Applications installed-languages table, referenced by ADD_LANGUAGE to determine which language rows must exist.

Usage Notes

This package is an internal ETRM API and is normally invoked indirectly rather than directly by end users. The most common invocation path is through the FEM user-defined dimension maintenance forms, where the Oracle Forms block handler calls LOCK_ROW, INSERT_ROW, UPDATE_ROW, and DELETE_ROW in response to user actions. The ADD_LANGUAGE and TRANSLATE_ROW procedures are executed by translation and language-installation concurrent programs. Because four other ETRM packages reference FEM_USER_DIM3_PKG, customizations should treat this package as a foundational layer and should not bypass it to write directly to FEM_USER_DIM3_B or FEM_USER_DIM3_TL, since audit columns, object version numbers, and translation consistency are enforced here.