CTMS 11.0 ER019-081

EMERGENCY RELEASE - CTMS 11.0

RELNOTE ER019-081

Module	Program Name	Ver	Call/Iss	Client Ref	Pr'ty	Remarks	Reporter
AT_SCH_ORD_333194.sql	Alter Table Script	1.1	333194	KH-A6QRC4	3	A new decode name of 'MODULO_43' will need to be setup for the 'REFERENCE' decode type with mapped values. A new import type called 'PROCESS_ITEMS' will need to be setup to process manually the Toyota order files. A new EDI process will need to be setup to process automatically the Toyota order files. The new import type and 'Interface Errors' tab page will need to be authorised for use by the appropriate user groups. The following directory structure will need to be setup to process the files: Delivery Folder: '/webint/{DATABASE}/interface/TOY/IN' Archive Folder: '/webint/{DATABASE}/interface/TOY/IN/archive' Failures Folder: '/webint/{DATABASE}/interface/TOY/IN/failures' New import decodes will need to be setup: TOY_PACK_TYPE for REFERENCE TOY_ASSET_TYPE for DU_TYPE TOY_DEALERSHIP for LOCATION A new EDI process will need to be setup with the following parameters and values: Parameter: DEFAULT_PROD_TYPE_ID as AMBIENT. Report Values: Package Name/PROCESS as DP_TOY_EDI_IN.P_PROCESS_FILES. Process Name/pi_proc_name as TOYOTA_ORDER_ITEMS. The EDI process will be called TOYOTA_ORDER_ITEMS with Customer, Cost Centre Code and Location set as required. Direction will be Inbound and Flow Type will be PROCESS. A new system parameter called INT_ADD_MOD43_CD will need to be setup for the Toyota customer with a value of Y. The import process will be called TOYOTA_ORDER_ITEMS to match the EDI process.	Kate Hunter
CT_INT_ORD_ITEMS_CSV_333194.sql	Create Table Script	1.1	"	"	"	"	"
CT_SEQ_INT_ORD_ITEMS_CSV_333194.sql	Create Table Script	1.1	"	"	"	"	"
DATA_1_IMP_IMPORT_TYPE_333194.sql	Data Script	1.2	"	"	"	"	"
DATA_2_IMP_FIELD_333194.sql	Data Script	1.1	"	"	"	"	"
DATA_ADM_FORM_TAB_333194.sql	Data Script	1.1	"	"	"	"	"
DATA_ADM_LOG_PROG_NAME_333194.sql	Data Script	1.1	"	"	"	"	"
DATA_ADM_SYSTEM_PARAM_333194.sql	Data Script	1.2	"	"	"	"	"
DATA_ADM_SYSTEM_PARAM_CONFIG_333194.sql	Data Script	1.2	"	"	"	"	"
TRG_INT_ORD_ITEMS_CSV_BIU.sql	Trigger	1.1	"	"	"	"	"
IMP.sql	Imports database package	5.126	"	"	"	"	"
DP_TOY_EDI_IN.sql	Inbound EDI database package	1.2	"	"	"	"	"
INT_ERR.fmx	Interface errors oracle form	1.87	"	"	"	"	"

Module	Program Name	Ver	Call/Iss	Client Ref	Pr'ty	Remarks	Reporter
DATA_ADM_SYSTEM_PARAM_333199.sql	Data Script	1.1	333199	KH-A6QRJX	3	A new system parameter called 'WCS_CALC_ITEM_WGT_VOL' should be set to 'Y' for the customer to calculate the weight and volume from the DU type in the 804 scanning message.	Kate Hunter
DATA_ADM_SYSTEM_PARAM_CONFIG_333199.sql	Data Script	1.1	"	"	"	"	"
DP_RDT_AUTO.sql	RDT Database package	5.39	"	"	"	"	"

Module	Program Name	Ver	Call/Iss	Client Ref	Pr'ty	Remarks	Reporter
DATA_1_REP_REPORT_333204.sql	Data Script	1.1	333204	KH-A6QRQK	3	New interface audit extract showing interface records by date/status alongside that according to scanning and delivery.	Kate Hunter
DATA_2_REP_REPORT_PARAM_333204.sql	Data Script	1.1	"	"	"	"	"
DATA_3_REP_PARAM_VALUE_333204.sql	Data Script	1.1	"	"	"	"	"
DP_CSV6.sql	Extract Package	1.27	"	"	"	"	"

New Access
Access Tab	Name	Description
INT_ERR/PROCESS_ITEMS	Process Items	The items that are provided in the CSV order file will be displayed in this tab page in the Interface Errors screen

New Parameters
Parameter Name	Config Level	Setting Value	Result
INT_ADD_MOD43_CD	CUSTOMER	Y	The non-asset item will be given a suffix for the check digit based on the Modulo 43 mapping.
INT_ADD_MOD43_CD	CUSTOMER	N	The asset item will not be given a suffix as at present.
WCS_CALC_ITEM_WGT_VOL	CUSTOMER	Y	The weight and volume will be calculated for the new asset item based on the values for the DU type
WCS_CALC_ITEM_WGT_VOL	CUSTOMER	N	The weight and volume will not be calculated as at present.