Search Results pay_sdb_shd




Overview
Explore in AI Chat

Overview

PAY_SDB_SHD is a PL/SQL package body owned by the APPS schema that supports Oracle Payroll's shadow defined balance infrastructure. Its name reflects its role: "SDB" denotes Shadow Defined Balance, and "SHD" refers to the shadow balance seeding and maintenance mechanism used by Oracle Payroll. Shadow defined balances provide a mirrored or staged representation of payroll balance data, allowing the payroll engine to compute, validate, and refresh balance results without directly disturbing the live balance records used for reporting and downstream processing.

In Oracle EBS 12.1.1 and 12.2.2, this package functions as a supporting utility rather than a primary business API. It is classified as OTHER in the ETRM documentation, indicating it is an internal technical component invoked by other payroll packages rather than a formally published API. The package body is currently VALID, and it depends upon the HR_API and HR_UTILITY packages, the PAY_SDB_SHD specification, the PAY_SHADOW_DEFINED_BALANCES table, and the ALL_CONSTRAINTS data dictionary view. It does not reference any other database object directly, but six other packages reference it, confirming its role as a shared service within the payroll balance subsystem.

Key Procedures and Functions

The ETRM metadata documents four procedures or functions within this package body. Their names indicate a mix of core processing logic and diagnostic helpers.

  • API_UPDATING — The principal entry point for updating shadow defined balance data. It coordinates the package's write activity against the shadow balance structures.
  • LCK — A locking routine. Given the concurrent nature of payroll processing, this procedure protects shadow balance records from simultaneous modification by competing sessions, preserving data integrity during balance refresh operations.
  • CONVERT_ARGS — An argument conversion helper, likely used to translate incoming parameter values into the format expected by internal balance processing logic.
  • CONSTRAINT_ERROR — An error handling procedure that raises or reports exceptions related to constraint violations detected during balance manipulation.

No parameter signatures are documented, and none should be assumed. Each routine should be treated as an internal implementation detail rather than a callable interface.

Tables Accessed

Two tables are documented as referenced through APPS synonyms:

  • PAY_SHADOW_DEFINED_BALANCES — The primary data store manipulated by this package. It holds the shadow or staged copies of defined balance results that the payroll engine maintains alongside the authoritative balance records.
  • ALL_CONSTRAINTS — A data dictionary view consulted at runtime. Its presence suggests the package inspects database constraints, likely to validate balance definitions or to confirm that expected integrity rules exist before performing updates.

Usage Notes

PAY_SDB_SHD is not intended for direct invocation by end users or by conventional concurrent programs. It is an internal payroll engine component, called by other packages in the payroll balance framework. The six dependent packages confirm that the shadow balance process flows through this body during balance calculation and refresh cycles.

Because it is classified as OTHER, no documented API contract governs its parameters, and Oracle does not guarantee backward compatibility for direct calls. Customizations should avoid referencing PAY_SDB_SHD directly; instead, they should use supported payroll balance APIs. Developers troubleshooting shadow balance discrepancies may review this package's logic to understand how staged balances are locked, converted, and updated, but modifications to its source are unsupported and may be overwritten by patching.