My Oracle Support Banner

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 later
Information 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


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