11i: Request Open Encumbrance Year Runs Slow (Doc ID 1965719.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
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))


STEPS
-----------------------
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

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

Cause

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