Search Results load_formulas




Overview
Explore in AI Chat

Overview

PY_SQWL_FORMULAS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API classification "OTHER." Its sole documented purpose is to load Oracle Fast Formula definitions into the Oracle Payroll (Oracle HRMS) formula repository. The package header, shipped as pysqwl.pkh (version 115.2, dated 1999/11/23), declares a single public procedure, LOAD_FORMULAS, and is defined with the AUTHID CURRENT_USER clause. This means the package executes with the privileges of the calling user rather than the definer, so any session invoking it requires appropriate grants on the underlying Fast Formula tables and any supporting objects.

The package sits in the Oracle Payroll utilities layer. Its name reflects a legacy naming convention in which payroll-specific utilities were prefixed "PY" and often carried shorthand identifiers such as "SQWL." Functionally it exists to seed or refresh Fast Formula metadata—the header-level and usage-level records that define a formula's name, type, effective dates, and associated text—so that payroll and HRMS processing engines can resolve and compile those formulas at runtime.

Key Procedures and Functions

  • LOAD_FORMULAS — The package's only documented procedure. Based on the package name and the objects it touches, LOAD_FORMULAS performs the loading of Fast Formula definitions into the relevant formula tables. It does not return a value and, per the ETRM metadata, exposes no documented parameters. In practice such loader routines insert or update formula header and usage records, often for a defined set of seeded or application-specific formulas, so the procedure should be treated as a bulk data-maintenance routine rather than a per-record API.

No functions, additional overloads, or nested helper procedures are documented for this package. Callers should not assume any interface beyond the single LOAD_FORMULAS entry point.

Tables Accessed

The ETRM metadata documents access to three Fast Formula tables, all reached through APPS synonyms:

  • FF_FORMULAS_F — The formula header ("F" for the base/foundation) table holding core formula attributes such as formula name, effective start and end dates, and definition text. LOAD_FORMULAS would insert or maintain header rows here.
  • FF_FORMULAS_S — The formula usage/context table ("S"), which records how a given formula is used—for example, its usage type and any context-specific linkage. Loader logic writes corresponding usage rows whenever a header is created.
  • FF_FORMULA_TYPES — The reference table of valid formula types (for example, Oracle Payroll, Oracle Benefits, or other product classifications). The loader reads this table to validate or resolve the type under which each formula is registered.

These three tables constitute the standard Fast Formula data model, consistent with the package's stated loading role.

Usage Notes

PY_SQWL_FORMULAS is a utility package rather than a user-facing API. It is not referenced by any other documented package in the ETRM metadata (referenced by 0 packages), which suggests it is invoked directly—typically from a concurrent program, a one-time data-load or patch script, or custom PL/SQL run by an implementation team. Because it is an internal, undocumented-interface routine, it should not be called from production application code without reviewing the specific EBS release (12.1.1 versus 12.2.2) for behavioral differences. Site administrators and technical consultants generally invoke LOAD_FORMULAS during formula seeding, migration between environments, or remediation of missing formula records. Given the AUTHID CURRENT_USER declaration, execution must be performed by a user with the necessary privileges on the FF_ tables, and any run should be validated in a test instance before being applied to production.