E1: 46: 49: Error JDB3400009 - Failed to perform Insert for F4615 When Updating Transportation Sales Order through P4210 Sales Order Entry
(Doc ID 2601768.1)
Last updated on OCTOBER 21, 2019
Applies to:JD Edwards EnterpriseOne Warehouse Management - Version 9.0 and later
JD Edwards EnterpriseOne Transportation Management - Version 9.0 and later
Information in this document applies to any platform.
When an user makes a change to a Transportation sales order in P4210/P42101 and saves the order they receive a Commit failed error "Transaction can not be committed. It has been cancelled." If the user then goes into the order again it is reserved by the user.
The JDE.log seems to indicate that it fails to update the F4615 table due to a duplicate key and shows the following errors.
ODB0000164 - STMT:00  [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'F4615_PK'. Cannot insert duplicate key in object 'PRODDTA.F4615'. The duplicate key value is (1.78822e+006).
ODB0000164 - STMT:01  [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.
JDB9900401 - Failed to execute db request
JDB3400009 - Failed to perform Insert for F4615
JDB9901232 - Canceling transaction because: TC052 InsertTable: Insert failed
Once the error occurs the first time for one user several other people across different branches all get the same error when editing other orders. This seems to last for about 10 minutes, then everything clears up by itself. The errors are intermittent but have happened several times in the last 2 weeks.
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