Search Results pay_action_information_n3




Overview
Explore in AI Chat

Overview

APPS.PAY_JP_PRE_TAX is a Japan-localized Oracle Payroll view owned by the APPS schema. It is identified in the ETRM repository by the FND Design Data reference PAY.PAY_JP_PRE_TAX and carries a status of VALID. The view exposes pre-taxation and statutory deduction data calculated for Japanese payroll assignments, including taxable salary and material amounts, health insurance, welfare pension, unemployment insurance, workers' accident insurance, income tax, and local tax components. Because it is a view and not a base table, it presents a consolidated, read-oriented projection of pre-tax results generated during the payroll run.

Oracle explicitly designates this object as Internal Use Only. The ETRM record carries the standard warning that Oracle Corporation does not support direct access to applications data through this object except from standard Oracle Applications programs. In practice this means the view is consumed by seeded payroll processes, localization logic, and Oracle-delivered reports rather than by customer-developed integrations. Its role in reporting and integration is therefore indirect: it feeds Japanese statutory reporting, year-end adjustment processing, and pre-tax aggregation routines that must satisfy Japanese payroll and tax regulations.

Underlying Base Objects

The documented dependency list for this view is deliberately narrow. ETRM records two referenced objects:

  • FND_NUMBER (PACKAGE) — the Oracle Application Object Library numeric conversion utility package, used within the view definition for numeric formatting or conversion operations.
  • PAY_ACTION_INFORMATION (SYNONYM) — a synonym resolving to the underlying Payroll action information storage, which supplies the action and assignment context for the pre-tax rows.

The view's column inventory, however, indicates a much richer derivation: fields such as PRE_TAX_ID (the primary key), ACTION_ID, ASSIGNMENT_ACTION_ID, and ASSIGNMENT_ACTION_ID_PERF tie each row to a specific payroll action and assignment action, which is the standard anchoring pattern for Japanese pre-tax balance storage. The organization columns (HI_ORGANIZATION_ID, WP_ORGANIZATION_ID, WPF_ORGANIZATION_ID, UI_ORGANIZATION_ID, WAI_ORGANIZATION_ID, ITAX_ORGANIZATION_ID, LTAX_ORGANIZATION_ID) reference the statutory bodies and tax authorities associated with each deduction category.

Key Columns

The column set divides into several functional groups:

Employee premiums (EE) represent the employee-borne portion, while employer premiums (ER) represent the company-borne portion; both are required for Japanese statutory filing and cost accounting.

Common Use Cases and Queries

Typical consumption includes validating pre-tax balances for a payroll action, reconciling employee versus employer statutory contributions, and extracting income and local tax figures for year-end adjustment. A representative query is:

  • SELECT pre_tax_id, assignment_action_id, salary_category, taxable_sal_amt, taxable_mat_amt, hi_prem_ee, hi_prem_er, wp_prem_ee, wp_prem_er, itax, itax_adjustment, ltax, ltax_lumpsum FROM apps.pay_jp_pre_tax WHERE assignment_action_id = :p_assignment_action_id;

Because access is unsupported, any such query should be treated as diagnostic only. Production integrations should use supported payroll APIs and Oracle-delivered Japanese localization reports instead of querying PAY_JP_PRE_TAX directly.