Search Results current_val




Overview
Explore in AI Chat

Overview

The PAY_US_FED_LIABILITIES_RBR_V view is a payroll reporting object owned by the APPS schema within the Oracle E-Business Suite Payroll (PAY) module. Its name reflects its purpose: "RBR" denotes run balance results, "US" indicates the United States legislative context, and "Fed Liabilities" identifies the federal tax liabilities it surfaces. The view presents federal tax liability balances for assignments processed by payroll actions, resolving those balances at four distinct temporal checkpoints — CURRENT, RUN, QTD (quarter-to-date), and YTD (year-to-date). It is not a stored table but a dynamically resolved view whose monetary columns are computed at query time through calls to the PAY_US_TAXBAL_VIEW_PKG.US_TAX_BALANCE_VM function, and whose behavioral flags derive from PAY_US_BALANCE_VIEW_PKG. This architecture makes the view a convenient façade for applications, reports, and integrations that require consistent federal liability figures without directly invoking the tax balance API. Output formats are opaque: each *_VAL column is used for display purposes, with formatting controlled by the underlying balance view logic rather than by the caller.

Underlying Base Objects

The view is defined over several documented base objects. PAY_ASSIGNMENT_ACTIONS and PAY_PAYROLL_ACTIONS supply the transactional context — assignment action state, action status, payroll action type, earned date, and effective date. PAY_US_FED_LIABILITY_TYPES_V is a supporting view that enumerates federal liability tax types and their attributes; it drives the row generation through a date-range join on NVL(PPA.DATE_EARNED, PPA.EFFECTIVE_DATE) against its effective start and end dates. Two packages supply runtime values: PAY_US_TAXBAL_VIEW_PKG.US_TAX_BALANCE_VM computes the four balance figures per tax type and period, while PAY_US_BALANCE_VIEW_PKG.GET_VIEW_MODE and GET_CALC_ALL_TIMETYPES_FLAG provide taxability mode and time-type calculation flags. Although not referenced in the excerpted text, the object depends transitively on the balance infrastructure that the packages read — namely PAY_RUN_BALANCES, PAY_BALANCE_ATTRIBUTES, and PAY_BAL_ATTRIBUTE_DEFINITIONS — since balance resolution cannot occur without them. All base references are resolved through APPS synonyms pointing to the underlying PAY tables.

Key Columns

Common Use Cases and Queries

Typical uses include federal tax liability reconciliation, quarter-end and year-end reporting, and downstream integration extracts. Reporting queries filter by assignment action or payroll action to retrieve the relevant CURRENT_VAL or YTD_VAL. A representative query:

SELECT ASSIGNMENT_ID, TAX_UNIT_ID,
       TAX_TYPE_CODE, EE_OR_ER_CODE,
       CURRENT_VAL, RUN_VAL, QTD_VAL, YTD_VAL
FROM   APPS.PAY_US_FED_LIABILITIES_RBR_V
WHERE  ASSIGNMENT_ACTION_ID = :p_assignment_action_id
AND    TAX_DOMAIN_CODE = 'FED';

For period reporting, users aggregate over QTD_VAL or YTD_VAL grouped by TAX_TYPE_CODE and EE_OR_ER_CODE. Because the balance columns are computed at execution time, query performance depends on the underlying balance processing rather than on simple table scans, and predicates on TAX_UNIT_ID, ASSIGNMENT_ID, and PAYROLL_ACTION_ID should be supplied wherever possible to limit the action set evaluated. The view is read-only; it exposes no DML and should be treated as a reporting and validation surface only.