EPY: Error Trying to Apply Tax Update 19-D "Running DataMover Import UPD23132576_01_IMP_DMS" Failed
(Doc ID 2612453.1)
Last updated on JUNE 15, 2023
Applies to:
PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and laterInformation 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 |