Search Results get_upgrade_flag

Overview

PAY_US_RSRW_UPGREV is an Oracle Payroll upgrade utility package owned by the APPS schema and classified as OTHER in the ETRM repository for Oracle EBS 12.1.1 and 12.2.2. Its business function is narrowly scoped but operationally significant: it migrates the legacy seeded earnings elements "Regular Salary" and "Regular Wages" for the US legislation to the newer element architecture, enabling Core Proration functionality. The package is executed by a concurrent program rather than invoked interactively, and it is designed as a one-time or controlled upgrade activity rather than a routine payroll processing component.

Because the migration changes the underlying element definitions and their associated Fast Formulas, the package documentation carries an explicit operational warning: customers must recompile the Fast Formulas REGULAR_SALARY and REGULAR_WAGES after the upgrade completes. Failure to do so leaves the migrated elements referencing stale compiled formula versions, which can produce incorrect payroll calculations or formula compilation errors during subsequent payroll runs.

Key Procedures and Functions

The ETRM metadata documents four procedures and functions, with five entries listed in total:

• GET_UPGRADE_FLAG — Introduced in version 115.1 (bug 8464127). Returns an indicator describing whether the Regular Salary and Regular Wages upgrade has been applied, allowing callers to determine upgrade state before attempting migration or revert operations. This is the object most commonly referenced by users searching on "get_upgrade_flag."
• REVERT_UPG_REG_SALARYWAGES — Performs the reverse of the package's primary purpose, restoring the pre-upgrade state of the Regular Salary and Regular Wages elements. This supports rollback scenarios when the forward upgrade must be undone.
• GET_PAYPRD_PER_FISCAL_YR — Introduced in version 115.1 (bug 8464127) and subsequently modified in version 115.3 (bug 8637053) to add a context element of element_type_id. Determines the number of payroll periods associated with a fiscal year, scoped by element type.
• GET_ASSIGNMENT_STATUS — Added in version 115.2. Returns assignment status information used by the upgrade logic to assess which assignments are affected by the element migration.

Tables Accessed

The package reads and writes across payroll, Fast Formula, and HR reference tables via APPS synonyms. The Fast Formula tables (FF_COMPILED_INFO_F, FF_FDI_USAGES_F, FF_FORMULAS_F, FF_FORMULA_TYPES) support the recompilation and validation of the migrated formulas and their usages. Payroll element metadata is handled through PAY_ELEMENT_TYPES_F and PAY_ELEMENT_TYPE_EXTRA_INFO, with PAY_EVENT_GROUPS and PAY_DATED_TABLES supporting dated element configuration and effective-dated records.

Upgrade bookkeeping relies on PAY_UPGRADE_DEFINITIONS, PAY_UPGRADE_DEFINITIONS_S, and PAY_UPGRADE_STATUS, which record the definition of the upgrade and its current state. Date-tracking and event information is drawn from PAY_DATETRACKED_EVENTS. Assignment and time period context for the fiscal-year and assignment-status functions comes from PER_ASSIGNMENT_STATUS_TYPES, PER_TIME_PERIODS, and PER_TIME_PERIOD_TYPES.

Usage Notes

PAY_US_RSRW_UPGREV is invoked through a concurrent program and is referenced by one other package in the ETRM repository; it is not exposed through a standard EBS form. The typical invocation sequence is to run the upgrade concurrent program, verify the result using GET_UPGRADE_FLAG, and then manually recompile the REGULAR_SALARY and REGULAR_WAGES Fast Formulas. Custom code may call GET_UPGRADE_FLAG defensively to confirm upgrade state before executing logic that depends on the new architecture, while GET_PAYPRD_PER_FISCAL_YR and GET_ASSIGNMENT_STATUS are supporting utilities used within the upgrade and revert flows. Because the package is AUTHID CURRENT_USER, invoked objects resolve under the calling schema's privileges, and the REVERT_UPG_REG_SALARYWAGES routine provides the documented rollback path where a migration must be reversed.