EGL 9.2: Chartfield Configuration Errors With Unique Constraint on EMDBO.PS_PSPNFIELD
(Doc ID 2338074.1)
Last updated on FEBRUARY 01, 2019
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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:
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)" .
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.
See attachment below for replication screenshots.
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