Search Results icesa_transmitter

Overview

PY_SQWL_FORMULAS is an Oracle Payroll seed-data package in the APPS schema that installs the Oracle Payroll formulas required to support State Quarterly Wage Listing (SQWL) and related federal reporting extracts, such as ICESA and SSA magnetic media transmissions. The package exists to ensure the formula definitions underpinning these statutory reports are registered in the Formula Manager repository, where the payroll engine can compile and execute them. In the Oracle EBS 12.1.1 and 12.2.2 architectures, this package belongs to the suite of "load" utilities shipped with Oracle Payroll that populate FF_FORMULAS_F with formula names and leave the formula text to be populated or compiled separately. Its API classification in ETRM is OTHER, indicating it is a data-seeding utility rather than a callable business API. The user search term insert_formula corresponds directly to the private helper procedure that performs the single-row formula registration, which is called repeatedly by the package's public driver.

Key Procedures and Functions

• LOAD_FORMULAS — The single documented public procedure. It is the driver that registers the full set of SQWL-related formulas by invoking the internal insert_formula helper once per formula name. The names seeded include ICESA series formulas (ICESA_TRANSMITTER, ICESA_BINFO, ICESA_EMPLOYER, ICESA_SUPPLEMENTAL, ICESA_TOTAL, ICESA_TOTAL2, ICESA_FINAL), SSA SQWL series (SSA_SQWL_TRANSMITTER, SSA_SQWL_BINFO, SSA_SQWL_EMPLOYER, SSA_SQWL_SUPPLEMENTAL, SSA_SQWL_TOTAL, SSA_SQWL_FINAL), and state-specific variants such as GASQWL, INSQWL, NJSQWL, NMSQWL, and NYSQWL supplemental, employer, employee, and transmitter formulas.
• insert_formula (internal, undocumented in ETRM) — A private procedure accepting a formula name. It resolves the formula type ID for 'Oracle Payroll' from FF_FORMULA_TYPES, checks for an existing row in FF_FORMULAS_F, and on NO_DATA_FOUND inserts a new formula row using the FF_FORMULAS_S sequence with canonical effective dates spanning 0001/01/01 to 4712/12/31, legislation code 'US', and NULL formula text and sticky flag.

Tables Accessed

• FF_FORMULA_TYPES — Read to obtain the formula_type_id for the 'Oracle Payroll' formula type, which is stamped on every inserted formula row.
• FF_FORMULAS_F — Read to test for the prior existence of each formula name; written with the new formula definition when no matching row is found. Formula text is inserted as NULL, so the template body is populated separately.
• FF_FORMULAS_S — The sequence supplying the surrogate formula_id for each inserted row.

Usage Notes

PY_SQWL_FORMULAS is a one-time or repeatable data-load utility, typically executed during Oracle Payroll implementation or when applying the SQWL patch set that introduces new reporting formulas. It is most often invoked by a DBA or implementation consultant from SQL*Plus or another PL/SQL client, for example by calling APPS.PY_SQWL_FORMULAS.LOAD_FORMULAS while connected as the APPS user. Because the internal insert_formula logic explicitly guards against duplicates via its NO_DATA_FOUND handler, the driver is safely re-runnable: formulas already present are skipped and no duplicate registration occurs. After the formulas are seeded, the standard Formula Manager compilation and the SQWL report concurrent programs must be run to populate formula text and make the definitions executable. No other packages reference this package, so its usage is confined to direct manual invocation rather than being embedded in a larger payroll processing dependency chain.