Search Results pay_sbf_shd




Overview
Explore in AI Chat

Overview

PAY_SBF_SHD is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema, classified under the Payroll (PAY) product family. The name follows the naming convention used throughout the Oracle Payroll shadow schema: the "SHD" suffix indicates that this package operates within the shadow balance architecture that supports the Payroll Balance Feeds feature. In Oracle EBS, balance feeds define which element input values contribute to which defined balances, and shadow balance feeds allow those feed definitions and their resulting balances to be maintained in a parallel, protected structure rather than directly against the live payroll balance tables. PAY_SBF_SHD provides the underlying programmatic logic for maintaining and updating the PAY_SHADOW_BALANCE_FEEDS repository during payroll processing and balance maintenance cycles.

The package is documented as VALID in the ETRM repository for both Oracle EBS 12.1.1 and 12.2.2. It is classified as an "OTHER" API, meaning it is not a published or externally supported public interface; it is an internal implementation package used by Oracle Payroll's shadow balance feed subsystem.

Key Procedures and Functions

The documented package exposes four procedures/functions. No parameter lists are published in the metadata, so only their purposes are summarised below.

  • CONSTRAINT_ERROR — An error-handling routine that raises or reports a constraint violation encountered while manipulating shadow balance feed records. It provides a controlled failure path when data integrity rules on the balance feed repository are breached.
  • API_UPDATING — Marks or detects whether an update is currently being performed through the public API layer. This is a standard Oracle Payroll guard used to prevent recursive or conflicting processing when a balance feed is modified through more than one entry point.
  • LCK — A locking routine that acquires the required row or table locks before modifying shadow balance feed data, ensuring that concurrent payroll processes and balance updates do not corrupt the feed repository.
  • CONVERT_ARGS — A utility routine that converts or normalises incoming arguments into the internal representation expected by the shadow balance feed processing logic, typically translating API-style parameter values into the structures used by the underlying repository.

Tables Accessed

The ETRM dependency listing documents two tables referenced through APPS synonyms:

  • PAY_SHADOW_BALANCE_FEEDS — The primary operational table for this package. It stores the shadow balance feed definitions that the package inserts, updates, and validates. All core processing in PAY_SBF_SHD centres on this table.
  • ALL_CONSTRAINTS — The Oracle data dictionary view used to inspect constraint definitions. The package queries it, most likely from CONSTRAINT_ERROR, to identify the specific constraint that was violated and to produce an accurate diagnostic message.

Dependencies further show that the package body references HR_API and HR_UTILITY, the standard Oracle HRMS utility packages used for error handling, message resolution, and common date or value conversions.

Usage Notes

PAY_SBF_SHD is not referenced by any database object according to the ETRM metadata, which confirms that it is invoked dynamically or from higher-level payroll packages rather than being statically bound into the dependency chain. The same metadata records that it is referenced by six other packages, indicating that it acts as a shared internal service for the shadow balance feed subsystem.

In practice, the package is invoked indirectly during payroll balance maintenance: when balance feeds are created, amended, or purged, the calling payroll process delegates to PAY_SBF_SHD to lock, validate, and persist the affected rows in PAY_SHADOW_BALANCE_FEEDS. Because it is classified as an internal "OTHER" API, it should not be called directly from custom code, concurrent program registrations, or Forms personalisations. Customisations that require balance feed changes should use the supported Oracle Payroll balance feed APIs instead, leaving PAY_SBF_SHD as an implementation detail of the standard payroll engine.