Search Results fem_dimension_grps_pkg




Overview
Explore in AI Chat

Overview

The APPS.FEM_DIMENSION_GRPS_PKG package body is a foundational data-maintenance API within the Oracle Enterprise Business Suite (EBS) Enterprise Performance Foundation / Enterprise Resource Tracking Module (ETRM) schema. Its primary business function is to manage the definition and translation of dimension groups — logical groupings of dimension members used for financial reporting, allocations, and analytical processing. The object X_DIMENSION_GROUP_ID acts as the unique primary key that binds each dimension group row to its business record, and this package provides the sole supported interface for creating, updating, locking, and deleting those records. Because dimension groups determine how dimension members are aggregated and sequenced in reporting hierarchies, this package underpins the referential integrity of the ETRM analytical model. It is classified as an OTHER API, meaning it is a table-maintenance package rather than a public business API, and it is invoked internally by other ETRM components rather than directly by end users.

Key Procedures and Functions

The package body exposes six documented procedures. Each targets the X_DIMENSION_GROUP_ID identifier either directly or as part of a composite key.

  • INSERT_ROW — Creates a new dimension group record. It writes the base row into FEM_DIMENSION_GRPS_B and simultaneously inserts the translatable descriptive columns (name and description) into FEM_DIMENSION_GRPS_TL for the session language. It accepts the full set of attributes, including X_DIMENSION_GROUP_ID, sequencing, enablement, personalization, and audit columns.
  • LOCK_ROW — Acquires a row-level lock on the dimension group identified by X_DIMENSION_GROUP_ID, preventing concurrent modification. This is the standard EBS concurrency-control pattern used before an update within an interactive or batch transaction.
  • UPDATE_ROW — Modifies an existing dimension group. It updates the base table attributes and the corresponding translated name and description rows.
  • DELETE_ROW — Removes the dimension group and its associated translation rows for the specified X_DIMENSION_GROUP_ID.
  • ADD_LANGUAGE — Inserts new language rows into the translations table when a language is added to the installation, propagating existing dimension group definitions to the new language.
  • TRANSLATE_ROW — Updates the translated name and description values for a dimension group in a specified language, supporting the multilingual Translation Framework.

Tables Accessed

The package reads and writes the following tables, accessed through APPS synonyms:

  • FEM_DIMENSION_GRPS_B — the base (non-translatable) table holding the primary DIMENSION_GROUP_ID, dimension references, sequence, flags, and audit columns. Insert, update, and delete operations target this table.
  • FEM_DIMENSION_GRPS_TL — the translatable table storing DIMENSION_GROUP_NAME and DESCRIPTION per language. Written by INSERT_ROW, ADD_LANGUAGE, and TRANSLATE_ROW.
  • FND_LANGUAGES — the Oracle Application Object Library language repository, queried by ADD_LANGUAGE to determine which installed languages require translation rows.

Usage Notes

Because this is a private table-maintenance package, it is not intended for direct invocation by end users or custom extensions. It is typically called from ETRM setup forms, from concurrent programs that seed or migrate dimension group definitions, and from higher-level ETRM APIs — the package is referenced by six other packages within the schema. Custom code should avoid calling these procedures directly and instead use the supported parent APIs, since direct inserts or updates bypass validation, concurrency checks, and the translation synchronisation logic that FEM_DIMENSION_GRPS_PKG enforces. When troubleshooting the X_DIMENSION_GROUP_ID identifier, developers should verify the corresponding row exists in FEM_DIMENSION_GRPS_B and that matching translation rows exist for the active language in FEM_DIMENSION_GRPS_TL.