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 SEPTEMBER 26, 2022
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 |