Re: Open period Request Takes too long

Posted by Saad Qaiser Khan on Mar 10, 2017; 7:16am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Open-period-Request-Takes-too-long-tp2249p2326.html

Hello Erman,

The issue has been resolved. After upgrade from 12.0.6 to 12.1.3 which was done by another vendor they made custom indexes in gl_balances. After dropping those the request is now completing in 45 minutes in UAT Server because it is slow. Hopefully in PROD Server it will be completed faster approx in 20 minutes. I learn new things in TOAD because of things you told.

I still don't know why it was doing it. Because of custom indexes.

Regards,
Saad