ER CTMS 040-016

From Calidus HUB


Aptean Logo.png


EMERGENCY RELEASE - CTMS 11.0


RELNOTE ER040-016


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks
DATA_ADM_LOG_PROG_NAME_00264620.sql Data Script 1.1 00264620 - 2 Amendments for the web service orders:

1. Writes to EPOD_WEB_SERVICE_AUDIT using an autonomous function

2. Writes to EPOD_WEB_SERVICE_AUDIT at the start with a status of REC for the received message - ACK and NAK will also be stored later

3. Excludes CANCELLED orders from the queries

4. Includes NOWAIT on FOR UPDATE actions and reports locked records when creating and updating orders at all levels, booking manifests, trunk trips, click & collect

5. Commits or rolls back the data for the orders and generates an ACK or a NAK message accordingly

INT_XML_OUT.sql Outbound XML Database Package 5.41 " " " "
DP_WEB_SERVICE_ORD.sql Web Service Orders Database Package 1.28 " " " "