Search Results fem_dhm_metadata_ops_key_s

Overview

The APPS.FEM_DIM_MEMBER_LOADER_PKG package body is a core component of the Oracle Enterprise Performance Foundation (now marketed within E-Business Suite as part of the Enterprise Tax, Treasury, and Risk Management / Financial Consolidation Hub data management stack). It is responsible for orchestrating the loading of dimension members into the FEM (Financial Enterprise Management) data model. Dimension members are the master data records that define hierarchies such as Account, Entity, Cost Center, Product, and Time, and they form the backbone of any Hyperion-style multi-dimensional application hosted inside the EBS schema.

The package encapsulates the end-to-end member-loading lifecycle: pre-validation, insertion of new members, translation-layer updates, base-attribute updates, attribute assignment, and post-load calendar period processing. Its status is VALID, and it is deployed under the APPS schema in both 12.1.1 and 12.2.2, where the ETRM/FEM functionality remains largely unchanged between releases.

Key Procedures and Functions

The package exposes eight documented procedures, all of which are driven from the MAIN entry point:

• MAIN — Top-level driver that controls the overall dimension member load transaction, invoking the subordinate procedures in sequence and managing error handling and commit semantics.
• PRE_VALIDATION — Performs validation of incoming member records against existing dimension metadata before any data is written, ensuring referential integrity with dimensions, dimension groups, and source systems.
• PRE_VALIDATION_ATTR — Applies attribute-specific validation logic for members that carry dimension attribute assignments, checking attribute definitions and versions.
• NEW_MEMBERS — Inserts newly identified dimension members into the member tables and related base tables for the first time.
• TL_UPDATE — Handles updates to translation-layer (TL) member records, typically for multi-language or multi-versioned name/description columns.
• BASE_UPDATE — Updates the base (non-translated) attributes of existing dimension members.
• ATTR_ASSIGN_UPDATE — Manages assignments and updates of dimension attributes to members, writing to the attribute and attribute-version tables.
• POST_CAL_PERIODS — Executes post-load processing for calendar periods, synchronizing time-dimension members against the FEM calendar definitions.

Tables Accessed

The package reads and writes a broad set of FEM metadata and control tables, referenced through APPS synonyms:

• FEM_DIMENSIONS_B, FEM_DIMENSION_GRPS_B, FEM_DIMENSION_GRPS_B_S — dimension and dimension-group master definitions.
• FEM_DIM_ATTRIBUTES_B, FEM_DIM_ATTR_VERSIONS_B — attribute definitions and their versions used during attribute assignment.
• FEM_DIM_LOAD_STATUS — tracks load progress and status per dimension.
• FEM_CALENDARS_B, FEM_TIME_DIMENSION_GROUP_KEY_S, FEM_TIME_GROUP_TYPES_B — time-dimension and calendar metadata used by POST_CAL_PERIODS.
• FEM_DHM_METADATA_OPS_KEY_S — the metadata operations key sequence that generates surrogate identifiers during load operations, and the object most directly associated with the user's search term.
• FEM_SOURCE_SYSTEMS_B, FEM_OBJECT_CATALOG_B, FEM_OBJECT_DEFINITION_B, FEM_PL_TABLES, FEM_MP_PROCESS_CTL_T — supporting metadata and multiprocessing control structures.
• FND_API, FND_MESSAGE, FND_MSG_PUB, FND_GLOBAL, FND_PROFILE, FND_LOG, FND_CONCURRENT — standard EBS APIs for error handling, logging, profile access, and concurrent request management.
• WF_EVENT, WF_PARAMETER_LIST_T — Workflow event propagation when member loads complete.

Usage Notes

FEM_DIM_MEMBER_LOADER_PKG is not referenced by any other database object, making it a self-contained entry point. It is typically invoked from FEM administrative concurrent programs or from the FEM Dimension Member Loader UI flows, which invoke the MAIN procedure with the appropriate load context. Custom integrations that need to load dimension members programmatically should call MAIN rather than the subordinate procedures to preserve transaction integrity. The package depends on FEM_DIMENSION_UTIL_PKG, FEM_ENGINES_PKG, FEM_MULTI_PROC_PKG, and FEM_PL_PKG, so all must be valid and compiled prior to execution. Because it emits Workflow events and writes to the FEM_DIM_LOAD_STATUS table, concurrent invocations should be serialized per dimension group to avoid contention.