Search Results per_isetup_migrator_util

Overview

APPS.PER_ISETUP_MIGRATOR_UTIL is a PL/SQL utility package within the Oracle E-Business Suite Human Resources (PER) product family. The name encodes its purpose: ISetup refers to the incremental setup or information-setup migration feature, and Migrator_Util identifies the package as a supporting utility rather than the primary migration engine. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking session rather than under the definer's schema. This is a deliberate security and session-context choice typical of EBS utility packages that must operate on behalf of a logged-in application user.

The package header carries a 2004 source control stamp (perisetmigutil.pkh 115.0), indicating that the specification was stabilized early in the 11i lifecycle and carried forward unchanged into Release 12.1.1 and 12.2.2. The absence of substantive evolution suggests a small, focused helper whose contract remained stable across major releases. In ETRM classification terms, the package is tagged as a UTIL object owned by APPS, which aligns it with the broad family of PER setup-migration utilities used to move or initialize configuration data between environments such as development, test, and production.

Key Procedures and Functions

The documented specification exposes exactly one public subprogram:

• apps_initialise — The single procedure declared in the package. Its purpose is to perform application-level session initialization for the migration utility, establishing the environment in which subsequent setup-migration processing takes place. In EBS the apps_initialise naming convention is widely used to set the application context (for example, initializing session state so that APPS-owned synonyms and views resolve correctly). No parameter list is documented in the ETRM metadata, and none should be assumed.

Because only the package specification is captured, the body implementation details are not part of the documented interface. Consumers should treat apps_initialise as the sole supported entry point.

Tables Accessed

The ETRM metadata documents a single table reference, resolved through APPS synonyms:

• FND_SESSIONS — The Oracle Application Object Library (FND) table that tracks active runtime sessions in an EBS instance. The utility's reference to this table is consistent with its initialization role: establishing or validating session identity before migration work proceeds. Utilization of FND_SESSIONS ties the package into the standard EBS session-management infrastructure shared by all products.

No PER setup tables are directly documented as accessed, reinforcing the conclusion that this package is a preparatory utility rather than a data-carrying migrator.

Usage Notes

PER_ISETUP_MIGRATOR_UTIL is a low-level infrastructure package. ETRM records zero packages referencing it, which indicates that it is not a shared entry point in the dependency graph but is instead invoked directly by the iSetup / setup-migration framework, by concurrent programs, or by custom migration scripts that need a consistent application session context before executing the actual setup copy logic.

Typical invocation patterns include:

• Called at the start of a setup-migration run to initialize the APPS session context.
• Invoked from custom PL/SQL that reuses the standard PER iSetup migration machinery, ensuring the caller's session is correctly registered.
• Executed under an APPS login in environments where FND_SESSIONS must reflect the active migrator session.

Because the package is a utility with a single documented procedure and AUTHID CURRENT_USER semantics, integrators should invoke it only within an APPS-authenticated session and should not depend on undocumented behavior. Given that its specification has been unchanged since 2004 and it is unsupported by published API documentation beyond the header, it should be treated as an internal helper rather than a supported public interface for new development on 12.1.1 or 12.2.2.