Payables Period Close Exceptions Report not displaying any data

Summary

Payables Period Close Exceptions Report is not displaying any data eventhough the Payables period cannot be closed

Content

Hi Folks,

We are facing an issue when trying to close payables period, the Close Payables Accounting Period program ends in warning with "AP_UNACCT_TRXS_EXISTS - Unaccounted Invoices and/or payments". However the Payables Period Close Exceptions report ends in Error with no data in it. 

When trying to run the report from Scheduled Processes work area, it runs successfully however there is still no data in it.

We are on 19C. Has anyone faced this issue? Appreciate your inputs if you have also faced this or were able to resolve it.