Search Results pay_balance_values_v




Overview
Explore in AI Chat

Overview

PAY_BALANCE_VALUES_V is an APPS-owned database view in the Oracle E-Business Suite Payroll (PAY) product module. It is registered in ETRM as VALID and described as a "sales ADS DISCO workbook req," indicating it was created to satisfy a specific reporting requirement rather than as a general-purpose seeded object. The view presents calculated payroll balance values at the level of individual assignment actions, combining assignment-action context, payroll action context, balance type and dimension metadata, and the resolved numeric value produced by the payroll balance engine. In effect, it exposes the output of PAY_BALANCE_PKG.GET_VALUE joined to the descriptive attributes of the balance definition that produced it.

Because it is a view and not a table, it carries no independent storage. Its role is to flatten the complex relationships between payroll runs, run results, run result values, balance feeds, defined balances, and balance dimensions into a single queryable row set suitable for reporting, reconciliation, and downstream integration or data-warehouse extraction.

Underlying Base Objects

The view is defined over a set of APPS synonyms and packages, all documented in the 12.2.2 metadata:

Key Columns

Common Use Cases and Queries

Typical uses include payroll balance reconciliation, validating run result values against defined balances, and extracting balance data for a data warehouse or third-party reporting tool. Because the underlying call to PAY_BALANCE_PKG.GET_VALUE is executed per row, queries against this view are expensive; filters on assignment action, payroll, balance type, and effective date should always be applied. The user's search term "org_info" corresponds to the organization information context (via HR_ORGANIZATION_INFORMATION and the org entry context), which is exposed through ORIGINAL_ENTRY_ID.

A representative query:

SELECT pbv.assignment_action_id,
       pbv.assignment_id,
       pbv.payroll_id,
       pbv.effective_date,
       pbv.balance_name,
       pbv.dimension_name,
       pbv.value,
       pbv.jurisdiction,
       pbv.balance_date
  FROM apps.pay_balance_values_v pbv
 WHERE pbv.payroll_id = :p_payroll_id
   AND pbv.effective_date = :p_effective_date
   AND pbv.balance_name = :p_balance_name
 ORDER BY pbv.assignment_id, pbv.dimension_name;