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 OCTOBER 15, 2019
Applies to:
PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |