Search Results report_level




Overview
Explore in AI Chat

Overview

APPS.PAY_CA_FED_ER_V is a Canadian federal payroll reporting view shipped with Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It consolidates assignment-level payroll action data with Canadian statutory balance definitions so that federal employer (ER) and related reporting balances can be presented as discrete period columns. The view is intended for reporting and integration rather than transactional entry; it exposes balances already computed by the Canadian payroll balance engine and shaped into current, run, prior-year, month, quarter-to-date, and period-to-date buckets.

Because the view resolves balance values through PL/SQL packages rather than stored columns, it is best understood as a reporting facade over the Payroll action model. It is commonly consumed by statutory reporting extracts, reconciliation queries, and custom reports that need Canadian federal balance figures without repeatedly invoking the underlying balance APIs.

Underlying Base Objects

The view is defined over a documented set of synonyms spanning the Payroll action and balance definition model, joined to two Canadian balance packages:

Key Columns

The view returns assignment and action identifiers (assignment_id, assignment_action_id, payroll_action_id, tax_unit_id, action_status, action_type, effective_date) alongside balance metadata (base_balance_name, balance_name, reporting_name, business_group_id, legislation_code). The principal reporting columns are CURRENT_VALUE, RUN_VALUE, PYDATE_VALUE, MONTH_VALUE, QTD_VALUE, and PTD_VALUE. Each is produced by pay_ca_balance_pkg.call_ca_balance_get_value using the same assignment action context but a different time dimension. The business_group_id and legislation_code columns are especially relevant to the "business_group" search intent, since they allow results to be filtered or partitioned by business group, and the BUSINESS_GROUP session variable is passed into every balance lookup.

Common Use Cases and Queries

Typical usage filters the view by business group and payroll action to extract Canadian federal balances for a run.

  • Extracting period balances for a single business group:
    SELECT assignment_id, balance_name, qtd_value, ptd_value FROM apps.pay_ca_fed_er_v WHERE business_group_id = :p_bg AND payroll_action_id = :p_action;
  • Reconciling reporting names against base balance names for a tax unit.
  • Feeding downstream statutory reporting extracts that require current, run, and prior-year columns side by side.

Because values are computed dynamically, queries should constrain business_group_id and action identifiers to limit the volume of balance function calls. Filtering on business_group_id also aligns with the view's internal use of the BUSINESS_GROUP session variable, ensuring the returned values match the intended legislative context.