Search Results apps_initialise

Overview

APPS.PER_ISETUP_MIGRATOR_UTIL is a utility package body in the Oracle E-Business Suite that supports the migration of setup data within the Oracle Human Resources (PER) product family. The package is classified as a UTIL object in the ETRM metadata for release 12.2.2 (and equally applicable to 12.1.1), indicating that it is not an end-user facing API but rather an internal helper routine consumed by other migration or setup components. Its primary responsibility is to establish and validate an application session context before any migration activity proceeds. This session bootstrap is achieved through the single documented procedure apps_initialise, which ensures that a corresponding row exists in FND_SESSIONS for the current database session.

Key Procedures and Functions

• apps_initialise — The only documented procedure in the package. Its purpose is to guarantee that the current user session is registered in the FND_SESSIONS table with a valid effective date. The procedure opens an explicit cursor that queries FND_SESSIONS for a row matching the current session identifier (returned by userenv('sessionid')) where the stored effective date matches the current system date. If no such row is found, the procedure inserts a new record into FND_SESSIONS containing the session identifier and the current system date. The procedure includes an exception handler that calls hr_utility.trace to log the first 100 characters of any error message before re-raising the error, ensuring that failures are both traceable and propagated to the caller.

No other procedures or functions are recorded in the ETRM documentation for this package; the source header indicates it was last modified in 2004 (version 115.4).

Tables Accessed

• FND_SESSIONS — Accessed via the APPS synonym. The procedure reads this table to determine whether the current session is already registered, and writes to it when no matching row exists. The table is a standard Oracle Application Object Library (FND) repository that tracks active application sessions, and its presence here confirms that the migration utility must operate within a properly initialized Applications context. The insert into FND_SESSIONS is essential because many EBS setup and migration routines assume that a valid session record exists before performing DML on setup tables.

Usage Notes

PER_ISETUP_MIGRATOR_UTIL is an internal utility and is not intended for direct invocation by end users. It is typically called programmatically by other PL/SQL packages or concurrent programs that orchestrate HR setup migration, immediately after the session has been established but before any migration logic executes. Because the procedure manipulates FND_SESSIONS, it must be executed by a user with appropriate privileges on that table—normally the APPS schema or a responsibility with equivalent access. The package is referenced by zero other packages in the ETRM metadata, suggesting that in the documented 12.2.2 environment it is either invoked dynamically, called from forms or concurrent program definitions not captured in package-level dependency tracking, or retained for backward compatibility. Developers integrating custom HR setup migration routines may call PER_ISETUP_MIGRATOR_UTIL.APPS_INITIALISE at the start of their process to replicate the same session-registration behavior and error tracing used by Oracle's own migration utilities.