GLPPOS Posting Program Has Poor Performance In glpipi gl_posting_interim_nn (Doc ID 115853.1)

Last updated on NOVEMBER 01, 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 10-Aug-2012***
EXECUTABLE:GLPPOS - Posting

Symptoms

You are experiencing performance problems while running the Posting process (GLPPOS) after a successful install/upgrade of Oracle General Ledger, Release 11i.

The following is what you see in the Posting log file:

glpipi()
gl_posting_interim_nn  <- where nn is a number


In one example, you are trying to post 50,000 lines and it is taking 24 hours.

Responsibility: General Ledger Super User
Navigation Path: Journals -> Post 

Cause

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