Search Results si_prem




Overview
Explore in AI Chat

Overview

APPS.PAY_JP_WIC_ASSACTS_V2 is an Oracle E-Business Suite internal view owned by the APPS schema and registered in the application design data under the FND Design Data reference PAY.PAY_JP_WIC_ASSACTS_V2. It belongs to the Japanese payroll localization layer of Oracle Payroll and presents assignment-level payroll action tax and social insurance results for Workers' Insurance Compensation (WIC / 労災) processing. The view exposes accumulated assessment figures derived from payroll action processing, including taxable amounts, social insurance premiums, mutual aid contributions, income tax, income tax adjustments, disaster tax reductions, and ITAX categorization attributes.

The view is explicitly flagged "Oracle Internal Use Only." Oracle Corporation does not support direct access to applications data through this object except from standard Oracle Applications programs. This restriction matters for support and certification purposes: it is not a customer-facing reporting interface, though it is commonly mined for diagnostic and reconciliation queries. The "V2" suffix indicates a revised generation of the view, layered over an earlier V1 definition.

The user search term "si_prem" maps directly to the SI_PREM column in this view, which carries the social insurance premium amount computed for the assignment action. This is the principal driver for querying the view in a Japanese payroll context.

Underlying Base Objects

According to the documented dependency metadata, the view references the following objects:

  • APPS.PAY_JP_WIC_ASSACTS_V1 (VIEW) — the immediate underlying view from which the V2 definition selects. This is the principal data source.
  • FND_DATE (PACKAGE) — Oracle Application Object Library date utilities, used for date conversion or formatting within the view definition.
  • FND_NUMBER (PACKAGE) — Oracle Application Object Library numeric utilities, used for numeric conversion and formatting.

Objects that reference PAY_JP_WIC_ASSACTS_V2 in turn are APPS.PAY_JP_WIC_ASSACTS_V (VIEW) and APPS.PAY_JP_WIC_PKG (PL/SQL package). The package dependency confirms that the view participates in the official Japanese WIC payload, and that any structural change to the view can invalidate the package.

Key Columns

The view exposes 26 columns. The most significant for Japanese payroll analysis are:

Common Use Cases and Queries

Typical use is reconciliation and analysis of Japanese WIC assessment results for a person or assignment action. A straightforward query filtering on the SI_PREM attribution is shown below. Because the view is unsupported for direct access, such queries should be treated as read-only diagnostics rather than a supported interface.

SELECT assignment_action_id, assignment_id, person_id, effective_date, taxable_amt, si_prem, mutual_aid, itax, itax_adjustment, disaster_tax_reduction FROM apps.pay_jp_wic_assacts_v2 WHERE si_prem IS NOT NULL AND business_group_id = :p_bg_id ORDER BY person_id, effective_date;

Additional scenarios include: (1) reconciling totals between SI_PREM and TA taxable amounts for a payroll period; (2) identifying rows where ITAX_ADJUSTMENT is non-zero to trace retroactive corrections; and (3) verifying the effects of DISASTER_TAX_REDUCTION on final liability. All queries should join to standard payroll views for person and assignment detail rather than relying on the internal identifiers alone.

In summary, PAY_JP_WIC_ASSACTS_V2 is an internal-only Japanese payroll view over PAY_JP_WIC_ASSACTS_V1 that surfaces social insurance premiums (SI_PREM) and associated income tax attributes, and should be referenced only within Oracle-supported program flow.