My Oracle Support Banner

EGL9.2: Upgrade Data Conversion Fails At Step UPG_GL.GLA02.InsData With 'ORA-00001: unique constraint' Error (Doc ID 2276548.1)

Last updated on APRIL 23, 2019

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:
-------
Encountered an error in Data Conversion when upgrading to FSCM v9.2 19 or later
 
Error:
------

Return: 805 - ORA-00001: unique constraint (xxxxx.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)


Steps to Replicate:
---------------------
Run Upgrade  data conversion step as after completing prerequisite steps as listed in Change Assistant job


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.