EGL9.2: When Running FSCM Image 14 Configuration By Project Using A Chartfield Relabeled Errors With Failed SQL stmt: UPDATE PS_PC_SUM_FIELDS SET FIELDNAME = :1 WHERE FIELDNAME = :2 (Doc ID 2089077.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
*** Checked for currency 23-May-2017****

Symptoms

On : 9.2 version, ChartField Configuration

The user receives the below error when running the Configuration by Project process on relabeled Chartfield 1, after upgrade to FSCM 9.2 Image 14:

File: /vob/peopletools/src/pssys/rdmupd.cppSQL error. Stmt #: 6131 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PC_SUM_FIELDS) violated
Failed SQL stmt: UPDATE PS_PC_SUM_FIELDS SET FIELDNAME = :1 WHERE FIELDNAME = :2
Unable to rename CHARTFIELD1 chartfield to XXXX. Failed with Error: 1 (9050,62)
Process XXXXX ABENDED at Step FS_CFUPDATE.RENAME.API (PeopleCode) -- RC = ? (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

ERROR
-----------------------
Unable to rename CHARTFIELD1 chartfield to XXXX. Failed with Error: 1 (9050,62)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Navigate to Set Up Financials/ Supply Chain > Common Definitions > Design Chartfields > Configure > Standard Configuration;
  2. Relabel Chartfield 1;
  3. Run the full configuration;
  4. Upgrade to FSCM 9.2;
  5. Run the configuration by project (Navigation path: Set Up Financials/ Supply Chain > Common Definitions > Design Chartfields > Configure > Configuration by Project)

 

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