Results for “non_payroll_payments”
6 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.PAY_AC_EMP_SUM_ACTION_INFO_V is a reporting view in the Oracle E-Business Suite Payroll (PAY) module that consolidates payroll action information into a single, denormalized row per employee summary action context. It presents aggregated monetary amounts drawn from the PAY_ACTION_INFORMATION table and expresses them as named, business-friendly columns such as EARNINGS, SUPPLEMENTAL_EARNINGS, IMPUTED_EARNINGS, PRETAX_DEDUCTIONS, INVOLUNTARY_DEDUCTIONS, VOLUNTARY_DEDUCTIONS, TAXES, TAXABLE_BENEFITS, NON_PAYROLL_PAYMENTS, AFTER_TAX_DEDUCTIONS, and GROSS_EARNINGS. The view is registered in ETRM for release 12.2.2 with owner APPS. Its principal role is to supply the data behind the employee payslip and payment summary presentation layer that appears in self-service and administrative payroll pages, converting stored character-based action information values into numeric aggregates using FND_NUMBER.CANONICAL_TO_NUMBER.
The user's search term "non_payroll_payments" corresponds directly to a column exposed by this view. NON_PAYROLL_PAYMENTS is derived by summing FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION13), and it represents payments made to an employee that are not part of the standard payroll run, such as expense-type or third-party disbursements captured through action information.
Underlying Base Objects
The view is defined over a documented set of base objects and packaged functions. The primary data source is PAY_ACTION_INFORMATION (referenced through its synonym PAY_ACTION_INFORMATION), from which the ACTION_INFORMATION4 through ACTION_INFORMATION14 columns are drawn. Employee identity and business group context come from PER_ASSIGNMENTS_F, joined through PAF.BUSINESS_GROUP_ID. Numeric conversion of the stored character values is performed by the FND_NUMBER package via CANONICAL_TO_NUMBER, which provides locale-independent parsing of numbers. Legislation-sensitive behavior is handled by PAY_US_EMPLOYEE_PAYSLIP_WEB.GET_LEGISLATION_CODE, used to vary the AFTER_TAX_DEDUCTIONS calculation between Canadian and other legislation codes. HR_GENERAL and HR_SECURITY are also listed as referenced base objects, supporting general HR lookups and the security predicates that restrict row visibility to the appropriate assignment and business group.
Because the view aggregates (SUM) over PAY_ACTION_INFORMATION values grouped by ACTION_CONTEXT_ID and ACTION_INFORMATION_CATEGORY, the grain of a returned row is one summary line per action context and information category, with ROW_LABEL populated from ACTION_INFORMATION14.
Key Columns
- ACTION_CONTEXT_ID — Grouping key identifying the summary action context to which the aggregated amounts belong.
- ACTION_INFORMATION_CATEGORY — Category used to classify the summary information rows.
- ROW_LABEL — Human-readable label sourced from ACTION_INFORMATION14 for display on payslips.
- EARNINGS / SUPPLEMENTAL_EARNINGS / IMPUTED_EARNINGS — Summed canonical numbers from ACTION_INFORMATION4, 5, and 6 respectively.
- PRETAX_DEDUCTIONS — Summed value from ACTION_INFORMATION7.
- INVOLUNTARY_DEDUCTIONS / VOLUNTARY_DEDUCTIONS — Summed values from ACTION_INFORMATION8 and 9.
- TAXES — Summed value from ACTION_INFORMATION10.
- TAXABLE_BENEFITS — Summed value from ACTION_INFORMATION11.
- NON_PAYROLL_PAYMENTS — Summed value from ACTION_INFORMATION13; the object of the user's search and the column representing non-payroll disbursements.
- AFTER_TAX_DEDUCTIONS — Derived by DECODE on legislation code; for 'CA' it adds pretax, involuntary, and voluntary deductions, otherwise it adds involuntary and voluntary deductions.
- GROSS_EARNINGS — Computed as the sum of earnings, supplemental earnings, imputed earnings, taxable benefits, and the value from ACTION_INFORMATION12.
Common Use Cases and Queries
This view is typically queried when reporting employee payment summaries, reconciling payslip figures, or extracting non-payroll payment amounts for a given action context or business group. A representative query filtering on the topic of interest is:
SELECT action_context_id, action_information_category, row_label, earnings, supplemental_earnings, imputed_earnings, pretax_deductions, involuntary_deductions, voluntary_deductions, taxes, non_payroll_payments, taxable_benefits, after_tax_deductions, gross_earnings FROM apps.pay_ac_emp_sum_action_info_v WHERE non_payroll_payments <> 0 ORDER BY action_context_id;
A second common pattern joins the context identifier back to the originating assignment and business group through PER_ASSIGNMENTS_F to produce employee-level summaries, applying HR_SECURITY so the query respects the session's security profile. Because all monetary columns are already aggregated and null-protected with NVL(... ,0), downstream reports generally require no further arithmetic except where the caller wishes to recompute gross or net figures. The view is most frequently consumed by payroll self-service pages, statutory reporting extracts, and custom BI Publisher or Oracle Reports layouts that reproduce the payslip breakdown, including the separation of non-payroll payments from ordinary earnings and deductions.