I have a process in which one of the step needs to update the XIsInEffect flag. I've tried using an Update step and also a SQL Statement flag. No error is raised, but the flag is not updated accordingly with the query generated by the process step.
If I run the query from the object browser, the update takes place, thus the query is correct. So why the process is not able to update the XIsInEffect flag? Any suggestion?