Search Results fem_dimension_migration_pkg




Overview
Explore in AI Chat

Overview

The APPS.FEM_DIMENSION_MIGRATION_PKG package is the migration engine for Oracle Enterprise Business Suite's Enterprise Performance Foundation (FEM) dimension framework. Its stated purpose, per the package header, is to migrate dimension members, member translatable names and descriptions, and member attribute assignments from a source database into the dimension member loader interface tables in a target database. In practice, this package supports consolidation, upgrade, and environment-cloning scenarios in which dimension metadata must be transported from a legacy or staging environment into the target EBS instance, most commonly following an upgrade to 12.1.1 or 12.2.2 where the FEM schema has been reorganized. The package is defined with AUTHID CURRENT_USER and is stamped with a creation date of 25-APR-2005 (PRANDALL), with a revision reference in the header dated 2005/07/25.

Key Procedures and Functions

  • Main — The top-level entry point, accepting an execution mode, an object definition identifier (defaulting to 1200), a dimension varchar label, and a date format mask, together with the standard concurrent program OUT parameters errbuf and retcode. It orchestrates the overall migration run and determines which downstream procedures are invoked.
  • MIGRATE_MEMBERS — Migrates the dimension member records themselves, including the member translatable names and descriptions, from the source database into the target interface tables.
  • MIGRATE_HIERARCHY — Migrates the parent/child hierarchy relationships that define how migrated members roll up within a dimension.
  • GET_ATTR_ASSIGN_VALUE — A helper that resolves attribute assignment values for a member during the migration, translating source-side attribute data into the form expected by the target loader interface.

The package declares a set of constants governing behavior — an enabled flag set to 'Y', and personal, read-only, and success/error status constants drawn from FND_API — which indicate the package follows standard Oracle Application Object Library API messaging conventions.

Tables Accessed

  • FEM_OBJECT_DEFINITION_B — The definition of the migration object being processed; the package default object definition id of 1200 points at a row in this table.
  • FEM_OBJECT_CATALOG_B — The catalog describing available FEM objects, used to validate and resolve the object being migrated.
  • FEM_XDIM_DIMENSIONS — The extended dimension definition table, used to resolve the target dimension identified by the dimension varchar label.
  • FEM_PL_TABLES — The FEM table registry, used to resolve which physical tables participate in the load.
  • PLITBLM — The PL/SQL index-by table of VARCHAR2 used by Oracle Forms and concurrent managers for parameter passing, indicating this package is invoked through the standard concurrent request mechanism.

Usage Notes

Because the Main procedure carries errbuf and retcode, the package is designed to be executed as a concurrent program from the FEM responsibility, typically through the Standard Request Submission form. Administrators invoke it when consolidating or migrating dimension metadata between environments, for example ahead of a production go-live. The default object definition id of 1200 and the dimension varchar label parameter allow the same program to be reused across different dimension definitions. The package is not referenced by any other database package (referenced by 0 packages), so it functions as a leaf-level utility rather than a shared library. Custom integrators may call Main directly, but must supply a valid date format mask and target dimension label. Because the header is dated 2005 and the revision number is 120.1, the package is a legacy component carried forward into 12.1.1 and 12.2.2; Oracle's standard guidance is to invoke it only through its supported concurrent program rather than from ad hoc SQL.