My Oracle Support Banner

GLOCPP: Close Period with Warning R_CLPR0003: Unprocessed Records Exist in GL_INTERFACE (Doc ID 818906.1)

Last updated on JANUARY 25, 2023

Applies to:

Oracle General Ledger - Version 12.0.4 and later
Information in this document applies to any platform.

GLOCPP module: Periods - Close Period


When running the program GLOCPP Periods - Close Period it ends with a warning and the logfile shows the entry:

SHRD0008: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Warning ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
R_CLPR0003: Unprocessed records exist in GL_INTERFACE for period XXX-XX

The period is closed anyway, in spite of the warning. This is normal behavior.

The message can happen under the following circumstances:

I. There are genuinely unprocessed rows in GL_INTERFACE table

II. There are no transactions in the Gan incorrect message even when the GL_INTERFACE table has zero records.

III. There are "Processed" transactions in the GL_INTERFACE Table which Journal Import has not deleted. The journals however are created in General Ledger.

IV. The calendar may have been changed while gl_date_period_map had not (rare cases)

The following scripts will show all the records with problems:

The sql used in GLOCCP includes a comparison between the accounting_date in the interface and the start and end date in the period, so the issue may occur if the accounting date is outside the start and end date that it has been placed in. This would only occur if the calendar had been changed but the gl_date_period_map had not.




To view full details, 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 a vibrant support community of peers and Oracle experts.