Search Results pre_validation_attr




Overview
Explore in AI Chat

Overview

APPS.FEM_DIM_MEMBER_LOADER_PKG is the core engine within the Oracle Enterprise Performance Foundation (now branded as Enterprise Planning and Budgeting / ETRM) schema responsible for loading dimension members from interface tables into the FEM repository. In Oracle EBS 12.1.1 and 12.2.2, the package orchestrates the movement of dimension member definitions, their translatable names and descriptions, and member attribute assignments into the FEM database. The package header comment confirms its purpose explicitly: it is the "engine for loading dimension members, member translatable names/descriptions, and member attribute assignments from interface tables into the FEM database." Because it is declared with AUTHID CURRENT_USER, it executes with the privileges of the calling user rather than the definer, which is significant for security and for applications that invoke it under the APPS schema context.

Key Procedures and Functions

The documented public specification exposes eight procedures that map to distinct stages of the load pipeline:

  • MAIN — The top-level entry point that drives the full load cycle for a given dimension load. History notes indicate that a date_format_mask parameter was removed in favour of the ICX: Date Format Mask profile option.
  • PRE_VALIDATION — Performs pre-load validation of the incoming interface data before any persistence occurs.
  • PRE_VALIDATION_ATTR — Validates attribute data associated with members. A level-specific attributes parameter was later required per Bug#3895203.
  • NEW_MEMBERS — Creates newly introduced members that do not yet exist in the FEM repository.
  • TL_UPDATE — Handles update of translatable (TL) member names and descriptions.
  • BASE_UPDATE — The user-searched procedure. It applies updates to the base member record. History entries record that its signature was modified to support undelete of dimensions (Bug#3906218) and to accommodate updating the dimension group for a member (Bug#4244082). It operates using dimension_id as passed in, so that list membership is derived from the Xdim metadata.
  • ATTR_ASSIGN_UPDATE — Persists member attribute assignments into the FEM attribute structures.
  • POST_CAL_PERIODS — Performs post-load calendar period processing tied to time dimensions.

Tables Accessed

The package references a broad set of FEM tables through APPS synonyms. Core structural tables include FEM_DIMENSIONS_B and FEM_DIMENSION_GRPS_B (with its _S sequence), FEM_DIM_ATTRIBUTES_B and FEM_DIM_ATTR_VERSIONS_B for attribute definitions and versioning, and FEM_OBJECT_CATALOG_B / FEM_OBJECT_DEFINITION_B for object metadata. Calendar and time dimension logic draws on FEM_CALENDARS_B, FEM_TIME_DIMENSION_GROUP_KEY_S, and FEM_TIME_GROUP_TYPES_B. Load orchestration and control data are maintained in FEM_DIM_LOAD_STATUS, FEM_MP_PROCESS_CTL_T, FEM_DHM_METADATA_OPS_KEY_S, and FEM_SOURCE_SYSTEMS_B. FEM_PL_TABLES is also referenced in the load path. These reads and writes collectively track the state of an in-flight dimension load and commit member metadata to the FEM repository.

Usage Notes

This package is invoked indirectly by the standard dimension upload concurrent programs and the associated HTML/Forms setup pages rather than being called directly by end users. Three other packages reference it, indicating that it sits beneath a supervisory loader layer. Custom code should call MAIN rather than individual sub-processes; the sub-processes were exposed publicly only in the 12.1.1 lineage for specific multiprocessing needs (history entry 06-MAY-04). Defects recorded in the header (ORA-01722 on budget members, snapshot loads with zero rows, folder security violations) demonstrate the error conditions the package raises through its declared exceptions, including those added for error reprocessing and date-overlap logic.