Search Results fem_dimensions_tl




Overview
Explore in AI Chat

Overview

FEM_DIMENSIONS_PKG is the Application Programming Interface (API) package for the Dimensions entity within the Enterprise Tax, Risk, and Management (ETRM) product family in Oracle E-Business Suite. It provides the canonical data manipulation layer for dimension definitions, which are the foundational metadata objects used to describe the analytical and regulatory structures that ETRM processes operate upon. The package encapsulates all DML against the base table FEM_DIMENSIONS_B and its translation table FEM_DIMENSIONS_TL, exposing a controlled set of procedures so that callers need not write directly to these tables. This enforces consistent handling of surrogate keys, object version numbers, audit columns, and multilanguage translation rows. As an "OTHER"-classified API, it is intended for internal product use rather than general customer extension, though it is referenced by three other packages within the application, indicating it is a foundational dependency in the ETRM data model.

Key Procedures and Functions

  • INSERT_ROW — Creates a new dimension record. It inserts the base row into FEM_DIMENSIONS_B and, in the same operation, seeds translation rows in FEM_DIMENSIONS_TL for every installed language returned by FND_LANGUAGES (INSTALLED_FLAG of 'I' or 'B'), avoiding duplicates via a NOT EXISTS check. The DIMENSION_NAME and DESCRIPTION supplied by the caller are written for the session language (userenv('LANG')) and used as the SOURCE_LANG. It returns the ROWID of the inserted base row and raises NO_DATA_FOUND if the base row cannot be located afterward.
  • LOCK_ROW — Obtains a pessimistic lock on a dimension row identified by DIMENSION_ID and validated against OBJECT_VERSION_NUMBER, protecting the row from concurrent modification during a read-modify-write cycle.
  • UPDATE_ROW — Modifies an existing dimension record, updating the base attributes in FEM_DIMENSIONS_B and the translatable DIMENSION_NAME and DESCRIPTION values in FEM_DIMENSIONS_TL for the current language.
  • DELETE_ROW — Removes a dimension and its associated translation rows, ensuring the base and translated data remain synchronized.
  • ADD_LANGUAGE — Introduces translation rows for a newly installed language, propagating the source-language name and description into FEM_DIMENSIONS_TL for that language code.
  • TRANSLATE_ROW — Updates the translated DIMENSION_NAME and DESCRIPTION for an existing dimension in a specific language, supporting ongoing multilingual maintenance of dimension metadata.

Tables Accessed

  • FEM_DIMENSIONS_B — The base (non-translated) table holding DIMENSION_ID, DIMENSION_VARCHAR_LABEL, DIM_OWNER_APPLICATION_ID, OBJECT_VERSION_NUMBER, and standard WHO audit columns. All key DML from INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW targets this table.
  • FEM_DIMENSIONS_TL — The translation table storing DIMENSION_NAME, DESCRIPTION, LANGUAGE, and SOURCE_LANG per language. It is written by INSERT_ROW, UPDATE_ROW, ADD_LANGUAGE, and TRANSLATE_ROW, and read by INSERT_ROW's duplicate-avoidance subquery. This is the table associated with the search term "fem_dimensions_tl."
  • FND_LANGUAGES — The Oracle Application Object Library reference table of installed languages. INSERT_ROW queries it to enumerate languages for which translation rows must be created.

Usage Notes

FEM_DIMENSIONS_PKG is typically invoked from ETRM setup and maintenance forms, concurrent programs that load or migrate dimension metadata, and other ETRM packages (three documented dependents) that must create or maintain dimensions programmatically. Callers should invoke the procedures within a single transaction and supply correct audit and object version values. Direct DML against FEM_DIMENSIONS_B or FEM_DIMENSIONS_TL should be avoided; the API must be used so that base and translation rows, language propagation, and version control remain consistent. When introducing a new language, ADD_LANGUAGE should be run after the base dimension exists, whereas TRANSLATE_ROW handles subsequent corrections to individual translations.