PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 06/12/2019 9:03 AM by  Aurora
Future dated XML errors
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Aurora
HRIS
Private
New Member
(6 points)
New Member
Posts:4


Send Message:

--
06/12/2019 9:03 AM

    We are on 11.0.0.32 GHR.  We parse the XML history tables into custom views so that our end users that utilize Crystal and SQL writers can access historical data easily (we do not use Infor reporting tools at this time).  We discovered that if a transaction is keyed with a future effective date, then another transaction is keyed prior to the effective dated row commits with an effective/entry date prior to the future effective date, it enters the future dated row into the middle of this row.  In the XML, it is a hot mess and does not process the rest of the entries.  We end up with data that just ENDS historically.  Has anyone else encountered this and/or have a solution as to how we can fix it?


     


    Example:


    Keyed: 9/18/2018 Effective: 9/30/2018


    Keyed: 9/24/2018 Effective: 9/16/201


    Snippet example: field name = "Position" t = "1" s = "9'<'entry applied="2018093004062164" timestamp="2018091812415794" actor=... You'll see the entry applied does not come at the of the previous row but rather the middle in a random spot.

    You are not authorized to post a reply.