Search Results process_members




Overview
Explore in AI Chat

Overview

APPS.FEM_DIMENSION_MIGRATION_PKG is an Oracle Enterprise Business Suite (EBS) PL/SQL package body that supports Oracle's Enterprise Tax, Risk, and Treasury Management (ETRM) / Financial Services component. Its core business function is to migrate dimension, hierarchy, and member metadata from a source environment to a target environment, an operation commonly required when cloning, refreshing, or promoting configuration between instances. The package is authored by Oracle Corporation and carries a header history reflecting production fixes, including Bug#5331497 (value set insertion) and Bug 5287339 (dimension hierarchy migration failure), confirming its role in transferring ETRM dimension definitions reliably across databases.

The source line for the requested search term, process_members, is not present in the documented procedure list, suggesting it is either an internal helper or an older/undocumented routine; the documented migration flow is driven by the procedures below.

Key Procedures and Functions

  • GET_ATTR_ASSIGN_VALUE — Retrieves the value assigned to a given attribute, supporting the mapping of metadata attributes during the dimension migration process.
  • MIGRATE_MEMBERS — The primary routine for moving member records; this is the procedure most closely associated with "process_members" style operations, iterating and loading member data into the target environment.
  • MIGRATE_HIERARCHY — Migrates dimension hierarchy structures, ensuring parent-child relationships and hierarchy object identifiers are correctly established in the target. This is the procedure addressed by Bug 5287339.
  • insert_value_sets — Documented via the history block (not counted in the four documented routines) and responsible for creating value sets, with default_member_id, default_load_member_id, and default_hierarchy_obj_id deliberately set to NULL because their sequence values differ between source and target databases (Bug#5331497).

Global package variables track post-processing statistics (gv_rows_fetched, gv_rows_rejected, gv_rows_loaded, gv_temp_rows_rejected) and concurrent request context (gv_request_id, gv_apps_user_id, gv_login_id, gv_pgm_id, gv_pgm_app_id), enabling audit and logging through FND_LOG levels.

Tables Accessed

  • FEM_XDIM_DIMENSIONS — Stores dimension definitions subject to migration.
  • FEM_OBJECT_CATALOG_B — Holds the catalog of ETRM objects; read to identify objects eligible for migration.
  • FEM_OBJECT_DEFINITION_B — Contains base object definitions used when recreating dimension metadata in the target.
  • FEM_PL_TABLES — A partitioned/parameter list table used to stage or drive the migration of table-level metadata.
  • PLITBLM — A PL/SQL index-by table helper used for bulk collection handling during processing.

Access is performed via APPS synonyms, consistent with EBS standards.

Usage Notes

The package is designed for administrative invocation rather than end-user transactional use. It is typically called from concurrent programs or migration utilities within the ETRM Administrator responsibility, and may also be referenced by custom migration scripts. Because it relies on FND_GLOBAL for concurrent request and user context, it should be executed within an EBS session, not from an external schema. No other packages reference it (referenced-by count is zero), indicating it is a top-level migration entry point rather than a shared library. Administrators migrating dimensions should run MIGRATE_MEMBERS and MIGRATE_HIERARCHY sequentially and review the gv_rows_rejected statistics for data quality issues.