You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unprocessed records exist in the GL_INTERFACE table

edited May 13, 2021 4:03PM in General Ledger & Intercompany 5 comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!