Inspection Plan ends in error: "A record with this combination of values already exists." (Doc ID 2857189.1)

Last updated on JULY 26, 2022

Applies to:

Symptoms

Facing an Issue while creating an inspection plan, Unable to Approve its Status in while creating a new Inspection plan for given Item and Particular ORG.
While it is Approved for some other ORG.
 

ERROR
-----------------------
A record with this combination of values already exists.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Quality Management
2. Select Create ('+' icon in top right corner) and select Inspection Plan
3. Enter Inspection Plan Details (Name, Type = Receiving, Organization, Item)
4. Enter Specifications
5. Enter Inspection Criteria (Document Type = Purchase Order, Supplier, NOTE: Supplier Site is NOT displayed)
6. Select Save
7. NOTE: Inspection Criteria shows '0' and the line added in Step 5 is not displayed
8. Reattempt to add Inspection Criteria and Save - error is encountered

Cause

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