Search Results pay_ca_soe_dedn_balances_rr_v




Overview
Explore in AI Chat

Overview

The view APPS.PAY_CA_SOE_DEDN_BALANCES_RR_V is a Canadian Payroll (PAY) reporting object that supports the generation of the Statement of Earnings (SOE) — specifically the deduction balances line of that report. It is defined over payroll assignment actions, element classifications, and balance type metadata, and it exposes, for each assignment action, the deduction-relevant balances captured during a payroll run. The name encodes its scope: CA for Canada, SOE for Statement of Earnings, DEDN for deductions, and BALANCES for the balance amounts retrieved.

The view is not a stored table; it is a query layer whose columns are resolved dynamically at runtime against the payroll run. Balance values are pulled through PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE, which reads run and current contexts based on the action type of the assignment action. As a result, the view behaves differently depending on whether the underlying payroll action is a run, quick pay, reversal, or other action type. In Oracle EBS 12.1.1 and 12.2.2 this view is used by the Canadian SOE report and by any downstream integration that requires a consolidated, per-assignment projection of deduction balances.

Underlying Base Objects

The view joins the following documented objects:

Key Columns

  • ASSIGNMENT_ID / ASSIGNMENT_ACTION_ID — the assignment and its action instance, forming the primary context for each row.
  • TAX_UNIT_ID — the tax unit under which the balance is evaluated.
  • ELEMENT_TYPE_ID / CLASSIFICATION_ID / CLASSIFICATION_NAME — the element and its classification (for example, deduction categories).
  • REPORTING_NAME / BASE_REPORTING_NAME — the reporting label and the underlying element reporting name.
  • SOE short name — the decoded value from the CA_SOE_SHORT_NAME lookup, falling back to the reporting name when no lookup entry exists.
  • DECODE_BALANCE — the human-readable balance name derived from the balance type ID.
  • PROCESSING_PRIORITY — the element processing priority, used for ordering.
  • Balance value — the numeric result produced by CALL_CA_BALANCE_GET_VALUE, selected by action type: run or current context.

Common Use Cases and Queries

The view is typically queried to reproduce or audit SOE deduction balances for a given assignment action, payroll run, or tax unit. A representative query:

  • SELECT assignment_action_id, assignment_id, classification_name, reporting_name, processing_priority FROM apps.pay_ca_soe_dedn_balances_rr_v WHERE assignment_action_id = :action_id ORDER BY processing_priority;
  • Filter by tax unit: AND tax_unit_id = :tax_unit_id.
  • Join to PAY_ASSIGNMENT_ACTIONS and PAY_PAYROLL_ACTIONS to constrain by payroll run or action type.

Because balance resolution depends on PAY_CA_BALANCE_VIEW_PKG session variables, the view should be queried within the context the SOE report establishes; calling it in isolation may return null or unexpected values when REPORT_LEVEL or JURISDICTION_CODE are unset. This view is a read-only reporting object and should never be used to post or modify payroll data.