Search Results pay_sfr_ins




Overview
Explore in AI Chat

Overview

PAY_SFR_INS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Payroll (PAY) product family. Its name reflects its function as an insert utility for Shadow Formula Rules (SFR), the configuration artefacts that control how Oracle Payroll writes payroll calculation results into the shadow formula rule tables used by the payroll run and related processes. The package operates as a low-level data maintenance component rather than a business-facing API; it is invoked by element template processing logic to persist shadow formula rule rows generated when element templates are created, copied, or seeded into a business group. The package body carries a VALID status in both the 12.1.1 and 12.2.2 releases and is documented in ETRM with an API classification of OTHER, indicating it is not published as a supported public interface.

Key Procedures and Functions

The documented interface of PAY_SFR_INS contains a single program unit.

  • INS — The sole documented procedure in the package. Its purpose is to perform the insertion of shadow formula rule definitions into the underlying shadow formula rule storage. Where the shadow formula rule already exists for the given element, input, or formula context, the procedure provides the maintenance path used by caller packages to add or refresh that rule data within the transaction context of the calling process.

No parameter lists are published in the ETRM metadata, and the procedure should be treated as an internal routine whose signature is defined by the package specification rather than a documented public contract. Custom code should not invoke INS directly.

Tables Accessed

PAY_SFR_INS references two base tables through APPS synonyms.

  • PAY_SHADOW_FORMULA_RULES — The primary target of the insert operation. This table stores the shadow formula rule records that determine how payroll results are written to the shadow rule tables during payroll processing. The INS procedure writes new rule rows here.
  • PAY_SHADOW_FORMULA_RULES_S — The translated (language) companion table for the shadow formula rules. Records inserted into the base table are accompanied by corresponding rows in the _S table so that rule text and descriptions are available in each installed language.

All access is performed through APPS synonyms, consistent with standard EBS data-access conventions and the package's dependency on the APPS schema and the SYS.STANDARD package.

Usage Notes

PAY_SFR_INS is an internal dependency rather than a standalone utility. ETRM records that it references PAY_SFR_SHD and that it is referenced by four other packages: PAY_AE_ELEMENT_TEMPLATE_PKG, PAY_CREATE_ELEMNT_TMPLT_RECORD, PAY_ELEMENT_TEMPLATE_UTIL, and PAY_IN_ELEMENT_TEMPLATE_PKG (with a self-reference also recorded). These callers are all element template processing routines, which confirms the package is reached when element templates are created, generated, or maintained — including the seeded element template flows for the UAE and India localisations. The package is therefore exercised implicitly from the Element Template configuration forms and from any concurrent program that builds element template records.

Because the INS procedure has no published signature and the package is classified as OTHER, it is not part of Oracle's supported public API set. Customisations, data fixes, or third-party payroll extensions should use the documented element template APIs and packages instead of calling PAY_SFR_INS directly; direct invocation bypasses the validation and derived-value logic applied by the calling template packages and risks inconsistent shadow formula rule data. When troubleshooting shadow formula rule discrepancies, the package is best examined as a trace point — the callers listed above identify where the insert is triggered — rather than as an entry point for remediation.