My Oracle Support Banner

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

Last updated on SEPTEMBER 13, 2021

Applies to:

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


EXECUTABLE:GLLEZL - Journal Import
GLOCPP module: Periods - Close Period
xlaaptrn.pkb

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 :

  1. There are genuinely unprocessed rows in GL_INTERFACE table. In this case, the period can be reopened and the journal import executed again to import the unprocessed lines.
  2. There are no transactions in the GL_INTERFACE Table for the period in question. The program is displaying an incorrect message even when the GL_INTERFACE table has zero records.
  3. There are "Processed" transactions in the GL_INTERFACE Table which Journal Import has not deleted. The journals however are created in General Ledger.



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

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.