My Oracle Support Banner

Period Close warning: R_CLPR0002- Unposted journals exist in period <period_name> (Doc ID 2440768.1)

Last updated on JUNE 26, 2023

Applies to:

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


On : version, Close Accounting Period-Close Ledgers

When attempting to close period, the following error occurs.

Warning in gapless period closing routine

xla.plsql.xla_gl_period_open_close_pub.gl_period_close=>Enter: xla.plsql.xla_gl_period_open_close_pub.gl_period_close
xla.plsql.xla_gl_period_open_close_pub.gl_period_close=>p_ledger_id: 300000001093260
xla.plsql.xla_gl_period_open_close_pub.gl_period_close=>p_period_name: 18-Jul
xla.plsql.xla_gl_period_open_close_pub.gl_period_close=>l_period_status: C
xla.plsql.xla_gl_period_open_close_pub.gl_period_close=>l_event_string: #GL_PERIOD_CLOSE#07-08-18 08:21:43.228102 AM#300000001093260#18-Jul;
xla.plsql.xla_online_txn_eng_pkg.stamp_cache_invalidation_event => 07-08-2018 08:21:43 Enter: xla.plsql.xla_online_txn_eng_pkg.stamp_cache_invalidation_event
xla.plsql.xla_online_txn_eng_pkg.stamp_cache_invalidation_event => 07-08-2018 08:21:43 p_event_string: #GL_PERIOD_CLOSE#07-08-18 08:21:43.228102 AM#300000001093260#18-Jul;
xla.plsql.xla_online_txn_eng_pkg.stamp_cache_invalidation_event => 07-08-2018 08:21:43 Total XLA_ONLINE_TXN_PROCS (accounting OTECs) updated row count: 3
xla.plsql.xla_online_txn_eng_pkg.stamp_cache_invalidation_event => 07-08-2018 08:21:43 Exit: xla.plsql.xla_online_txn_eng_pkg.stamp_cache_invalidation_event
xla.plsql.xla_gl_period_open_close_pub.gl_period_close=>Exit: xla.plsql.xla_gl_period_open_close_pub.gl_period_close

The issue can be reproduced at will with the following steps:
1. Go to Manage Accounting Period
2. Close the required period
3. Check the log file

The issue has the following business impact:
Due to this issue, users are getting warning message while closing the period.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.