Search Results qualify_pay_jp_pre_tax

Overview

PAY_JP_GENERIC_UPGRADE_PKG is an Oracle Applications (APPS) PL/SQL package that supports the upgrade and migration of Japanese payroll legislative data within Oracle E-Business Suite. It belongs to the Oracle Payroll (PAY) product family and carries the JP suffix indicating localization for Japanese payroll and statutory tax requirements. The package is classified as VALID in the ETRM registry and is treated as an OTHER-type API, meaning it is not a public, supported extension API but rather an internal utility invoked through Oracle-provided upgrade processes.

Its core business function is to migrate legacy or pre-upgrade payroll structures — particularly pay element links, input values, element entries, run results, and Japanese pre-tax and tax-reduction constructs — into the current data model expected by the upgraded EBS release. This enables customers upgrading from earlier releases or localization patches to preserve existing payroll definitions for Japanese employees without requiring manual re-entry of legislative configuration. The package operates against APPS-owned synonyms and depends only on the STANDARD package from SYS.

Key Procedures and Functions

The package exposes 55 documented programs. They fall into several functional clusters:

• Upgrade control and state: GET_UPGRADE_STATUS, SET_UPGRADE_COMPLETED, GET_BUSINESS_GROUP_ID establish and report whether the Japanese payroll upgrade has run for a given business group, preventing duplicate execution.
• Pre-tax and tax-reduction handling: VALIDATE_PAY_JP_PRE_TAX, QUALIFY_PAY_JP_PRE_TAX, UPGRADE_DISASTER_TAX_REDUCTION, VALIDATE_ITAX_DESCRIPTION, QUALIFY_ITAX_DESCRIPTION, UPGRADE_ITAX_DESCRIPTION, and VALIDATE_CODE_JP_PRE_TAX manage the creation and validation of Japanese pre-tax and itemized tax elements.
• Prior job migration: VALIDATE_PREV_JOB, QUALIFY_PREV_JOB, and UPGRADE_PREV_JOB handle legacy "previous job" payroll data.
• Payroll/element upgrade: INIT_PAY_A, VALIDATE_PAY_A, QUALIFY_PAY_A, and UPGRADE_PAY_A perform initialization, validation, qualification, and the actual upgrade of payroll element structures.
• Entries and link synchronization: SYNC_LINK_INPUT_VALUES, SYNC_ENTRIES_AND_RESULTS, and ENTRIES_OR_RESULTS_EXIST reconcile element link input values with element entries and run results.

The recurring VALIDATE / QUALIFY / UPGRADE naming pattern reflects a staged approach in which records are first checked for validity, then qualified for migration, and finally upgraded.

Tables Accessed

The package reads and writes through APPS synonyms. Key tables include PAY_ELEMENT_LINKS_F, PAY_INPUT_VALUES_F, and PAY_LINK_INPUT_VALUES_F for element link and input value migration; PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, and PAY_ELEMENT_ENTRY_VALUES_S for entry data; PAY_RUN_RESULTS and PAY_ASSIGNMENT_ACTIONS for payroll processing results; PAY_ACTION_INFORMATION and PAY_PAYROLL_ACTIONS for payroll action context; PAY_ELEMENT_TYPES_F for element definitions; PAY_JP_PRE_TAX_OLD as the legacy source for Japanese pre-tax data; PAY_LEGISLATION_RULES for statutory rules; FF_USER_ENTITIES for FastFormula entities; and HR_ORGANIZATION_INFORMATION for business group/organization context.

Usage Notes

PAY_JP_GENERIC_UPGRADE_PKG is not referenced by other packages in the ETRM registry, confirming it is an entry-point utility rather than a shared library. It is typically invoked by Oracle-supplied upgrade drivers, datapatch/AD upgrade scripts, or Japanese localization patch routines during an EBS 12.1.1 to 12.2.2 upgrade or localization update. Because it is classified as OTHER and not a supported public API, custom code should not call it directly; customers should allow Oracle upgrade processes to invoke it automatically. Sites extending Japanese payroll should rely on the supported PAY element APIs instead. Any manual invocation risks inconsistent upgrade state, since SET_UPGRADE_COMPLETED and GET_UPGRADE_STATUS enforce idempotent, single-run behavior per business group.