My Oracle Support Banner

E1: SOLEXP: Cannot insert duplicate key in object F9001- Unable to Rename the Favorites (Doc ID 2232805.1)

Last updated on FEBRUARY 06, 2019

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.


 User is not able to change the title of tasks in favorites which are copied from existing user. When user tries to change the title of tasks in favorites, an exception is thrown.


Also E1root.log has below error message :

JDBJSQLException occured in the SQLPhysicalConnection.insert(): | Vendor code= 2627, SQL state = 23000 | Table or View Name = F9001 | Data Source =Control Tables - Test of PRIMARY KEY constraint 'F9001_PK'. Cannot insert duplicate key in object 'TESTCTL.F9001'. The duplicate key value is (98 , B7332 , B7332 ,545D99D4-2D21-495f-A879-36BCEEDA93F4, 005787e7-af4b-11d3-a276-00104b65be64,20).



(1) User A has few favorites
(2) User A favorites were copied to User B following the steps in Document : 2137548.1


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

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