Search Results assignment_set

Overview

PAY_JP_WL_PACT_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined against the Payroll (PAY) module. It exposes a filtered subset of rows from the PAY_ACTION_INFORMATION table, specifically those records that carry Japanese payroll worklist action context. The view's name and predicate indicate its purpose: it presents "PACT" (Payroll Action) information associated with Japanese statutory reporting and payroll worklist processing. Because it restricts rows to ACTION_CONTEXT_TYPE = 'AAP' and ACTION_INFORMATION_CATEGORY = 'JP_WL_PACT', it functions as a logical convenience layer rather than a broad reporting table.

The view is classified as VALID and is intended for read access by concurrent programs, BI Publisher reports, and custom SQL integrations that need to retrieve payroll action attributes for Japanese legislation without re-implementing the filtering predicate. References to ASSIGNMENT_ID and the derived ASSIGNMENT_SET column make it relevant to assignment-based queries, which is consistent with the search term that led to this object.

Underlying Base Objects

The documented base objects are PAY_ACTION_INFORMATION (accessed through its APPS synonym) and the FND_NUMBER package. PAY_ACTION_INFORMATION is the core Payroll table that stores flexible, categorized action metadata across many payroll contexts. Each row is keyed by ACTION_INFORMATION_ID and qualified by ACTION_CONTEXT_ID and ACTION_CONTEXT_TYPE. The view applies a fixed combination of context type 'AAP' and category 'JP_WL_PACT' to isolate Japanese worklist payroll actions.

FND_NUMBER is referenced for its CANONICAL_TO_NUMBER function, which converts canonical (textual) numeric values stored in the generic ACTION_INFORMATION3 and ACTION_INFORMATION4 columns into true numeric values. This conversion is necessary because PAY_ACTION_INFORMATION stores all descriptive values in character columns; consumers of the view receive numeric-typed results for those two positions where appropriate.

Key Columns

The view projects a defined column list that includes both structural identifiers and Japan-specific attributes: ROWID, ACTION_INFORMATION_ID, OBJECT_VERSION_NUMBER, ASSIGNMENT_ID, EFFECTIVE_DATE, ASSIGNMENT_ACTION_ID, ACTION_CONTEXT_TYPE, ACTION_INFORMATION_CATEGORY, SUBJECT_YEAR_MNTH, ARCHIEVE_OPTION, MASTER_PAYROLL_ACTION_ID, PAYROLL_ID, WITHHOLDING_AGENT, ASSIGNMENT_SET, STATUS, MASTER_FLAG, and the standard audit columns LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, and CREATION_DATE.

• ACTION_INFORMATION_ID — primary identifier of the underlying action information row.
• ASSIGNMENT_ID — the assignment to which the payroll action relates; central to assignment-level analysis.
• ASSIGNMENT_SET — the assignment set associated with the action, used to group assignments for payroll and reporting runs.
• SUBJECT_YEAR_MNTH — the statutory target year and month for the Japanese reporting action.
• ARCHIEVE_OPTION — the archiving/reissue option stored for the action.
• MASTER_PAYROLL_ACTION_ID / MASTER_FLAG — identify the master action in a grouped or consolidated processing scenario.
• WITHHOLDING_AGENT / PAYROLL_ID — the tax withholding agent and payroll context for the action.
• STATUS — current processing state of the action.
• OBJECT_VERSION_NUMBER — optimistic locking version for the row.

Common Use Cases and Queries

Typical use cases include auditing Japanese payroll worklist actions, reconciling assignment sets submitted for statutory reporting, and extracting master-versus-child action relationships. A representative query is shown below.

SELECT assignment_id, assignment_set, subject_year_mnth,
       status, master_flag, withholding_agent
  FROM apps.pay_jp_wl_pact_v
 WHERE assignment_set = :p_assignment_set
   AND effective_date BETWEEN :p_start AND :p_end;

Because the view already filters to a single context type and category, no additional category predicate is required. Joins to PAY_ASSIGNMENT_ACTIONS on ASSIGNMENT_ACTION_ID, or to PAY_PAYROLL_ACTIONS on ACTION_CONTEXT_ID, are common when a report must combine these action attributes with payroll run details.