My Oracle Support Banner

DATA INTEGRITY ERROR WHILE CREATING SOURCING EVENT (18,2) (Doc ID 2473781.1)

Last updated on JULY 15, 2020

Applies to:

PeopleSoft Enterprise SCM Strategic Sourcing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The below Error message shows up when trying to Save event with multiple line items.


"Data being added conflicts with existing data. (18,2)

When adding a new item to the database, the system found a conflicting item already exists.

This problem can happen if another user has entered similar information at the same time as you. Note the changes you have made, cancel the page, then retry your changes.

If the problem persists, it may be because of an application or other programming error and should be reported to technical support staff.

This error occurs when the keys on the record being inserted match a record that is already in the database. The application must ensure that each inserted record has unique keys."



The issue can be reproduced with the following steps:

1.Navigate to Sourcing->Create Events->Event Details. Enter the basic information.
2.Go to Line Items link. Add few line items using Copy from Requisition feature.Save event.Come back to the Event page.
3.Again go line items page, try o delete few lines and add new lines and Click Save Event Changes and receive the error.


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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