The Welsh Government has provided more details about how the issue, which affected thousands of households, came about