R12: Performance Issue When Querying Journals in Journal Inquiry Form
(Doc ID 2238205.1)
Last updated on SEPTEMBER 30, 2019
Applies to:Oracle General Ledger - Version 12.1 and later
Information in this document applies to any platform.
Post upgrade, when querying Journals through GL Responsibility in Journal Inquiry form, for just a few Journals it is taking more than a minute to complete; during period closure time the proces is taking around 20-30 minutes.
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
- Login into GL Responsibility
- Navigate to Inquiry -> Journals
- Enter the Period and maybe restrict to Unposted criteria only
- For 4-5 Journals observe this is taking more than a minute and it may take up to 30 minutes sometimes
Recently upgraded to current R12 version.
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