Task #19566: EAWB Issue - Error when generating FHL. - level-3-support - Redmine

Actions

Copy link

Task #19566

open

EAWB Issue - Error when generating FHL.

Added by Redmine Admin 5 months ago. Updated 3 months ago.

Status:

New

Priority:

High

Assignee:

Start date:

03/23/2026

Due date:

03/23/2026 (about 5 months late)

% Done:

Estimated time:

0:00 h

Spent time:

4:00 h

GitLab ID:

4044

GitLab Milestone:

GitLab Ticket Number:

775

GitLab Time Logged:

14400

Lock Timeline Date:

gitlab project trace:

Description

Refer to Mail: FW_ ERROR MESSAGE RECEIVED ON MACCS.eml

RCA: Error pointing towards OCI, which partly generated as NULL

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

GitLab Sync Log

[{"id": "40707", "author": "Nirmal Shibchurn", "hours": 4.0, "created": "2026-03-23T09:36:01.089Z", "log_date": "2026-03-23", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2026-03-23T09:36:01.089Z: 4h-(4.0)h spend at: 2026-03-23", "status": "active", "deleted_by": "", "redmine_entry_id": 12709}]