Data Conversion Issue Upg_py90.hcpym01c.step04 Throws Unique Constraint Error

(Doc ID 2392945.1)

Last updated on APRIL 30, 2018

Applies to:

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

Symptoms

On : 9.1 version, HR Upgrade

Data Conversion issue upg_py90.hcpym01c.step04 throws unique constraint error

Currently customer is upgrading the HCM application from 8.9 MP1 to 9.1. FP2 . AS part of Upgrade , customer is getting upg_py90.hcpym01c.step04  unique constraint error.

Following are the errors encountered:

ERROR 1
-------------

PSAESRV.7056 (1) [04/22/18 03:27:18](3) File: e:\pt852-903-r1-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1620 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_HRS_APP_ITEMS) violated

ERROR 2
---------------
PSAESRV.7056 (2) [04/22/18 03:28:49](3) File: e:\pt852-903-r1-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1620 Error Position: 51 Return: 12899 - ORA-12899: value too large for column "SYSADM"."PS_HRS_RES_SECTION"."HRS_RES_SEC_NAME12" (actual: 10, maximum: 3)
Failed SQL stmt:UPDATE PS_HRS_RES_SECTION SET HRS_RES_SEC_NAME12 = 'COMPETENCY' WHERE HRS_RES_SEC_NAME12 = 'COM'

ERROR 3
--------------
 PSAESRV.3728 (1) [04/22/18 03:28:50](3) File: e:\pt852-903-r1-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1620 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_UPG_PCS_VCB_TAO) violated
Failed SQL stmt:INSERT INTO PS_UPG_PCS_VCB_TAO (FDM_HASH , FDM_HASH21) VALUES (:1 ,:2)

Changes

 

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