Search Results delete_session

Overview

APPS.HR_JP_DATA_MIGRATION_PKG is a Japanese localization data migration package within Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. Its primary business function is to migrate and restructure Japanese-specific payroll and assignment data during upgrade or localization activities, particularly around the Japan-specific SMR (Social/Medical/Remuneration reporting data) and dependent data structures. The package focuses on converting legacy element entry records (head and detail) into the current data model, ensuring that historical payroll element entries, run results, and associated assignment-level data are properly qualified, validated, and migrated.

The package leans on HR_UTILITY for common HR utility routines and references assignment records via PER_ALL_ASSIGNMENTS_F and business group context via PER_BUSINESS_GROUPS, confirming its role within the HR module's Japanese localizations. It is also referenced by PAY_JP_GENERIC_UPGRADE_PKG, illustrating that it participates in the larger Japanese payroll upgrade flow and can be invoked as a dependency by that higher-level upgrade package.

Key Procedures and Functions

The package exposes 19 documented procedures/functions organized loosely around session management, data initialization, qualification, validation, and migration execution. Key members include:

• Session Management: INSERT_SESSION and DELETE_SESSION create and remove migration session records, providing traceability and isolation between migration runs. GET_MIG_DATE and GET_ASS_INFO retrieve migration dates and assignment information needed to drive the migration logic.
• Element Entry Handling: ELEMENT_RUN_RESULT_COPY copies run result data associated with element entries; ADD_NEW_INPUT_VALUE adds new input values to element entries; END_ELEMENT_ENTRY finalizes element entries by setting end dates. These support restructuring of the payroll element entry data.
• SMR (Head) Migration: QUALIFY_HI_SMR_HD, INIT_DEF_HI_SMR_DATA, VAL_MIG_SMR_ASSACT, MIGRATE_HI_SMR_HD, MIG_SMR_ASSACT, and RUN_MIG_SMR form the SMR head migration pipeline — qualifying records, initializing defaults, validating assignment/action relationships, and performing the actual migration.
• Dependent (Head) Migration: QUALIFY_DEP_HD, INIT_DEF_DEP_DATA, VAL_MIG_DEP_ASSACT, MIG_DEP_ASSACT, and RUN_MIG_DEP mirror the SMR pipeline for dependent data, again ending in a run driver procedure.

The paired QUALIFY/INIT/VALIDATE/MIGRATE/RUN naming convention indicates a staged migration architecture: records are qualified, defaults initialized, assignments validated, detail rows migrated, then executed in a single run procedure.

Tables Accessed

The package reads and writes across the HR and Payroll core tables via APPS synonyms. Assignment context is sourced from PER_ALL_ASSIGNMENTS_F and business groups from PER_BUSINESS_GROUPS. Session tracking relies on FND_SESSIONS, and messaging/output on FND_NEW_MESSAGES. Payroll element processing touches PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F/S, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PAY_LINK_INPUT_VALUES_F/S, PAY_RUN_RESULTS, PAY_RUN_RESULTS_S, and PAY_RUN_RESULT_VALUES. Japan-specific parameters are read from HR_JP_PARAMETERS, allowing the migration behavior to be controlled by localization configuration rather than hard-coded values.

Usage Notes

HR_JP_DATA_MIGRATION_PKG is not intended for ad hoc runtime use. It is typically invoked from within the Japanese payroll upgrade path — most notably as a dependency of PAY_JP_GENERIC_UPGRADE_PKG — and from custom migration scripts executed during localization upgrades, patch application, or data conversion projects. Because the package performs bulk data movement with staging sessions and element entry restructuring, it should be executed under controlled conditions with backups, ideally after running the qualification and validation steps to confirm data readiness. Direct invocation from Oracle Forms is not typical; the package serves as backend migration logic rather than a user-facing API.