How to monitor to know when bulk dunning letters are completed

Advanced Collections - EBS 12.2

We have a custom program that reads the XMLDATA field from iex_xml_request_histories and combines them all into one large XML file to send to an external vendor for printing.

As it is, our Collections dept. business leader will run Strategy Management once a month and after the job has completed in the concurrent manager, we will get thousands of letters created (i.e. rows in iex_xml_request_histories) and updated over the next couple of hours.

We are basically blind for this two-hour window as to what is going on and how to know when the last letter has completed. The only way I know is to run queries against the table to see when the count has stopped going up.