Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small when loading D records (Defect photos to be created as as associated document) in the inspection loader
Check the product option and any user options DEFDOCCAT. Some upgrades / installs set it to <TO BE DEFINED> which is greater than the 8 characters allowed. Either blank out the product / user option, or set it to a valid document category.