Data Warehouse Staging Errors Report

Purpose: Use this report to review order transactions that contain item or SKU errors. For example you perform a merge/purge which updates an old order that contains an item or SKU that has since been deleted. Transactions that contain item/SKU errors remain in the DW Capture Transaction file until the errors are corrected.

The system deletes any records in the following data warehouse staging files that are related to the order transaction in error:

• DW Order Header

• DW Order Detail

• DW Order Ship To

• DW Order Payment

• DW Order Payment Activity

• DW Order Detail Activity

• DW Order Additional Charges

This report sorts in company, date, order number, line number, item, SKU sequence. The report page breaks for each company that contains item or SKU errors.

How to print: Process data warehouse changes by:

• submitting the Initial Load; see Clear Staging Files Window.

• pressing Enter at the Process Data Warehouse Changes Window.

• submitting the Process DW Changes (DWCHG) periodic function (DWR0068).

CWDirect Rel 6.0 Data Warehouse Staging Errors KBOTTGER DWR0092 3/14/02 10:28:05 Page 1 KAB Co. Date Order# Line# Item SKU Error 3/14/02 5509 - 1 1 BUGGY <<< Order Contains An Invalid Item >>> 3/14/02 5524 - 1 1 B234U <<< Order Contains An Invalid Item >>> 3/14/02 5525 - 1 1 CH75K <<< Order Contains An Invalid Item >>> 3/14/02 5525 - 2 1 B94NY <<< Order Contains An Invalid Item >>> 3/14/02 5525 - 2 3 GI756FE <<< Order Contains An Invalid Item >>>

Contents:

• date: the date when the order transaction in error was submitted to the staging data warehouse.

• order number: the order number containing the item or SKU in error.

• line number: the order line number containing the item or SKU in error.

• item: the item number that is in error.

• SKU: the SKU code that is in error.

• error: a description of the error. The only error that prints on this report is Order Contains an Invalid Item.