My Oracle Support Banner

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

Last updated on SEPTEMBER 26, 2018

Applies to:

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

Symptoms

On : 11.12.1.0.0 version, Close Accounting Period-Close Ledgers

When attempting to close period, the following error occurs.

ERROR
-----------------------
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



STEPS
-----------------------
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

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

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.