R12: Performance Issue When Querying Journals in Journal Inquiry Form
Last updated on AUGUST 15, 2017
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.
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 hundreds of Community platforms