ER CTMS 041-073: Difference between revisions
No edit summary |
m (Text replacement - "[[Category:{{#var:System}} ER]]↵</noinclude>" to "[[Category:{{#var:System}} ER]]Category:ER CTMS 041 </noinclude>") |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 76: | Line 76: | ||
|Database Script | |Database Script | ||
|1.1 | |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 | |DATA_IMP_DECODE_02108654.sql | ||
| Line 115: | Line 133: | ||
|TRG_EPOD_WEB_SERVICE_AUDIT.sql | |TRG_EPOD_WEB_SERVICE_AUDIT.sql | ||
|Database Trigger | |Database Trigger | ||
|1. | |1.4 | ||
|" | |" | ||
|" | |" | ||
| Line 178: | Line 196: | ||
<noinclude> | <noinclude> | ||
[[Category:{{#var:System}} ER]] | [[Category:{{#var:System}} ER]][[Category:ER CTMS 041]] | ||
</noinclude> | </noinclude> | ||
Latest revision as of 09:57, 14 July 2025
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. |
