My Oracle Support Banner

Data Inconsistency Error While Cancelling Line In PO Copied From a Requisition (Doc ID 1643277.1)

Last updated on NOVEMBER 23, 2019

Applies to:

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


On the existing dispatched PO.If we try to copy Requisition into PO and cancel the existing line in the PO(not the new line added while copying requisition)
We get a Data inconsistency error.

By following these steps the issue can be reproduced:

Step One: Create requisition of 6 lines (Line 1,3 have same vendor loc and line 2,4,5,6 have same vendor location)
Step Two: Source the requisition for Purchase order
Step Three: Two purchase orders will be sourced for the requisition as the requisition lines has different vendor locations included in the requisition lines
Step four: Two POs will be created one PO for lines 1&3 and another PO for lines 2, 4, 5 & 6
Step Five: Approve both POs and dispatch the POs
Step Six: Cancel PO (header) for the PO created for lines 1 &3. While cancellation select the option for resourcing the requisition lines.
Step 7 : After cancellation of the PO created for Line 1&3 create a change order on the PO created for lines 2, 4, 5&6. The change order to be carried out is copying the requisition lines 1,3 by using copy requisition functionality on the PO.
The lines copied over will be added as lined 7&8 .After the change order is done Approve and Dispatch the PO
Step 8: Navigate back to the PO and attempt creating a change order this time by cancelling line 4 (Lline 4 is the line two on the PO). While cancelling you will get the date inconsistency error.


Error Message
Data being Added conflicts with existing data (18,2)


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.