11i: Request Open Encumbrance Year Runs Slow

(Doc ID 1965719.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Oracle General Ledger - Version and later
Information in this document applies to any platform.


The open encumbrance year program is taking longer time to run than expected based on previous years experience.

The most expensive statement is:

select 1 into :b0 from DUAL where exists (select null from gl_balances b where (((b.set_of_books_id=:b1 and b.actual_flag='E') and b.encumbrance_type_id is not null ) and b.period_year=:b2))

The issue can be reproduced at will with the following steps:
1. Go to General Ledger Super user
2. Go to Setup-->Open/Close
3. Click on Open Encumbrance Year

The issue has the following business impact:
Due to this issue, users cannot open the next encumbrance year


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