Search Results pay_sf_ins




Overview
Explore in AI Chat

Overview

PAY_SF_INS is a PL/SQL package in the APPS schema of Oracle E-Business Suite that supports the Oracle Payroll shadow formula infrastructure. Shadow formulas are internal, system-generated formula definitions that mirror or supplement user-defined payroll formulas, allowing the payroll engine to evaluate calculations without exposing the underlying system logic through the standard formula maintenance forms. PAY_SF_INS provides the insertion logic that creates and registers these shadow formula records within the Payroll application.

In the broader Oracle Payroll architecture, formula definitions are the mechanism by which payroll administrators express calculation rules (for example, earnings, deductions, and rates) using Oracle FastFormula syntax. When elements, element templates, or template-generated records are created, the system frequently needs to generate corresponding shadow formulas automatically. PAY_SF_INS is the package that performs this insertion work on behalf of the higher-level element template and formula maintenance processes.

The package is classified as an OTHER API in the ETRM documentation for release 12.2.2, indicating that it is an internal, non-public interface rather than a supported open API. It is not intended for direct invocation by customers or integrators, and its behavior may change between releases without notice.

Key Procedures and Functions

The documented interface of PAY_SF_INS consists of a single procedure:

  • INS — The insertion routine that creates shadow formula records. Based on the package name and its position in the dependency chain, INS accepts the attributes required to construct a new shadow formula row and persists it to the shadow formula tables. It serves as the controlled entry point through which callers such as the element template packages request that a shadow formula be registered. The ETRM metadata does not publish a parameter list for this procedure, and none is asserted here.

No public functions are documented for this package. The procedure is intended for internal use by the Payroll application components listed under Usage Notes below.

Tables Accessed

The package operates against the following Payroll tables, accessed through APPS synonyms:

  • PAY_SHADOW_FORMULAS — The primary shadow formula definition table. PAY_SF_INS inserts records into this table to register a new shadow formula, capturing the formula definition and its associated metadata.
  • PAY_SHADOW_FORMULAS_S — The corresponding translation or secondary detail table for shadow formulas. The package writes the companion row in this table as part of the same logical insert operation, ensuring the shadow formula record is complete and consistent across both tables.

The dependency metadata also shows a reference to PAY_SF_SHD, a shadow table associated with this package, reflecting the standard Oracle EBS pattern in which a "_SHD" object shadows the primary package for concurrency or audit purposes. The package additionally depends on the SYS.STANDARD package, which is the standard PL/SQL environment and is present in all compiled packages.

Usage Notes

PAY_SF_INS is an internal component and is not invoked from a seeded Oracle EBS form or concurrent program in the standard user interface. It is called programmatically by the following Payroll packages, as documented in the ETRM dependency information:

These callers invoke PAY_SF_INS during element template creation and related setup activities so that the required shadow formulas are established before the associated elements are used in payroll processing. Because the package is undocumented as a public API, custom code should not call it directly. Integrations that need to create formulas should use supported Payroll formula APIs and the standard element template facilities, allowing the application to manage shadow formula creation through PAY_SF_INS and its siblings. Organizations upgrading between 12.1.1 and 12.2.2 should treat PAY_SF_INS as subject to change and avoid any dependency on its internal signature.