How To Check For Unposted Journals At Period End

(Doc ID 285262.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle General Ledger - Version 11.5.9 to 12.1.3 [Release 11.5.9 to 12.1]
Information in this document applies to any platform.

Executable:GLOOAP - Open Period

Goal

When closing the period its possible to leave unposted journals or incomplete imports. There is no warning message available or other simple method to warn you that there are pending journal entries for that period yet to be posted.
GL does NOT have a profile to prevent the closing of the period if there are pending journal entries for that period yet to be posted.

The period can be closed and those journals will error out if they are POSTED. The period will need to be re-opened in the open period screen to allow the journals to be posted and the imports to be completed

Those Journals, then remaining in the GL _INTERFACE table, can then be edited to change the date for them to be POSTED into another open period.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms