EGL9.2: When Trying To Delete Duplicate Row From Commitment Control / Budget Definitions / Control Chartfiled Page The Error 'Duplicate key value -- not allowed. (15,7)' Occurs And The Row Cannot be Deleted (Doc ID 2947144.1)

Last updated on JULY 18, 2023

Applies to:

Symptoms

Under navigation Commitment Control / Budget Definitions - On ChartField Values Grid there should be a Delete Icon for eliminating unwanted entries.

Replication Steps:

1) Main Menu > Commitment Control > Define Control Budgets > Budget Definitions
Click on Control ChartField TAB
2) On ChartField Values Grid there is no Delete icon whereas for the other Tabs it does exist
3) If add a new row on ChartField Values Grid which is duplicate with an existing one above and try to save it the message is displayed.

4) Press Ok button for the message to disappear
5) And try do delete the row, BUT the "-" Delete icon does not exist on this grid
6) You must go back to Budget Definitions Search Page again

Please see Replication screenshots for more details.

In the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Cause

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