HCM 9.1 Bundle 5: Error Running RS854244_02.dms: "ORA-00904: "STR_REPLACE", invalid identifier Failed SQL stmt UPDATE PS_HRS_APP_NID" (Doc ID 2064858.1)

Last updated on OCTOBER 11, 2015

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

HCM HRMS 9.1
Applying Bundle 5

Error when running the rs854244_02.dms data mover script

Error:
ORA-00904: "STR_REPLACE", invalid identifier Failed SQL stmt UPDATE PS_HRS_APP_NID
set NATIONAL_ID = str_replace (NATIONAL_ID,",Null) where NATIONAL_ID like '%%'.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms