Search Results fem_dim_snapshot_util_pkg




Overview
Explore in AI Chat

Overview

APPS.FEM_DIM_SNAPSHOT_UTIL_PKG is a utility package within the Oracle Enterprise Performance Management (EPM) / Enterprise Data Management foundation shipped with Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its header identifies the source file as fem_dim_snapshot_utl.pls and describes the package as the Package Specification for a utility that provides functions and procedures supporting the Dimension Snapshot data model. The snapshot model persists point-in-time definitions of analytical dimensions so that dimensional hierarchies and their associated attributes can be captured, compared, or re-applied independently of live definition tables.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling session rather than the definer. It relies on standard EBS API constants from FND_API (G_FALSE, G_TRUE, G_RET_STS_SUCCESS, G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR) and on FND_GLOBAL for session context. In the 12.1.1 ETRM classification the package is registered as an OTHER API, not as a public or private EBS API, which reflects its role as an internal supporting utility rather than an externally published integration interface.

Session identity is captured at package instantiation through two package constants: c_user_id, bound to FND_GLOBAL.USER_ID, and c_login_id, bound to FND_GLOBAL.Login_Id. These constants are the point most frequently referenced by users searching for "c_login_id" in connection with this object, and they indicate that snapshot operations are attributed to the invoking EBS user and login session.

Key Procedures and Functions

ETRM documents two public procedures on this package. Both follow the standard EBS API error-handling convention, returning x_return_status, x_msg_count, and x_msg_data to the caller.

  • ADD_DIMENSION — Adds a dimension to the snapshot data model. It accepts a dimension snapshot object definition identifier and a varchar label that identifies the dimension, and records the dimension against the supplied snapshot object definition. The procedure honors the standard API version, message-list initialization, and commit parameters.
  • REMOVE_DIMENSION — Removes a previously registered dimension from the snapshot data model. It follows the same API signature pattern as ADD_DIMENSION, including the API version, initialization, and commit parameters, and returns status and message information to the caller.

No other procedures or functions are documented in the ETRM registry for this package.

Tables Accessed

The documented table references, resolved through APPS synonyms, define the snapshot metadata model:

  • FEM_DSNP_RULE_DIMS — Stores the association between snapshot rules and the dimensions they cover; this is the principal target of the add and remove operations.
  • FEM_OBJECT_CATALOG_B — The base table of the object catalog that registers snapshot object definitions.
  • FEM_OBJECT_DEFINITION_B — The base table of object definitions, keyed by the definition identifier passed into ADD_DIMENSION.
  • DBMS_UTILITY and DUAL — Utility and dual references used for standard PL/SQL error stack and message handling.

Usage Notes

Because it is classified as an OTHER API, FEM_DIM_SNAPSHOT_UTIL_PKG is not intended as a documented integration surface. It is typically invoked from within the EPM/EDM foundation code path — for example, from concurrent programs or internal setup flows that create or modify dimension snapshot definitions — rather than directly from a Forms-based user interface.

Callers should treat the package as an internal utility: supply the standard API parameters (API version, initialization flag, commit flag), inspect x_return_status for G_RET_STS_SUCCESS, G_RET_STS_ERROR, or G_RET_STS_UNEXP_ERROR, and drain x_msg_count / x_msg_data using standard FND_MSG_PUB conventions. Custom code should not depend on the package signature across releases.