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 11.12.1.0.0 and laterInformation 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! |
In this Document
Symptoms |
Cause |
Solution |