Search Results transfer_data




Overview
Explore in AI Chat

Overview

APPS.PER_FR_TERMINATION_UPG_PKG is a French localization upgrade utility that forms part of the Oracle E-Business Suite Human Resources (PER) product family. Its purpose is to support a data migration or upgrade activity specific to French statutory requirements, in which termination (leaving) information historically stored in a non-standard column on the periods-of-service record must be converted into a properly recognized leaving reason. The package is designed for one-time or limited use during an upgrade cycle, not for routine transactional processing. The package body carries the version marker $Header: pefrtmup.pkb 115.2, confirming it is a delivered Oracle seed object rather than a customer extension.

The package was delivered in the older 11i file form and remains present, though effectively dormant, in EBS 12.1.1 and 12.2.2. In 12.2.2 the ETRM classification for the package is OTHER, reflecting that it is an internal upgrade helper rather than a public API.

Key Procedures and Functions

The documented interface exposes a single entry point, RUN_UPGRADE. This is the driver routine intended to be called when the French termination upgrade is executed. Internally the package body also defines TRANSFER_DATA, a function that must be called from RUN_UPGRADE. According to the source comments, TRANSFER_DATA returns a status code: 0 indicates the upgrade completed successfully, 1 indicates completion with warnings, and 2 indicates the upgrade failed. A private helper, WRITE_PDS_TO_LOG, writes the employee number, full name, and the legacy termination value to the upgrade log so that users can manually re-enter the information where the process could not create it automatically. The package-level variable g_package holds the package name for logging purposes.

Tables Accessed

The package reads from two documented tables through APPS synonyms:

  • PER_PERIODS_OF_SERVICE — the primary source. The cursor csr_pds selects the period-of-service identifier, the legacy value held in pds_information2, the leaving reason, the start date, and the associated business group. Records are filtered to those where pds_information2 is populated but leaving_reason is null, i.e. terminations captured in the old format awaiting conversion.
  • PER_ALL_PEOPLE_F — joined on person_id and constrained to the period start date falling within the person's effective date range, providing the employee number and full name used in log output.

The cursor additionally joins the HR_LOOKUPS view (lookup type LEAV_REAS) on an outer-join basis to resolve the legacy value to a valid leaving-reason lookup code. Records are ordered by full name and period start date.

Usage Notes

This package is invoked as part of a controlled upgrade script, typically from SQL*Plus or a wrapper concurrent program, passing the target business group identifier to RUN_UPGRADE. It should not be scheduled or called from application forms or from custom code as part of normal HR operations. Because TRANSFER_DATA explicitly requires being called from RUN_UPGRADE, direct invocation from outside the package is not supported.

Customers on 12.1.1 and 12.2.2 should treat this as legacy localization code. Where the metadata indicates the package is referenced by one other package, callers are Oracle-internal upgrade components rather than customer objects. Any manual correction of termination data should be performed through standard HR termination functionality, using the package log output as the source of the values that failed conversion.