E1: 42: Ship Confirm (P4205) is Failing when Processing a Transfer Order (ST/OT) Due to a Duplicate Key Error Attempting to Insert to the Receipts Unedited Transaction Table (F43121Z1)
(Doc ID 2818277.1)
Last updated on NOVEMBER 02, 2021
Applies to:JD Edwards EnterpriseOne Sales Order Management - Version 9.1 to 9.2 [Release 9.1 to 9.2]
Information in this document applies to any platform.
The customer is attempting to ship confirm a transfer order. The customer is processing multiple orders at the same time. Ship confirm is failing with an error indicating a duplicate key error, Violation of PRIMARY KEY constraint 'F43121Z1_PK'. Cannot insert duplicate key in object 'PRODDTA.F43121Z1'
The customer is also using receipt routing during ship confirmation.
Violation of PRIMARY KEY constraint 'F43121Z1_PK'. Cannot insert duplicate key in object 'PRODDTA.F43121Z1'.
The issue can be reproduced at will with the following steps:
- In Sales Order Entry (P4210) create a transfer order, ST/OT.
- In Ship Confirm (P4205), ship confirm the ST order along with other ST/OT orders.
- The duplicate key error is displayed.
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