PRC: Generate Draft Revenue for a Range of Projects - Conflict between using From/To Project Number
In order to reduce the runtime of one of the 14 processes, we broke it into 13 multiple processes using both a From Project Number and To Project Number range, as well as the Project Type parameter. The resulting 26 processes were run in parallel. Because some of the project number ranges were large (eg., 10000 to 99999), this meant that several of the simultaneous processes were potentially querying the same project numbers.