Search Results create_dim_group




Overview
Explore in AI Chat

Overview

FEM_DIM_GROUPS_UTIL_PKG is an Oracle Enterprise Business Suite (EBS) utility package owned by the APPS schema and classified under the API classification "OTHER." Its documented purpose, taken directly from the package header in fem_dimgrp_utl.pls, is to serve as a "Utility package for Dimension Groups (also known as 'levels')." Dimension Groups are the mechanism by which the Enterprise Performance Foundation (FEM) application organizes and sequences the analytic dimensions that participate in a business hierarchy or model. The package therefore underpins the creation and maintenance of these dimension groupings, providing the programmatic layer through which dimension group metadata is validated and persisted into the FEM data model.

The source header identifies the original author as Robert Flippo, with an initial creation date of 06/03/2005 and a subsequent modification on 07/20/2005 under Bug#4504983 to add dim_group_sequence as an OUT parameter and to introduce a NULL default for p_dimension_group_seq. The package is declared AUTHID CURRENT_USER and defines a standard set of constants consistent with the FND_API error-handling model, including success, error, and unexpected-error return statuses, as well as logging constants drawn from fnd_log and common FND_GLOBAL values such as user ID, responsibility application ID, and login ID.

Key Procedures and Functions

The ETRM documentation records a single documented subprogram for this package: CREATE_DIM_GROUP. This procedure is the primary entry point for establishing a new dimension group record within the FEM schema. Based on the package's stated purpose and the modification history, CREATE_DIM_GROUP accepts dimension group attributes and, following the Bug#4504983 enhancement, returns the newly assigned dim_group_sequence through an OUT parameter. The sequence value governs ordering within the dimension group definition.

Consistent with Oracle EBS API conventions expressed in the package constants, CREATE_DIM_GROUP would be expected to return a standard FND_API status code (success, error, or unexpected error) rather than raising unhandled exceptions, allowing callers to inspect the outcome and any associated messages. No other procedures or functions are enumerated in the documented metadata, and parameter lists are not reproduced here because they are not part of the supplied documentation.

Tables Accessed

The package operates against a set of FEM base, translation, and sequence tables accessed through APPS synonyms. These include:

  • FEM_DIMENSIONS_B — the base dimensions table, used to validate or resolve the dimensions that will belong to the group.
  • FEM_DIMENSION_GRPS_B and FEM_DIMENSION_GRPS_B_S — the base dimension groups table and its sequence, holding the group definition and generating primary keys.
  • FEM_DIMENSION_GRPS_TL — the translation table storing language-specific dimension group names and descriptions.
  • FEM_TIME_DIMENSION_GROUP_KEY_S — the sequence supplying keys for time dimension group associations.
  • FEM_TIME_GROUP_TYPES_B — the time group types table, relevant when a dimension group relates to time-based hierarchies.
  • FEM_XDIM_DIMENSIONS — the cross-dimensional (extended) dimensions table, used where a group references extended dimension definitions.
  • DUAL — the standard single-row utility table used for lightweight validation or sequence-style queries.

Collectively these tables confirm that CREATE_DIM_GROUP writes the group header, its translated attributes, and its sequencing, while reading dimension and time-type reference data to enforce integrity.

Usage Notes

FEM_DIM_GROUPS_UTIL_PKG is a server-side utility invoked programmatically rather than through a user-facing form in the documented metadata. It is referenced by one other package, indicating that the primary consumers are higher-level FEM APIs or processing routines that need to create dimension groups as part of a broader model setup or configuration flow. Typical invocation contexts include concurrent programs that seed or migrate FEM metadata, and custom PL/SQL extensions that must register new dimension groups.

Because the package is declared AUTHID CURRENT_USER, callers execute it with their own privileges, so the invoking schema requires appropriate grants on the FEM tables and FND utilities. Callers should also expect FND_API-compliant return statuses and should capture the returned dim_group_sequence where the caller must later reference or order the created group. The package was delivered with the 11.5.x FEM code line and remains present in the 12.1.1 and 12.2.2 releases, where it continues to serve as the foundational utility for dimension group creation.