EGL 9.2: Chartfield Configuration Errors With Unique Constraint on EMDBO.PS_PSPNFIELD
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.
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.
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