We have a post processing method directive that executes a stored procedure to output some XML for an integration. It appears that despite running in post, Epicor’s cache has not been flushed to SQL Server when the sproc runs. I see evidence of this in a decision being made in the BPM based on a value of a checkbox, but the opposite value appearing in the XML.
I’ve considered introducing an artificial delay in the hope that it will increase the probability of the cache being flushed. If that fails, I might have to reimplement the sproc inside the BPM. Are there any other options?