Data Conversion Error with DC22175166 Occurs When Applying Updates through PUM 20 (Doc ID 2222849.1)

Last updated on AUGUST 08, 2017

Applies to:

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

Goal

A Data Conversion error was encountered in Change Assistant while applying updates through PUM, Update Image 20. The bug that contains the data conversion is Bug 22175166.

Error message-

error. Stmt #:1703 Error Position:0 Return: 805-ORA-00001: unique constraint
(HRDEV.PS_HR_GSS_RSN_TMP) violated.
Failde SQL stmt: INSERT INTO PS_HR_GSS_RSN_TMP (HR_MSS_CT_NAME, ACTION, EFFT,
...........................................)
Process 135615 ABEND at Stp DC22175166.MAIN.Step02 (SQL) -- RC = 805 (108,
524)
Message Set Number: 108
Message Number: 524
Message Reason: Process 135615 ABENDED at Sep DC22175166.MAIN.Step02 (SQL)
--RC = 805 (108,524)

What should be done about this issue?


 

Solution

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