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)

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:

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)

Changes

Cause

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