Pre-Crush Position Detail- Net Futures bucket is incorrect

Issue No: RM-2694
Created 3/8/2019 2:10:37 AM
Type Bug-QC
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 18.3
Description ISSUE   Daily Position Report does not account the Match Derivative Transaction History. Thus, making the Net Futures and Price Risk incorrect.   ACCEPTED   Net Futures should consider the Match Derivative Transaction to reflect the right Contract qty     *Email sent to Liz:*   *------------------------------------------------------------------------*   Liz,     I don’t remember the Jira(s) associated with this but it has to do with the following SPs and function:     * *uspRKDPRPreCrushPositionDetail* * *uspRKDPRHedgeDailyPositionDetail* * *fnRKGetOpenFutureByDate*     I think what happened was some unfinished code made it into production and broke the DPR (hedge section missing and Price Risk overinflated). I think it was Jonas code if I’m remembering correctly.   Up to today I would simply patch those two SPs and function with the prior version to keep Creston and Ithica functional. We’ve had several conversations about needing a patch in the next release so I don’t have to do the manual patch anymore. It happened again today, Creston was upgraded to 18.3.0305.776 (Ithaca is on 18.3.0219.744).   I’m no longer able to do a manual patch because someone added the ysnPreCrush column to the tblRKFutOptTransactionHistory which causes an Ambiguous error for the function:   !http://jira.irelyserver.comfile///C:/Users/jdafforn/AppData/Local/Temp/msohtmlclip1/01/clip_image001.jpg|height=310,width=435! !http://jira.irelyserver.comfile///C:/Users/jdafforn/AppData/Local/Temp/msohtmlclip1/01/clip_image001.jpg|height=310,width=435! Bottom line this has created an urgent situation at Zeeland in general and we need to fix it today (my tonight).   !http://jira.irelyserver.comfile///C:/Users/jdafforn/AppData/Local/Temp/msohtmlclip1/01/clip_image002.jpg|height=512,width=766!