Data Being Added Conflicts With Existing Data (18,2) When Saving Requisition (Doc ID 1490329.1)

Last updated on FEBRUARY 06, 2024

Applies to:

Symptoms

Getting Data being added conflicts with existing data (18,2) When Saving requisition.

Environment Setup

1) AWE is enabled for Requisition, Resubmit Workflow for Decrease in Quantity /Price unchecked
2) Change Tracking = S Change Template = STANDARD
3) ALLOW_CHANGE_REQUEST Role Action is assigned to user


Steps to Reproduce the Issue

1) Create a requisition with quantity 200
2) Approve the requisition
3) Quick source requisition
4) Change the quantity to 198
5) Requisition will be in approved status as requisition resubmit workflow is turned off for the increase or decrease in the quantity/price
6) Process the change orders to purchasing
7) Change the quantity again to 200
8) Save the requisition. Requisition will be in pending status as requisition quantity is increased
9) Approve the requisition
10) Run change order  process
11) Change the requisition quantity again to 198
12) Click save and submit


Error Message:

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.

Error Message (2):
Class Record: assumed property LINE_NBR is not a valid field name. (2,274) SRM_REQ.Change.ChangeTrack.OnExecute  Name:PopChgRcd  PCPC:11114  Statement:239
Called from:SRM_REQ.Change.ChangeTrack.OnExecute  Name:compareRcdFlds  Statement:102
Called from:PV_REQ_WRK.PV_SAVE_REQ.SavePreChange  Name:HdrChg  Statement:266
Called from:PV_REQUISITIONS.GBL.SavePreChange  Statement:236

The specified object property is assumed to be a field name, but the field is not found in the current object.

Use the PeopleCode Debugger or a PeopleCode trace to determine the point of the error, and correct the program.

Cause

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