Unprocessed records exist in the GL_INTERFACE table
Content
Hello: We received a warning when closing the GL this month, that that were unprocessed records in the GL Interface table. All the subledger period exception reports were clear and no errors showed in the GL dashboard. I found the following script on the knowledge base for ?showing the records in the interface table?, but when we run it, we are getting an error. Does anyone know how to report the transaction in the interface table?
The following scripts will show all the records with problems:
SELECT gli.user_je_source_name,
gli.ledger_id,
gli.period_name,
gli.status,
4