R12: Performance Issue When Querying Journals in Journal Inquiry Form

(Doc ID 2238205.1)

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.

The issue can be reproduced at will with the following steps:

  1. Login into GL Responsibility
  2. Navigate to Inquiry -> Journals
  3. Enter the Period and maybe restrict to Unposted criteria only
  4. 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