ER CTMS 037-011

From Calidus HUB


Aptean Logo.png


EMERGENCY RELEASE - CTMS 11.0


RELNOTE ER037-011


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks
AT_MIS_EXTRACT_HEADER_373655.sql AT Script 1.1 373655 - 3 New system parameter MIS_TAB_DELIMITER exists to use a tab as a delimiter for the MIS extracts. When this parameter is Y, a tab will be used as a delimiter for the MIS extract files.

Assesses a new value for the MIS query to use:

Transactional will use created date and updated date within the date ranges for the MIS report values of 'P_from_date' and 'p_to_date' to select records.

The standard delimiter should be setup as '||'@'||' for conversion to a tab delimiter.

Reference (which is the default value) will use the existing queries.

DATA_I_ADM_SYSTEM_PARAM_373655.sql Data Script 1.1 " " " "
DP_MIS.sql MIS Interface Package 5.6 " " " "


New Parameters
Parameter Name Config Level Setting Value Result
MIS_TAB_DELIMITER SYSTEM Y A tab will be used as the delimiter for the MIS extract files.
MIS_TAB_DELIMITER SYSTEM N The specified delimiter will be used for the MIS extract files.