My Oracle Support Banner

Gleoyr - Gleodeb_delete_ecbr_bal Step Running Very Slowly (Doc ID 1291259.1)

Last updated on JULY 07, 2020

Applies to:

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


On : version, Budgets and related objects

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

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.