Search Results pay_jp_itax_other2_v2




Overview
Explore in AI Chat

Overview

PAY_JP_ITAX_OTHER2_V2 is an APPS-owned database view within the Oracle E-Business Suite Payroll (PAY) product. As documented in the ETRM metadata, its stated purpose is to support the Japanese localization only. The view presents a filtered, denormalized projection of payroll action information records that belong specifically to the JP_ITAX_OTHER2 action information category, restricted to the context type 'AAP'. In Oracle EBS 12.1.1 and 12.2.2, such localization views act as reporting and integration surfaces, allowing concurrent programs, extracts, and downstream interfaces to consume Japanese withholding tax and other statutory deduction data without directly navigating the wide PAY_ACTION_INFORMATION table.

The view is recorded with a status of VALID in the APPS schema. It does not store data of its own; it is a query-layer definition whose rows are materialized at runtime from the underlying payroll action information store. This makes it a read-oriented object suited to inquiry, extraction, and reporting workloads rather than transactional DML.

Underlying Base Objects

The documented referenced base objects are FND_NUMBER (a package) and PAY_ACTION_INFORMATION (exposed through a synonym). The view body selects from PAY_ACTION_INFORMATION with two governing predicates: ACTION_CONTEXT_TYPE = 'AAP' and ACTION_INFORMATION_CATEGORY = 'JP_ITAX_OTHER2'. The 'AAP' context type associates the stored rows with an assignment-level action context, and the JP_ITAX_OTHER2 category segregates the Japanese income tax "other" descriptor set from other localization categories.

The FND_NUMBER package is invoked during row projection: the view calls FND_NUMBER.CANONICAL_TO_NUMBER over ACTION_INFORMATION1, converting the canonical text representation stored in the action information column into a numeric value for consumers. The remaining ACTION_INFORMATIONn columns are both individually projected and concatenated in pairs, producing composite descriptive fields used by Japanese payroll reporting.

Key Columns

Common Use Cases and Queries

Typical consumers include Japanese payroll extraction reports, year-end adjustment (Nenmatsu Chousei) data preparation, and interfaces that feed external statutory reporting. A representative query joins the view to the assignment to obtain current tax descriptors for a population of employees.

  • Reporting: list the Kanji and Kana descriptions stored for a given assignment and effective date, ordered by EFFECTIVE_DATE.
  • Integration: extract numeric values produced by the FND_NUMBER conversion together with the composite concatenated columns for downstream loaders.
  • Validation: confirm that records exist for a given ASSIGNMENT_ID before processing a Japanese withholding run.

Sample SQL: SELECT assignment_id, effective_date, itw_system_desc1_kanji, wtm_system_desc_kana FROM apps.pay_jp_itax_other2_v2 WHERE assignment_id = :p_assignment_id ORDER BY effective_date DESC; Because the view enforces the context type and category predicates internally, callers do not need to reproduce those filter conditions in their own statements.