Test Case Form DP 2 updated [IBM—华为供应链全套方案].doc

Test Case Form Function / Sub-function ID :Module - Function Name :Demand PlanningTest Name (TBA by BD)Test ID (TBA by BD)Test Condition / Test Scenario:DP Inbound Data Verification in ODS Dependencies / Prerequisites DP Inbound Data Extract from Oracle & EDSResponsibility(required to execute this test case)Module AE, Module HW lead, Module IT LeadStep # Navigation ActionExpected ResultsActual ResultsPass /FailTest Defect number1a1bVerify Bucket Master in ODS using TOAD.Verify Bucket Detail in ODS using TOADCheck for entries- ENTERPRISE = HW, BUCKETNAME = DP_Buckets and ENGINE_ID = value which is read by DP (refer ENGINE LIST table in ODS)Check for entries- ENTERPRISE = HW, BUCKETNAME = DP_Buckets, BUCKETID = Serial No of bucket from 1 to 59STARTDATE = Month start date from ENDDATE = Month end dateENGINE_ID = value which is read by DP (refer ENGINE LIST table in ODS)Entries Found in ODSEntries Found in ODS2a2bVerify Measure Master in ODS using TOADVerify Bucketed Measure Data in ODS using TOADCheck for entries-ENTERPRISE = HW, MEASURENAME = Units Sold, etcMEASURETYPE = History, etcENGINE_ID = value which is read by DP (refer ENGINE LIST table in ODS)Check for entries-ENTERPRISE = HW, MEASURENAME = Units Sold, etcSALESNAME = 001001001001, etcSALESLEVEL = OffGrp, etcPRODUCTNAME = 01010071, etcPRODUCTLEVEL = Item, etcSTARTDATE = 1/1/2000, etcENDDATE = 2/1/2000, etcQUANTITY = numerical quantity for measureENGINE_ID = value which is read by DP (refer ENGINE LIST table in ODS)Check that all entries in Measure Master have data in Bucketed Measure DataEntries Found in ODSEntries Found in ODS3a3bVerify SALES MASTER in ODS using TOADVerify PRODUCT MASTER in ODS using TOADCheck for entries-ENTERPRISE = HW, SALESNAME = 1, etcSALESDESC = Huawei, etcSALESLEVEL = AllGeo, etcENGINE_ID = value which is read by DP (refer ENGINE LIST table in ODS)Check for entries-ENTERPRISE = HW, PRODUCTNAME = 1, etcPRODUCTDESC = All Products, etcPRODUCTLEVEL = AllProd, etcENGINE_ID = value which is read by DP (refer ENGINE LIST table in ODS)Entries Found in ODSEntries Found in ODS4a4bVerify SALES BOM in ODS using TOADVerify SALES BOM OPTION in ODS using TOADCheck for entries-ENTERPRISE = HW, BOMID = unique ID for BOMs, Entries for Plng Percent and Sales Order HistoryPLANID = 1SALESNAME = 1 for BOMs, none for PlngPercent and Sales Order HistoryPRODUCTFAMILYNAME = 01010071 etc for BOMs, none for PlngPercent and Sales Order HistoryPRODUCTFAMILYLEVEL = Item, etc for BOMs, none for PlngPercent and Sales Order HistoryENGINE_ID = value which is read by DP (refer ENGINE LIST table in ODS)待添加的隐藏文字内容3Check for entries-ENTERPRISE = HW, BOMID = unique ID for BOMs, Entries for Plng Percent and Sales Order HistoryPLANID = 1OPTIONNAME = 02310443, etcOPTIONLEVEL = Item, etcSALESNAME = none for BOMs, 1, etc for PlngPercent and 001001001001, etc for Sales Order HistorySALESLEVEL = none for BOMs, AllGeo, etc for PlngPercent and OffGrp, etc for Sales Order HistoryPRODUCTFAMILYNAME = none for BOMs, 01010071, etc for PlngPercent and Sales Order HistoryPRODUCTFAMILYLEVEL = none for BOMs, Item, etc for PlngPercent and Sales Order HistoryATTACHRATE = none for BOMs, numerical value for PlngPercent and Sales Order HistoryMAPSETNAME = Map1, etc for BOMs, none for PlngPercent and Sales Order HistoryEFFSTARTDATE = none for BOMs, dates for PlngPercent and Sales Order HistoryEFFENDDATE = none for BOMs, dates for PlngPercent and Sales Order HistoryENGINE_ID = value which is read by DP (refer ENGINE LIST table in ODS)Entries Found in ODSEntries Found in ODS5Verify HIERARCHY MASTER in ODS using TOADCheck for entries- ENTERPRISE = HW, HIERARCHYNAME = Item View, etc HIERARCHYTYPE = SALES, etc and ENGINE_ID = value which is read by DP (refer ENGINE LIST table in ODS)Entries Found in ODS6a6bVerify PRODUCT HIERARCHY MASTER in ODS using TOADVerify SALES HIERARCHY MASTER in ODS using TOADCheck for entries- ENTERPRISE = HW, HIERARCHYNAME = Item View, etc PRODUCTNAME = 1, etcPRODUCTDESC = ALLPROD, etcPRODUCTLEVEL = AllProd, etcPARENTPRODUCT = 1, etc (none for ALLPROD)PARENTPRODUCTLEVEL = AllProd, etc (none for ALLPROD)HIERARCHYTYPE = SALES, etc and ENGINE_ID = value which is read by DP (refer ENGINE LIST table in ODS)Check for entries- ENTERPRISE = HW, HIERARCHYNAME = Group View, etc SALESNAME = 1, etcSALESLEVEL = AllGeo, etcPARENTSALESNAME = 1, etc (none for ALLGEO)PARENTSALESLEVEL = AllGeo, etc (none for ALLGEO)ENGINE_ID = value which is read by DP (refer ENGINE LIST table in ODS)Entries Found in ODSEntries Found in ODS7Verify PLAN MASTER in ODS using TOADCheck for entries- ENTERPRISE = HW, PLANID = 1PLANDESC = Demand PlanningINSTANCEID = DmPl-dp_DefaultENGINE_ID = value which is read by DP (refer ENGINE LIST table in ODS)Entries Found in ODS8Verify DP PLAN PARAMETER DETAIL in ODS using TOADCheck for entries- ENTERPRISE = HW, MEASURENAME = Units Sold, etcENTITYNAME = BucketedMeasureData, etcENTITYPLANID = 1EFFSTARTDATE = Start date for applicable measures (like Entity Name)EFFENDDATE = End date for applicable measures (like Entity Name)DIMENSION1LEVEL = OffGrp, etc for applicable measures (like Entity Name)DIMENSION2LEVEL = Item, etc for applicable measures (like Entity Name)OPERATION = LOAD or EXPORTENGINE_ID = value which is read by DP (refer ENGINE LIST table in ODS)Entries Found in ODS9Verify HIERARCHY TRANSACTION LOG in ODS using TOADCheck for entries- ENTERPRISE = HW, OLDPRODUCTNAME = 01010071, etcPRODUCTLEVEL = Item, etcNEWPARENTPRODUCTNAME = 03, etcPARENTPRODUCTLEVEL = Pgroup, etcTRANSACTIONID = 1, etcTRANSACTIONDATE = DateENGINE_ID = value which is read by DP (refer ENGINE LIST table in ODS)Entries Found in ODSTest Case Author:Test Case Reviewed by:(inc. date)Test Executed by: (inc. date)Output attached: (yes/no)Test Retested by: (inc. date)Results Reviewed by:(inc. date)Sign off