Open period Request Takes too long

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

Hello Erman,

EBS Release 12.1.3
DB Ver 11.2.0.4

Open period request takes too long to open(approx 2 hours). Opened the SR they recommend me patches to upgrade the version

Open Periods Program Poor Performance in GLOODB and GLOPIB Routines (Doc ID 1312309.1)

R12: GLOOAP Open Period Program Has Poor Performance (Doc ID 1501226.1)

Here are the logs.


>> main() 01-MAR-2017 11:52:15

>> glusca() 01-MAR-2017 11:52:15

<< glusca() 01-MAR-2017 11:52:15

>> glulsr() 01-MAR-2017 11:52:15

<< glulsr() 01-MAR-2017 11:52:15

>> glooap() 01-MAR-2017 11:52:15

>> gloovp() 01-MAR-2017 11:52:15

<< gloovp() 01-MAR-2017 11:52:15

>> glopcs() 01-MAR-2017 11:52:15

<< glopcs() 01-MAR-2017 11:52:15

>> gloodb() 01-MAR-2017 11:52:15

<< gloodb() 01-MAR-2017 11:52:15

>> glucmt() 01-MAR-2017 11:52:15

<< glucmt() 01-MAR-2017 11:52:15

>> glucmt() 01-MAR-2017 11:52:15

<< glucmt() 01-MAR-2017 11:52:15
SHRD0019: glooap - process exiting after successful execution.

<< glooap() 01-MAR-2017 11:52:15

>> launch_req() 01-MAR-2017 11:52:15

<< launch_req() 01-MAR-2017 11:52:15
SHRD0019: glooap - process exiting after successful execution.

<< glooap.xla_balance_open() 01-MAR-2017 11:52:15

Please recommend me any patch or solution.

Thanks and Regards,
Saad