EGL:Upgrade from FSCM 9.1 to 9.2 - Task 6-9-20: Importing Application Data Results to the following error: ORA-00001: unique constraint (SYSADM.PS_DATE_CODE_TBL) violated

(Doc ID 2297875.1)

Last updated on AUGUST 16, 2017

Applies to:

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

Symptoms

Issue:

On upgrading from FSCM 9.1 to 9.2 Image 19 :

Currently on Task 6-9-20: Importing Application Data using the .dat file created by the previous task and getting following error:

     Importing DATE_CODE_TBL
     SQL Error. Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_DATE_CODE_TBL) violated
     INSERT INTO PS_DATE_CODE_TBL (FIELDNAME, DATE_CODE, DESCR, POST_LEDGER, POST_LDG_ADB) VALUES (:1, :2, :3, :4, :5)
     SQL Error. Error Position: 0 Return: 0 -
     Error: SQL unable to commit transaction for DATE_CODE_TBL

When checking against the table in database the values all looked to be in place correctly but still not able to get past this error.

Steps to replicate:

On upgrading from FSCM 9.1 to 9.2 Image 19 (MTP 1)
Task 6-9-20: Importing Application Data using the .dat file created by the previous task

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