EGL 9.2: Chartfield Configuration Errors With Unique Constraint on EMDBO.PS_PSPNFIELD

(Doc ID 2338074.1)

Last updated on JANUARY 02, 2018

Applies to:

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

Symptoms

ISSUE
---------------
When running the Standard chartfield configuration process as part of upgrade to 9.2, the process errors with unique constraint on EMDBO.PS_PSPNFIELD. After restarting chartfield configuration it goes to success, but when you try to pull  up these pages in App Designer you get an error:
  
CA_DETAIL_PROJ
GM_AWARDS_PER_PROJ
WM_PM_SCHD_WKBC
GM_PROPOSAL_PROJ
PPK_COST_DEPT_SUM
PPK_COST_SUMMARY

 
ERRORS
---------------

Message Log from Running Chartfield Configuration: Stmt # 1685 Error Position: 0 Return: 805 ORA-00001: unique constraint (EMDBO.PS_PSPNLFIELD) violasted Failed SQL Stmt:

Error in App Designer: "Control Creation failed for Page field.(15,63)" .

STEPS
---------------
The issue can be reproduced with the following steps:
1. Re-order fields and then run standard chartfield configuration (It goes to error)

2. Restart chartfield configuration

3. When chartfield configuration goes to success, pull up any of these pages in App Designer and receive an error.

CA_DETAIL_PROJ
GM_AWARDS_PER_PROJ
WM_PM_SCHD_WKBC
GM_PROPOSAL_PROJ
PPK_COST_DEPT_SUM
PPK_COST_SUMMARY


See attachment below for replication screenshots.

Changes

 

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