Search Results base_reporting_name




Overview
Explore in AI Chat

Overview

APPS.PAY_CA_SOE_DEDN_BALANCES_RR_V is a read-only database view in the Oracle E-Business Suite Applications (APPS) schema. It is classified by Oracle as a supplementary view intended to simplify forms coding, and the documentation explicitly warns that querying or altering data through this view is not recommended, as its definition may change substantially in subsequent minor or major releases. Accordingly, the view should be treated as an internal, non-public interface rather than a supported reporting or integration object.

The object belongs to the Canadian payroll Statement of Earnings (SOE) functionality, indicated by the CA segment in its name and its dependency on PAY_CA_BALANCE_PKG and PAY_CA_BALANCE_VIEW_PKG. Its purpose is to expose deduction-related balance values calculated for an assignment, combined with element classification and reporting-name attributes, so that the forms layer can retrieve pre-shaped data without constructing the underlying joins itself. Because it is not referenced by any other database object, it functions purely as a terminal presentation view.

Underlying Base Objects

The view is defined over a combination of payroll base tables, translations, and PL/SQL packages. The documented dependencies are:

These objects are surfaced in the APPS schema largely as synonyms (for example, PAY_ASSIGNMENT_ACTIONS and PAY_RUN_RESULTS) or as packages (PAY_CA_BALANCE_PKG, HR_BALANCES), reflecting the standard EBS layering where APPS code calls into the product-holder schemas.

Key Columns

The view exposes columns that identify the assignment and action, describe the element and balance, and provide deduction amounts across several time frames:

Common Use Cases and Queries

Because Oracle designates this as a forms-support view, direct SQL against it should be limited to diagnostics, troubleshooting, and understanding how the SOE deduction balances are assembled. Typical diagnostics include confirming which deduction balance values exist for a given assignment action, or resolving the reporting label for an element.

To inspect deduction balances for a specific assignment action:

  • SELECT ASSIGNMENT_ID, ELEMENT_NAME, BASE_REPORTING_NAME, DEDN_AMT, YTD_VALUE FROM APPS.PAY_CA_SOE_DEDN_BALANCES_RR_V WHERE ASSIGNMENT_ACTION_ID = :p_action_id;

To resolve reporting names and classifications for deduction elements:

  • SELECT DISTINCT ELEMENT_TYPE_ID, CLASSIFICATION_NAME, REPORTING_NAME, BASE_REPORTING_NAME FROM APPS.PAY_CA_SOE_DEDN_BALANCES_RR_V ORDER BY CLASSIFICATION_NAME;

For supported reporting, extend the underlying base tables (PAY_RUN_RESULTS, PAY_ELEMENT_TYPES_F, HR_BALANCES) or use the Canadian payroll SOE concurrent reports instead of querying this view directly, given Oracle's explicit caution about its stability.