Re: Open period Request Takes too long

Posted by ErmanArslansOracleBlog on Mar 03, 2017; 11:08am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Open-period-Request-Takes-too-long-tp2249p2251.html

Hi Saad,

This log doesn't say anything. It is just listing the names of the routines.
Why don't you follow the SR?
There are indeed performance issue recorded for this.
I just searched the Oracle Support with the keyword "glooap performance" and here are the results of my search;

R12: GLOOAP Open Period Program Has Poor Performance(Doc ID 1501226.1)
GLOOAP: Open Periods Program Poor Performance in GLOODB and GLOPIB Routines(Doc ID 1312309.1)
Information Center: Optimizing Performance for Oracle General Ledger(Doc ID 1489537.2)
GLOOAP Open Period Even After Applying Patch 5069154 When Open New Period in New Year Have Poor Performance(Doc ID 404362.1)