Task #19570
openTask #19558: Sprint Planning for 23/03/2026 - 30/03/2026
AIR manifest transmission – CCS integration, status tracking & XML mapping fixes
75%
Description
Scope:
Unified AIR/OCEAN transmission screen (/transmission/manifest) with tab-based layout and MAWB deep-link navigation
- AIR file reference screen: manifest status badge (Not Sent → Awaiting CCS → Approved/Rejected), click-through to transmission screen pre-filtered by MAWB
- JMS consumer (MessageIntegrationService) wired to update ManifestSubmission with CCS customs response fields (customsResponse, customsMessage, jobNumber, approvalDate)
- CDC (application-prod.yml) fix: AIRCCS_IMP.HOUSEMANI_HEADER was missing from prod Debezium table watch list, preventing CCS status updates in production
- LPD XML mapping fixes: volume missing on line of goods (commodity → HAWB → MAWB fallback), bulk cargo ref rejecting - special character (replaced with alpha suffix A/B/C...)
- Flight ccsReference backfill: Liquibase migration to populate null ccsReference on existing flights; FlightHelper updated to always recompute from airline + flight number + departure date
- FlightLegMapper fix: detached entity error on flight creation caused by leg ID being copied from DTO
Impacted modules:
ffa-be (service-impl, dao, integration), ffa-fe (air views, transmission, manifest service), ChangeDataCapture
GitLab Sync Log
[{"id": "40816", "author": "Al-Shad Isaac", "hours": 6.0, "created": "2026-03-24T06:44:28.134Z", "log_date": "2026-03-24", "comment": "Imported from GitLab by @Al-Shad Isaac on 2026-03-24T06:44:28.134Z: 6h-(6.0)h spend at: 2026-03-24", "status": "active", "deleted_by": "", "redmine_entry_id": 12724}, {"id": "40815", "author": "Al-Shad Isaac", "hours": 7.0, "created": "2026-03-24T06:44:21.490Z", "log_date": "2026-03-22", "comment": "Imported from GitLab by @Al-Shad Isaac on 2026-03-24T06:44:21.490Z: 7h-(7.0)h spend at: 2026-03-22", "status": "active", "deleted_by": "", "redmine_entry_id": 12725}, {"id": "40894", "author": "Al-Shad Isaac", "hours": 2.0, "created": "2026-03-24T12:22:39.106Z", "log_date": "2026-03-24", "comment": "Imported from GitLab by @Al-Shad Isaac on 2026-03-24T12:22:39.106Z: 2h-(2.0)h spend at: 2026-03-24", "status": "active", "deleted_by": "", "redmine_entry_id": 12735}, {"id": "40975", "author": "Al-Shad Isaac", "hours": 7.0, "created": "2026-03-25T11:11:20.686Z", "log_date": "2026-03-25", "comment": "Imported from GitLab by @Al-Shad Isaac on 2026-03-25T11:11:20.686Z: 7h-(7.0)h spend at: 2026-03-25", "status": "active", "deleted_by": "", "redmine_entry_id": 12745}, {"id": "41663", "author": "Al-Shad Isaac", "hours": 7.0, "created": "2026-04-08T05:53:48.332Z", "log_date": "2026-04-06", "comment": "Imported from GitLab by @Al-Shad Isaac on 2026-04-08T05:53:48.332Z: 7h-(7.0)h spend at: 2026-04-06", "status": "active", "deleted_by": "", "redmine_entry_id": 12923}, {"id": "41662", "author": "Al-Shad Isaac", "hours": 7.0, "created": "2026-04-08T05:53:38.128Z", "log_date": "2026-04-05", "comment": "Imported from GitLab by @Al-Shad Isaac on 2026-04-08T05:53:38.128Z: 7h-(7.0)h spend at: 2026-04-05", "status": "active", "deleted_by": "", "redmine_entry_id": 12924}]