EGL92: FS_CFCONFIG Giving Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSPNLFIELD) When Running After Upgrade to FSCM 9.2 (Doc ID 2205541.1)

Last updated on NOVEMBER 18, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 PI 18, Tools 8.55.06, Chartfield Configuration post-9.2 Upgrade

Chartfield Configurator program FS_CFCONFIG is abending with the below error.

ERROR
-----------------------
File: /vob/peopletools/src/pssys/pdmupd.cppSQL error. Stmt #: 1682 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSPNLFIELD) violated Failed SQL stmt: INSERT INTO PSPNLFIELD (PNLNAME, FIELDNUM, PNLFLDID, FIELDTYPE, EDITSIZE, FIELDLEFT , FIELDTOP, FIELDRIGHT, FIELDBOTTOM, EDITLBLLEFT, EDITLBLTOP, EDITLBLRIGHT, EDITLBLBOTTOM, DSPLFORMA T, DSPLFILL, LBLTYPE, LBLLOC, LBLPADSIZE, LABEL_ID, LBLTEXT, FIELDUSE, FIELDUSETMP, DEFERPROC, OCCUR SLEVEL, OCCURSCOUNT1, OCCURSCOUNT2, OCCURSCOUNT3, OCCURSOFFSET1, OCCURSOFFSET2, OCCURSOFFSET3, PNLFI ELDNAME, RECNAME, FIELDNAME, SUBPNLNAME, ONVALUE, OFFVALUE, ASSOCFIELDNUM, FIELDSTYLE, LABELSTYLE, F IELDSIZETYPE, LABELSIZETYPE, PRCSNAME, PRCSTYPE, FORMATFAMILY, DISPFMTNAME, PROMPTFIELD, POPUPMENU,T REECTRLID, TREECTRLTYPE, MULTIRECTREE, NODECOUNT, GRDCOLUMNCOUNT, GRDSHOWCOLHDG, GRDSHOWROWHDG, GRDO

STEPS
-----------------------
1.Navigate to Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Configure > Standard Configuration
2.Enter chartfield sequence and label choices
3.Click the Configure button
4.Run the FS_CFCONFIG program

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