Summary
While uploading a CSV file on the supplier in the Serialized Logistics application, the logic checks whether the data in the CSV file is valid and consistent. If the application detects an error, it displays an error message. If mutliple entries are impacted, the error message may contain multiple errors.
Symptoms
The following table summarizes the errors that can occur during a CSV file upload on the supplier in the Serialized Logistics application.
| Error message | Description |
|---|---|
| "GTIN" length must be 14 characters long | A GTIN is not 14-digit long. |
| Invalid check digit <GTIN> | For the displayed GTIN, the last digit (check digit) is invalid. |
| "1st Aggregation Level" length must be 18 characters long | An SSCC at the first aggregation level is not 18-digit long. |
| "2nd Aggregation Level" length must be 18 characters long | An SSCC at the second aggregation level is not 18-digit long. |
| Invalid check digit <SSCC> | For the displayed SSCC, the last digit (check digit) is invalid. |
| "Expiry Date" length must be 10 characters long | The expiry date is not given in the YYYY-MM-DD format. |
| "Manufacturing Date" length must be 10 characters long | The manufacturing date is not given in the YYYY-MM-DD format. |
| "1st Aggregation Level" is not allowed to be empty | The second aggregation level is specified without the first aggregation level for an entry. |
| Invalid expiry date YYYY-MM-DD | The given expiry date contains an invalid month or day:
|
| Invalid manufacturing date YYYY-MM-DD | The given manufacturing date contains an invalid month or day:
|
| Invalid GTIN <GTIN> for company prefix <Company Prefix> | There is a mismatch between the GTIN and the company prefix of the GTIN. The GTIN must contain the company prefix, starting from the second digit. |
| Invalid first aggregation level <SSCC> for company prefix <Company Prefix> | There is a mismatch between the SSCC and the company prefix of the SSCC at the first aggregation level. The SSCC must contain the company prefix, starting from the second digit. |
| Invalid second aggregation level <SSCC> for company prefix <Company Prefix> | There is a mismatch between the SSCC and the company prefix of the SSCC at the second aggregation level. The SSCC must contain the company prefix, starting from the second digit. |
| Inconsistent batch expiry GTIN: <GTIN>, Batch: <Batch>, Expiry: <YYYY-MM-DD> | Multiple expiry dates are specified for the same batch and GTIN in multiple entries. Inconsistent batch expiry dates. The displayed expiry date is different from the expiry date in previous entries. |
| Duplicate item (GTIN <GTIN>, serial <Serial Number>) | The same GTIN and serial number appear in multiple entries. |
| Cycles in aggregation levels child <SSCC> parent <SSCC> | In one entry, SSCC A is the parent of SSCC B, while in another entry, SSCC A is the child of SSCC B. |
| Aggregation inconsistency (same child <SSCC> under multiple parents) | In one entry, SSCC A belongs to parent SSCC B, while in another entry, SSCC A belongs to parent SSCC C. |
Resolution
1. Understand the issue based on the description in the table
2. Find the entries causing the error.
3. Correct the CSV file.
4. Re-try the upload.
