Task #19566
Updated by Redmine Admin 5 months ago
Refer to Mail: [FW\_ ERROR MESSAGE RECEIVED ON MACCS.eml](/uploads/c8429869a925745b2245ddd8564e94a5/FW__ERROR_MESSAGE_RECEIVED_ON_MACCS.eml) RCA: Error pointing poiting towards OCI, which partly generated as NULL OCI Refer to FNA received: =HEADER\ RCV,2026/02/28 05:55\ =PRIORITY\ QN\ =DESTINATION TYPE B\ STX,MRUCSXH\ =ORIGIN\ QVIBGAF\ =MSGID\ 280555\ =TEXT\ FNA/1\ ACK/ERROR..AT LEAST ONE FIELD OF FHLMESSAGE.HOUSEWAYBILLS .OTHERCUS\ /TOMSSECURITYANDREGULATORYCONTROLINFORMATION.DETAILS .ISOCOUNTRYC\ /ODE FHLMESSAGE.HOUSEWAYBILLS .OTHERCUSTOMSSECURITYANDREGULATORYC\ /ONTROLINFORMATION.DETAILS .INFORMATIONIDENTIFIER FHLMESSAGE.HOUS\ /EWAYBILLS .OTHERCUSTOMSSECURITYANDREGULATORYCONTROLINFORMATION.D\ /ETAILS .CUSTOMSSECURITYANDREGULATORYCONTROLINFORMATIONIDENTIFIER\ / SHOULD BE PRESENT FOR CONDITION XFZB DETAIL 4 CIMP AT LEAST ONE\ / FIELD PRESENT OTHER CUSTOMS INFORMATION AT FHLMESSAGE.HOUSEWAYBI\ /LLS 0 .OTHERCUSTOMSSECURITYANDREGULATORYCONTROLINFORMATION.DETAIL\ /S 1 .CUSTOMSSECURITYANDREGULATORYCONTROLINFORMATIONIDENTIFIER\ /ERROR..AT LEAST ONE FIELD OF FHLMESSAGE.HOUSEWAYBILLS .OTHERCUS\ /TOMSSECURITYANDREGULATORYCONTROLINFORMATION.DETAILS .ISOCOUNTRYC\ /ODE FHLMESSAGE.HOUSEWAYBILLS .OTHERCUSTOMSSECURITYANDREGULATORYC\ /ONTROLINFORMATION.DETAILS .INFORMATIONIDENTIFIER FHLMESSAGE.HOUS\ /EWAYBILLS .OTHERCUSTOMSSECURITYANDREGULATORYCONTROLINFORMATION.D\ /ETAILS .CUSTOMSSECURITYANDREGULATORYCONTROLINFORMATIONIDENTIFIER\ / SHOULD BE PRESENT FOR CONDITION XFZB DETAIL 4 CIMP AT LEAST ONE\ / FIELD PRESENT OTHER CUSTOMS INFORMATION AT FHLMESSAGE.HOUSEWAYBI\ /LLS 0 .OTHERCUSTOMSSECURITYANDREGULATORYCONTROLINFORMATION.DETAIL\ /S 1 .INFORMATIONIDENTIFIER\ /ERROR..AT LEAST ONE FIELD OF FHLMESSAGE.HOUSEWAYBILLS .OTHERCUS\ /TOMSSECURITYANDREGULATORYCONTROLINFORMATION.DETAILS .ISOCOUNTRYC\ /ODE FHLMESSAGE.HOUSEWAYBILLS .OTHERCUSTOMSSECURITYANDREGULATORYC\ /ONTROLINFORMATION.DETAILS .INFORMATIONIDENTIFIER FHLMESSAGE.HOUS\ /EWAYBILLS .OTHERCUSTOMSSECURITYANDREGULATORYCONTROLINFORMATION.D\ /ETAILS .CUSTOMSSECURITYANDREGULATORYCONTROLINFORMATIONIDENTIFIER\ / SHOULD BE PRESENT FOR CONDITION XFZB DETAIL 4 CIMP AT LEAST ONE\ / FIELD PRESENT OTHER CUSTOMS INFORMATION AT FHLMESSAGE.HOUSEWAYBI\ /LLS 0 .OTHERCUSTOMSSECURITYANDREGULATORYCONTROLINFORMATION.DETAIL\ /S 1 .ISOCOUNTRYCODE\ /ERROR..AT LEAST ONE FIELD OF FHLMESSAGE.HOUSEWAYBILLS .OTHERCUS\ /TOMSSECURITYANDREGULATORYCONTROLINFORMATION.DETAILS .ISOCOUNTRYC\ /ODE FHLMESSAGE.HOUSEWAYBILLS .OTHERCUSTOMSSECURITYANDREGULATORYC\ /ONTROLINFORMATION.DETAILS .INFORMATIONIDENTIFIER FHLMESSAGE.HOUS\ /EWAYBILLS .OTHERCUSTOMSSECURITYANDREGULATORYCONTROLINFORMATION.D\ /ETAILS .CUSTOMSSECURITYANDREGULATORYCONTROLINFORMATIONIDENTIFIER\ / SHOULD BE PRESENT FOR CONDITION XFZB DETAIL 4 CIMP AT LEAST ONE\ / FIELD PRESENT OTHER CUSTOMS INFORMATION AT FHLMESSAGE.HOUSEWAYBI\ /LLS 0 .OTHERCUSTOMSSECURITYANDREGULATORYCONTROLINFORMATION.DETAIL\ /S 2 .CUSTOMSSECURITYANDREGULATORYCONTROLINFORMATIONIDENTIFIER\ /ERROR..AT LEAST ONE FIELD OF FHLMESSAGE.HOUSEWAYBILLS .OTHERCUS\ /TOMSSECURITYANDREGULATORYCONTROLINFORMATION.DETAILS .ISOCOUNTRYC\ /ODE FHLMESSAGE.HOUSEWAYBILLS .OTHERCUSTOMSSECURITYANDREGULATORYC\ /ONTROLINFORMATION.DETAILS .INFORMATIONIDENTIFIER FHLMESSAGE.HOUS\ /EWAYBILLS .OTHERCUSTOMSSECURITYANDREGULATORYCONTROLINFORMATION.D\ /ETAILS .CUSTOMSSECURITYANDREGULATORYCONTROLINFORMATIONIDENTIFIER\ / SHOULD BE PRESENT FOR CONDITION XFZB DETAIL 4 CIMP AT LEAST ONE\ / FIELD PRESENT OTHER CUSTOMS INFORMATION AT FHLMESSAGE.HOUSEWAYBI\ /LLS 0 .OTHERCUSTOMSSECURITYANDREGULATORYCONTROLINFORMATION.DETAIL\ /S 2 .INFORMATIONIDENTIFIER\ /ERROR..AT LEAST ONE FIELD OF FHLMESSAGE.HOUSEWAYBILLS .OTHERCUS\ /TOMSSECURITYANDREGULATORYCONTROLINFORMATION.DETAILS .ISOCOUNTRYC\ /ODE FHLMESSAGE.HOUSEWAYBILLS .OTHERCUSTOMSSECURITYANDREGULATORYC\ /ONTROLINFORMATION Solution: To fix SP fetching OCI info and ignore nulls. Ref: Efreight.dbo.SP_GenerateFHL