SQL query time exceeds the limit (2400 sec) Attempting to Run Subledger Period Close Exceptions Report
(Doc ID 2788088.1)
Last updated on JULY 12, 2021
Applies to:Oracle Fusion General Ledger Cloud Service - Version 11.13.21.01.0 and later
Information in this document applies to any platform.
Body SR 3-26284926191
On Fusion 11.13.21.01.0, find that there are performance issues with Subledger Period Close
The Subledger Period Close Exceptions Report times out with the following Error:
SQL query time exceeds the limit (2400 sec)
Customer is running this report as part of month-end period close process.
It usually only takes a couple of minutes to complete successfully whether there are exceptions to report or not.
Expected reports to run successfully within minutes
The issue can be reproduced at will with the following steps:
Processing some unprocessed reports, Projects items etc... , the report then ran and completed successfully.
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