Version No: IFS Cloud

Product/Capability:  IFS Cloud 21.1

Residency:  Cloud

Solution: Issue corrected in versions 21R2 SU16 ,22R1 SU11 , 22R2 SU4,  23R1 EA

Root Cause: The reason for this server error is, there are 5915 characters for values_(index) variable value and this value cannot be assigned to the file_lines_(i_) variable which can hold a maximum of 4000 characters in INTRASTAT_HANDLING_SVC.CREATE_NEW_FILE___ method.

FOR index_ IN 1..count_ LOOP
IF (names_(index_) = 'FILE_CONTENT') THEN
file_lines_(i_) := values_(index_);
new_rec_.file_data := External_File_Utility_API.Pack_To_Blob(file_lines_);
ELSIF (names_(index_) = 'IMPORT_PROGRESS_NO') THEN
new_rec_.import_progress_no := Client_SYS.Attr_Value_To_Number(values_(index_));
ELSIF (names_(index_) = 'EXPORT_PROGRESS_NO') THEN
new_rec_.export_progress_no := Client_SYS.Attr_Value_To_Number(values_(index_));
ELSIF (names_(index_) = 'INFO') THEN
info$_ := values_(index_);
END IF;
END LOOP;