MSSQL FH_HDL_EXTRACT Program Fails With Error (Doc ID 2165362.1)

Last updated on JULY 26, 2016

Applies to:

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

Symptoms

Integration from PS HR 9.1 to Fusion Compensation using FH_HDL_EXTRACT  the program fails with errors

Stmt #: 1620 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]The replace function requires 3 argument(s).
[Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180

Failed SQL stmt:UPDATE PS_FH_LOCATIONVO SET FH_LOCATION_ID = REPLACE(REPLACE(('LOC' + SETID + LOCATION),'-'), ' ') WHERE (1 = 2 OR SETID <> ' ' OR LOCATION <> ' ')

Navigation for submission of the process:


Fusion Integration Toolkit > Extract Process > Send HR Data to Fusion

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