How does the ar_bpa_print_requests table get populated?
Summary:
We are getting timeout issue when trying to print an invoice using the Print Receivable Program. However, this issue only happens if the delivery method of an Invoice is either Paper or None. It works fine when the invoice delivery method is Email. Furthermore, this only happens to PROD but working perfectly in other environments.
Of course, we have customized the bursting script to align with our business process, but it doesn't make any sense why we keep getting timeout even if we are only printing one invoice.
I took a closer look on the bursting script and identified that AR_BPA_PRINT_REQUESTS table that stores information about print requests. Then one time, while the program is still running (during this time, it's been running for 30 min for just one invoice), I query the said table and was able to see that request id of the program but wondering why there is no data being populated on the customer_trx_id.