EAM-55782 Datalake: - xxx_lastupdate solumn for normal inserts and updates uses local time while deletes uses UTC time when uploaded from EAM - HxGN EAM - Version 12.0 - Hexagon

EAM-55782 Datalake: - xxx_lastupdate solumn for normal inserts and updates uses local time while deletes uses UTC time when uploaded from EAM

 Description 

Steps to reproduce:

1. Create datalake schedule and add table(s) for uploads to Datalake. Use R5BINSTOCK in this example.

2. Go the Part screen | Stock tab.

3. Either manually add a store/bin/lot and quantity to a Part or update the quantiy of an existing Bin.

In this example I created a part called DATALAKE PART 001. Add a store, bin and Qty on hand. Commit.

4. Note the local time stamp on your computer. In my example the date/time stamp is 02/04/2022 at 10:25 am EST.

5. Log into ION Desk | Datalake | Compass. Run query to view this synced entry into R5BINSTOCK from Compass and note the bis_lastsaved field also uses local time ending in 000.Z. In my example it is 2022-02-04T10:25:21.000Z.

6. Back to EAM. Same Part screen | Stock tab. To perform a Delete, update the quantity of an existing Bin to zero. Now delete the Bin.

7. Note the local time stamp on your computer. In my example the date/time stamp is 02/04/2022 at 10:29 am EST.

8. Wait for the DKDL job to run as it runs once an hour on the hour.

9. Log into IONDESK | Datalake | Compass and select R5BINSTOCK

10. Run the query using the query below using AllVariations to get the latest updates for this part against this table:

SELECT

"eam_R5BINSTOCK"."BIS_BIN",

"eam_R5BINSTOCK"."BIS_LASTSAVED",

"eam_R5BINSTOCK"."BIS_PART",

"eam_R5BINSTOCK"."BIS_QTY",

"eam_R5BINSTOCK"."BIS_STORE",

"eam_R5BINSTOCK"."_DELETED"

FROM

infor.AllVariations('eam_R5BINSTOCK') where "eam_R5BINSTOCK"."BIS_PART" = 'DATALAKE PART 001' order by bis_lastsaved desc

The time stamp for this Deleted record is 2022-02-04T15:29:42.000Z which is +5 hours from the local time.

Actual Results: Time stamps from EAM for inserts and updates of existing rows use the loacl time stamp while deletes use Z time despite the "z" that is added to the end of each time stamp.

Expected Results: Consistent z time stamps for all rows submitted from EAM to Datalake. In the past, it looks like all inserts and updates did actually use z time/utc time.