Results for “reference_number2”

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

Overview

PAY_JP_ITAX_ARCH_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is delivered exclusively for the Japanese localization of the Oracle Payroll (PAY) product. The view surfaces archived Japanese income tax (ITAX) action information recorded against employee assignments, providing a denormalized, read-only presentation of payroll action data that would otherwise require knowledge of the underlying key-flex structure to interpret.

In Oracle Payroll, the PAY_ACTION_INFORMATION table stores action-level data using a generic category and attribute model, in which each row carries an ACTION_INFORMATION_CATEGORY and up to thirty numbered ACTION_INFORMATION1 through ACTION_INFORMATION30 segments. This design supports many localizations and business contexts within a single physical table, but it obscures the semantic meaning of each row. PAY_JP_ITAX_ARCH_V resolves this by restricting the result set to the Japanese income tax archive context and projecting the generic attribute columns, making the archive records accessible directly for reporting, reconciliation, and third-party integrations.

Underlying Base Objects

The view is defined over a single base object, PAY_ACTION_INFORMATION, which is exposed in the APPS schema as a synonym. The view text selects all relevant columns and applies two filters: ACTION_INFORMATION_CATEGORY = 'JP_ITAX_ARCH' and ACTION_CONTEXT_TYPE = 'AAP'. These predicates ensure that only Japanese income tax archive rows associated with the assignment action context are returned. Because the view depends on a single table with no joins, its performance characteristics mirror those of the base table, and it inherits the standard WHO audit columns maintained by the underlying entity.

Key Columns

• ROWID — Pseudo-column exposed by the view for row identification.
• ACTION_INFORMATION_ID — Primary identifier of the source action information record.

The remaining columns fall into three functional groups. The first group provides context and keys: ACTION_CONTEXT_ID, ACTION_CONTEXT_TYPE (fixed to 'AAP'), ASSIGNMENT_ID, PERSON_ID, ASSIGNMENT_ACTION_ID, PAYROLL_ID, and OBJECT_VERSION_NUMBER. These link the archive entry to the employee, assignment, and payroll action run that produced it.

The second group carries the Japanese tax archive payload: EFFECTIVE_DATE, DATE_EARNED, EMPLOYMENT_CATEGORY, ITAX_CATEGORY, ITAX_YEA_CATEGORY, SUBMISSION_REQUIRED_FLAG, and the employer detail fields EMPLOYER_NAME, EMPLOYER_ADDRESS, EMPLOYER_TELEPHONE_NUMBER, and TAX_OFFICE_NUMBER. Reference and sequencing columns such as REFERENCE_NUMBER, REFERENCE_NUMBER1, REFERENCE_NUMBER2, and ACTION_SEQUENCE support document tracking.

The third group holds descriptive text, including DESCRIPTION1 through DESCRIPTION5, FILE_DESCRIPTION1 through FILE_DESCRIPTION5, and their Kanji and Kana variants (DESCRIPTION_KANJI, DESCRIPTION_KANA, FOR_FILE_DESCRIPTION_KANJI, FOR_FILE_DESCRIPTION_KANA). The standard audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, and CREATED_BY are also present.

Common Use Cases and Queries

This view is typically used for Japanese tax reporting, auditing of archived income tax submissions, and extracts destined for external tax filing systems. A representative query retrieving archive entries for a specific assignment is shown below.

• SELECT ACTION_INFORMATION_ID, ASSIGNMENT_ID, PERSON_ID, EFFECTIVE_DATE, ITAX_CATEGORY, TAX_OFFICE_NUMBER FROM PAY_JP_ITAX_ARCH_V WHERE ASSIGNMENT_ID = :p_assignment_id ORDER BY EFFECTIVE_DATE DESC;
• SELECT PAYROLL_ID, COUNT(*) FROM PAY_JP_ITAX_ARCH_V WHERE SUBMISSION_REQUIRED_FLAG = 'Y' GROUP BY PAYROLL_ID;

Because the view is read-only and localized to Japan, it should never be used as a target for DML; maintenance must be performed through the standard payroll action information APIs.