Search Results fem_dimension_grps_b_s

Overview

The package body APPS.FEM_DIM_GROUPS_UTIL_PKG is a utility package within the Oracle Enterprise Performance Foundation / Enterprise Tax Reporting and Management (ETRM) schema in Oracle E-Business Suite. Its role is to provide reusable business logic for the creation and maintenance of dimension groups — logical groupings of dimensions that are used throughout the FEM analytical and reporting engines. Dimension groups allow the application to treat a related set of dimensions as a single unit when constructing balances, time mappings, or cross-dimensional hierarchies. The package name uses the legacy "FEM" prefix, indicating it belongs to the Financial Enterprise Management / Enterprise Performance Foundation family of products that underpins applications such as Oracle Financial Consolidation Hub, Oracle Profitability Manager, and related ETRM components.

Key Procedures and Functions

The documented package exposes a single public API, identified in the ETRM metadata as:

• CREATE_DIM_GROUP — the principal program unit through which dimension group definitions are established. Consistent with the FEM design convention, this procedure validates the requested group against the underlying dimension and group metadata and then persists the new group definition. The metadata confirms the procedure is classified as an OTHER API, meaning it is a public, formally supported entry point that can be invoked programmatically. No parameter list is published in the ETRM documentation, and one is not reproduced here. Callers should reference the live package specification (FEM_DIM_GROUPS_UTIL_PKG) in the database for the exact signature before invoking it from custom code.

Tables Accessed

The package depends on a focused set of FEM base and translation tables:

• FEM_DIMENSION_GRPS_B and FEM_DIMENSION_GRPS_B_S — the base and sequence-tracking tables for dimension group headers. The _B_S suffix denotes the surrogate-key sequence table, which supplies primary keys for new group records. The user search term fem_dimension_grps_b_s refers directly to this object, confirming the link between group creation and sequence generation.
• FEM_DIMENSION_GRPS_TL — stores translated, language-specific group names and descriptions.
• FEM_DIMENSIONS_B and FEM_XDIM_DIMENSIONS — the dimension definition tables against which group members are validated.
• FEM_TIME_DIMENSION_GROUP_KEY_S and FEM_TIME_GROUP_TYPES_B — time-dimension-related group structures, reflecting the special handling applied to time hierarchies.
• DUAL — a standard Oracle utility table, typically used for sequence lookups and validation queries.

In addition, the package references the sibling packages FEM_DIMENSION_GRPS_PKG, FEM_DIMENSION_UTIL_PKG, and FEM_ENGINES_PKG, and relies on the standard FND infrastructure packages FND_API, FND_GLOBAL, FND_LOG, and FND_MSG_PUB for API error handling, session context, logging, and message resolution. Access to these tables is made through APPS synonyms, and all references resolve to the APPS schema.

Usage Notes

FEM_DIM_GROUPS_UTIL_PKG is an internal utility library rather than a user-facing API. It is not referenced by any other database object according to the ETRM metadata, which indicates that its callers reside outside the database — principally the FEM Setup forms within Oracle EBS. The package is therefore typically invoked when an administrator creates or copies a dimension group through the FEM configuration user interface, or when a concurrent program or upgrade script programmatically constructs the standard dimension groups required by the ETRM engines. Because the package writes directly to base dimension-group tables, custom integrations should prefer the documented CREATE_DIM_GROUP entry point and must supply the correct FND application context (via FND_GLOBAL) before invocation to ensure proper auditing, language handling, and message propagation. Direct DML against the underlying FEM_DIMENSION_GRPS_* tables is not recommended, as it bypasses the validation and sequencing logic embedded in this utility.