Search Results pay_sbf_ins




Overview
Explore in AI Chat

Overview

PAY_SBF_INS is an Oracle Application Object Library (AOL) PL/SQL package owned by the APPS schema and validated in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The name follows the Oracle naming convention for insert operations, with "SBF" denoting Shadow Balance Feeds. The package therefore serves as the primary insertion gateway for the payroll shadow balance feed infrastructure — the mechanism by which Oracle Payroll maintains summarized, pre-aggregated balance records used to accelerate balance inquiries, balance validation in element eligibility rules, and downstream reporting.

PAY_SBF_INS is classified as OTHER in the ETRM repository, meaning it is an internal processing package rather than a formally published public API with a commitment to backward compatibility. It is not intended for direct customer invocation, though it is widely referenced by other application code, making its behavior significant during patching and upgrades. ETRM lists four dependent packages that reference it: PAY_AE_ELEMENT_TEMPLATE_PKG, PAY_CREATE_ELEMNT_TMPLT_RECORD, PAY_ELEMENT_TEMPLATE_UTIL, and PAY_IN_ELEMENT_TEMPLATE_PKG. These references establish that shadow balance feed creation is triggered as part of element template definition and instantiation workflows. The package in turn depends on the SYS.STANDARD package and on the shadow table package PAY_SBF_SHD, which confirms an association with shadow (mirror) table maintenance for the underlying data.

Key Procedures and Functions

ETRM documents a single callable procedure within PAY_SBF_INS: INS. Consistent with the package naming convention, INS performs the core insert logic — persisting one or more rows into the shadow balance feed structures owned by Oracle Payroll. It is the sole documented entry point and encapsulates the insert-side operations required to populate a shadow balance feed definition.

The procedure is invoked indirectly rather than directly by end users. The four packages identified in the dependency chain call PAY_SBF_INS.INS when an element or element template requires a corresponding shadow balance feed record to be generated. No parameter lists are documented in the ETRM metadata; the procedure's interface should be treated as internal and subject to change between releases.

Tables Accessed

The package accesses two documented tables through APPS synonyms: PAY_SHADOW_BALANCE_FEEDS and PAY_SHADOW_BALANCE_FEEDS_S. The former is the primary transactional table storing shadow balance feed definitions, while the "_S" suffixed table is the corresponding shadow (translation) table used by Oracle EBS for multilingual seed data and referential integrity during upgrades. The INS procedure performs insert operations against these tables to create or populate shadow balance feed records. Actual maintenance of the shadow tables derived from these feeds is delegated to PAY_SBF_SHD, per the documented dependency.

Usage Notes

PAY_SBF_INS.INS is normally executed implicitly during element configuration — specifically when element templates are created, copied, or instantiated via the element template utility packages. It may also be invoked from concurrent programs and, less commonly, from custom extension code that programmatically creates element templates. Under no circumstances should the package be called directly in production, as it bypasses the validation and sequencing logic embedded in the calling template packages and can produce inconsistent shadow balance data.

Because shadow balance feeds affect balance calculation performance and the accuracy of balance-based eligibility rules, any diagnostic or data-fix scripts that reference PAY_SBF_INS should be reviewed against Oracle Support guidance for the specific release. Where feeds are missing or corrupt, the recommended remediation path is to re-run the applicable element template process rather than to invoke INS directly. In upgrade scenarios from 12.1.1 to 12.2.2, developers should verify that customizations calling PAY_SBF_INS remain compatible, as the package is internal and may change without notice.