The information previously contained herein has now been consigned to a downloadable file: balance_migration.txt

Herein re-attached!

Bumped to publicise the updated version of the document - arising from some discussions with other forum members this morning! You know who you are....

From memory another foible is that the you have your pay_balance_batch_lines rows all waiting with a status of 'U' the first thing the Balance Upload process does is set them all to 'V' so you cannot monitor how things are going...it then unsets the 'V' to 'E' as it finds Errors.

So you have no idea how things are progressing at least within that table

Fair point - all the more reason to keep the batch sizes small, i.e. balances for one assignment only. Monitoring throughput rates then becomes more feasible.