Search Results pay_jp_pre_itax_v1




Overview
Explore in AI Chat

Overview

PAY_JP_PRE_ITAX_V1 is a read-only database view owned by the APPS schema in Oracle E-Business Suite, defined within the PAY (Payroll) product family. It exists specifically to support Japanese statutory payroll reporting, serving as the underlying data source for the concurrent programs PAYJPITT (Income Tax), PAYJPITW, and PAYJPPRS, as well as for associated value sets used within those report parameters. The view consolidates pre-tax declaration data captured against completed payroll and assignment actions, exposing organization-level, salary-category, and income-tax-category attributes required by Japanese tax reporting regulations.

The view operates over action information records associated with the JP_PRE_TAX_1 information category — the Japanese pre-tax declaration DFF context — and restricts output to assignment actions in a completed ('C') status linked to payroll actions of type 'R', 'Q', 'B', or 'I' (Regular, QuickPay, Bonus, and Immediate). Because it is derived entirely from transactional payroll action data rather than configuration tables, the view is refreshed implicitly as payroll runs are completed and their action information is populated.

Underlying Base Objects

The view is defined over four documented base objects:

PAY_ACTION_INTERLOCKS is also documented as a referenced object, typically involved in interlock processing logic associated with action sequencing. The join chain requires matching BUSINESS_GROUP_ID, PAYROLL_ACTION_ID, and effective-date contexts between the three payroll tables.

Key Columns

Common Use Cases and Queries

The primary use case is feeding statutory Japanese income tax reports. The view's built-in NOT EXISTS filter prevents a year-end adjustment assignment action from appearing alongside ordinary payroll actions for the same assignment and tax organization within the same calendar year, ensuring clean report output.

A typical query retrieves tax declaration rows for a period and organization:

  • SELECT assignment_id, itax_organization_id, salary_category, itax_category, itax_yea_category, effective_date FROM pay_jp_pre_itax_v1 WHERE business_group_id = :p_bg_id AND itax_organization_id = :p_org_id AND effective_date BETWEEN :p_start AND :p_end;

Analysts also use it to reconcile which assignments contributed to a tax filing, or to validate that YEA and RE_YEA rows were captured correctly. Because it exposes only completed actions with valid JP_PRE_TAX_1 DFF data, it is a reliable validation source before and after running PAYJPITT, PAYJPITW, and PAYJPPRS.