We have written a flex code on R5REQUISLINES for both POST INSERT and POST UPDATE trigger points. We have a requirement where we have to update few columns of R5REQUISLINES table post insertion - so we've wrote direct UPDATE statement in POST-INSERT of R5REQUISLINES. Since we have POST-UPDATE flex rule as well for R5REQUISLINES, and this implementation calls POST-UPDATE flex rule from POST-INSERT flex rule, we're getting random/wrong ROWID. Is it possible in any way we can achieve this to work? i.e, 1. Can we fetch the correct ROWID to POST-UPDATE flex rule from POST-INSERT flex rule? 2. Or is there any way we can flow the ROWID using other method? like session related variables or something. Thanks in advance!!
From my understanding, you can only pull the ROWID from the record you are currently on. Additionally you may need to combine the two flex statements to be similar to one another rather than calling one from the other which is currently not available. If you have further questions about this specific flex, please feel free to email