Search Results executive_flag




Overview
Explore in AI Chat

Overview

APPS.PAY_JP_PRE_ITAX_V2 is a Japanese payroll view within Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes pre-computed withholding income tax (ITAX) results for Japanese payroll assignments, providing a consolidated read model over individual income tax, social insurance premium, and mutual aid contribution data. The view is registered in FND Design Data as PAY.PAY_JP_PRE_ITAX_V2 and carries a status of VALID, with an internal view type. As part of the Oracle HRMS Payroll (PAY) product family, it supports the Japanese localization, where statutory withholding calculations must be performed prior to payroll run finalization. The view is a logical successor to PAY_JP_PRE_ITAX_V1, layering additional derived and prior-period columns rather than replacing the earlier structure. Oracle documentation explicitly designates this object for Oracle Internal Use Only and states that Oracle Corporation does not support direct access to applications data through it except from standard Oracle Applications programs. Because it exposes an EXECUTIVE_FLAG attribute, the view is frequently located by implementers and auditors investigating executive tax treatment, but it remains a diagnostic and reporting artifact rather than a documented integration interface.

Underlying Base Objects

The view is defined over a combination of base tables, synonyms, views, and a PL/SQL package, all owned within the APPS schema. Documented dependencies include FND_NUMBER (PACKAGE), used for numeric conversion and formatting during view evaluation; PAY_ACTION_INTERLOCKS (SYNONYM), which links payroll actions to their interdependencies; PAY_ASSIGNMENT_ACTIONS (SYNONYM), the assignment-level action driver table; PAY_PAYROLL_ACTIONS (SYNONYM), supplying payroll action context; PER_ALL_ASSIGNMENTS_F (SYNONYM), the effective-dated assignment fact table supplying assignment_id, person_id, and business_group_id; and PAY_JP_PRE_TAX (VIEW), which provides the underlying Japanese pre-tax element results. It also references PAY_JP_PRE_ITAX_V1 (VIEW), the preceding version of the same calculation set, from which a portion of the column logic is inherited. This layered design means the V2 view is not a simple projection of a single table but a joining and derivation point that marshals tax, social insurance, and prior-period figures onto the assignment-action grain. PAY_JP_PRE_ITAX_V2 is referenced by the PUBLIC synonym of the same name, indicating that it may be resolved outside the APPS schema, although the Internal Use Only restriction continues to apply.

Key Columns

The view's grain is essentially a payroll assignment action. YEAR, BUSINESS_GROUP_ID, and ITAX_ORGANIZATION_ID establish the statutory and organizational context, with ITAX_ORGANIZATION_ID and ITAX_CATEGORY stored as VARCHAR2(240). ASSIGNMENT_ID, PERSON_ID, ASSIGNMENT_ACTION_ID, ACTION_SEQUENCE, and PERIOD_OF_SERVICE_ID identify the affected assignment and action. EFFECTIVE_DATE and DATE_EARNED carry the effective and earning dates. EXECUTIVE_FLAG is a VARCHAR2 column distinguishing executive from non-executive treatment, the attribute most commonly used to filter the view. ITAX_YEA_CATEGORY provides the year-end adjustment category. Monetary columns include TAXABLE_AMT, ITAX, SI_PREM, and MUTUAL_AID, while PREV_SWOT_TAXABLE_AMT, PREV_SWOT_ITAX, PREV_SWOT_SI_PREM, and PREV_SWOT_MUTUAL_AID preserve prior-period (SWOT) taxable and contribution values. TERM_TAXABLE_AMT and TERM_ITAX hold termination-related amounts.

Common Use Cases and Queries

Typical uses include reconciliation of withholding tax against payroll run results, executive-flag analysis, year-end adjustment (YEA) reporting, and error investigation during the pre-tax calculation stage. A representative query returning executive assignments for a payroll year is:

  • SELECT person_id, assignment_id, itax_category, executive_flag, taxable_amt, itax FROM apps.pay_jp_pre_itax_v2 WHERE business_group_id = :p_bg_id AND year = :p_year AND executive_flag = 'Y';
  • SELECT itax_organization_id, SUM(itax) total_itax, SUM(si_prem) total_si FROM apps.pay_jp_pre_itax_v2 WHERE year = :p_year GROUP BY itax_organization_id;
  • SELECT period_of_service_id, prev_swot_taxable_amt, prev_swot_itax, term_taxable_amt, term_itax FROM apps.pay_jp_pre_itax_v2 WHERE assignment_action_id = :p_action_id;
  • SELECT a.assignment_id, a.itax, b.element_name FROM apps.pay_jp_pre_itax_v2 a, pay_element_types_f b WHERE a.year = :p_year AND ROWNUM < 100;

Given the Internal Use Only designation, any extract should be validated against supported Oracle payroll reports and processes rather than treated as a certified interface.