Incorrect booking history data in Demantra
Hi,
We are seeing a problem with demantra shipment and booking history collection. Some reason collection is not putting data in right columns in sales_data table.
I have below orders booked yesterday in EBS (11/29/16) and line status is Awaiting Shipping.
FG# Item A s/o 1810828 Req Date = 12/15/16 Ship Date = 01/20/17
FG# Item B s/o 1810829 Req Date = 01/10/17 Ship Date = 02/08/17
FG# Item C s/o 1810830 Req Date = 12/12/16 Ship Date = 03/20/17
Ran shipment collection in Net Change mode with all 8 data streams set to Yes.
After completion of collection, I see sales order quantities in EBS_BH_BOOK_QTY_BD and EBS_BH_REQ_QTY_BD columns for November 2016 month and other columns are blank. I was expecting to see quantities for Item A and Item C in December and Item B for Jan 2017?