Search Results pay_shadow_balance_feeds_s

Overview

PAY_SBF_INS is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The name resolves to "Pay Shadow Balance Feed Insert," and the package forms part of the payroll shadow balance feed infrastructure used by Oracle Payroll. Shadow balance feeds are the internal mechanism by which Oracle Payroll records the movement of balances between the primary payroll balance tables and the shadow (reporting) balance tables. These feeds act as a staging and propagation layer, ensuring that balance dimension values and balance aggregates remain consistent when payroll runs, balance adjustments, or retroactive processing write new results.

The package is classified in the ETRM repository as an OTHER API rather than a public, supported interface. It is not referenced by any other database object, which is consistent with a low-level insert utility invoked by the internal shadow balance feed processing chain rather than by external callers.

Key Procedures and Functions

The documented program unit exposes a single procedure named INS. The name indicates that its role is insertion: it writes new shadow balance feed rows into the underlying feed table. The procedure encapsulates the insert logic that the rest of the shadow balance feed machinery relies upon, so that the required columns, audit attributes, and validated lookup values are populated consistently in a single location. No public specification parameters are documented in the ETRM metadata, and no parameter lists are reproduced here, as the repository records only the program unit name.

Supporting logic is not implemented inside PAY_SBF_INS itself. Instead, the package body depends on PAY_SBF_BUS, which supplies the shared business rules and validation logic for shadow balance feeds, and on PAY_SBF_SHD, which handles shadow-side processing. Calls to HR_API and HR_UTILITY provide the standard human resources utility routines and error-handling conventions used throughout Oracle HRMS PL/SQL. The DUAL and STANDARD dependencies reflect routine SQL and PL/SQL constructs.

Tables Accessed

The package body references two documented tables through APPS synonyms. PAY_SHADOW_BALANCE_FEEDS is the base table that stores the individual shadow balance feed records. PAY_SBF_INS writes rows into this table through the INS procedure. This table is the transactional store that the feed processor later consumes when updating shadow balance results.

PAY_SHADOW_BALANCE_FEEDS_S is the corresponding sequence, and the user search term "pay_shadow_balance_feeds_s" identifies precisely this object. The sequence supplies the unique primary key for each new shadow balance feed row generated by INS. The pairing of a base table with a same-named sequence is the standard Oracle HRMS pattern for surrogate-key generation in high-volume payroll tables, avoiding contention on the parent key and preserving deterministic ordering of inserted feed records.

Usage Notes

PAY_SBF_INS is an internal package and is not intended for direct invocation from forms, concurrent programs, or customer extensions. It is called by the payroll shadow balance feed processing logic during balance updates, most notably when payroll run results, balance adjustments, or balance initialization routines create new feed entries. Four other packages reference it, confirming that it operates as a shared internal dependency rather than a standalone entry point.

Because the package writes directly to PAY_SHADOW_BALANCE_FEEDS, direct calls risk bypassing validation performed in PAY_SBF_BUS and can leave the shadow balance tables in an inconsistent state. Administrators and developers diagnosing shadow balance issues should review the package dependencies and trace flows through PAY_SBF_BUS and PAY_SBF_SHD rather than invoking PAY_SBF_INS.obs The package status is VALID in the ETRM repository, confirming that it is a current, compiled component of the Oracle Payroll shadow balance architecture.