Search Results pay_run_results_n1




Overview
Explore in AI Chat

Overview

APPS.PAY_JP_SI_BON_PAYMENT_V is a Japan-localized Oracle E-Business Suite payroll reporting view that consolidates Social Insurance (SI) bonus payment information for employees processed through the Japanese payroll legislation. It joins payroll action, assignment action, run result, and assignment data to surface the bonus amounts subject to social insurance calculation, together with organizational identifiers and employee-level insurance numbers. Because it is a view rather than a table, it materializes no data of its own; instead it derives its content at query time from the underlying payroll and HR tables.

In the context of ETRM documentation for releases 12.1.1 and 12.2.2, the view is exposed for reporting and integration purposes. Users searching on ern_kind typically reach this object while investigating earnings classifications tied to bonus payments, since the view aggregates SI-type bonus amounts keyed by payroll action and assignment action. It provides a stable, denormalized projection suitable for downstream extracts, statutory filings, and reconciliation reports.

Underlying Base Objects

The view is owned by APPS and is defined over the following documented base objects:

The view’s driving subquery orders and indexes these objects to aggregate SI-type bonus input values by business group and element configuration.

Key Columns

  • payroll_action_id — identifies the payroll action under which the bonus was processed.
  • assignment_action_id and action_sequence — pinpoint the assignment action and its processing sequence.
  • assignment_id and person_id — identify the employee and the assignment.
  • business_group_id — the business group owning the payroll data.
  • effective_date and date_earned — the processing date and the date the earnings were earned.
  • si_sum_mtd_bon — the month-to-date bonus sum parameter retrieved via PAY_CORE_UTILS.get_parameter.
  • si_org_id — the Social Insurance organization identifier, resolved through PAY_JP_BALANCE_PKG.get_entry_value_number.
  • hi_number and wp_number — the Health Insurance and Welfare Pension numbers, resolved via get_entry_value_char.
  • si_type — the aggregated Social Insurance type, derived from organization name codes such as HI_LOCATION, WP_LOCATION, and WPF_LOCATION.

Common Use Cases and Queries

This view is typically used to report SI-classified bonus payments for a given payroll action or employee, and to reconcile the month-to-date bonus figure against organization and insurance identifiers. A representative query follows:

  • SELECT payroll_action_id, assignment_id, person_id, effective_date, date_earned, si_sum_mtd_bon, si_org_id, hi_number, wp_number, si_type FROM apps.pay_jp_si_bon_payment_v WHERE payroll_action_id = :p_action_id;
  • SELECT person_id, SUM(si_sum_mtd_bon) FROM apps.pay_jp_si_bon_payment_v WHERE business_group_id = :p_bg_id GROUP BY person_id;
  • SELECT assignment_id, si_type, si_org_id FROM apps.pay_jp_si_bon_payment_v WHERE effective_date BETWEEN :p_from AND :p_to;

Because the view relies on packaged functions and legislative parameters, query performance benefits from filtering on payroll_action_id, assignment_id, or business_group_id. Use it in extracts and statutory interfaces rather than for transactional updates.