Gleoyr - Gleodeb_delete_ecbr_bal Step Running Very Slowly

(Doc ID 1291259.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

On : 11.5.10.2 version, Budgets and related objects

When attempting to GLEOYR module: Open Encumbrance Year, the request hangs in the following module

ERROR
-----------------------
>> gleoceb_check_ecbr_bal() 11-JAN-2011 15:03:00

EOYR0001: An encumbrance balance exists for the period year 2011
<< gleoceb_check_ecbr_bal() 11-JAN-2011 15:11:56
>> gleodeb_delete_ecbr_bal() 11-JAN-2011 15:11:56
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. This job initially failed due to inability to extend index - once this was fixed and job rerun, the step above is running at approx 30,000 records per hour - at this rate,, job has approx 160 hours left to run

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