Error "Data being added conflicts with existing data. (18,2)" When Record Level Audit is Enabled for Material Storage Location Page. (Doc ID 2966806.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

Symptoms

Inventory-Material Storage Locations page is giving below error when record level audit is enabled and same key field information is updated more than once.

Error:
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.

Steps:
1. Enable audit for the record STOR_LOC_INV in the app designer.
2. Create an audit record by copying the above record and add the fields audit_oprid, audit_stamp, audit_actn.
3. Open the Material Storage Location page and update any location
      Inventory--> Maintain Storage Locations--> Material Storage Locations
4. Query the audit record to see that the data change is updated.
5. Try to update the same location and see the above error.

Cause

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