Purchase Order Details Window Generates Error and Deletes All Items While Adding a Duplicate Item (Doc ID 2942064.1)

Last updated on APRIL 13, 2023

Applies to:

Symptoms

When attempting to add duplicate item to the order, the following error occurs.

Error
-----------------------
"A record being inserted is a duplicate of an existing record. Please delete the duplicate record and try again. A duplicate record exists for the current record."

Steps to Reproduce
-----------------------

1. Create Single Location Order
2. Go to Details and Add two items.
3. Click on Actions> Add the first Item again in Order Distribution Screen
4. Note the information popup "The supplier pack size, country of sourcing and unit of purchase will be defaulted because the item or another item from the same item group already exists on the order."
5. Click Ok.
6. Enter the Quantity >Click Ok
7.Note the error "A record being inserted is a duplicate of an existing record. Please delete the duplicate record and try again."
8.Click on Ok and Click on "x" on Add Item screen
9. Note the Error " A record being inserted is a duplicate of an existing record. Please delete the duplicate record and try again.
A duplicate record exists for the current record."

Cause

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