Search Results pay_sfr_upd




Overview
Explore in AI Chat

Overview

PAY_SFR_UPD is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM/API framework as "OTHER." Its object name, together with its principal dependency on PAY_SFR_SHD and its access to PAY_SHADOW_FORMULA_RULES, indicates that the package supports the Oracle Payroll "Shadow Formula Rules" (SFR) feature. Shadow formula rules allow payroll administrators to test proposed formula changes against live payroll data without affecting the production calculation, by executing candidate logic in a shadow context and capturing the resulting rule evaluations. The "_UPD" suffix denotes that this package is the update-side component of the SFR subsystem: it writes or refreshes shadow formula rule records, whereas the companion PAY_SFR_SHD package provides the shared, lower-level routines that both read and maintain the underlying data structures. The package carries a status of VALID in the APPS schema and is documented as an API-classified object, meaning it is intended to be called by Oracle's own forms and concurrent processing infrastructure rather than being treated as an end-user-callable interface.

Key Procedures and Functions

The documented metadata for PAY_SFR_UPD lists a single entry point, UPD, which is the sole currently documented procedure or function in the package specification. As the name implies, UPD performs the update operation for shadow formula rules — persisting changes to SFR definitions and their derived evaluation data. No parameter list is documented in the ETRM record, and no signature should be assumed; the package is not published as a supported public API, and its callers are internal Oracle components. Historically, the package body also contained a set of private helper routines used to stage and validate shadow rule rows before the update is committed, but these are not exposed in the documented interface. The package shares its shadow-rule logic with PAY_SFR_SHD, which it references at runtime, so any custom code that must manipulate SFR data should be evaluated carefully against these internal dependencies.

Tables Accessed

PAY_SFR_UPD operates on PAY_SHADOW_FORMULA_RULES, accessed through APPS synonyms. This table stores the shadow formula rule definitions that mirror selected production formula rules during a comparison or trial run. The package reads the existing rule rows, applies the requested updates, and writes the modified definitions back to the table so that subsequent shadow payroll runs evaluate the candidate rules. Because the table of record is a payroll configuration table, direct DML outside the package can leave the SFR data in an inconsistent state relative to the production formula definitions it shadows. The package's dependency graph also shows references to HR_API (the Oracle HRMS public API layer) and to the STANDARD database package, indicating that it relies on standard HR security and error-handling utilities during execution.

Usage Notes

PAY_SFR_UPD is an internal Oracle Payroll component and is not documented as a public API. It is most commonly invoked indirectly through the Payroll Shadow Formula Rules forms and through Oracle concurrent programs that manage shadow rule maintenance; the ETRM metadata records zero dependent packages that reference PAY_SFR_UPD, confirming that it is a top-level internal utility rather than a shared service. Custom developers who need to adjust shadow formula rules should use the supported Oracle Payroll forms or documented HRMS APIs rather than calling UPD directly, since the procedure's signature and behavior are not guaranteed across patch levels. Where custom code must interact with PAY_SHADOW_FORMULA_RULES, the strongly recommended pattern is to replicate the package's update logic through supported APIs and to validate all changes in a test instance before promotion.