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

Last updated on MAY 09, 2024

Applies to:

Symptoms

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.

Changes

Cause