Does anyone know if there's a limit to filtered items when creating a filter (> 100 items)
Hello,
In Payables Command Center(V5) I tried to update a filter that filters on specific suppliers(supplier numbers, segment1) Before my update the filter contained about 90 suppliers and when I added about 10 more suppliers I got an error message while saving the filter. Does anyone know if this is a bug?
Error message:
"Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: ORA-12899: value too large for column "ECC"."ECC_SAVED_SEARCH_TL"."TAGS" (actual: 1003, maximum: 1000) Error Code: 12899 Call: INSERT INTO ECC_SAVED_SEARCH_TL (SEARCH_NAME, SOURCE_LANGUAGE, TAGS, "LANGUAGE", SAVED_SEARCH_ID) VALUES (?, ?, ?, ?, ?) bind => [5 parameters bound]"