My Oracle Support Banner

EPY: Error Trying to Apply Tax Update 19-D "Running DataMover Import UPD23132576_01_IMP_DMS" Failed (Doc ID 2612453.1)

Last updated on NOVEMBER 19, 2019

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Tax Updates and Upgrades

When attempting to import a script part of Tax Update 19-D,
the following error occurs.

ERROR
-----------------------
Importing EOAW_PRCS
SQL Error. Error Position: 290 Return: 904 - ORA-00904: "EOAW_PRCS_NOTIFMG": invalid identifier
INSERT INTO PS_EOAW_PRCS (EOAWPRCS_ID, EOAWDEFN_ID, EFFDT, EFF_STATUS, DESCR, EOAWADMIN_ROLENAME, EOAWACT_LINE_LEVEL, EOAWAUTO_APPROVE, EOAWFIELD_LIST_ID, EOAWCRTA_ID, EOAWDEFN_CRTA_ID, EOAW_REQSTR_SW, EOAW_INCL_REQSTR, EOAWDEFN_DEFAULT, EOAWDEFN_PRIORITY, EOAW_CALENDAR, EOAW_PRCS_ERRACT, EOAW_PRCS_NOTIFMG) VALUES (:1, :2, TO_DATE(:3,'YYYY-MM-DD'), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18)
Error: Unable to insert row 1
Error: SQL execute error for EOAW_PRCS

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Applying TU 19-D
2. Importing DMS script UPD23132576_01_IMP_DMS
3. The step  "Running DataMover Import UPD23132576_01_IMP_DMS" Failed

Changes

 

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


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