Attempts to create or update a purchase record may fail if the record has a value in the Part No./SKU field that contains more than 2 occurrences of any of the following characters appearing within the first 7 characters: \ % _ [ ]
The issue occurs due to a data processing error that can occur when the problematic characters are used within the first 7 characters of a SKU value.
Logging associated with this issue may include the following error message:
String or binary data would be truncated. The statement has been terminated.
This issue affects creating and updating purchase records through any interface, including the web UI, business adapters, and procurement data spreadsheet uploads.
Avoid using more than 2 occurrences of the problematic characters in the first 7 characters of SKU values on purchase records.
There are no plans to address this issue.
Affected components: Business adapters, Purchase management, Web UI
Master issue ID: IOK-929475
Also known as: ITAM-2018
Sep 09, 202202:33 AM - edited Nov 20, 202301:33 PM