Separate Remittance Advices are Re-Sent
Hello, On May 16th, we ran a Payment Process Request and the Send Separate Remittance Advice program ran and sent out remittances.
On June 12th, we shut down Oracle EBS for some maintenance which required the DBA to re-run autoconfig. Once EBS was re-started, the Remittances from May 16th were sent to the vendor's again even though the Send Separate Remittance Advice program did not run at this time.
I would like to know:
1. What query does the Send Separate Remittance execute to determine unsent remittances?
2. Is this program using Workflow to send the remittances? Would there be a SENT or UNSENT flag in one of the workflow tables?