EPY: While Installing Tax Update Patch From HCM PUM#30 Script upd20766428_01_IMP.dms fails with Invalid Action Type 'HR_ACTION_TYPE' (Doc ID 2549518.1)

Last updated on JULY 12, 2021

Applies to:

Symptoms

On: PeopleSoft Enterprise Payroll for North America 9.2, Attempting to apply Tax Update 19-B from PI 30.

Change assistant fails on script upd20766428_01_IMP.dms with error.

ERROR
-------------
Database: HRPUMTAX (ENG)
Input file: C:\PSCA\stage\softwareupdateTAX_UPDATE_AB_2019{HR92U030-HRPUMTAX}IP20190528091357\data\upd20766428_01.dat (ENG)
Commit done at end of record
Importing ACTN_REASON_TBL
SQL Error. Error Position: 0 Return: 8010 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'HR_ACTION_TYPE'.
INSERT INTO PS_ACTN_REASON_TBL (ACTION, ACTION_REASON, EFFDT, EFF_STATUS, DESCR, DESCRSHORT, HR_ACTION_TYPE, OBJECTOWNERID, SYSTEM_DATA_FLG, LASTUPDDTTM, LASTUPDOPRID) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)
Error: Unable to insert row 1
Error: SQL execute error for ACTN_REASON_TBL
Ended: Tue May 28 09:31:26 2019
Unsuccessful completion

STEPS to REPRODUCE
-----------------------------
The issue can be reproduced at will with the following steps:
1. Begin applying Tax Update 19-B from PI 30
2. Receive error upon attempting to Import into PS_ACTN_REASON_TBL

Changes

 Customer on an early PUM Image is applying tax update 19-B

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.