Search Results pay_jp_wl_yea_info_v

Overview

PAY_JP_WL_YEA_INFO_V is a Japanese localization view owned by the APPS schema in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is part of the PAY (Payroll) product family and is classified as a reporting-oriented, read-only database object with a status of VALID. The view surfaces Year-End Adjustment (YEA) related payroll action information, which is central to Japanese statutory payroll processing, including the annual year-end tax adjustment (Nenmatsu Chousei) and the year-end adjustment workload associated with the Japanese Payroll ("JP WL") module.

The view flattens and exposes data stored in the generic, flexfield-driven action information repository, converting EBS canonical (textual) number storage into numerically interpretable values. Because ACTION_INFORMATION columns in the base table are stored as character strings, the view applies the FND_NUMBER.CANONICAL_TO_NUMBER function to produce consistent numeric output. This makes the view suitable for downstream reporting, extraction, and integration scenarios where YEA figures must be treated as numbers rather than strings.

Underlying Base Objects

The view is defined over two documented base objects:

• PAY_ACTION_INFORMATION (SYNONYM): The primary source of rows and columns. This table stores payroll action information records keyed by ACTION_INFORMATION_ID, with generic ACTION_INFORMATION1 through ACTION_INFORMATIONn columns holding data in canonical form.
• FND_NUMBER (PACKAGE): A public Oracle Application Object Library utility package that supplies the CANONICAL_TO_NUMBER function used to convert the canonical text values of ACTION_INFORMATION1 through ACTION_INFORMATIONn into numeric values.

The view carries forward the identifying and audit columns of the base table, including ROWID, ACTION_INFORMATION_ID, OBJECT_VERSION_NUMBER, ACTION_CONTEXT_ID, ACTION_CONTEXT_TYPE, ASSIGNMENT_ID, EFFECTIVE_DATE, ACTION_INFORMATION_CATEGORY, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, and CREATION_DATE.

Key Columns

• ACTION_INFORMATION_ID: Primary identifier for each action information record.
• ASSIGNMENT_ID: References the assignment (employee/employment) to which the YEA record relates.
• EFFECTIVE_DATE: The date on which the action information row is effective.
• ACTION_INFORMATION_CATEGORY: Classifies the type of action information, distinguishing YEA-related records from other payroll actions.
• ACTION_INFORMATION1 … ACTION_INFORMATIONn: Generic descriptive flexfield segments. In this view they are wrapped with FND_NUMBER.CANONICAL_TO_NUMBER, so they are returned as numeric values representing YEA amounts, counts, or related figures. The specific business meaning of each numbered segment is defined by the Japanese payroll flexfield configuration.
• OBJECT_VERSION_NUMBER, LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN: Standard EBS concurrency and audit columns.

The user search term "net_income" typically maps to one of the YEA amount segments exposed as a numeric ACTION_INFORMATION column, depending on the configuration of the underlying flexfield.

Common Use Cases and Queries

The view supports year-end adjustment reporting, payroll reconciliation, and data extraction into external tax filing or analytics systems. A representative query follows:

• SELECT aia.ACTION_INFORMATION_ID, aia.ASSIGNMENT_ID, aia.EFFECTIVE_DATE, aia.ACTION_INFORMATION_CATEGORY, aia.ACTION_INFORMATION1, aia.ACTION_INFORMATION2 FROM APPS.PAY_JP_WL_YEA_INFO_V aia WHERE aia.EFFECTIVE_DATE BETWEEN :p_start AND :p_end;
• Filter by ASSIGNMENT_ID to isolate an individual's YEA records.
• Filter by ACTION_INFORMATION_CATEGORY to limit results to relevant YEA categories.
• Aggregate numeric ACTION_INFORMATION columns to derive totals such as net income across a population.

Because the view is read-only and defined over the action information repository, it should be queried rather than updated. Any modification must be performed on the underlying PAY_ACTION_INFORMATION data through the supported payroll application interfaces.