Results for “pay_jp_soe_run_deductions_v”

40 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_JP_SOE_RUN_DEDUCTIONS_V is an APPS-owned database view within the Oracle E-Business Suite Payroll (PAY) product module. Its documented purpose is limited strictly to the Japanese localization, where it supports the Statement of Earnings (SOE) reporting requirements specific to Japanese payroll statutory processing. The view presents a consolidated, report-ready projection of payroll run deduction results, joining payroll run results to element classifications configured in HR_JP_PARAMETERS under the owner code PAYJPSOE. By resolving element classifications against Japanese parameter definitions and linking run result values, the view exposes the deductions that must appear on the Japanese Statement of Earnings, including social insurance premiums, tax deductions, and year-end adjustment amounts. It is most commonly consumed by Japanese localization concurrent programs and SOE-related reports rather than by general payroll processing. Because the view is a read-only projection over base payroll run data, it plays no role in calculations and is therefore safe to query for reporting and reconciliation. The view carries a VALID status in ETRM and is present in both 12.1.1 and 12.2.2 installations that have the Japanese localization applied.

Underlying Base Objects

The view is defined over a combination of synonyms, tables, and views. It references PAY_RUN_RESULTS and PAY_RUN_RESULT_VALUES as the source of payroll run result rows and their numeric results, PAY_ASSIGNMENT_ACTIONS and PAY_PAYROLL_ACTIONS to establish assignment action and payroll action context, and PAY_ELEMENT_TYPES_F and PAY_ELEMENT_TYPES_F_TL to obtain element type definitions and language-translated names. PAY_INPUT_VALUES_F supplies the input value definitions used to filter element inputs by unit of measure. PAY_SUB_CLASSIFICATION_RULES_F is used in a correlated subquery for the year-end adjustment (YEA) classification. HR_JP_PARAMETERS provides the Japanese localization parameter definitions that map classification IDs to specific deduction categories, and HR_LOOKUPS supplies lookup translations. HR_API appears as a referenced package, reflecting the localization's dependency on the HR API layer for parameter access. All base objects are accessed via APPS synonyms, and the view itself is a straightforward read-only construct with no DML capability.

Key Columns

  • ASSIGNMENT_ACTION_ID — Identifier of the assignment action that produced the run result, linking the deduction back to a specific employee payroll action.
  • REPORTING_NAME / ELEMENT_NAME — The element's reporting label, resolved via NVL from the translated element types table so that the SOE displays the localization-appropriate name.
  • RUN_RESULT_ID — Identifier of the payroll run result row from which the value is derived.
  • RESULT_VALUE — The numeric deduction amount, wrapped in NVL(TO_NUMBER(...), 0) so that null results are reported as zero.

The join logic restricts rows to run results with status 'P' or 'PA', associates element types whose classification matches PAYJPSOE parameters such as SAL_SI_PREM_CLASS_ID, BON_DEDUCT_CLASS_ID, TERM_DEDUCT_CLASS_ID, and YEA_CLASS_ID, and applies effective-date and language filters to return only valid, user-language rows.

Common Use Cases and Queries

The primary use case is generating the Japanese Statement of Earnings deduction section, typically within a concurrent program or BI Publisher report. A representative query filters by assignment action or run result range:

  • SELECT assignment_action_id, element_name, run_result_id, result_value FROM apps.pay_jp_soe_run_deductions_v WHERE assignment_action_id = :p_assignment_action_id;
  • SELECT run_result_id, element_name, result_value FROM apps.pay_jp_soe_run_deductions_v WHERE run_result_id IN (SELECT run_result_id FROM apps.pay_run_results WHERE assignment_action_id = :p_aa_id);

Reconciliation analysts also use the view to verify that social insurance premium and tax deduction classifications configured in HR_JP_PARAMETERS are correctly reflected in run results, while support teams query it during SOE troubleshooting to confirm that expected element classifications appear. Query performance is influenced by the effective-date and language predicates, so filtering on assignment action or run result identifiers is recommended.