EBStoSCP PurchaseOrderRequisition_PO.csv ERROR DUPLICATE ROWS Rev alpha & Rev numeric
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:
- 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.