Search Results fem_user_dim3_pkg




Overview
Explore in AI Chat

Overview

FEM_USER_DIM3_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (Enterprise Territory and Resource Management) module. It serves as the maintenance API for the third user-defined dimension configured in Oracle's Enterprise Performance Foundation / Profitability and Cost Management data model. In EBS 12.1.1 and 12.2.2, user-defined dimensions provide extensibility beyond the seeded dimension set, allowing implementations to model additional analytical axes such as product line, channel, or custom hierarchies. This package encapsulates the DML layer for that dimension, exposing procedures for inserting, locking, updating, deleting, and translating dimension member records, and shielding callers from the underlying base and translation tables. Its classification as OTHER reflects that it is an internal supporting API rather than a public end-user interface.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new user dimension member into the dimension3 base table, establishing the row that represents a new analytical value.
  • LOCK_ROW — Acquires a row-level lock on an existing dimension member, typically used to serialize concurrent modification before an update or delete.
  • UPDATE_ROW — Modifies attributes of an existing dimension3 member record in the base table.
  • DELETE_ROW — Removes a dimension member record from the base table.
  • ADD_LANGUAGE — Inserts a translation row for a newly created dimension member, seeding the translated name/description row for a target language.
  • TRANSLATE_ROW — Updates the translatable attributes (name, description) of an existing dimension member for a specific language, maintaining multilingual support across installed languages.

Tables Accessed

  • FEM_USER_DIM3_B — The base table holding the language-independent definition of each user dimension3 member. INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW operate against this table.
  • FEM_USER_DIM3_TL — The translation table holding language-specific name and description text. ADD_LANGUAGE and TRANSLATE_ROW maintain this table.
  • FND_LANGUAGES — The Oracle Application Object Library language registry, consulted to validate or enumerate installed languages during translation operations.
  • FEM_USER_DIM3_PKG — The package specification, referenced by the body for its public declarations.

Additional dependencies include APP_EXCEPTION for standardized error raising, FND_MESSAGE for message retrieval, and FND_LOAD_UTIL, indicating integration with the standard loader/translation utilities used across EBS metadata maintenance APIs.

Usage Notes

The package is invoked programmatically rather than interactively. No database object references FEM_USER_DIM3_PKG, but four other APPS packages depend on it, so it is called internally by higher-level dimension management or loader routines within ETRM. In practice, these procedures execute when dimension3 metadata is created or maintained through Oracle's Enterprise Performance Foundation setup flows, language installation or translation-loading processes that propagate member names across installed languages, and concurrent programs or custom code that bulk-load or migrate user dimension members. LOCK_ROW should always precede UPDATE_ROW or DELETE_ROW in custom callers to avoid lost-update conditions, and ADD_LANGUAGE should follow INSERT_ROW for each installed language so that every base row has corresponding translation rows. Because the package is APPS-owned and ETRM-internal, support and patch activity may modify its behavior between 12.1.1 and 12.2.2; customizations should avoid direct DML on the underlying _B and _TL tables and route writes through these procedures to preserve package-level validation and exception handling.