R11i How to Avoid the STPM0017 GLSTPM Lock Messages in the GL Posting (Doc ID 1084978.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Oct-2013***
Executable:GLPPOS - Posting
Executable:GLSMST - Program - Maintain Summary Templates


Goal

High frequency blocking sessions caused by simultaneous GLPPOS concurrent requests.
Basically, when getting these locks on these GLPPOS jobs the EM monitoring sends alerts about numerous blocking sessions in the Database.

Solution

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