SQL Error 'ORA-904: "DESCR100": invalid identifier' on Change Assistant Step 'Running DataMover Import UPD26914298_03_IMP_DMS'
(Doc ID 2556943.1)
Last updated on NOVEMBER 26, 2021
Applies to:
PeopleSoft Enterprise HCM Global Payroll Brazil - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
When applying HCM PUM Image 30 to Development environment CA Step: Running DataMover Import UPD26914298_03_IMP_DMS is failing with the following error:
SQL Error. Error Position: 75 Return: 904 - ORA-904: "DESCR100": invalid
identifier
INSERT INTO PS_GPBR_SOC_PRE_CD (GPBR_TAX_CODE, EFFDT, EFF_STATUS, DESCR50,
DESCR100) VALUES (:1, TO_DATE(:2,'YYYY-MM-DD'), :3, :4, :5)
The issue can be reproduced at will with the following steps:
1. Apply Change Package make Dev environment current to PUM Image 30
2. Note step: Running DataMover Import UPD26914298_03_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 |