Task #18365
closedAir - Delivery Order - Production checklist
Description
Deployment Checklist for Air Import Delivery Order Functionality (Master and House)¶
SQL Server (Production)¶
-
Create stored procedure
SP_GetCompanyDetailsByIDon SQL Server production environment.
Oracle Database (Production)¶
Tables¶
-
Create table
MASTER_DELIVERY_ORDER. -
Create table
HOUSE_DELIVERY_ORDER.
Sequences¶
-
Create sequence
MASTER_DO_SEQ. -
Create sequence
SEQ_MDO_REF. -
Create sequence
HOUSE_DO_SEQ. -
Create sequence
SEQ_HDO_REF.
Triggers¶
-
Create trigger
TRIG_MASTER_DO_ID. -
Create trigger
MDO_DATE_TRIG. -
Create trigger
TRIG_HOUSE_DO_ID. -
Create trigger
HDO_DATE_TRIG.
Package¶
- Create PKG_DELIVERY_ORDER package.
Configuration Updates¶
SERVICE_CONFIG Table (Oracle Schema CCS_COMMON)¶
-
Insert SMTP configuration in
SERVICE_CONFIGtable. -
Confirm values:
-
ID:
2 -
SERVICE_NAME:
EMAIL_SERVICE -
MODULE:
CCS -
KEY:
SMTP_ADDRESS -
VALUE:
smtp01.maccs.oci.ldn.com -
Provide application package to IT
-
Update Company Name & Address on MaccsPortal
GitLab Sync Log
[{"id": "25329", "author": "Jeremy Roussel", "hours": 0.5, "created": "2025-06-19T07:51:18.634Z", "log_date": "2025-06-19", "comment": "Imported from GitLab by @Jeremy Roussel on 2025-06-19T07:51:18.634Z: 30m-(0.5)h spend at: 2025-06-19", "status": "active", "deleted_by": "", "redmine_entry_id": 9691}, {"id": "25658", "author": "Jeremy Roussel", "hours": 3.0, "created": "2025-06-24T10:00:31.584Z", "log_date": "2025-06-24", "comment": "Imported from GitLab by @Jeremy Roussel on 2025-06-24T10:00:31.584Z: 3h-(3.0)h spend at: 2025-06-24", "status": "active", "deleted_by": "", "redmine_entry_id": 9738}, {"id": "25657", "author": "Jeremy Roussel", "hours": 1.0, "created": "2025-06-24T10:00:10.124Z", "log_date": "2025-06-23", "comment": "Imported from GitLab by @Jeremy Roussel on 2025-06-24T10:00:10.124Z: 1h-(1.0)h spend at: 2025-06-23", "status": "active", "deleted_by": "", "redmine_entry_id": 9739}]