EBStoSCP PurchaseOrderRequisition_PO.csv ERROR DUPLICATE ROWS Rev alpha & Rev numeric — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

EBStoSCP PurchaseOrderRequisition_PO.csv ERROR DUPLICATE ROWS Rev alpha & Rev numeric

edited Jul 1, 2025 10:08PM in Supply Chain Planning and Collaboration 4 comments

Summary:

EBStoSCP collections pulling alpha revision values and numeric revision values in FBDI file PurchaseOrderRequisition_PO.csv for the same PO#/PO line#. This is causing the PO#/Line# to end up in an error log with ERROR TEXT: "Duplicate record is not allowed."

QUESTIONS:

  1. Why did the EBS collection generated two rows with different "REVISION" and "DELETE FLAG"?

Content (please ensure you mask any confidential information):

More than 15 Purchase orders errored out due to duplicate rows in the "PurchaseOrderRequision_PO.csv" file. Note the file contains different alpha values for the "REVISION" column such as A,  B,  C,  D,  E,  F,  G,  H,  J,  K,  L,  M,  N,  P,  S,  T,  V,  W, AF, AU, AY, CY.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!