UPG_HC90.HCHCL117.Step02 Failed During HCM 9.0 to 9.2 Upgrade (Doc ID 2009992.1)

Last updated on APRIL 06, 2017

Applies to:

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

Symptoms

When upgrading HCM 9.0 to 9.2 image 9, data conversion UPG_HC90.HCHCL117.Step02 failes and the following error occurs.

ERROR

The data type, length or value of the argument for the parameter in position "2" of routine "TIMESTAMP" is incorrect. Parameter name: "TIMESTAMP". SQLSTATE = 42815 (SQLSTTE 42815) -171. Failed SQL Stmt: INSERT INTO PS_PER_POI_TYPE (EMPLID, POI_TYPE, LAST_CHILD_UPDDTM, LASTUPDDTTM, LASTUPDOPRID) SELECT EMPLID, POI_TYPE, (TIMESTAMP(LAST_CHILD_UPDDTM,('00.00.00'))) + (0) MINUTES, LASTUPDDTTM, LASTUPDOPRID FROM PS_UPGPER_POI_TYPE WHERE LAST_CHILD_UPDDTM IS NOT NULL

Process 279330 ABENDED at Step UPD_HC90.HCHCL117.Step02 (SQL) -- RC = 8601 (108,524)


STEPS

The issue can be reproduced at will with the following steps:
1. Upgrade HCM 9.0 to 9.2.
2. Run data conversion.

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