ER CTMS 041-073
EMERGENCY RELEASE - CTMS 11.0
RELNOTE ER041-073
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks |
|---|---|---|---|---|---|---|
| DP_EXPORT_EVENTS.sql | Database package | 5.7 | 00296022 | - | 3 | DP_EXPORT_EVENTS is modified to use two edi_process_triggers AUDIT_STATUS for the status from EVENTS_OUT and AUDIT_METHOD for the storage option.
Then audit the NAK/ACK responses and store them in audit records or text FILE accordingly. DP_CTMS_IMPORT- (import_order and import_customer functions) are modified to use two edi_process_triggers AUDIT_STATUS for the status and AUDIT_METHOD for the storage option. To choose the audit responses as NAK/ACK/NAK,WAK/ALL and store them in audit records or text FILE accordingly. |
| DP_CTMS_IMPORT.sql | Database package | 5.4 | " | " | " | " |
| DATA_EDI_PROCESS_TRIGGERS_296022.sql | Database Trigger | 1.1 | " | " | " | " |
| AT_RES_TRAILER_TYPE_296022.sql | Database Script | 1.1 | " | " | " | " |
| New Parameters | |||
|---|---|---|---|
| Parameter Name | Config Level | Setting Value | Result |
| AUDIT_STATUS | - | ALL | EDI parameter AUDIT_STATUS default value is set to 'ALL' |
| AUDIT_METHOD | - | WS | EDI parameter AUDIT_METHOD default value is set to 'WS' |
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks |
|---|---|---|---|---|---|---|
| DATA_ADM_SYSTEM_PARAM_02108654.sql | Database Script | 1.1 | 02108654 | - | 3 | New email messages for NAK events.
Setup: The new system parameter called 'MSG_NAKS' can be set to 'Y' to trigger email messages for 'NAK' events. The new system parameter called 'MSG_NAKS_EMAIL' can be used to store email addresses for 'NAK' events (delimited by semi-colons). The new system parameter called 'MSG_NAKS_TYPE' to list the types of processes for 'NAK' events (delimited by commas). A new message type called 'NAK_MSG' is present to enable the email messages to be processed for 'NAK' events. A new import decode type called 'MSG_NAK_EVENTS' is available to configure the text for the emails for the type of messages being generated, for example: 'INBOUND' as 'Inbound from EPOD' 'IN_API_ORD' as 'Inbound order from AX' 'IN_API_CUST' as 'Inbound customer from Elucid' 'OUT_API' as 'Outbound to AX' 'OUTBOUND' as 'Outbound to EPOD' |
| DATA_IMP_DECODE_02108654.sql | Database Script | 1.1 | " | " | " | " |
| DATA_1_MSG_EVENT_TYPE_02108654.sql | Database Script | 1.1 | " | " | " | " |
| DATA_2_MSG_TYPE_02108654.sql | Database Script | 1.1 | " | " | " | " |
| DATA_3_MSG_REQ_02108654.sql | Database Script | 1.1 | " | " | " | " |
| TRG_EPOD_WEB_SERVICE_AUDIT.sql | Database Trigger | 1.4 | " | " | " | " |
| MSG_PROCESSING.sql | Message Processing Database Package | 5.73 | " | " | " | " |
| EPOD_WSA.fmx | EPOD Web Service Audit Oracle Form | 1.9 | " | " | " | " |
| New Parameters | |||
|---|---|---|---|
| Parameter Name | Config Level | Setting Value | Result |
| MSG_NAKS | SYSTEM | Y | Triggers the emails for NAK events in the EPOD web service auditing. |
| MSG_NAKS | SYSTEM | N | Does not send an email to a recipient for a message for NAK responses. |
| MSG_NAKS_EMAIL | SYSTEM | Populated | Sends an email to the recipient(s) for a message for NAK responses. |
| MSG_NAKS_EMAIL | SYSTEM | Null | Does not send an email to a recipient for a message for NAK responses. |
| MSG_NAKS_TYPE | SYSTEM | Populated | Lists the type of processes to trigger the emails for NAK events in the EPOD web service auditing. |
| MSG_NAKS_TYPE | SYSTEM | Null | Does not send an email to a recipient for a message for NAK responses. |
