Search Results archive_sequence

Overview

APPS.PAY_JP_ITWB_PACT_V is a seeded Oracle E-Business Suite database view owned by the APPS schema and registered under the FND Design Data identifier PAY.PAY_JP_ITWB_PACT_V. It is classified as an internal view, carrying the standard Oracle warning that it is intended for use only by standard Oracle Applications programs and is not supported for direct customer access. The object's naming convention associates it with the Japanese localization of Oracle Payroll, specifically the Income Tax Withholding Book (ITWB) reporting and payroll action functionality. In practical terms, the view exposes action information records relevant to Japanese payroll processing, presenting a denormalized, query-friendly projection over the underlying payroll action information data. The presence of ITAX_ORG_ID among its columns explains why the view surfaces in searches for that term, as it is the join key linking payroll action records to the applicable income tax organization (tax office) within the Japanese statutory reporting framework.

Underlying Base Objects

The documented dependency information establishes that APPS.PAY_JP_ITWB_PACT_V is defined over two referenced objects: the synonym PAY_ACTION_INFORMATION and the packaged function FND_NUMBER. PAY_ACTION_INFORMATION is the core payroll action information entity, storing contextual attributes attached to a payroll action, keyed principally by ACTION_INFORMATION_ID and PAYROLL_ACTION_ID. The FND_NUMBER reference indicates that one or more columns are generated through a numeric conversion or formatting function supplied by the FND_NUMBER package. The view is, in turn, referenced by PAY_JP_ITWB_ARCHIVE_OPTION_V and PAY_JP_ITWB_ARCHIVE_PKG, which confirms its role as a supporting data source for the Japanese ITWB archive option and archiving processes. This dependency chain shows the view acting as a middle layer between raw action information storage and the higher-level localization reporting logic maintained by Oracle.

Key Columns

• ROW_ID – a ROWID pseudocolumn providing the physical row address of the underlying record.
• ACTION_INFORMATION_ID – primary identifier for the payroll action information record.
• PAYROLL_ACTION_ID – foreign key to the parent payroll action; PAYROLL_ACTION_ID_O carries the preserved original value, typically used in archive scenarios.
• ACTION_CONTEXT_TYPE and ACTION_INFORMATION_CATEGORY – classify the nature and category of the action information, enabling filtering by processing context.
• EFFECTIVE_DATE – the date from which the action information is applicable.
• ITAX_ORG_ID – identifies the income tax organization (tax office) associated with the record; central to Japanese withholding tax reporting.
• STATUS – describes the processing or validity status of the action information.
• ARCHIVE_SEQUENCE – sequencing value supporting archival operations.
• OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY – standard audit columns tracking record versioning and user accountability.

Common Use Cases and Queries

Because the view is internal and seeded, the primary consumers are Oracle's own Japanese payroll localization programs, notably the ITWB archive package and its associated option view. Consultancy and support scenarios that require investigation of payroll action information tied to a specific tax organization may still query the view to reconcile records. A typical diagnostic query retrieves action information for a given tax organization and payroll action:

• Tax office reconciliation: SELECT ACTION_INFORMATION_ID, PAYROLL_ACTION_ID, ITAX_ORG_ID, EFFECTIVE_DATE, STATUS, ACTION_INFORMATION_CATEGORY FROM APPS.PAY_JP_ITWB_PACT_V WHERE ITAX_ORG_ID = :p_org_id ORDER BY EFFECTIVE_DATE;
• Action-level review: SELECT * FROM APPS.PAY_JP_ITWB_PACT_V WHERE PAYROLL_ACTION_ID = :p_action_id;
• Archive auditing: SELECT PAYROLL_ACTION_ID, PAYROLL_ACTION_ID_O, ARCHIVE_SEQUENCE, LAST_UPDATE_DATE FROM APPS.PAY_JP_ITWB_PACT_V WHERE ARCHIVE_SEQUENCE IS NOT NULL ORDER BY ARCHIVE_SEQUENCE;

All access should be treated as read-only and limited to diagnostic purposes, consistent with the Oracle Internal Use Only designation.