Results for “pay_jp_wic_assacts_v”

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

Overview

PAY_JP_WIC_ASSACTS_V is an APPS-owned database view within the Oracle E-Business Suite Payroll (PAY) product. Per ETRM documentation, it exists solely to support the Japanese localization ("This view is used for Japanese localization only") and is marked VALID. The view presents assignment action ("ASSACT") records related to Japanese withholding income tax (WIC) processing, exposing the effective, non-superseded assignment action rows for a given assignment, tax organization, and tax year context. Its central purpose is to filter the full set of assignment actions so that downstream Japanese tax reporting and calculation logic sees only the currently relevant row, discarding prior actions that fall within the same fiscal year and belong to the same tax category class.

Because it is a reporting and integration view rather than a base table, it does not store data independently. Instead, it derives everything from its parent view PAY_JP_WIC_ASSACTS_V2 and applies an anti-join predicate to eliminate redundant or superseded actions. This makes it suitable for year-end tax adjustment and withholding statement reporting, where presenting duplicate or stale tax-category actions would corrupt results.

Underlying Base Objects

The documented referenced objects for this view are: FND_DATE (PACKAGE), FND_NUMBER (PACKAGE), and PAY_JP_WIC_ASSACTS_V2 (VIEW). The view text, however, selects exclusively from PAY_JP_WIC_ASSACTS_V2 (aliased WIC), so the substantive data lineage rests on that parent view. FND_DATE and FND_NUMBER are standard Oracle Application Object Library utility packages frequently referenced in the dependency chain of Japanese localization views for date and numeric conversions, though they do not appear directly in the SELECT list.

The filtering logic is expressed through a correlated NOT EXISTS subquery against the same parent view (aliased WIC2). A row from PAY_JP_WIC_ASSACTS_V2 is returned only when no later action (higher ACTION_SEQUENCE) exists for the same ASSIGNMENT_ID and ITAX_ORGANIZATION_ID whose EFFECTIVE_DATE falls before the twelfth month of the current action's fiscal year (ADD_MONTHS(TRUNC(EFFECTIVE_DATE,'YYYY'),12)). The suppression rule excludes a later action when it shares the same tax-category class as the current row—pairing M_KOU/D_KOU, M_OTSU/D_OTSU, and D_HEI—or when that later action carries a valid future YEA category (ITAX_YEA_CATEGORY = '0').

Key Columns

• ASSIGNMENT_ACTION_ID — Primary identifier for the assignment action row.
• ASSIGNMENT_ID — The assignment to which the action belongs; the key used in the suppression join.
• ACTION_SEQUENCE — Ordering sequence of actions; the view keeps the latest qualifying action.
• PAYROLL_ACTION_ID, BUSINESS_GROUP_ID, PAYROLL_ID — Payroll processing context.
• EFFECTIVE_DATE, DATE_EARNED — Effective and earned dates used in fiscal-year windowing.
• ITAX_ORGANIZATION_ID — Withholding tax organization; part of the suppression key.
• SALARY_CATEGORY — Salary classification for the action.
• ITAX_CATEGORY — The income tax category (for example M_KOU, D_KOU, M_OTSU, D_OTSU, D_HEI); central to the duplicate-exclusion predicate and to the user search term "itax_category."
• ITAX_YEA_CATEGORY — Year-end adjustment category; a value of '0' denotes a valid future YEA action, which suppresses the earlier row.
• PERSON_ID, PERIOD_OF_SERVICE_ID, DATE_START — Person and period-of-service attributes.
• LEAVING_REASON, ACTUAL_TERMINATION_DATE, EMPLOYMENT_CATEGORY, LEGISLATIVE_PARAMETERS — Termination, employment, and localization parameter details.

Common Use Cases and Queries

Typical usage involves retrieving the current withholding income tax action for an assignment or set of assignments, filtering by ITAX_CATEGORY, tax organization, or effective date for tax reporting and year-end adjustment. The following illustrates selecting active Japanese withholding assignment actions for a tax organization.

• Report the effective ITAX_CATEGORY for an assignment in a tax year.
• Identify assignments with a specific ITAX_CATEGORY (for example D_KOU or M_OTSU).
• Feed year-end adjustment (YEA) and withholding statement processes with non-duplicated actions.

SELECT assignment_id, assignment_action_id, itax_category, itax_yea_category, effective_date
FROM apps.pay_jp_wic_assacts_v
WHERE itax_organization_id = :p_org_id
  AND effective_date BETWEEN :p_start AND :p_end;