My Oracle Support Banner

Purchase Order(PO) - Data Conflict error(18,2) When Cancelling a PO Line (Doc ID 2496787.1)

Last updated on JANUARY 15, 2020

Applies to:

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


The user is trying to cancel a PO line and is receiving a Data Conflict error (18,2).

Steps to reproduce the issue:

Under Installation options - Purchasing
Max rows to Retrieve for is set as 2 for Purchase orders and Requisitions

1) Create Requisition with 5 lines
2) Copy/Source to PO
3) Add one time address on PO line 4
4) Save and dispatch PO
5) Cancel PO line 4
6) Try to Save PO
7) Get below Data conflict (18,2) 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.




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

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