EGL 9.2: Upgrade Conversion Failed Due To Return: 805 - ORA-00001: unique constraint (SYSADM.PS_GL_INCR_STATUS) violated (Doc ID 2276548.1)

Last updated on JUNE 14, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE STATEMENT
---------------
Error when upgrading from Finance 9.1, PT8.52.06 to Fin9.2, PUM 19 PT8.55.05 Data Conversion Step
 
ERROR
---------------
PSAESRV started service request at 12.32.11 2017-05-31


'PTIADATACONV' RunID: 1 ThreadID: 1 started at 2017-05-31-12.32.11.000000 (274,2)

File: e:\pt85505y-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_GL_INCR_STATUS) violated
Failed SQL stmt: INSERT INTO PS_GL_INCR_STATUS (PROCESS_ID, BUSINESS_UNIT, LEDGER_GROUP, LEDGER, FISCAL_YEAR, FISCAL_YEAR_TO, PROCESS_GROUP, CURR_STEP, ASOFDATE, ACCOUNTING_PERIOD, DETAIL_LEDGER, DETPER_FROM, DETPER_TO, ADJ_PER_FROM, ADJ_PER_TO, PERIOD_OPTN, DTTM_STAMP_SEC, IN_PROCESS) SELECT 'SUML', S.BUSINESS_UNIT, ' ', S.LEDGER, S.FISCAL_YEAR, S.FISCAL_YEAR, ' ', ' ', NULL, S.ACCOUNTING_PERIOD, S.DETAIL_LEDGER, S.DETPER_FROM, S.DETPER_TO, 0, 0, '1', S.DTTM_STAMP_SEC, 'N' FROM PS_SUMLED_STATUS S

Process 8275626 ABENDED at Step UPG_GL.GLA02.InsData (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 12.32.16 2017-05-31


STEPS
---------------
1. Upgrade to 9.2 Image 19 PT 8.55.05 -- data conversion step


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