EGL: Task 5-5-8 in 9.0 to 9.2 Configuration By Project Fails Task During Step FS_CFUPDATE.RENAME.API (Doc ID 1914078.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

On : Upgrade 9.0 to  9.2 version, ChartField Configuration

Configuration by Project fails with the following error:
ERROR
-----------------------
Process 3038365 resumed after step FS_CFUPDATE.RENAME.AppTable (108,538)
 Message Set Number: 108
 Message Number: 538
 Message Reason: Process 3038365 resumed after step FS_CFUPDATE.RENAME.AppTable (108,538)
File: ........SQL error. Stmt #: 6131 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PTDBFIELD) violated
Failed SQL stmt: UPDATE PS_PTDBFIELD SET FIELDNAME = :1 WHERE FIELDNAME = :2
 Message Set Number: 200
 Message Number: 0
 Message Reason: File:........error. Stmt #: 6131 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PTDBFIELD) violated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Review task : Upgrade Task 5-5-8 Running Configuration by Project fails
2. Run task per instructions.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, unable to complete initial pass.

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