Search Results fem_comp_dim_member_loader_pkg




Overview
Explore in AI Chat

Overview

FEM_COMP_DIM_MEMBER_LOADER_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that belongs to the Enterprise Territory Management (ETRM) module, internally designated by the FEM product prefix. Its central purpose is to load and validate dimension member records that populate the composite dimension structures used by ETRM's analytical and territory assignment engine. Composite dimensions in ETRM are groupings of related dimension members drawn from cost objects, products, activities, and other cost or profitability entities, and they serve as the building blocks against which territory rules and profitability calculations are evaluated.

The package is classified under the generic API classification "OTHER," indicating that it is not part of a formally published public API set and is intended for controlled, internal consumption within the ETRM calling stack. Its status is VALID in both the 12.1.1 and 12.2.2 application releases, confirming that it remains an active component of the codebase across the two major EBS versions. The package exposes a single documented procedure, PROCESS_ROWS, and reads from a set of ETRM configuration and setup tables.

Key Procedures and Functions

The metadata documents one procedure:

  • PROCESS_ROWS — The primary driver routine of the package. It processes a set of incoming dimension member rows, applying the validation and transformation logic required before the members are written into the composite dimension structures. It is the single entry point through which member data flows into the loader and is responsible for orchestrating the interaction with the referenced ETRM tables. No parameter list is published in the ETRM metadata, and none should be assumed.

Beyond PROCESS_ROWS, the package body contains additional private logic and internal helpers that are not individually documented, which is typical of packages classified as OTHER. Differential detail on internal calls is limited to the dependency list below.

Tables Accessed

The package references the following ETRM tables via APPS synonyms, each serving a specific role in member loading and validation:

  • FEM_XDIM_DIMENSIONS — the dimension definition repository; defines the dimensions and their properties against which members are validated.
  • FEM_ACTIVITIES — activity dimension members available for composition.
  • FEM_COST_OBJECTS — cost object dimension members used to build composite groupings.
  • FEM_COLUMN_REQUIREMNT_B — column requirement definitions controlling which member attributes must be supplied.
  • FEM_DIM_ATTRIBUTES_B — dimension attribute definitions applied to loaded members.
  • FEM_GLOBAL_VS_COMBOS_B and FEM_GLOBAL_VS_COMBO_DEFS — global value set combination definitions used in validation.
  • FEM_PRODUCTS_ATTR — product attribute data supporting product dimension members.
  • PLITBLM — a standard EBS PL/SQL table type used by the loader for in-memory row processing.

Additionally, the package depends on FND_API, FND_GLOBAL, and FND_LOG for the standard EBS API error-handling, session context, and logging framework, and on the SYS STANDARD package.

Usage Notes

FEM_COMP_DIM_MEMBER_LOADER_PKG is not referenced by any other documented EBS package, which indicates a narrow call surface. It is typically invoked indirectly through ETRM's composite dimension setup and member maintenance flows, including concurrent program processing and internal ETRM procedures that populate composite dimension members. Because it is not a published public API, custom code should avoid calling it directly; instead, use supported ETRM interfaces. Direct invocation, where required for controlled data migration, should follow the same validation sequence PROCESS_ROWS expects and should be tested carefully against the specific EBS release, as the package has no documented external callers to indicate backward-compatibility guarantees.