My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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