Search Results get_dim_member_id

Overview

APPS.FEM_MIR_PKG is a PL/SQL package within the Oracle Enterprise Tax, Risk, and Management (ETRM) / Enterprise Performance Foundation (FEM) schema, declared with AUTHID CURRENT_USER. Its source header dates to 2007 and the object is documented in ETRM 12.1.1 with an API classification of OTHER, indicating it is an internal utility rather than a public, governed API. The package encapsulates metadata resolution logic for the FEM dimensional model: it translates surrogate identifiers and internal codes (dimension groups, dimension attributes, attribute versions, dimension members, value sets, and calendar periods) into their display codes and, conversely, resolves display codes and natural keys back into their internal IDs. Because Oracle EBS reporting, hierarchy maintenance, and dimension member management screens must present user-facing display codes while persisting internal numeric IDs, FEM_MIR_PKG functions as the shared translation layer that keeps those two representations consistent. It references the FND_API and FND_LOG APIs for standardized return statuses and logging levels, and it exposes a set of package-level constants (for example the selection set, product, user, responsibility, and request identifiers used in import/interface processing) that suggest it also participates in metadata import or interface routines.

Key Procedures and Functions

The documented interface comprises twenty-three procedures and functions, organized below by the metadata entity they resolve.

• Dimension group functions: GET_DIM_GROUP_DISPLAY_CODE returns the display code for a dimension group; GET_DIM_GROUP_ID returns the corresponding surrogate identifier; HIER_DIM_GRP_EXISTS checks whether a hierarchy-to-dimension-group association exists; and VALIDATE_HIER_DIM_GRPS_ORDER validates the ordering of hierarchy dimension groups.
• Dimension attribute functions: GET_DIM_ATTR_VARCHAR_LABEL retrieves the varchar label of a dimension attribute; GET_DIM_ATTRIBUTE_ID resolves an attribute to its ID; GET_DIM_ATTR_VER_DISPLAY_CODE returns the display code of an attribute version; and GET_DIM_ATTR_VERSION_ID resolves an attribute version to its ID.
• Dimension member functions: GET_DIM_MEMBER_DISPLAY_CODE, the routine most commonly sought by developers, returns the display code of a dimension member; GET_DIM_MEMBER_ID performs the inverse resolution from display code to member ID.
• Value set functions: GET_VALUE_SET_DISPLAY_CODE and GET_VALUE_SET_ID provide the same display-code/ID pairing for value sets.
• Calendar and period functions: GET_GL_PERIOD_NUM returns the GL period number, and GET_CAL_PERIOD_END_DATE returns a calendar period end date.
• General resolution functions: GET_OBJECT_ID and GET_DIMENSION_ID resolve a generic object or a dimension to its identifier.

All routines follow the FND_API return-status convention (success, error, unexpected error) defined by the package constants.

Tables Accessed

The package reads the FEM metadata tables through APPS synonyms:

• FEM_DIMENSIONS_B — base dimension definitions; source for GET_DIMENSION_ID.
• FEM_DIMENSION_GRPS_B — dimension group definitions; source for the dimension group ID and display code functions.
• FEM_HIER_DIMENSION_GRPS — hierarchy-to-dimension-group associations; used by HIER_DIM_GRP_EXISTS and order validation.
• FEM_DIM_ATTRIBUTES_B and FEM_DIM_ATTR_VERSIONS_B — attribute and attribute version definitions, backing the attribute ID, version ID, display code, and varchar label functions.
• FEM_VALUE_SETS_B — value set definitions, backing the value set display code and ID functions.
• FEM_CAL_PERIODS_ATTR — calendar period attributes, used by GET_GL_PERIOD_NUM and GET_CAL_PERIOD_END_DATE.

No other packages are documented as referencing this package, confirming its role as a leaf-level utility within the FEM metadata resolution layer.

Usage Notes

FEM_MIR_PKG is typically invoked from FEM/ETRM forms and concurrent programs that display or capture dimensional metadata, and from custom PL/SQL that needs to convert between internal FEM IDs and user-facing display codes without duplicating lookup SQL. The GET_DIM_MEMBER_DISPLAY_CODE function is commonly used in custom reports and extensions to render member display codes from stored member IDs. Because the package is classified OTHER, has no documented public API designation, and is referenced by no other packages, it should be treated as an internal, version-sensitive object: callers should avoid depending on its signatures across patches and should prefer supported FEM public APIs where one exists. Database links, invoker's rights (AUTHID CURRENT_USER), and the APPS synonym layer all imply that the calling schema must have appropriate privileges on the FEM tables.